June 20, 2013

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

May 2, 2013 By 10 Comments

Mrten, Galera/PXC handles the privileges differently even if these tables are MyISAM – simply do not make direct modification to them instead use the usual commands i.e. GRANT, DROP USER, etc

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

Post: Using MyISAM in production

June 17, 2006 By 36 Comments

… about MyISAM, for example Arjen wrote pretty nice article about MyISAM features so I thought I would share my own view on using MyISAM in production. For me it is not only about table locks. Table locks is only one of MyISAM limitations… list of items you need to keep into account while using MyISAM tables. Recovery. MySQL was running stable for us, giving us…

Filed Under: Insight for DBAs Tagged With: ,

Post: Should you move from MyISAM to Innodb ?

January 12, 2009 By 59 Comments

There is significant portion of customers which are still using MyISAM when they come to us, so one of the big … would not switch table to MyISAM because it gives 5% performance improvement but I can perfectly use MyISAM (or Archive) for logging. Innodb Needs Tuning As a final note about MyISAM to Innodb migration I…

Filed Under: Insight for DBAs Tagged With: , ,

Post: Using CHAR keys for joins, how much is the overhead ?

June 18, 2007 By 18 Comments

… benchmark. The results below are for MySQL 5.1.18 using MyISAM and Innodb tables. This time unlike other benchmarks I decided… joining on the integer. In fact this was expected as MyISAM uses key compression for varchar columns so random key lookups become… from few percent to couple of times for Innodb tables MyISAM Tables may suffer significantly if key compression is not disabled…

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

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

March 13, 2013 By 8 Comments

… you have a lot of non-transactional tables (i.e. myisam), use –rsync option. This will rsync a copy of all the… myisam tables are dumped. We are researching into how we could further improve lock times here when non-transactional tables are used Almost no locking, if not using myisam tables Built in compression Each table is…

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

Post: Getting annoyed with MyISAM multiple key caches.

May 1, 2009 By 11 Comments

… wrote few times using multiple key caches is a great way to get CPU scalability if you’re using MyISAM. It is however… the caches I need to see number of accesses, blocks used, number of misses. Such basic feature either does not exist… is not documented. I’m not sure how relevant is MyISAM with MariaDB on a way but this is surely sad…

Filed Under: Insight for DBAs Tagged With:

Post: Crashes while using MyISAM with multiple key caches

July 18, 2009 By Leave a Comment

… random MySQL crashes in production when multiple key caches were used. Unfortunately this never was frequent or critical enough issue so… resize. It is just this code most actively used in case you’re using multiple key caches. It is very rare one… run into the bug – In my practice number of people using multiple key caches with relatively light load never ran into…

Filed Under: Insight for DBAs Tagged With: ,

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

June 8, 2006 By 14 Comments

… with MyISAM tables these are MyISAM related. join_buffer_size Buffer used for joins without indexes and few other cases. It is used by… Key Buffer used to buffer Index blocks (row data is not cached). Used only for MyISAM tables. If you do not use MyISAM tables still keep it 4-32MB to be used for temporary tables…

Filed Under: Insight for DBAs Tagged With: ,

Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1

January 8, 2007 By 117 Comments

… KB 16GB of RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14… 2). There MyISAM shows bad scalability with increasing count of thread. I think the reason is pread system call MyISAM uses to access… and %d MyISAM scales good here, because of access only to key column and ‘pread’ syscall is not used. READ_KEY_RANGE…

Filed Under: Benchmarks Tagged With: ,

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

February 26, 2013 By 1 Comment

… a very big fan of MyISAM; I would argue that in most situations, any possible advantages to using MyISAM are far outweighed by the potential disadvantages and the strengths of InnoDB. However, up until MySQL 5.6, MyISAM was… would be a migration to InnoDB, but due to their use of MyISAM FTS, the idea of a complete or partial migration…

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