… nutshell, here is how one would start the memcached plugin: mysql> install plugin daemon_memcached soname ‘libmemcached.so’; In an effort….4 Single core VM 528M RAM Host-Only network 1 Box with http/php, 1 box with memcache or mysql started PHP…(); $avgTimeFetch = $totalTimeFetch / 1000000; While this benchmark doesn’t show any multi-threading or other advanced operation, it is using identical code…
Comment: Why use encrypted backup with Percona XtraBackup 2.1 for MySQL?
April 10, 2013 By 2 Comments
… our first alpha of Percona XtraBackup for MySQL 2.1″ Is anybody even still using MySQL 2.1? Or do you actually… released our first alpha of Percona XtraBackup 2.1 for MySQL” which would make more sense. Just thinking about how google… your page. You product sounds pretty cool, especially with the multi-core encrypt threads.
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
…’s seriously limiting MySQL in core use cases (links: part 1, 2, 3). This post is about the way MySQL handles connections, allocating…’t be a great OLTP web database too. MySQL replication is one of the core, fundamental features — and it’s single-threaded… why I listed those as major limitations. And because MySQL is a multi-threaded database for Web usage that tends to be…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… way too little for what you would expect from 24 core system. For comparison you can checkSysbench Results which Vadim published…_clust_rec_for_mysql,row_search_for_mysql,ha_innobase::index_read,handler::read_ra nge_first,handler::read_multi_range_next,QUICK…,row_sel_get_clust_rec_for_mysql,row_search_for_mysql,ha_innobase::general_fetch,handler::read _multi_range_next,QUICK_RANGE_SELECT…
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
… for the high core count, which is more than I can remember seeing in the wild. The database was MySQL 5.5…-run with the same core counts and with sysbench on another machine, instead of taking 12 cores away from MySQL and giving them to sysbench. That way we could test with 48 cores and see what…
Post: Percona Server scalability on multi-cores server
September 29, 2010 By 14 Comments
… Intel Westmere CPUs (X5670 @ 2.93GHz). Each CPU has 6 cores and 12 threads. The most amazing part is the amount… get from “threads”, as there are only 12 “real” cores, with each core having two “threads”. So, I took Percona Server 5… will be interesting to compare these results with the latest MySQL 5.5 releases, and especially in cases with the number…
Post: Making MySQL Replication Parallel
January 30, 2007 By 1 Comment
… and worse as computers are getting “wider” these days with multi-core CPUs. Kevin proposes to execute queries in parallel and it… idea, the problem is however implementing it right without changing MySQL Replication semantics – which is – Slave database state corresponds to master… parallel enough for many application without serious code complications. If MySQL would not implement it it might be nice feature to…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… constantly referring to the amazing MySQL manual, especially the option and variable reference table. But….commanual connect_timeoutblogpercona.commanual Connectionsblogpercona.commanual consoleblogpercona.commanual core_fileblogpercona.commanual Created_tmp_disk_tablesblogpercona.commanual Created_…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
… question: MySQL 4.1 MySQL 5.0 MySQL 5.1 (with built-in InnoDB) MySQL 5.1 with InnoDB-plugin MySQL 5.5 MySQL 5.6… vanilla MySQL, not Percona Server. The results are there: There is nothing unexpected, staring with InnoDB-plugin, MySQL scale much better on multi-cores… (more is better) threads MySQL 4.1 MySQL 5.0 MySQL 5.1 MySQL 5.1+InnoDB-plugin MySQL 5.5 MySQL 5.6.2 1…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… can handle the write operations. If the replication master is multi-cores servers and is heavily writing using multiple threads, the slaves… level is summarized in the table below. Expertise level MySQL replication Typical, average MySQL DBA + some Sysadmin skills Master-Master with MMM…
