Quick Table of Contents

  1. Windows service system error 1067 on start
  2. DNS lookups
  3. Use recommended settings

MySQL Tuning and Troubleshooting

[top]

1. Windows service system error 1067 on start

You may encounter the following:

>net start mysql
The MySql service is starting.
The MySql service could not be started.

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.

Check my.cnf

Check that basedir and datadir in configuration file my.cnf are pointing to the correct directories. They can be muddled due to an old installation.

[top]

2. DNS lookups

Disable DNS lookups as a faulty DNS server can cause slow connections as mysql reverse and forward looks up the IPs that are being connected. You can disable it using the --skip-name-resolve option.

[top]

3. Use recommended settings

Depending on the size of your server (memory, cpu, disk etc..), MySQL comes with recommended settings. Look into these instead of installing the defaults.