June 19, 2013

Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL

May 1, 2013 By 10 Comments

…Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump… reasons to stay with MyISAM nowadays i.e. if you have FULLTEXT you simply cannot replace in short term. Control …Although the previous bug has been fixed on latest release (5.5.30-23.7.4), table without PK imposes an …

Filed Under: Insight for DBAs, MySQL, Percona Software, XtraDB Cluster Tagged With: , , , ,

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

March 4, 2013 By 7 Comments

… with name, address, and the like. We are using MySQL 5.5.30 and MySQL 5.6.10 with no configuration tuning other than to…) so 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… to use InnoDB FTS as a simple drop-in replacement for your current MyISAM FTS, the results may surprise you. That last…

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

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… to using MyISAM are far outweighed by the potential disadvantages and the strengths of InnoDB. However, up until MySQL 5.6, MyISAM was the… that InnoDB full-text search in MySQL 5.6 (part 1) in MySQL 5.6 is syntactically identical to MyISAM full-text search, in the… table for the SEO dataset looks identical, except that we replace “full_name” with a VARCHAR(255) “title” and “details” with…

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

Post: MySQL Upgrade Webinar Questions Followup

June 28, 2012 By 7 Comments

… to 5.5 for MyISAM tables? MyISAM have not been getting any significant development since MySQL 4.1, so in-place upgrade of MySQL 5.0 to MySQL 5.5… from MySQL 5.5 to Percona Server 5.5 Compatibility is our highest priority with Percona Server, so it should be good as drop in replacement…

Filed Under: Insight for DBAs, MySQL

Post: Finding your MySQL High-Availability solution – The questions

October 16, 2009 By 36 Comments

… with MMM manager 99% Heartbeat/SAN (depends on SAN) 99.5% to 99.9% Heartbeat/DRBD 99.9% NDB Cluster 99… MyISAM. The HA solutions that work well with MyISAM are “MySQL replication” and “Master-Master with MMM manager”. Depending on the application, the MyISAM Full text indexes might be replaced by…

Filed Under: Insight for DBAs, MySQL Tagged With:

Post: MySQL Error control changes

February 19, 2007 By 4 Comments

In MySQL 5.0 mainly error control was improved, such as strict mode was added to change famous MySQL behavior of cutting too… but forgot to delete old ones) MySQL Server simply would not start. In recent MySQL 5.0 series however it will continue loading… from storage engines which failed to initialize are not automatically replaced with empty MyISAM tables of the same structure :)

Filed Under: Insight for Developers Tagged With:

Post: MySQL Indexing Best Practices: Webinar Questions Followup

August 16, 2012 By 4 Comments

… Q: One developer on our team wants to replace longish (25-30) indexed varchars with an …key is appended to it internally anyway. For MyISAM table you should use K(id2,id1) …5” and “`id` IN (5)” regarding indexes and performance? A: Recent MySQL versions are smart enough to convert id IN (5) to ID=5…

Filed Under: Insight for DBAs, MySQL

Post: Return of the Query Cache, win a Percona Live ticket

August 26, 2011 By 4 Comments

…-point in the server. Now that’s gone. As of MySQL 5.5, the query cache mutex isn’t hit at all if… 5.5, and instead backported the 5.5 fix to our 5.1 branch and replaced our fix. There are some other query cache improvements in MySQL 5.5… you used to be able to see that you had MyISAM problems really easily when you had a screen full of…

Filed Under: Events and Announcements, Insight for DBAs, MySQL

Post: Dynamic row format for MEMORY tables

September 6, 2011 By 5 Comments

… true-VARCHAR support for MEMORY tables for MySQL 5.0. Although this patch did not add … depending on MEMORY tables, they are no replacement for application-specific tests. We start by …important feature is missing from this release however: MyISAM tables are still used for temporary tables …

Filed Under: MySQL, Percona Software

Post: MySQL Slow query log in the table

May 31, 2007 By 1 Comment

…MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as… I found even if I convert table to MyISAM, disable concurrent inserts and run long reporting …procedure to “normalize” query by removing comments and replacing constants with some placeholders as this would allow…

Filed Under: Insight for DBAs Tagged With:
« Older Posts