… you have a large spike in number of connections to MySQL, which often happens when several transactions kill the database performance resulting in… a long list of transactions or a large deadlock dump may easily exhaust the limit. MySQL in such situation truncates the output… ? Ssl 0:01 /usr/sbin/mysqld –defaults-file=/etc/mysql/my.cnf In my case the process ID is 11886, so I…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… this server because I have few reading queries but on large tables (~10 millions rows) and a lot lot of insertions… the whole database size is almost 8Go (~60 millions records). This database contains some real-time information, so if the database is slow… the database latency. To give you more information, this is my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max…
Post: Get Me Some Query Logs!
November 22, 2012 By 14 Comments
… SQL queries, and analyzing which queries are accounting for your database load. But the report you get from pt-query-digest… a large enough sample of query logs, collected over a period of time when you have representative traffic on your database. You…. -c config allows you to specify a MySQL config file other than $HOME/.my.cnf, so you can store host, user, and…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
…now! One of our customers was complaining that the database would lock up at random times and then …slow deleting large files), then write operations in MySQL will suffer since that very same mutex is used inside MYSQL_…have it set to 100MB in their default my.cnf) down to 50MB and we never saw this …
Comment: Should MySQL update the default innodb_log_file_size?
November 22, 2011 By 37 Comments
… often don’t even use the provided my.cnf variants. Even Amazon RDS has some undersized defaults…could hurt the XAMPPiness of MySQL. (b) All MySQL instances are on dedicated database servers. I do encounter …which predate the plugin architecture. So a very large log file has some downside. Of course …
