…with a Xeon E5-2680 (8 cores, 16 threads) with fast IO (OCZ R4 1.6TB) …performance_schema For the InnoDB tests, a 64GB buffer pool was used. O_DIRECT was used so, there was no caching…ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…-file=/etc/my.cnf (if this is where your my.cnf file is …cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona/mysql…mysql-5.5.28/usr/sbin/mysqld) | | | ->10.10% (7,135,744B) 0x3ECF60677B: start_thread… that the default options will perform well in most scenario’s…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…thread and in MySQL 5.6.2 one can have multiple dedicated purge threads. Percona Server 5.1 supports multiple purge threads…performed on Percona’s R900 machine. The scripts and results are on Benchmark Wiki and the relevant my.cnf…per_table max_connections=2000 table_cache=2000 Percona Server 5.1 …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… usage and performance of the splitter. It is multi-threaded(actually multi-… my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-…cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…my.cnf configuration: [mysqld] datadir=/data/mysql…cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M thread_cache_size = 32 query_cache…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL…’ve seen values over 100.000 used. thread_cache Thread creation/destructions can be expensive, which …workload. P.S Note MySQL distribution contains bunch of sample my.cnf files which may be …
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf…thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…restart performance and has the advantage of persisting across machine restarts. The configuration variables for my.cnf… Fixes When adding a table to the cache, the server may evict and close …stopping the Slave SQL thread. Bugs Fixed #813587 / #51196 and #61790 in MySQL (Alexey Kopytov). …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… lot of us are using MySQL because it seems to offer the neccessary performance. Are we just … cache. The ideal configuration in a dedicated server is: set innodb_flush_method=O_DIRECT in my.cnf… into the development process? HT: Contention and thread thrashing depends very much on the hardware,…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
… My.cnf ========== freehold: [client] port=3323 socket=/tmp/mysqld_mdmp.sock character-sets-dir=/home/mysqld/sys/5.5.8/share/mysql/charsets… # performance sort_buffer_size = 8M read_buffer_size = 2M query_prealloc_size = 65536 read_rnd_buffer_size = 8M table_open_cache = 1024 thread_cache…
