…I’m in — obviously a FreeBSD box is different). For example, [percona@…Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received | 38563413074 |…checking for default users in the mysql.* tables, running mk-duplicate-key-checker …
Comment: Beware of MyISAM Key Cache mutex contention
January 12, 2010 By 10 Comments
… end to a 3 weeks long 24×7 research. MySQL 5.0.81 on FreeBSD 7.0 4 quad core Xeon 16gb I… tracks: FreeBSD bugs, MySQL bugs. One of the nights I got your post: BINGO! I immediately created 10 tailored Key Caches for each… by the fact that they use the same key_cache and the table is used for fulltext search, so no InnoDB possible…
Comment: How Percona diagnoses MySQL server stalls
March 9, 2011 By 6 Comments
… a FreeBSD 8 machine to test its new scheduler, but actually did not help (minimal). I really believe the combination FreeBSD scheduler + MySQL… the most used/concurrent tables and assigned dedicated key cache preloading it at startup. (benchmarks I did: http://caligula.mysql.name/core_tests…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… Operating System needs you also have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, per thread sort buffer which… be OS cache. You want to bypass cache for your Innodb tables but there are other things you need OS cache for – MyISAM tables (mysql database… Windows you do not need to do anything. On Linux, FreeBSD, Solaris you need to set innodb_flush_method=O_DIRECT…
Post: JOIN Performance & Charsets
October 21, 2008 By 2 Comments
…,000. The data set fit easily in memory. mysql> EXPLAIN EXTENDED SELECT SQL_NO_CACHE COUNT(t1.char_id) > FROM t1 > JOIN t2 USING (char_id)\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table….33 to 3.12 seconds. This test was performed with MySQL 5.0.67, FreeBSD 7, on a box with 2GB RAM.
Post: SystemTap - DTrace for Linux ?
September 14, 2009 By 17 Comments
… and ZFS on Solaris, FreeBSD, MacOS, but not on …tried to hack around MySQL ® probe process(“/usr/libexec/mysqld”)…. running simple SELECT against InnoDB table: stap -v lsprob.stp …cached /root/.systemtap/cache/4f/stap_4f8b8738f58ff78e294c62765ac83d91_36925.c Pass 4: using cached /root/.systemtap/cache…
Comment: Getting annoyed with MyISAM multiple key caches.
January 12, 2010 By 11 Comments
… multiple Key Caches help a bit, and helped me in a very bad mysql deadlock issue. I created ten tailored key caches for the ten most high concurrent tables and at 48… the same table by multiple threads at once. Anybody has suspects on the OS as well? I have’em on FreeBSD scheduler…
Comment: How Percona diagnoses MySQL server stalls
March 9, 2011 By 6 Comments
…’ combination: MyISAM mutex on the key cache, FreeBSD scheduler, and multiple cores (on different CPUs!) (AMD) MySQL would go (once a week) into… swiches are much higher. Also creating one key cache for each high concurrency table and preloading indexes helped lower the contention. Moving…
