…is similar to InnoDB but, depending on your database designed and the application, it can be faster. PBXT is…/O is optimal at this stage. This is ongoing work for PBXT… of data will become less and less important. What is the …data and (approximately) 32K pages for the table data. Both sizes can be set…
Post: Sell-an-Elephant-to-your-Boss-HOWTO
August 28, 2012 By 3 Comments
…a good enough guess as the data is just way too far from you… to your manager or whoever sets project priorities and make it clear: “Our company is… is your turn to show exactly how is it wasting that much money and what to …of work and indeed it is, however it is very rewarding as you focus on what is…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…for your benefit. This is followed by a description of FlexCDC, the change data …is usually expensive. A change data capture tool can be used to implement an efficient way of refreshing them. What is Change Data… changes. The file is well commented. The example settings file should work for most MySQL…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what …MyISAM. MyISAM may work kind of OK with default key_buffer_size even with large data set but it will … and it is typically best to size your cache so it is large enough to keep most of your tables open…
Post: Tokyo Tyrant - The Extras Part I : Is it Durable?
November 10, 2009 By 5 Comments
…is actually a global transaction and locks all write operations ( used for maintenance ). What is missing here is…is a performance hit here is an understatement. The reason for this however is really how msync works…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
…your available drives. This is the easiest setup to configure and maintain and is…. Is it work …is a set of mirrored drives, so the number here is num drives / 2. RAID 5: is…=2 data = bsize…is a complicated topic, and I’ve tried to temper the complexity with what will provide the most benefit. What…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…is best done in binary mode for large data sets. Such global recovery can also put very high stress on your…is R1Soft. Though I have not had a chance to look at it in details. What is about slave loss ? The slave loss is…
Post: How fast can you sort data with MySQL ?
August 18, 2007 By 26 Comments
…is the same for all platforms or data sets) – The optimal sort_buffer_size in this case was 70K-250K which is…What do we learn from these results: Benchmark your application Unfortunately general tuning guidelines can be wrong for your…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… on the memory fit diagram – understanding your working set is paramount but taking number from other application is one of the worst mistakes you can… what is the most important. Assuming you have fixed amount of disk at your disposal and if you have BBU most likely data files is…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…solution is best? What is really tricky with MySQL is…is fairly fast at transferring data between the master and the slaves, there is a window of time where data loss is…HA solutions that work well with MyISAM … is your staff or support company? There is…depending on your project. For example, “setting …
