MySQL can be deployed in several ways, and that means…you have to deal with. Even later, when asynchronous or single-threaded replication is not enough, people can use Percona XtraDB … popular, sooner or later you have to think about write scalability, and implement sharding ultimately. I will give a …
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads… faster than an actual database write. The slow logs were split … result is similar for every single graph, each chunk warmed up…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… (PXC) for MySQL is a hot thing right now and…cluster. Also, at the time of this writing, from async stream, MyISAM is not being…INSERTs are happening on not only a single node. However, this may work differently when…an additional overhead, this means the SQL_THREAD will not be able to execute events …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… the single-node configuration used 16 threads (8 cores on a single socket x 2 threads …per_table = true innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity =…percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… an opposite question: why MySQL performance at low concurrency is important for you. I decided to write about this topic as a… which single-thread execution is what is going to happen — many batch jobs are written to be single-threaded. MySQL replication is single-thread too, and MySQL 5…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the …not. It contains no other magic that helps single node writing in PXC to perform better. gcs.fc…of some large transaction briefly stalling an applier thread. However, it is possible to halt queue …
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…Single core VM 528M RAM Host-Only network 1 Box with http/php, 1 box with memcache or mysql… / 1000000; While this benchmark doesn’t show any multi-threading or other advanced operation, it is using … plugin). As expected, there is a slowdown for write operations when using the InnoDB version. But …
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… the DB (most appearing in one section …latest writes etc ), it will probably be quicker in the…whole partition can be cached, as opposed to a single table, where probably only recently read records will… quicker on a partitioned table, as Mysql can fire off one thread per partition (at least I have…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… find on MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61) and a single test, innodb…== Possible data race during write of size 8 at 0x6e29da8 by thread #15 ==9090== at 0x6BC3EFD: srv_monitor_thread (srv0srv.c:1994) ==9090…== This conflicts with a previous write of size 8 by thread #14 ==9090== at 0x6BC4594: srv_error_monitor_thread (srv0srv.c:1671) ==9090…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… MySQL Replication goes in single thread it is enough for one statement to get stuck to have all replication stalled. Long Queries – MySQL Replication… almost fully busy handling the writes. This is not the case – because MySQL Replication runs in single thread (two threads, but only one of them…
