June 19, 2013

Post: MySQL EXPLAIN limits and errors.

July 24, 2006 By 6 Comments

… executed – will in add index live as it can now do on Cluster ? Is it expected to rebuild index by sort of key_cache as it can for MyISAM. EXPLAIN may take long time In MySQL 5.0… some non-index based filtering applied. The other reason for difference is join_buffer which reduces number of passes MySQL had to…

Filed Under: Insight for Developers Tagged With: ,

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

February 26, 2013 By 1 Comment

…myisam.frm -rw-rw—-. 1 mysql mysql 155011048 Feb 19 17:17 dir_test_myisam.MYD -rw-rw—-. 1 mysql mysql…rebuild the table. -rw-rw—-. 1 mysql mysql 98304 Feb 20 18:57 FTS_0000000000000025_ADDED.ibd -rw-rw—-. 1 mysql mysql… FT indexes, it’s entirely possible to DROP multiple FT indexes with …

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

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

March 4, 2013 By 7 Comments

…: mysql: SHOW CREATE TABLE innodb_myisam_stopword\G *************************** 1. row *************************** Table: innodb_myisam_stopword Create Table: CREATE TABLE `innodb_myisam_…rebuild our FT index on the InnoDB table and try the above queries one more time. We already know what the MyISAM…

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

Comment: Why MySQL could be slow with large tables ?

November 29, 2006 By 141 Comments

Normally MySQL is rather fast loading data in MyISAM table, but there is exception, which is when it can’t rebuild indexes by sort but builds them row by row instead. It can be happening due to wrong configuration (ie too small myisam_max_sort_file_size or myisam_max_extra_sort_file_size) or it…

Filed Under: Insight for DBAs Tagged With: ,

Post: What to do with MySQL Full Text Search while migrating to Innodb ?

September 10, 2009 By 12 Comments

… Search indexes which are not supported for Innodb tables. So what can you do ? Leave Tables as MyISAM The beauty of MySQL storage… a “shadow” MyISAM table which is used for full text search. In certain cases you can just use MySQL triggers to maintain… contention on the writes. In this case you can just rebuild the table from Innodb source on regular basics. In case…

Filed Under: Insight for Developers Tagged With: ,

Comment: Why MySQL could be slow with large tables ?

June 17, 2008 By 141 Comments

Normally MySQL is rather fast loading data in MyISAM table, but there is exception, which is when it can’t rebuild indexes by sort but builds them row by row instead. It can be happening due to wrong configuration (ie too small myisam_max_sort_file_size or myisam_max_extra_sort_file_size) or it…

Filed Under: Insight for DBAs Tagged With: ,

Post: Recovering Innodb table Corruption

July 4, 2008 By 22 Comments

… having data corrupted in secondary indexes, in which case simple OPTIMIZE TABLE could be enough to rebuild it, but it is much…’m using MyISAM table for the reason you’ll see later. You may think why do not you simply rebuild table by… may want to CHECK your MyISAM table you use for recovery after MySQL crashes to make sure indexes are not corrupted. So we…

Filed Under: Insight for DBAs Tagged With:

Post: Hacking to make ALTER TABLE online for certain changes

October 29, 2007 By 26 Comments

…MyISAM, you’d usually ALTER TABLE `huge_table` CHANGE `id` `id` int(6) NOT NULL and then wait hours for table rebuild to complete. If you’re unlucky i.e. you have a lot of indexes… violate mysql data file structure, so be really careful with that one. Default values. MySQL rebuilds table…

Filed Under: Insight for DBAs Tagged With: , ,

Post: Paul McCullagh answers your questions about PBXT

November 20, 2009 By 2 Comments

…makes performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show …) supports the MySQL Backup API which was originally implemented in MySQL 6.0. … page size does not require a rebuild because a page of records …the versions in indexes, and can PBXT use MVCC for index scans? If …

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

Post: Falcon Storage Engine Design Review

January 12, 2007 By 19 Comments

… do quite frequently with MySQL :) [+] Compact Indexes Compact Indexes are great. Huge indexes is where large portion … for example changing default value needs table rebuild even though for other storage engines …row ever split into multiple parts like with MyISAM or always stored as single piece ? …

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