…/mysql/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4 of log file size. On… MySQLDB performance cracks like Baron recommend you to be on the safe / perfect side. innodb_log_file_size is always a fixed….g instead of 32M x 4 = 128M innodb_buffer_pool_size). According to my previous posts in this blog a dynamic…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…_buffer_size, while MariaDB introduces a different variable to control the MRR buffer size mrr_buffer_size. Both buffer sizes default to 256K in MySQL… query execution plan, is not sufficiently tuned and it is recommended to turn this off. The query used is: select c… MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M MariaDB 5.5 MariaDB 5.5 w/ mrr_buffer_size…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… (i.e. xfs) should be used. Traditionally our recommendation is xfs, and it comes to known problem … point to consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona … in 4 do sysbench –test=fileio –file-total-size=${size}G –file-test-mode=rndwr –max-time=3600 –…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… line looks like: sysbench –test=fileio –file-total-size=${size}G –file-test-mode=rndwr –max-time=18000 … and random writes do not allow me to recommend this drive for a database server usage, even … interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-9…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
… high value. Sample my.cnf values on large memory sizes recommend 1M settings and MySQL built-in default is 128K. Some people having… check things out I’ve created table with simple structure: mysql> show create table dt2 \G *************************** 1. row *************************** Table: dt2 Create…, with 3 runs and averaged results. MySQL 5.1.21-beta was used for tests. mysql> select count(*) from dt2 where slack…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… [1] recommends using the innodb_max_dirty_pages_pct and innodb_io_capacity parameters to get stable throughput in MySQL 5.5… buffer_pool_size to data. For the initial tests, I used MySQL 5.5.8 (the tar.gz binary from dev.mysql.com… within 3/4 of the limit of the total log size (total size is 2000MB*2). The 15-minute average throughput is…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
…_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 1900M innodb_log_files_in_group… we were using SSD as storage, then I would recommend it. Vanilla MySQL performs equally bad on SSD and HDD, while for… results on Percona Server. So first recommendation you may hear in this case from the Oracle/MySQL engineers is to decrease “innodb…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… you want us to analyze and present recommendations for your consideration, and take a …mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table_size | 268435456 …
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… memory size on the big boxes, though it can be even less than that. Besides Operating System needs you also have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, per thread sort… pool. I guess these clarifications work better than 70-80% recommendation and of course you should not stick just to 50GB…
Comment: Upgrading MySQL
January 17, 2010 By 23 Comments
… and also how you are using MySQL. MySQL often recommends (if possible) doing an upgrade by doing a MySQL dump of the databases and… tables. Recommendation by the mysql_upgrade binary is to dump the tables and then load them back. Of course to run mysql_upgrade… small mysql server, but also at least mentions the issues that need to be taken into account when the server size gets…
