…a gallery with select query with ORDER BY, LIMIT and with paging — Handler_read_rnd 12 … /var/lib/mysql socket = /var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x #…Mysql ver. 5.0.45 via socket on x86_64 centos 5.2, 1 CPU 4core with 4 Gb RAM…
Comment: Innodb Performance Optimization Basics
March 30, 2009 By 75 Comments
… Quad Dual Core 4GB Ram, Server 2003 and using MySQL 5.0. Query cache size is 156M and limit is 8M. All tables except one are INNO DB and its buffer pool size is 1024M. The end user client… is increasing rapidly. I have got hold of High Performance MySQL but any hints where should I be looking at first…
Comment: MySQL random freezes could be the query cache
March 27, 2009 By 23 Comments
… Quad Dual Core 4GB Ram, Server 2003 and using MySQL 5.0. Query cache size is 156M and limit is 8M. All tables except one are INNO DB and its buffer pool size is 1024M. The end user client… is increasing rapidly. I have got hold of High Performance MySQL but any hints where should I be looking at first…
Comment: What to tune in MySQL Server after installation
October 6, 2006 By 118 Comments
…, unfortunately… My VPS has 256mb ram and all of mysql resources are fine with the current…My current settings: [mysqld] max_connections = 300 max_user_connections = 300 key_buffer = 16M myisam_sort_buffer… = 2M max_connect_errors = 1000 query_cache_limit = 1M query_cache_size = 12M query_cache_type…
