…. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops…_and_free_block(buf_pool_t*, unsigned long) | buf_LRU_get_free_block(buf_pool_t*) | | | |–94.84%– buf_page_init… second for MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL performs quite well, though we can see small performance drop in MySQL…
Post: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… your product. Independent expertise. Customers like to get trustworthy information that does not come from…and this engine is pretty much dead today. Second is a recent example from the Monty Program …”In principle, anyone who has an interest in MySQL and MariaDB surviving should contact the MariaDB …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… of MySQL used was Percona Server 5.5.30-rel30.1-465. Each test was allowed to run for 7200 seconds, and the first 3600 seconds were discarded as warmup time; the remaining 3600 seconds were averaged into 10-second intervals. All… one interesting item here is that vCache actually appears to get *better* over time; I’m not entirely sure why that…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
… seconds to mysql 5.1 and in about 6-9 seconds on mariadb 5.5, while the galera two-node cluster seems to get it done in 11-14 seconds. This…=100000 MariaDB-Galera-server-5.5.29-1.x86_64 mysql-5.1.67-1.el6_3.x86_64 MariaDB-server…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… how the primary index gets created it will have minimal `ID` among the indexes of the table. mysql> select * from SYS_INDEXES… statement internally they always go first in a record. The second issue we should take into account is internal fields DB… of the dictionary tables into some MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD DATA INFILE ‘/path/to/SYS…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…, which at that time (in MySQL AB) was aggressively driven by sales. They did not get the time to do these things… were important for quality but didn’t directly drive more $). Secondly – several features were engineered in a rush because of lack… early example of this is classic MySQL replication, which was implemented by Sasha Pachev at MySQL AB around 1999, paid for by…
Post: Configuring MySQL For High Number of Connections per Second
January 6, 2012 By 23 Comments
… connections to MySQL per second during peak times. This is a high number by any account. When a new connection to MySQL is…]), With MySQL 5.5 default back_log of 50 and 2000 connections created per second it will take just 0.025 seconds to… created every second during normal operation. I would note if you’re having more than 1000 connections/sec you’re getting pretty…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…. For Innodb Table id2 is not needed pas part of second key as PRIMARY key is appended to it internally anyway… would prefer to define second key as UNIQUE this has benefits and drawbacks. Benefit being you can get extra optimizations by optimizer… column. This works because by scanning data in index order MySQL gets data in already sorted order and looks at “one group…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… running 16 seconds per second. Of course no system scale perfectly, so you would unlikely be able to get 16 queries per second on… MySQL process in 1/100 of the second. (This is pretty idle test system). So 347 and 5303 correspond to 3.47 seconds… per query. If you’re running Percona Server you can get the value from User Statistics *************************** 1. row *************************** USER:user TOTAL…
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
… have intense connection. I’ll explain the math below. Second – is MySQL parameter back_log which has default value of just 50… more than 2 seconds does not make much sense because if client does not get a response within 3 seconds it will consider… else. If you’re creating 1000 of connections a second to MySQL Server you might be pushing your luck and at very…
