… to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that…_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer pool is sized… THAN MAXVALUE ENGINE = InnoDB) */ Also, I ran 5 instances of iiBench simultaneously to simulate 5 concurrent connections writing to the table, with…
Comment: Percona Server 5.5.23-25.3 released!
May 17, 2012 By 2 Comments
@ James Ubuntu Precise (12.04 LTS) will be officially supported with the next Percona Server releases. Percona Server 5.5.24-26.0 is currently scheduled for release in the first week of June.
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
…,000/(10,000^1.1) = 39 times. Obviously with θ=0 we are getting uniform distribution – each row is accessed equal… on how many times each row selected for different θ: 0.5, 0.9, 1.1: The curve is very skewed, so I… !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait… 120502… be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait… InnoDB…:51:17 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.0.95′ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… to change the logfile size in a 5.0.95 MySQL database running on RHEL 5. I add the following line to /etc…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…. I renamed it and copied /usr/share/doc/mysql-server-5.0.95/my-medium.cnf to /etc/my.cnf After doing…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… of threads. For 8 threads the 95% response time is 0.69ms. Now let me get back to random write case…/sec. I am still interesting in asynchronous IO, as MySQL 5.5 uses async IO for writes. Maybe 8 threads in the… !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id…
Comment: Joining many tables in MySQL - optimizer_search_depth
April 23, 2012 By 5 Comments
… in 2012. So yes, the default should be changed to ‘0‘ which means “choose automatically”, which in turn means “choose depth… potential pitfalls with the change to plan pruning in MySQL 5.6. Ideally, the server should analyze the query and should…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… lowest query time is for MySQL 5.6 which takes 0.16s less as compared to MySQL 5.5 While with join_buffer_size…/ join_buffer_size=6M & read_rnd_buffer_size=6M MariaDB 5.5 MariaDB 5.5 w/ join_buffer_size=6M & mrr_buffer_size=6M MariaDB 5.5 Hash Join Disabled w/ join_buffer_size=4M & mrr_buffer_size=4M Created_tmp_disk_tables 0 0 0 0 0 0 Created_tmp…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 9 Comments
… for MySQL 5.6, increase of 0.02s. But the query times for MariaDB 5.5 are greater than both MySQL 5.5 and MySQL 5.6… calculated inside MariaDB? Other Observations Sometimes both for MariaDB 5.5 and MySQL 5.6, the optimizer chooses the wrong query execution plan… is no difference in query times between MySQL 5.5 and MySQL 5.6/MariaDB 5.5 This is another area of improvement in the…
