…keys=on‘ (only on MariaDB 5.5) optimizer_switch=’mrr_cost_based=off’ read_rnd_buffer_size=4M (only on MySQL … to note is that MySQL 5.6 and MariaDB 5.5 are both reading more rows than MySQL 5.5…both MariaDB and MySQL 5.6 are reporting high numbers for Innodb_rows_read, which is completely in line …
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 5 Comments
…on customer case today I ran …less than 1000 rows and doing it completely in memory. The plan optimizer picked was… which points to problem with optimizer performance. Note though if you have subqueries these …the following explanation from Timour Katchaounov in MySQL mailing list archives I have some …
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
…# mysqldump –single-transaction dumptest > dump.sql SESSION1: (before dump has completed) mysql> alter table C add i int not null; Query OK…_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; — Dump completed on 2012-03-23 7:27:18 SESSION1: mysql> select * from C; +——+—+ | t | i…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take… such as range scans, where index parts after the part on which range condition is applied cannot be used for filtering…
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
April 1, 2012 By 16 Comments
… Alex/Vadim, We had install mysql-server-wsrep-5.5.20-23.4 with galera-23….copies all data from main the node to the others on each transaction? Can you please help us trace this … 120401 14:14:27 [Note] WSREP: 1 (ubuntu-server-129): State transfer from 0 (ubuntu-server-128) complete. Apr 1 14:14…
Comment: MariaDB 5.3 is released as GA!
March 7, 2012 By 17 Comments
… as ignorant as my “archetype” above. It is interesting to note that before I pointed out that Percona Server even exists… is completely different from what the core MySQL community focuses on – in fact I would say MariaDB is seriously underrepresented on places like planet mysql… what you’d believe from simply reading the blog posts on planet mysql) FWIW, MariaDB may very well be a good choice…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…you might become upset and become one of thouse bloggers. Note – any database management system is different in some respect… things down too much. On other hand join of few large tables, which is completely disk bound can be very… build applications operating with very large data sets based on MySQL….
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
…0 on October 15, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5…is nothing to do. InnoDB Kill Idle Transactions NOTE: Percona classes this feature as Beta and …ON, restoring from the LRU dump file is synchronous, i.e. InnoDB waits until it is complete …
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…0 on October 14, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5…is nothing to do. InnoDB Kill Idle Transactions NOTE: Percona classes this feature as Beta and …ON, restoring from the LRU dump file is synchronous, i.e. InnoDB waits until it is complete …
Post: Testing MySQL column stores
August 16, 2010 By 15 Comments
… do some testing on a large data set against two MySQL column-store storage engines. I’d like to note that this effort… InfiniDB Community Edition on a 950GB data set. The first first part of my analysis focused on testing specific MySQL functionally with Infobright… I modified the configuration settings on a 16GB box, one query did not have enough memory to complete on InfiniDB. Overall, I would…
