…database options” beyond just those two. Again my goal is to not…not storing my data in MySQL and instead looking outside the database for an answer. Now sure there are other reasons…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… case you decide to continue on to a longer relationship with Percona, which is reasonably common; in …m ready to see what’s up with the database. The first step is to find out what MySQL … it’s not possible to use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get …
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
…use cases. I decided to write a series of blog posts on MySQL…reason for sharding. It’s too bad that “the replica can’t keep up with the write workload” becomes the reason to…database. If the application is built such that each database…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…worked! A partially valid use of Key_reads There is a partially valid reason to examine Key_reads, …is likely to be impacted. If we manage to reduce Key_reads, we might make the database server faster… in MySQL to guide your decisions. It is also not the be-all and end-all of MySQL performance…
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
…database is already loaded. So operating wit such large databases you need to be patient and learn to…reasons to use Innodb even if you do not care about Table Locks or transactions). Besides these various trips and gotchas you simply need to…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…. I have not yet tested PDO but would not expect it to beat MySQLi in speed. It is however bad idea to use mysql_ functions directly… with almost empty database. With database growth it will however start to crawl. So developing you PHP applications use test database with reasonable amount of data…
Post: Why Swapping is bad for MySQL Performance ?
January 18, 2010 By 11 Comments
… any reasonable level of efficiently – when database deals with on disk data it often uses different set of algorithms which are optimized to limit… operations is not bad enough on its own lets see what swapping does for concurrent (multi CPU, multi client) processing. Database Locks… prefer to see slowdown instead of MySQL being killed because of out of memory but do react on them promptly and do not…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
…not intended to support it. Remember early MySQL versions knew only about table locks and were not initially designed to support transactions. Most of other databases…MySQL 4.1 if it would be actively maintained now. And hey this is exactly one if the reasons…
Post: MySQL, AIX5L and malloc()
November 3, 2008 By 11 Comments
… the idea to use one spare partition for MySQL tests. Because I had no past experience with it and there is not much documentation… any reason, you decided to run MySQL database on AIX 5L operating system. You compiled it successfully, configured and.. unluckily database didn’t start due to…
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
…MySQL and Web Servers is rather good practice. It is more secure – Compromising your web server does not directly give access to your database…reason for some cheap environments to have Web servers also on database…
