S125.ru - форумы
Правила форума Помощь Поиск Пользователи Календарь
2 страниц V  < 1 2  
Ответить в данную темуНачать новую тему
Программа для мониторинга VPS сервера, Сабж
kradabash
сообщение 27.9.2014, 21:40
Сообщение #31





Группа: Пользователи
Сообщений: 281
Регистрация: 19.1.2014




Как я понял эта из-за мускула:

(IMG:http://i6.pixs.ru/thumbs/8/3/9/Saguteypng_1196208_14009839.jpg)

Кто может подсказать в чём именно проблема? Предоставлю любые логи, любые тесты.
Перейти в начало страницы
 
+Цитировать сообщение
Muzzle
сообщение 28.9.2014, 11:05
Сообщение #32





Группа: Пользователи
Сообщений: 560
Регистрация: 6.7.2008
Из: офиса ^_^




Цитата(kradabash @ 27.9.2014, 22:40) *
Как я понял эта из-за мускула:

(IMG:http://i6.pixs.ru/thumbs/8/3/9/Saguteypng_1196208_14009839.jpg)

Кто может подсказать в чём именно проблема? Предоставлю любые логи, любые тесты.

нагрузка постоянная? периодическая?
желательно посмотреть конфиг mysql, в момент нагрузки так же посмотреть в mysql SHOW PROCESSLIST, возможно висит какой-то запрос.
Перейти в начало страницы
 
+Цитировать сообщение
kradabash
сообщение 28.9.2014, 14:25
Сообщение #33





Группа: Пользователи
Сообщений: 281
Регистрация: 19.1.2014




Цитата(Muzzle @ 28.9.2014, 12:05) *
нагрузка постоянная? периодическая?
желательно посмотреть конфиг mysql, в момент нагрузки так же посмотреть в mysql SHOW PROCESSLIST, возможно висит какой-то запрос.


My.cfg: (1.512 озу)
Код
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# [url="http://dev.mysql.com/doc/mysql/en/server-system-variables.html"]http://dev.mysql.com/doc/mysql/en/server-s...-variables.html[/url]

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port      = 3306
socket      = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket      = /var/run/mysqld/mysqld.sock
nice      = 0

[mysqld]
#
# * Basic Settings
#
user      = mysql
pid-file   = /var/run/mysqld/mysqld.pid
socket      = /var/run/mysqld/mysqld.sock
port      = 3306
basedir      = /usr
datadir      = /var/lib/mysql
tmpdir      = /tmp
lc-messages-dir   = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address      = 127.0.0.1
#
# * Fine Tuning
#
key_buffer      = 16M
max_allowed_packet   = 16M
thread_stack      = 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
max_connections        = 500
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit   = 1M
query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
#log_slow_queries   = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id      = 1
#log_bin         = /var/log/mysql/mysql-bin.log
expire_logs_days   = 10
max_binlog_size         = 100M
#binlog_do_db      = include_database_name
#binlog_ignore_db   = include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem



[mysqldump]
quick
quote-names
max_allowed_packet   = 16M

[mysql]
#no-auto-rehash   # faster start of mysql but no tab completition

[isamchk]
key_buffer      = 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/


Нагрузка периодическая, 5\10 секунд ничего нет, потом бах 200%. Сейчас онлайна на ботах нет, всё вроде нормально. В пик сделаю mysql SHOW PROCESSLIST

Сообщение отредактировал kradabash - 28.9.2014, 14:42
Перейти в начало страницы
 
+Цитировать сообщение
kradabash
сообщение 28.9.2014, 20:37
Сообщение #34





Группа: Пользователи
Сообщений: 281
Регистрация: 19.1.2014




Код
mysql> show processlist;
+-----+------+-----------+-------+---------+------+-----------+---------------------------------------------------------------------------------------------+
| Id  | User | Host      | db    | Command | Time | State     | Info                                                                                        |
+-----+------+-----------+-------+---------+------+-----------+---------------------------------------------------------------------------------------------+
|  85 | root | localhost | melee | Sleep   |   14 |           | NULL                                                                                        |
|  86 | root | localhost | melee | Sleep   |   14 |           | NULL                                                                                        |
|  87 | root | localhost | melee | Sleep   |   18 |           | NULL                                                                                        |
|  88 | root | localhost | melee | Sleep   |   14 |           | NULL                                                                                        |
|  89 | root | localhost | melee | Sleep   |   35 |           | NULL                                                                                        |
|  90 | root | localhost | melee | Sleep   |   14 |           | NULL                                                                                        |
|  91 | root | localhost | melee | Sleep   |   35 |           | NULL                                                                                        |
|  92 | root | localhost | melee | Sleep   |   35 |           | NULL                                                                                        |
|  93 | root | localhost | melee | Sleep   |   14 |           | NULL                                                                                        |
|  94 | root | localhost | melee | Sleep   |   34 |           | NULL                                                                                        |
|  95 | root | localhost | melee | Sleep   |    3 |           | NULL                                                                                        |
|  96 | root | localhost | melee | Sleep   |   14 |           | NULL                                                                                        |
|  97 | root | localhost | melee | Sleep   |    2 |           | NULL                                                                                        |
|  98 | root | localhost | melee | Sleep   |   35 |           | NULL                                                                                        |
|  99 | root | localhost | melee | Sleep   |   13 |           | NULL                                                                                        |
| 100 | root | localhost | melee | Sleep   |    3 |           | NULL                                                                                        |
| 101 | root | localhost | melee | Sleep   |   14 |           | NULL                                                                                        |
| 102 | root | localhost | melee | Sleep   |   35 |           | NULL                                                                                        |
| 103 | root | localhost | melee | Sleep   |   33 |           | NULL                                                                                        |
| 104 | root | localhost | melee | Sleep   |   14 |           | NULL                                                                                        |
| 105 | root | localhost | melee | Sleep   |    3 |           | NULL                                                                                        |
| 106 | root | localhost | melee | Sleep   |   14 |           | NULL                                                                                        |
| 107 | root | localhost | melee | Query   |    0 | query end | INSERT into scores (category,name,server,score) VALUES ('dota_elo','denisd123','',1.000000) |
| 108 | root | localhost | melee | Sleep   |   12 |           | NULL                                                                                        |
| 109 | root | localhost | melee | Sleep   |   32 |           | NULL                                                                                        |
| 110 | root | localhost | melee | Sleep   |   32 |           | NULL                                                                                        |
| 111 | root | localhost | melee | Sleep   |   32 |           | NULL                                                                                        |
| 112 | root | localhost | melee | Sleep   |   32 |           | NULL                                                                                        |
| 113 | root | localhost | melee | Sleep   |   34 |           | NULL                                                                                        |
| 114 | root | localhost | melee | Sleep   |   32 |           | NULL                                                                                        |
| 115 | root | localhost | melee | Sleep   |   39 |           | NULL                                                                                        |
| 116 | root | localhost | melee | Sleep   |   32 |           | NULL                                                                                        |
| 117 | root | localhost | melee | Sleep   |   32 |           | NULL                                                                                        |
| 118 | root | localhost | melee | Sleep   |   32 |           | NULL                                                                                        |
| 119 | root | localhost | melee | Sleep   |   32 |           | NULL                                                                                        |
| 120 | root | localhost | melee | Sleep   |   56 |           | NULL                                                                                        |
| 121 | root | localhost | melee | Sleep   |   38 |           | NULL                                                                                        |
| 122 | root | localhost | melee | Sleep   |    3 |           | NULL                                                                                        |
| 123 | root | localhost | melee | Sleep   |   56 |           | NULL                                                                                        |
| 124 | root | localhost | melee | Sleep   |   36 |           | NULL                                                                                        |
| 125 | root | localhost | melee | Sleep   |   32 |           | NULL                                                                                        |
| 126 | root | localhost | melee | Sleep   |    3 |           | NULL                                                                                        |
| 127 | root | localhost | melee | Sleep   |   69 |           | NULL                                                                                        |
| 128 | root | localhost | melee | Sleep   |   32 |           | NULL                                                                                        |
| 129 | root | localhost | melee | Sleep   |   32 |           | NULL                                                                                        |
| 130 | root | localhost | melee | Sleep   |   34 |           | NULL                                                                                        |
| 131 | root | localhost | melee | Sleep   |   70 |           | NULL                                                                                        |
| 132 | root | localhost | melee | Sleep   |   37 |           | NULL                                                                                        |
| 133 | root | localhost | melee | Sleep   |   24 |           | NULL                                                                                        |
| 134 | root | localhost | melee | Sleep   |   24 |           | NULL                                                                                        |
| 135 | root | localhost | melee | Sleep   |   24 |           | NULL                                                                                        |
| 136 | root | localhost | melee | Sleep   |   22 |           | NULL                                                                                        |
| 137 | root | localhost | melee | Sleep   |   31 |           | NULL                                                                                        |
| 138 | root | localhost | melee | Sleep   |   24 |           | NULL                                                                                        |
| 139 | root | localhost | melee | Sleep   |   38 |           | NULL                                                                                        |
| 140 | root | localhost | melee | Sleep   |   24 |           | NULL                                                                                        |
| 141 | root | localhost | melee | Sleep   |   24 |           | NULL                                                                                        |
| 142 | root | localhost | melee | Sleep   |   38 |           | NULL                                                                                        |
| 143 | root | localhost | melee | Sleep   |   93 |           | NULL                                                                                        |
| 144 | root | localhost | melee | Sleep   |   31 |           | NULL                                                                                        |
| 145 | root | localhost | melee | Sleep   |   24 |           | NULL                                                                                        |
| 146 | root | localhost | melee | Sleep   |   24 |           | NULL                                                                                        |
| 147 | root | localhost | melee | Sleep   |   35 |           | NULL                                                                                        |
| 148 | root | localhost | melee | Sleep   |   45 |           | NULL                                                                                        |
| 149 | root | localhost | melee | Sleep   |   22 |           | NULL                                                                                        |
| 150 | root | localhost | melee | Sleep   |   24 |           | NULL                                                                                        |
| 151 | root | localhost | melee | Sleep   |   45 |           | NULL                                                                                        |
| 152 | root | localhost | melee | Sleep   |   24 |           | NULL                                                                                        |
| 153 | root | localhost | melee | Sleep   |   24 |           | NULL                                                                                        |
| 154 | root | localhost | melee | Sleep   |   36 |           | NULL                                                                                        |
| 155 | root | localhost | melee | Sleep   |   38 |           | NULL                                                                                        |
| 156 | root | localhost | melee | Sleep   |   24 |           | NULL                                                                                        |
| 311 | root | localhost | NULL  | Sleep   |  568 |           | NULL                                                                                        |
| 312 | root | localhost | NULL  | Sleep   |  484 |           | NULL                                                                                        |
| 313 | root | localhost | NULL  | Sleep   |  347 |           | NULL                                                                                        |
| 314 | root | localhost | NULL  | Query   |    0 | NULL      | show processlist                                                                            |
+-----+------+-----------+-------+---------+------+-----------+---------------------------------------------------------------------------------------------+
76 rows in set (0.00 sec)

mysql>
Перейти в начало страницы
 
+Цитировать сообщение

2 страниц V  < 1 2
Ответить в данную темуНачать новую тему
1 чел. читают эту тему (гостей: 1, скрытых пользователей: 0)
Пользователей: 0

 



Для

Тема
Сообщение
Текстовая версия Сейчас: 20.11.2019, 13:57