MySQL query caching: limited to a maximum cache size of 128 MB?

The warning issued by mysqltuner.py is actually relevant even if your cache has no risk of being swapped. It is well-explained in the following: http://blogs.oracle.com/dlutz/entry/mysql_query_cache_sizing Basically MySQL spends more time grooming the cache the bigger the cache is and since the cache is very volatile under even moderate write loads (queries gets cleared often), putting … Read more

Getting error “Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed” when starting MySQL

This error also happens when your Database data is corrupt. You may fix this issue by moving your Db data files (ib_logfile0 and ib_logfile1) mentioned below to another location. ib_logfile0 and ib_logfile1 are system tablespace for the InnoDB infrastructure. These files contains several classes for information vital for InnoDB. You may read about these files … Read more

How do I deal with this race condition in django?

This could be an off-shoot of the same problem as here: Why doesn’t this loop display an updated object count every five seconds? Basically get_or_create can fail – if you take a look at its source, there you’ll see that it’s: get, if-problem: save+some_trickery, if-still-problem: get again, if-still-problem: surrender and raise. This means that if … Read more