… released our first alpha of Percona XtraBackup 2.1 for MySQL and with it we included the ability to encrypt backups… multiple CPU cores can be used for encryption (with the –encrypt-threads option). You can also combine compression and encryption, each using multiple CPU cores…
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 one thread per connection to the server. MySQL is a single process with multiple threads. Not all databases are architected this way; some have multiple processes that communicate…
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
… kernel buffer of connection requests on LISTEN socket is overflow – MySQL is not accepting connections as quickly as it needs. There… problem and do some Math. First lets look into how MySQL accepts connection. There is single main thread which is accepting… cache. From this point on MySQL processes network communication in multiple threads and can benefit from multiple cores but this work done by main…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… the performance of queries against a MySQL database by distributing the work over multiple machines and/or multiple cores. This is similar to the… loading) or it can load files directly, in parallel, to multiple hosts. Shard-Query will execute queries in parallel over all… IN. It is also possible to spread your data over multiple machines, scaling out to improve query response times significantly. These…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… things of the past. However, if you think about Core idea of the MySQL Query Cache – it is great. The transparent cache… can use same “cheat” as MySQL 5.5 uses for Innodb Buffer Pool and have multiple MySQL Query Cache instances hashed by query… from Multiple Misses So you have item invalidated from query cache and there are multiple connection requesting the same item. What MySQL will…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
…/lib/mysql (datadir) on my system (Ubuntu). You might be lucky and it might work in your system. I also enable multiple “versions” of core files here with different pid numbers which I think can be quite helpful. After you have configured dumping core… this message – you should see Segmentation fault(core dumped) after Writing a core file. If core file was not written you will just…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… indexes in parallel by running sorts in different threads – using multiple cores becomes increasingly important as their number per CPU just keeps… others due to statement level MySQL Replication which among other requirements, needs all auto-increment values in multiple value insert to be… patch out where already which may come in MySQL 5.2 or even MySQL 5.1. I surely would like to see…
Post: Intel Woodcrest vs AMD Opteron for MySQL
June 8, 2006 By 9 Comments
… published Intel Woodcrest preview benchmarks which have some numbers for MySQL as well. From these numbers performance looks great and it… work well with cores and hypperthreading as you need people to understand you want to pay more for multiple cores and threads, not… article also has very interesting observation on MySQL Multiple CPU scalability . As you can see MySQL could be slower on Linux with many…
Post: Finding an optimal balance of I/O, CPU, and RAM for MySQL
May 16, 2011 By 4 Comments
… how MySQL scales as you add more memory to the server. Vadim recently benchmarked the effects of increasing memory and CPU core… storage — specifically, the Virident tachIOn drive — has more bandwidth than MySQL can fully utilize at present. Therefore, to decrease the price…. You can read the full details in our Scaling MySQL With Virident Flash Drives and Multiple Instances of Percona Server white paper.
Post: Looking at Redis
August 27, 2009 By 27 Comments
… many Redis instance on single server to get advantage of multiple cores. I call Redis semi-persistent because it does not store… updates/sec. This was using about 5 cores so you could probably get 4 MySQL instances on this server and get up….000 updates/sec with about 1.5 core being used. I have not tried running multiple instances and I’m not sure…
