…the database. The first step is to find out what MySQL instances …in a high-performance system is virtually every query.) If it’s not possible to use a patched binary, we can use MySQL…our internal IRC channel and mailing list. We share all … or apps that have a lot of stored procedures, which are more…
Post: Watch out for your CRON jobs
October 14, 2009 By 19 Comments
…from starting again) or using GET_LOCK function in MySQL. The second one is good if you want…at once. Watch for errors Cron has a powerful feature of mailing you the output. If you …you restart database server etc but information about cron errors should find you. Store Historical Run Times In a lot…
Post: Mail clients and Databases
March 13, 2007 By 14 Comments
I get a lot of mail and I prefer to store it for long time if not forever. With modern hard … not use some form of databases which both would handle problem of recovery and memory consumptions as databases usually are designed to handle large data sizes with limited amount of memory. MySQL in its embedded version…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
… you’ve been reading enough database related forums, mailing lists or blogs you probably heard complains about MySQL being unable to handle more… old and rarely accessed data stored in different servers), multi-server partitioning to use combined memory and a lot of other technics which…
Post: Maatkit Now Supports Memcached
July 24, 2009 By 9 Comments
…Store Keys That Never Get Retrieved Have a Low Cache Hit Ratio (i.e. query MySQL too much) Suffer a…a quantitative, scientific approach to measuring memcached performance, just like everything else we do. memcached is basically a key-value in-memory database…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… MySQL 5.4. The Backup API makes it possible to pull a consistent snapshot of an entire database…holds a row-level lock for each row returned by the SELECT. These locks are all stored in RAM… on in plugging into MySQL? Unfortunately the “war” continues. I have already received several e-mails that …
