June 20, 2013

Post: MySQL Backup tools used by Percona Remote DBA for MySQL

March 13, 2013 By 8 Comments

… was corrupt and mysql shuts down Your server or RAID controller crashes and all data is lost on… binlogs off your primary server so you can perform point in time recovery. Store your binlogs offsite… myisam tables Built in compression Each table is dumped to a separate file. This is very important to…

Filed Under: Cloud and NoSQL, Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , , , , ,

Post: Why you should ignore MySQL's key cache hit ratio

February 28, 2010 By 28 Comments

… are identically tuned, and they have identical data, hardware, and workload. Even that doesn’t help… to MyISAM tables. Consider your mixture of storage engines (some InnoDB, some MyISAM, which is more important …MySQL to guide your decisions. It is also not the be-all and end-all of MySQL performance…

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…important goals too. We want to know what your concerns are at this stage. Is it the current performance, future performance… settings and status pretty quickly. Analyzing MySQL‘s workload and data After I’m done with … indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it…

Filed Under: Insight for Developers Tagged With:

Post: High-Performance Click Analysis with MySQL

December 22, 2008 By 13 Comments

…is important is that nested-loop joins on large data sets are very expensive.  If MySQL supported sort…cost of repairing huge MyISAM tables and taking downtime, I would not use MyISAM for anything but read…  The problem is that MySQL doesn’t tend to perform well on a data warehousing workload.  The…

Filed Under: Insight for Developers Tagged With: , , , ,

Post: MySQL Performance on Memory Appliance

March 31, 2008 By 23 Comments

… check out MySQL Performance on “Memory Appliance” by …MyISAM with myisam_use_mmap option which did not seems to give any significant performance benefit, may be even reducing performance…important things about Innodb – it just loves to have as much data in buffer pool as possible for best performance…

Filed Under: Benchmarks Tagged With: , ,

Post: How much overhead is caused by on disk temporary tables

August 16, 2007 By 26 Comments

…’m using ORDER BY NULL clause as otherwise MySQL will sort the data after performing group by which is overhead we’re not… here is the summary: key_buffer_size is important for MyISAM temporary tables performance to avoid OS writes OS Write cache is not… least on Linux Performance of Disk MyISAM tables may not scale proportionally with table size, even when all data fits in memory MEMORY…

Filed Under: Benchmarks, Insight for DBAs Tagged With:

Post: MySQL Users Conference - Innodb

May 9, 2007 By 6 Comments

… for example will LOAD DATA INFILE be optimized same way as for MyISAM tables by separate phase … mode which will start offering more performance benefits in MySQL 5.1 It also should be …it is still important. IO Scalability patches Mark Callaghan from Google released so many MySQL patches so …

Filed Under: Events and Announcements Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… results returned from a MyISAM FTS query will be exactly identical to the same query when performed against InnoDB data, OR that the… that it matches MyISAM‘s default ft_min_word_length. First, MyISAM, with MySQL 5.5, on the SEO data set: mysql: SELECT id, title… important best practice even if FTS isn’t involved. Always test how your application behaves as a result of a major MySQL…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Predicting how long data load would take

May 24, 2007 By 14 Comments

…. Data Insert Order It is well known it is important to load data in primary key order into Innodb tables for optimal performance, but…. MySQL Configuration Different storage engines have different settings which need to be set for optimal load speed. Depending on load type MyISAM…

Filed Under: Insight for DBAs Tagged With: ,

Post: MySQL Server Variables - SQL layer or Storage Engine specific.

June 8, 2006 By 14 Comments

…mean MyISAM variables are not important ? Not really. You still have some tables in MyISAM format in “mysql” …_write Delay updating indexes for MyISAM tables. Good for performance but tables will be badly corrupted …(row data is not cached). Used only for MyISAM tables. If you do not use MyISAM tables…

Filed Under: Insight for DBAs Tagged With: ,
« Older Posts
Newer Posts »