(Peter Zaitsev) Working on customer case today I ran into interesting problem – query joining about 20 tables (thank you ORM by joining all tables connected with foreign keys just in case) which would take 5 seconds even though in the read less than 1000 rows and doing it completely in memory.

(Rob Gravelle) There are times when you need to create databases and tables from a batch file. Whether it’s part of an automated application deployment, or you need to repeat the process on many workstations, a batch process is usually the easiest and fastest solution available. Since the emergence

(Maciej Dobrzanski) Using mysqldump is a quick way to do backups, although usually limited to only smaller databases – perhaps up to a few gigabytes large. It is still a fairly popular solution as majority of databases aren’t even that big. Also phpMyAdmin provides a variant of mysqldump format thro

(Sean Hull) MySQL replication technology is powerful and flexible. But it doesn’t do everything perfectly all the time. You may experience trouble with the slaves falling behind the master, or want to scale horizontally by building new slaves automatically. Or you might need to build a slave without

(Vineet Kumar Saini) In the last article you saw how to insert a value from a radio button in the MySQL database in PHP. Now in this article you will see how to insert a value from a checkbox in the MySQL database. Using a checkbox you can insert multiple values in the MySQL database in PHP.

(Giuseppe Maxia) A few days ago, Ronald Bradford asked for a mysqldump –ignore-database option.

(Jack Wallen) The right MySQL management tool can make your database chores go a lot more smoothly. Here are five topnotch tools to consider.

(Maciej Dobrzanski) There are probably thousands of articles on the Internet about disk statistics in Linux, what various columns mean, how accurate the information is, and so on. I decided to attack the problem from a little bit more practical side. Hopefully this will be just the first of many fut

Amazon Web Services (AWS) provides a managed MySQL solution via Relational Database Service (RDS). The following instructions will enable you to configure and run RDS. Refer to Using Amazon Web Services for initial information about AWS requirements.

(Maciej Dobrzanski) MySQL 5.1 or newer can sometimes start throwing a strange message into an error log. The message states that a query was unsafe for binary logging along with some additional information. What does it mean? Is it a problem?