…system I’m working with. System performance Next I investigate what the system is doing, in terms of…high-performance system is virtually every query.) If it’s not possible to use a patched binary, we can use MySQL…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
…the system and make recovery much more complicated than simply swapping the server. This is exactly one of the reasons many high scale installations prefer Innodb – it is…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
…MySQL Performance on “Memory Appliance” by Violin Memory which can be used as extremely high speed storage system. I helped Violin Memory to optimize MySQL…load was mostly CPU bound. Next I went on testing MySQL… workload so it is quite surprising adaptive … this would be one of the Items besides CPU …
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…MySQL has no way to identify which one of them would so it gets rid of all of them. This is one of the…of the same data in cache effectively wasting memory. Distirbuted caching systems can effectively use memory on multiple systems so there is no duplication. Memcached is probably the…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…MySQL and so problem potential is larger. So lets look at the problem which happen during the crash which might need to take care of…system extremely slow and also can use up all allowed connections or run out of memory ( myisam_sort_buffer_size is…is not highly available so there is…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…is happening on the system. This is not however how things happen in real world when we have significant variance in the load…of the smaller table from the buffer pool with only 12MB remaining. This makes workload extremely IO bound hence such drop in performance. The performance of…
Post: Living with backups
November 6, 2008 By 28 Comments
…The storage is handling reads issued by the system, but only at an extremely limited rate. So when a task is reading a lot of…the actual data is always read from disk. The active portions of tables will likely be placed by the system in memory…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…MySQL features it is designed for particular load…memory OS or MySQL…extreme cases I’ve seen over 10 pieces in average per row – this is…system call is needed to get data from Operation System even when it is in cache but it is only part of the problem. The other problem is – it is…
Post: Beware: ext3 and sync-binlog do not play well together
January 21, 2009 By 19 Comments
…of our customers reported strange problem with MySQL having extremely poor performance when sync-binlog=1 is enabled, even though the system…is not RAID controller related we repeated the run on the in memory…
