… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer… by query cache on write heavy workload. OK, so that was all about the configuration of the EC2 instance and MySQL. Now…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… async IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load… wild guess about drops – the drive periodically cleans an internal cache or something. To understand better what kind of response time… you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-9. It…
Comment: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 27, 2012 By 10 Comments
…? I know it’s not normally an environment to run MySQL on, but IF there’s reasonable advantage with SSDs, then… these issues are related to the GC or the internal cache issue..
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… Check for Table Cache Related Allocations There are cases when MySQL will allocate a lot of memory for table cache, especially if you… have created which temporary tables (both in memory and not): mysql> select * from information_schema.global_temporary_tables \G *************************** 1. row… and fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…’ optimizer_switch=’join_cache_incremental=on’ optimizer_switch=’join_cache_hashed=on’ optimizer_switch=’join_cache_bka=on’ join_cache_level=8 join_buffer… 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5 the query… a look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… case of MySQL 5.5 and ~5 hours in case of MySQL 5.6 and MariaDB 5.5. Note that query cache is… on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M…, there is no difference in query times between MySQL 5.5 and MySQL 5.6/MariaDB 5.5 This is another area…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places… key cache for improved scalability That’s really just a sampling. A good starting point for learning more is the MySQL versus… more choice than ever — there are three great versions of MySQL that suit different needs and personalities, with different characteristics, and…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
…. The new xbstream format works with parallel compression to (without caching) stream several compressed files at once. tar4ibd functionality is replaced…
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
… have my website develop in PHP with MYSQL, these are MYSQL values: datadir=/data/mysql socket=/data/mysql/mysql.sock max_connections = 600 wait_timeout…/log/mysql-slow-queries.log long_query_time=15 log-queries-not-using-indexes query_cache_type=1 query_cache_size=32M thread_cache_size=30 table_cache=4096 join_buffer_size=6M key_buffer_size=12M server-id = 1 log-bin=/data/mysql/drbd…
