… envinronment are: Cache Type Cache Gets/sec Array Cache 365000 APC Cache 98000 File Cache 27000 Memcached Cache (TCP/IP) 12200 MySQL Query Cache (TCP/IP) 9900 MySQL Query Cache (Unix Socket) 13500 Selecting from table (TCP/IP) 5100 Selecting from table (Unix Socket…
Comment: Cache Performance Comparison
October 4, 2007 By 74 Comments
… benchmarks for caching. I just rebuilt my homeserver, it’s running Wordpress/Mysql5/PHP5; now utilizing Varnish for HTTP accel, MySQL Query Cache (Unix Socket) on the database, and then the WP-Cache plugin for Wordpress. Seems I need to…
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 118 Comments
…/mysqld/mysqld.pid max_connections=255 query_cache_size=8M table_cache=510 tmp_table_size=13M thread_cache_size=12 myisam_max_sort… Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 72 days 19 hours 45 min 58 sec Threads: 1 Questions: 10163302 Slow queries: 149 Opens…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…query-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query_cache…Unix sockets…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…local-infile’ ‘–with-mysqld-user=mysql‘ ‘–with-unix-socket-path=/var/lib/mysql/mysql.sock’ ‘–with-pic’ ‘–prefix…cc patching file sql/sql_cache.cc patching file sql/…query_time=# Log all queries that have taken more than long_query_time microseconds to execute to file. This option is standard MySQL…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…needs – your system processes, page tables, socket buffers etc all need memory. I… you also have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary tables,…MySQL With 10GB Innodb buffer pool for example and see how large RSS and VSZ get in “ps” output on Unix…
