(Oli Sennhauser) In one of my previous posts I was writing about how to read other processes memory [1]. As an example I tried to get the value of the hard coded MySQL internal InnoDB variable spin_wait_delay (srv_spin_wait_delay).

(Peter Zaitsev) Resolving extreme database overload for the customer recently I have found about 80 copies of same cron job running hammering the database. This number is rather extreme typically the affect is noticed and fixed well before that but the problem with run away cron jobs is way to frequ

(Shlomi Noach) MySQL 5.1 boasts some new and useful INFORMATION_SCHEMA tables. Among them is the GLOBAL_STATUS table.

(yves) As my first contribution to the MySQL Performance Blog, I joined Percona at the beginning September, I chose to cover the various high-availability (HA) options available for MySQL. I have done dozen of MySQL HA related engagements while working for Sun/MySQL over the last couple of years us

(Andrew Morgan) OpenLDAP includes a driver that allows it to store and access data held in MySQL Cluster. It uses the NDB-API to access the database and so the performance is extremely good. One of the great things about the solution is that it lets you simultaneously access the same data through bo

(Sean Hull) Usually an article like this one will start out with the technical word “scaling”. Unfortunately like health care reform, everyone can’t always agree on what they mean by it, or even what the goal is. So, I deliberately chose not to use the word, and use the non-technical words that we

(Glynn) Fairly often I hear customers say that they plan a table that accumulates millions of rows per day, and they want to keep around, say, the last 30 days worth of data. (For the sake of examples, I’m going to make it the last 3 days.) So this is a kind of round-robin table, with rolling additi

(Johan Andersson) If you need to create a big database into MySQL Cluster with: –A lot of tables indexes, columns, and tables –A lot of records there are a few things to think about:

(Shlomi Noach) I had a call from a new customer last week. They had issues with their MySQL server. Apparently, it was repeatingly crashing, every few hours. To have their production system kept alive, they used a script to periodically see if MySQL was still alive, and if not – start it.

(Pavel Stehule) PL/pgSQL isn’t dynamic language. Usually it isn’t problem. This language is best as glue of SQL statements. One typical feature is strongly static access to record or row fields. But sometime we need dynamic access. This is very hard task in older version. Some better situation is in