MySQL Deleting Anonymous Accounts security tip

When you install MySQL on Windows, it automatically creates some accounts for you. On Linux, this happens when you run the mysql_install_db script. Two of these accounts are anonymous; they represent…

MySQL compiling and Linking for Speed

You may be able to get a performance improvement from your server by downloading the source version and compiling it yourself. Specifically, if you have a Pentium-based machine and run Linux, you will…

MySQL Creating Indexes

Usually, you create all the indexes you need when you are creating tables. Any column declared as PRIMARY KEY, KEY, UNIQUE, or INDEX will be indexed. Sometimes you will find that you are running many…

MySQL Using TRUNCATE

The TRUNCATE statement allows us to delete all the rows from a table. TRUNCATE is faster than a DELETE statement because it works by dropping the table and re-creating it empty. One thing to bear in mind…

Compressing MyISAM Tables

Although tables become static or dynamic without your specific request (but in response to your design decisions), tables are not automatically compressed. To compress a table, you need to use the command-line…