Some great stuff on getting the best performance out of MySQL …
MySQL Performance Blog
I have just been reading this …
ORDER BY … LIMIT Performance Optimization. Pagination is used on just about every site I work on - that article is great on speeding up queries using ORDER BY and LIMIT.
Bigdump is a PHP script that staggers the import of a large MySQL dump. It processes a small chunk and then refreshes. This continues until the database is fully imported. This is great for hosts that don’t give you access to ssh or who place restrictions on file uploads or server execution times.
The only thing to configure is the database host, user, and password. Simply upload the dump file to the same directory as the bigdump file (use FTP or the built-in uploader) and then process that file.
Great presentation reviewing how to kill database performance.
Response to a blog post on MySQL optimization. Has some good comments on using (or rather avoiding use of) SQL_SMALL_RESULT, HIGH/LOW_PRIORITY, and INSERT DELAYED. STRAIGHT_JOIN.
read more | digg story
A list featuring a few very simple tips for optimizing php/mysql applications …
read more | digg story
Create A Website
Entries (RSS) - Privacy
