….commanual Handler_commitblogpercona.commanual Handler_deleteblogpercona.commanual Handler_prepareblogpercona.commanual Handler_read_firstblogpercona.commanual Handler_read_keyblogpercona.commanual Handler_read_lastblogpercona.commanual Handler_read_nextblogpercona.commanual Handler_read…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’Handler_commit’, ’19092941′ ‘Handler_delete’, ’0′ ‘Handler_discover’, ’0′ ‘Handler_read_first’, ’1100773′ ‘Handler_read_key’, ’2491307870′ ‘Handler_read_next’, ’1266206297′ ‘Handler_read_prev’, ’0′ ‘Handler… mysql conf: [mysqld] server-id=5908 port=3309 socket=/tmp/mysql.sock pid-file=/var/run/mysql…
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 139 Comments
… query with ORDER BY, LIMIT and with paging — Handler_read_rnd 12 M Handler_read_rnd_next 4,483 M Created_tmp… 12 M — Actual my.cnf: [mysqld] datadir = /var/lib/mysql socket = /var/lib/mysql/mysql.sock user=mysql # Default to using… with Apache 2.2. Mysql ver. 5.0.45 via socket on x86_64 centos 5.2, 1 CPU 4core with…
Post: Worse than DDOS
August 18, 2008 By 5 Comments
… needs. If you’re using PHP functions make sure default_socket_timeout has proper value or set it per session. Set… setting timeout is not enough. Beware of PHP sessions “files” handler I already wrote about this topic, but when troubleshooting this all takes another angle. Default file handler means file gets locked while PHP request is being served…
