Category to track posts in PlanetMySQL
Insertion and Queries
Databases are complicated beasts, but I’d like to focus on the storage engine, just the part that talks to the storage system, and doesn’t have to worry about SQL, etc.: just transactions, concurrency, compression, updates and queries. In the next couple of blog entry, I’d like to just focus on updates […]
Have you ever seen a connection in the SHOW PROCESSLIST output which is in “Sleep” state for a long time and you have no idea why this would happen?
I see if frequently with web applications and it is often indication of trouble. Not only it means you may run out of MySQL connections […]
If you’ve been reading enough database-related forums, mailing lists, or blogs you have probably heard complains about MySQL being unable to handle more than 1,000,000 (or select any other number) rows by some of the users. On the other hand, it is well known with customers like Google, Yahoo, LiveJournal, and Technorati, MySQL has […]Read more