…a virtual-machine approach, but for the optimal production deployment you want two identical physical…one machine to another and configured with Linux network interface bonding in balance-rr mode;…” system; there really isn’t anything quite like that in the MySQL world, except maybe MyISAM files…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…of Hardware OS And Application optimization. I call this Innodb Performance Optimization Basics so these … using Linux setup LVM for database directory to get more efficient backup. EXT3 file system works OK… tuning for Innodb Especially when coming from MyISAM background there would be some changes …
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…file system cache I would normally have on database server for those things which need to be cached — system files, binary log, FRM files, MySQL MyISAM system… System | Supermicro; PDSMi; v0123456789 (Other) Service Tag | 0123456789 Platform | Linux…table which was not optimized for prolonged period …
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…mysql-5.6.10-linux-glibc2. | | PERFORMANCE_SCHEMA_MAX_COND_…but getting MyISAM because Innodb…files is expensive operation (such as using MySQL on NFS file system). innodb_data_file…_name=’OPTIMIZER_SWITCH’ \G *************************** 1. row *************************** VARIABLE_NAME: OPTIMIZER…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…file system is unaware how to align files properly. 4. Partition table and file system…
Comment: Thoughts on MySQL Replication
July 9, 2006 By 18 Comments
…problem is often overlooked for some reason. MyISAM row cache in memcached could be … – technically distributed file systems should do well for this purpose, of course if they optimize cache to…ready for serious production use. Speaking about Linux page cache efficiency – yes, thanks for catching…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…files. In fact my.cnf files are usually one of the smallest levers we can pull for server optimization. Schema and query optimization…the system. Next I continue looking around the server. Holding with the assumption of GNU/Linux… that it’s time to convert MyISAM tables to InnoDB. (But then again, …
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…Innodb Performance Optimization got a lot of comments choosing proper… important processes to make room for file cache. OS may find it unfair … “si/so” columns are zero on Linux. Couple of swaps per minute would … for dedicated Innodb system. If you have fair amount of MyISAM, Archive, PBXT, Falcon …
Post: The tool I've been waiting for years
March 18, 2008 By 10 Comments
… data per table for MyISAM and Archive tables to INFORMATION_SCHEMA (or other system tables) which would be … large portion of table is cached would allow optimizer to take much smarter decisions in many cases…. it can’t perform direct IO to log files on Linux because it is not aligned. [root@DB01 …
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…optimizations…system and additionally allows marginal database downtime. It should also work on virtually any Linux distribution and possibly under most other systems…MyISAM…
