Atualmente estou movendo um site joomla de um host compartilhado para um dedicado.
O problema que estou enfrentando é que estou tendo um carregamento de página lento e acho que tem algo a ver com o mysql. Eu digo a você porque às vezes (3 vezes desde ontem: S) o daemon mysql desce e eu tenho que colocá-lo online novamente (log in / var / log / mysql / não reporta nada. Não sei porque).
Liguei o log de consultas lentas e ele relata isso:
/usr/sbin/mysqld, Version: 5.5.35-0+wheezy1-log ((Debian)). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
# Time: 140213 15:42:22
# User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
# Query_time: 5.542592 Lock_time: 0.000729 Rows_sent: 0 Rows_examined: 643
SET timestamp=1392302542;
select count(*) into @discard from 'information_schema'.'PARTITIONS';
/usr/sbin/mysqld, Version: 5.5.35-0+wheezy1-log ((Debian)). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
# Time: 140213 15:46:52
# User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
# Query_time: 3.404442 Lock_time: 0.000656 Rows_sent: 0 Rows_examined: 643
SET timestamp=1392302812;
select count(*) into @discard from 'information_schema'.'PARTITIONS';
/usr/sbin/mysqld, Version: 5.5.35-0+wheezy1-log ((Debian)). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
# Time: 140213 15:53:23
# User@Host: kool2B[kool2B] @ localhost []
# Query_time: 3.020636 Lock_time: 0.000340 Rows_sent: 5 Rows_examined: 4868
use kool2Bdb;
SET timestamp=1392303203;
SELECT i.id, i.catid, i.alias, i.modified, i.publish_down, c.alias AS categoryalias , c.name AS categoryname, i.title, i.introtext, i.fulltext
FROM w0nmk_k2_items AS i
INNER JOIN w0nmk_k2_categories c ON c.id = i.catid
INNER JOIN w0nmk_k2_tags_xref tr ON tr.itemID = i.id
AND tr.tagID IN (SELECT tagID FROM w0nmk_k2_tags_xref WHERE itemID = '5199')
WHERE i.published = 1 AND c.published = 1
AND (i.publish_down > CURDATE() OR i.publish_down = '0000-00-00 00:00:00')
AND i.id <> 5199 AND i.catid IN(149,150,151,152,153,154,155,156,159,160,161,163,164,167,165,138,139,142,143,213)
GROUP BY i.id
LIMIT 0, 5;
# Time: 140213 15:56:34
# User@Host: kool2B[kool2B] @ localhost []
# Query_time: 3.612114 Lock_time: 0.000392 Rows_sent: 5 Rows_examined: 5865
SET timestamp=1392303394;
SELECT i.id, i.catid, i.alias, i.modified, i.publish_down, c.alias AS categoryalias , c.name AS categoryname, i.title, i.introtext, i.fulltext
FROM w0nmk_k2_items AS i
INNER JOIN w0nmk_k2_categories c ON c.id = i.catid
INNER JOIN w0nmk_k2_tags_xref tr ON tr.itemID = i.id
AND tr.tagID IN (SELECT tagID FROM w0nmk_k2_tags_xref WHERE itemID = '5275')
WHERE i.published = 1 AND c.published = 1
AND (i.publish_down > CURDATE() OR i.publish_down = '0000-00-00 00:00:00')
AND i.id <> 5275 AND i.catid IN(149,150,151,152,153,154,155,156,159,160,161,163,164,167,165,138,139,142,143,213)
GROUP BY i.id
LIMIT 0, 5;
Você acha normal ter esse horário com esse servidor?
Atom 1,6 GHz + com 2 GB de RAM
Aqui está o arquivo my.cnf:
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
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
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam-recover = BACKUP
query_cache_limit = 1M
query_cache_size = 16M
expire_logs_days = 10
max_binlog_size = 100M
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M
Espero que alguém possa me dar uma mão com isso. Obrigado.
Bem, eu finalmente descobri que havia um componente instalado no joomla que tinha um problema de segurança e um hacker o usou para matar o Apache. Então não houve problemas com o mysql.
Eu encontrei olhando para os logs do apache. Bem, obrigado mesmo assim !!
Atenciosamente