… Server has introduced innodb_read_views_memory and innodb_descriptors_… where an unprivileged MySQL account owner could perform brute-force password …MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server for MySQL…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…, it’s currently up and available for viewing over at percona.com. My apologies if …MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL…want to use MySQL on top of something like that? I can’t imagine the performance being …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance…
Post: MySQL VIEW as performance troublemaker
August 12, 2007 By 57 Comments
… derived tables MySQL 5.0 will fail and perform very inefficiently in many counts. MySQL has two ways of handling the VIEWS – query merge, in which case VIEW is simply…_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 So how would you get number of comments left by the given user ? mysql> select count…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…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…performed without temporary table or external sort. Q: How can we manage indexes on servers from DBA point of view…
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
… problematic queries is very powerful tool for MySQL Performance optimization. If you’ve been using this …cache as it can for MyISAM. EXPLAIN may take long time In MySQL 5.0 with addition …least an alternative view. If you want to find more information about understanding EXPLAIN output, MySQL manual …
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…MyISAM, for example Arjen wrote pretty nice article about MyISAM features so I thought I would share my own view on using MyISAM…performance for small application. As load increases you might convert certain tables to MyISAM and other storage engines for performance… MyISAM tables. Recovery. MySQL was…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…, movie etc was viewed. This is sometimes handy feature but it can be rather expensive from performance point of view. The nasty thing… caches stuff and you can’t easily tell it to perform certain action (ie write back to the database) when object… use memcache + another mysql instance (or simply the database which is not replicated) to log updates in heap/myisam/archive table and…
Post: Using VIEW to reduce number of tables used
September 28, 2007 By 12 Comments
…challenges in IO management and recovery. For MyISAM it works better but still overhead can…views, specially INSTEAD OF triggers so you could write triggers to perform insert inserts to base tables instead of views…of the view so would not be available even if MySQL would support triggers on VIEWs (…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…, from the practical point of view, you should have ntpd running, … replication, galera and built-in mysql replication are independent from each other….MyISAM support is experimental. Apart from some very special, edge cases, I would not recommend using MyISAM. Q: How does write performance…
