…/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on… table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine=myisam…_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer_size=10G # Disabling symbolic-links is recommended to prevent assorted security…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… bugs at http://bugs.percona.com/ key_buffer_size=52428800 read_buffer_size=131072 max_used_connections=13 max_threads=2002 thread… that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4432877 K bytes of memory Hope…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… query cache by set global query_cache_size = 0; All this on a fairly decent size server where I have 6GB innodb_buffer_pool_size split into 3 innodb_buffer_pool…
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
Yves: The problem with your config is this: “limit ARC size to 4GB” ZFS needs a significant portion of ram to… the file system vs the InnoDB caching. However, limited ARC size also limits ZFS file system’s internal metadata caching(which…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…. Bug fixed #1185686. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would make server stop… cause small tablespaces to expand too fast around 500KB tablespace size. Bug fixed #1169494. Fixed the RPM package dependencies issues. Bug…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… DROP INDEX `redundant`, ADD INDEX `redundant` (`col2`); # ######################################################################## # Summary of indexes # ######################################################################## # Size Duplicate Indexes 9 # Total Duplicate Indexes 1 # Total Indexes 2…
Comment: ZFS on Linux and MySQL
May 28, 2013 By 17 Comments
… adler32) and space (to store it) for a 4k block size. lzjb seems interesting, hadn’t heard of it before. @Nils… other of XFS itself. In case of InnoDB, the block size – 16k – is much larger than 4k and so overhead may…
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
….5/en/innodb-performance-recovery.html “If you kept the size of your redo log files artificially low because recovery took…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…. Bug fixed #1186690. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would make server stop…
Comment: MySQL Query Patterns, Optimized - Webinar questions followup
June 5, 2013 By 2 Comments
Hi Oleksii, thanks for viewing my webinar and your comments. I use the short index names because the alternative would require the font size on the slides to be very small. I know that abbreviated index names are harder to understand, but hopefully the tradeoff is the right one.
