…MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections but yet MySQL…(406936 + 18144) Dictionary memory allocated 2623331 Buffer pool size 7864319 Buffer pool size, bytes 128849002496 Free buffers 1 Database pages 8252672 Old…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | | SORT_BUFFER_SIZE | 2097152 | 262144 | | LC_MESSAGES_DIR | /mnt/nfs/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6…_VERSION | 5.5.30 | 1.2.10 | | INNODB_BUFFER_POOL_INSTANCES | 1 | 8 | | QUERY_CACHE_SIZE | 0 | 1048576 | | SLOW_QUERY_LOG_FILE | /mnt… now set to 1000 making Innodb Buffer Pool Size scan resistant by default. Very welcome change ! thread_cache_size is enabled by default, though…
Post: Innodb Recovery - Is large buffer pool always better ?
July 17, 2007 By 3 Comments
How does Buffer Pool size affects Innodb Performance ? I always expected the effect to be positive, Innodb with large buffer pool to performing better. Including… the page. So I took a shot at restarting MySQL with much smaller buffer pool size and we got it recovered much faster. Interesting…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… can only do good” change as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most important they often come with a need of warmup, because buffer pool…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should allow it….28-29.1 on it with 6GB allocated for innodb_buffer_pool which with other memory needs leaves roughly 1GB for OS…) The table is approximately 30GB in size including indexes which is way more than buffer pool size and OS cache which is available. I…
Post: How Much memory do you use to run MySQL
November 2, 2012 By 8 Comments
… range from problems with large size Query Cache to bad drop table performance with large Innodb Buffer Pool size. As such I wonder how much memory do we really use to run MySQL Server these days ? [poll id="2"] Feel free to select multiple sizes if you have multiple…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…’t something you should expect to deliver huge wins. If MySQL is actually badly configured, you can hurt its performance significantly… common ones I see are not configuring the InnoDB buffer pool size or log file size, and not using InnoDB. If your server really…, I sometimes see unlikely settings, such as making the sort buffer size much too large (a gigabyte comes to mind). As a…
Post: Should MySQL update the default innodb_log_file_size?
November 21, 2011 By 37 Comments
… engine in MySQL, is it time to update the default configuration for the InnoDB log file size (innodb_log_file_size) setting? In… installation. MySQL 5.5 increased the default buffer pool size to something more sane (128MB instead of 8MB), but the log file size remains at… you think? Write your suggestion for a default log file size into the comments. By the way, if you’re looking…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… to have a single separate dedicated purge thread and in MySQL 5.6.2 one can have multiple dedicated purge threads… and the relevant my.cnf settings were innodb_buffer_pool_size=16G innodb_log_file_size=1900M innodb_flush_log_at_trx_commit=2… to not to penalize further TPS. MySQL 5.6.2 Results Now let’s test MySQL 5.6.2. It is important…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… are the contents of the buffer pool in pages afterwards: mysql> select sq.*, pages / (@@innodb_buffer_pool_size / 16384) * 100 pct_buffer_pool from ( select table_name, index… rows in set (0.00 sec) mysql> select sq.*, pages / ((@@innodb_buffer_pool_size / 16384)) * 100 pct_buffer_pool from ( select table_name, index_name, count…
