MySQL can be deployed in several ways, and that means you … simple services or development systems, many people are using a single server with some backups configured, and then simply take the… you have to deal with. Even later, when asynchronous or single-threaded replication is not enough, people can use Percona XtraDB Cluster…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… 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… database maintenance operations such as “alter table” are run in single-thread too. In fact, chances are your system actually runs at…
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-count… up with chunk 3. The result is similar for every single graph, each chunk warmed up the buffer pool for the…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users … collisions when INSERTs are happening on not only a single node. However, this may work differently when replicating from… PXC has an additional overhead, this means the SQL_THREAD will not be able to execute events as fast,…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… saw previously. Note that the single-node configuration used 16 threads (8 cores on a single socket x 2 threads per socket), while the… –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… bits/sec (bug 1132900) * Extended “MySQL Threads” graph with all kind of threads (bug 1157911) * Some Cacti single-item graphs were broken due to… Utilities. Also the following Cacti graphs need to be recreated: MySQL “MySQL Threads”, Linux “Network Traffic”. A new tarball is available from downloads…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 22, 2013 By 16 Comments
… to the older eBay-sponsored thread pool implementation. Is it the same implementation that was available in MySQL 6.0.x branches, and, IIRC, was merged to MariaDB before the current implementation? IIRC it didn’t have the “thread is waiting now” annotations, it used single-threaded libevent and had to serialize on LOCK_thread_count or some other…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… nutshell, here is how one would start the memcached plugin: mysql> install plugin daemon_memcached soname ‘libmemcached.so’; In an effort… 6.4 Single core VM 528M RAM Host-Only network 1 Box with http/php, 1 box with memcache or mysql started… = $totalTimeFetch / 1000000; While this benchmark doesn’t show any multi-threading or other advanced operation, it is using identical code to…
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 lack…not. It contains no other magic that helps single node writing in PXC to perform better. …of some large transaction briefly stalling an applier thread. However, it is possible to halt queue applying…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… (like allocator from glibc) this will notably slowdown MySQL-transaction creation and many threads will get stuck on glibc/kernel syscalls, which… a single block this 2 layers approach is quite inefficient and in some cases can be the reason for notable MySQL performance… for read view structure and that causes drops at high threads with glibc. Jemalloc helps to solve that. = Percona Server 5…
