… sets of MySQL configuration parameters. For example, given that the front-end device is a …what‘s actually happening on the system during all these various tests. Clockwise from the top left in…_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…in PXC can be a master or a slave on asynchronous replication, galera and built-in mysql…What about myisam storage? is it safe to use it? Does xtrabackup works as a sst method for myisam? A: Yes, but for MyISAM xtrabackup is…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…what the operating parameters are. Can we suggest upgrades, rewriting queries, or whatnot? Sometimes there are rigid constraints on what…is happening 6 times every ten seconds. We need to figure out what is happening because it can indicate something else is wrong. This is…in mysql…
Post: Getting annoyed with MyISAM multiple key caches.
May 1, 2009 By 11 Comments
…can access is key cache parameters – via structured variables In …what you have created. See the mappings I can now map tables to be cached in different key caches but there is…is MyISAM with MariaDB on a way but this is surely sad to see the feature of multiple key caches first introduced in MySQL…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… MyISAM and InnoDB in both…MySQL Backup API which was originally implemented in MySQL 6.0. This feature is now scheduled for an upcoming version of MySQL…. What is the page size in …in this regard is twofold: I hope that most installations can get away with setting a minimum of tuning parameters, in…
Comment: Beware of MyISAM Key Cache mutex contention
January 12, 2010 By 10 Comments
… the parameters I could think of, and mysql processes showed in issue periods multiple copies of the same query, sometimes with also same parameters… Xeon cores 16gb box. What is your opinion? What do you think of Sphinx to substitute the fulltext search on MyISAM table? Peter, I…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
September 26, 2008 By 34 Comments
What about MySQL Monitor, the Monitoring tool that is part of MySQL Enterprise? I have installed MySQL Monitor and it gives specific information about parameters… MyISAM to InnoDB and vice versa, parameters in my.cnf should be modified. Unfortunately modification of certain parameters is not easy in …
Comment: What to tune in MySQL Server after installation
October 8, 2012 By 118 Comments
…myisam…mysql/mysql.sock [Server] server-id = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql…is the max conection; when we have setting this parameters in…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…is much easier than InnoDB, there only few parameters…is also that TokuDB can keep in memory much more records then InnoDB / MyISAM. Actually in internal cache records are stored in…is that MySQL does not yet provide an interface for that. This is going to be fixed in MySQL…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…/29/quick-comparison-of-myisam-infobright-and-monetdb/) this …in InfoBright. MySQL is really stupid here, and EXPLAIN for this query took 6 min! If you wonder about carriers – EV is…MonetDB. I do not know what is the magic behind the curtain…line is weak ( I had to use bash and pass query as parameter…
