June 19, 2013

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

June 7, 2013 By Leave a Comment

… For example, if you see a large number of long-running queries in the output of SHOW PROCESSLIST that …isn’t anything quite like that in the MySQL world, except maybe MyISAM files on top of a clustered …get the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but …

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

Post: Using MyISAM in production

June 17, 2006 By 36 Comments

…. If this happened make sure you have decent myisam_sort_buffer_size and large myisam_max_sort_file_size otherwise recovery may be…. MyISAM uses table locks and has concurrent inserts which can go concurrently with selects. This is sometimes presented as great concurrency for inserts… select statements but it has to be one insert at the time. Happily inserts in MyISAM are rather fast so it rarely is the…

Filed Under: Insight for DBAs Tagged With: ,

Post: Concatenating MyISAM files

November 19, 2012 By 5 Comments

Recently, I found myself involved in the migration of a large read-only InnoDB database to MyISAM (eventually packed). The only issue was…, 23B rows. Not small… I calculated that with something like insert into MyISAM_table… select * from Innodb_table… would take about 10… was simply to do insert into MyISAM_table select * from MyISAM_table1 and so on for the 16 files. Since MyISAM are flat files…

Filed Under: MySQL

Post: Beware of MyISAM Key Cache mutex contention

August 12, 2008 By 10 Comments

…insert rate… or so it seemed. In reality inserting in parallel into different tables when indexes fit in memory results in… to the thread local space. Happily MyISAM allows you to create multiple key caches ….not expect so large difference for Inserts. I have already wrote about very large impact on…

Filed Under: Insight for DBAs Tagged With: ,

Post: Quick comparison of MyISAM, Infobright, and MonetDB

September 29, 2009 By 30 Comments

… who has MyISAM tables with many columns (the same one Peter wrote about recently). The client’s performance is suffering in part… SQL statements. I wanted to see how fast MyISAM vs. MonetDB would interpret really large INSERT statements, the kind produced by mysqldump. But… it: you can, should you choose to, give it instructions in MonetDB Assembly Language (MAL), the underlying language. An abstracted front…

Filed Under: MySQL Tagged With: , , ,

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

June 8, 2006 By 14 Comments

…in MyISAM format in “mysql” database. Plus HEAP/MEMORY tables are used for temporary tables which may become MyISAM if they are large…

Filed Under: Insight for DBAs Tagged With: ,

Post: Predicting how long data load would take

May 24, 2007 By 14 Comments

… not end here. If indexes are built by inserts in Btree order in which entries are inserted in the index can affect performance dramatically. Table… type MyISAM may benefit from bulk_insert_tree_size increase myisam_sort_buffer_size or key_buffer_size increase. Innodb typically needs large innodb…

Filed Under: Insight for DBAs Tagged With: ,

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

February 26, 2013 By 1 Comment

… full-text search), that’s largely where the similarities end. NOTE 1…MyISAM rather than InnoDB. Loading the data was done via a simple Perl script, inserting….dir_test_innodb | optimize | status | OK | +———————-+———-+———-+———-+ 1 row in set (4.60 sec) mysql> select …

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

Post: High-Performance Click Analysis with MySQL

December 22, 2008 By 13 Comments

… cost of repairing huge MyISAM tables and taking downtime, I would not use MyISAM for anything but read-… hard-to-scale database server for the initial insertion, because you can write CSV files with any … queries, but that’s often justified by a large reduction in table size. I sort of stumbled upon …

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

Comment: Innodb Performance Optimization Basics

April 25, 2008 By 75 Comments

… than MyISAM to insert the data – it all depends on what you’re looking at. For inserts in single table by single user MyISAM most likely will win because of Transactional overhead in Innodb, however if you have large system and many concurrent inserts or…

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