…go change all kind of configuration options in case you …SMALL_RESULT. Check whatever stats are the same (run SHOW INDEXES FROM for… file a bug or report the problem through MySQL support…MySQL changes between versions on Percona enhancements. Before reporting bug to Percona Server bug tracking system…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…MySQL is troubleshooting memory usage. The problem usually starts like this – you have configured MySQL…File system 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560) Recovery system…small blocks, it should be just swapped out and when never needed again. So if you see swap file…
Post: Learning about MySQL Table Fragmentation
May 1, 2008 By 20 Comments
…read rate or you would see MySQL becoming CPU bound if IO subsystem…10MB/sec which is very low for this system which had 6 15K SAS…small IO request sizes in iostat and simply read speed. Like for the customer in question I saw file… if file fragmentation is the issue or it is poor or miss configured IO…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…my favorite MySQL configurations for high availability is master-master replication, which is … problem on small systems, but with buffer pools in the dozens of gigabytes (which is arguably “small” these days),…I loaded this file into a table on my laptop with LOAD DATA INFILE and kept it for later….
Post: Announcing Percona XtraBackup 2.0.5
January 23, 2013 By Leave a Comment
…file has been introduced. This option specifies from what extra file to read the default MySQL options before the standard defaults-file…for the dedicated backup user from a separate configuration file, to avoid storing it in the crontab or a script somewhere in the system…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… do anything to align InnoDB pages – file system takes care of it (assuming you configure the file system correctly). I would however mention couple things… you gonna be writing small (say 500 byte) files mostly, it’s best to use 512-byte blocks, for bigger files 4k may make…). You want to know that when setting parameters for file system but when RAID is configured, there’s nothing more you can do about…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
…MySQL related and part related to LAMP in general) of system which does quite a bit of content delivery, serving file…configured well. In this case however the problem was zero TTL set in DNS configuration. This obviously adds latency especially for…lot of small files which can fit in squid (for …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…for these non-mysql processes drops rapidly when you increase the amount of system memory. We just deployed a new Linux/Mysql server for… the available RAM as its file cache. The ideal configuration in a dedicated server is:…small OS file cache. I am not sure if Linux currently has any switch for this…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…system. It is worth to note MySQL actually uses midpoint insertion for its buffer pool replacement policy . Unfortunately by default it is configured…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…configuration and look for tuning ideas or try to read between the lines. For example we can see for J2EE the system…mysql/var innodb_data_file_path = ibdata1:10000M:autoextend innodb_file_per_table innodb_log_group_home_dir = /log/mysql… you have queries which only do small sorts it is indeed better …
