fisharebest

MySQL has a large number of configuration options. Adjusting these can make an enormous difference to the performance of your database. Unfortunately, there is no single “best” set of settings. The optimal configuration depends on the version of MySQL, the server resources, other server processes, etc. It is also dependent on the server role; development, testing or live operation. Continue reading →

If you want to use a cursor, you are going to need a loop. All the examples on the MySQL website are a bit convoluted, have unnecessary flags and checks.

This is a better way to do it: Continue reading →