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
Comment: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 2, 2013 By 10 Comments
Comment: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 2, 2013 By 10 Comments
It’s a pity that the mysql databases with all the privileges are still MyISAM…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… partition (at least I have seen this happen in a MyIsam environment on similar sized tables). What I am really saying…
Comment: Percona Server 5.5.30 with TokuDB for MySQL
April 26, 2013 By 26 Comments
…. on XtraBackup support… we may have a very basic backup MyISAM-like for TokuDB. Fully functional backup will be available from…
Comment: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
and one more question “how many tables (MYISAM or INNODB) mysqld can create, the maximum number ?”
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
… am using wordpress and drupal, and i converted databases from MyISAM to InnoDB, mysql tunning script gives below results for temp…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… in comparison to InnoDB and MyISAM. The second goal of benchmark was a popular myth that MyISAM is faster than InnoDB in… LIMIT queries will be fixed before release. MyISAM shows stable result. InnoDB is better than MyISAM by 58% in case with 4… million rows. InnoDB is better than MyISAM by ~30% with 4-16 threads, but MyISAM scales a bit better in this case…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… were recently number of posts about MyISAM, for example Arjen wrote pretty nice article about MyISAM features so I thought I would… application. As load increases you might convert certain tables to MyISAM and other storage engines for performance reasons…. of course keeping… this happened make sure you have decent myisam_sort_buffer_size and large myisam_max_sort_file_size otherwise recovery may be…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… for you when you’re running MyISAM but instantly break upon upgrading to Innodb. Features The MyISAM features which forbid moving to… really gives substantial gains. I would not switch table to MyISAM because it gives 5% performance improvement but I can perfectly… defaults. I’ve seen hundreds of GB databases ran with MyISAM with default settings and it worked reasonably. Innodb needs resources…
Post: Concatenating MyISAM files
November 19, 2012 By 5 Comments
…. Not small… I calculated that with something like insert into MyISAM_table… select * from Innodb_table… would take about 10 days… to do insert into MyISAM_table select * from MyISAM_table1 and so on for the 16 files. Since MyISAM are flat files, that… -rq test_concat – check record delete-chain – recovering (with sort) MyISAM-table ‘test_concat’ Data records: 3 – Fixing index 1 myisamchk…
