… memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance… IF NOT EXISTS statements on an existing table could wait on a metadata lock instead of failing or returning immediately if there is a…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…MySQL backup. The new 2.1.1 GA version offers improved performance, enterprise-grade security, and lower resource usage. This release is…number of threads started by XtraBackup when rebuilding secondary indexes on innobackupex –apply-log –rebuild-indexes. This…
Post: Finally. How to verify if all MySQL records were recovered
April 25, 2013 By Leave a Comment
… case the same question arises: How many MySQL records were recovered and how many were lost…page stores. The index page has a header PAGE_N_RECS – this is a number of records the page stores. …make: The page structure is not corrupt You know how many records to expect This is what constraints_parser …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… let’s look at some numbers. vCache vs. vCache – MySQL parameter testing The first test …This is, however, only a hypothesis. vCache vs. FlashCache – dirty page threshold Finally, we examine the impact of a…_purge_threads = 1 innodb_fast_shutdown = 1 #not innodb options (fixed) back_log = 50 wait_…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
…-write-scalability does not work anymore? I am running mysqlslap against a galera-head of a master/master pair …14 seconds. This is all on centos 6.4, adaptec raid controller with six 300G SAS drives in a raid10 …-type=mixed –number-of-queries=100000 MariaDB-Galera-server-5.5.29-1.x86_64 mysql-5.1….
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
…a total of 32 virtual cores. This is the same machine which was used in my previous benchmark run. A…is worth noting here that EXT4 outperforms XFS by a fairly significant margin. The approximate raw numbers…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…see much higher numbers from NDB and 5.5.x clusters with not just simple …MySQL clustering performance: http://themattreid.com/wordpress/2013/03/01/building-a-mysql-private-cloud-step-1/ — this will be a… an aside, setting the pager to ‘less’ is a useful bit when running show processlist on high…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…a supported version of this code, it was agreed that Monty would rewrite this and MySQL Inc would provide a supported MySQL…-mysql-conference-expo/ for more information. Now, a bit more about the code itself is … of the numbers of database connections the thread pool supported. I was not part …
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… do not know where this number is now but it is not zero. We also see Open Core models with MySQL getting traction (and Tokutek is actually moving… proprietary licensed software as there is no choice. I think this is where the advantages of TokuDB might have not been enough as the… not see large benefits. The Cloud might change a lot in this game on many levels as it often removes distribution factor which is…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… | 1 | 0 | 0 | | 738 | +————–+—–+——–+——+——–+———+————–+——-+ SYS_INDEXES This table …NOT NULL properties etc. `LEN` is the maximum number of bytes a field uses to store a value. I’m not sure what `PREC` is…our example is 1679: mysql> SELECT * FROM SYS_FIELDS…
