… cron jobs allowed unless they prevent themselves from started in multiple copies or put a wrapper script around developer written jobs… GET_LOCK function in MySQL. The second one is good if you want to serialize jobs from multiple servers (for example you specially put script in CRON job on 2 servers for High Availability Purposes…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
One of the big “Selling Points” of MySQL is support for Multiple Storage engines, and from the glance view it is indeed… engines, but really this is not enough as MySQL allows you using multiple storage engines in the query you need to test… what we could have if we have a version of MySQL Server which drops everything but Innodb Storage engine (it could be…
Post: Multiple MySQL instances on Fusion-io ioDrive
October 7, 2011 By 6 Comments
… resources available on modern hardware. Idea is to run multiple instances of MySQL to gain better performance on Fusion-io ioDrive card… PDF For tests we used tpcc-mysql package, which generates TPCC-like workload on MySQL systems. Server hardware: Dell PowerEdge R815 Storage: Fusion…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… can use same “cheat” as MySQL 5.5 uses for Innodb Buffer Pool and have multiple MySQL Query Cache instances hashed by query… Server we’ve done the first step by allowing you to strip comments when checking query cache for match. Protection from Multiple Misses So you have item invalidated from query cache and there are multiple connection requesting the same item. What MySQL will…
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
… of methods. Smaller applications usually start with single server which has both MySQL and Web server on it. In this case it is… need to have multiple servers you may decide ether to grow system in MySQL+Apache pairs or split MySQL And Web Server and place them on different boxes. Generally using separate boxes for MySQL and Web Servers…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… 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…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
… sensitive). I wonder how many of MySQL Users are running applications of these scale, for single MySQL Server ? Please comment if you do… considered medium scale MySQL installations would get there. With MySQL we seems to prefer to run more low end server and storage configurations… get a lot better performance with multiple MySQL instances on powerful storage. When you move to multiple instances and you have to “shard…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… operations. If the replication master is multi-cores servers and is heavily writing using multiple threads, the slaves will likely not be… a growth that will need sharding (splitting the database over multiple servers), then you might need to take a serious at that… level is summarized in the table below. Expertise level MySQL replication Typical, average MySQL DBA + some Sysadmin skills Master-Master with MMM…
Post: How Much memory do you use to run MySQL
November 2, 2012 By 8 Comments
We have seen number of issues with MySQL Server related to amount of memory you have in the system – … really use to run MySQL Server these days ? [poll id="2"] Feel free to select multiple sizes if you have multiple kinds of instances… will be frozen so we do not get results from multiple years mixed.
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
Sometimes on very busy MySQL server you will see sporadic connection timeouts, such as Can’t connect to MySQL server on ‘mydb’ (110). If… cache. From this point on MySQL processes network communication in multiple threads and can benefit from multiple cores but this work done by…. If you’re creating 1000 of connections a second to MySQL Server you might be pushing your luck and at very least…
