According to the manual, FLUSH LOGS is supposed to:Closes and reopens all log files. If binary logging is enabled, the sequence number of the binary log file is incremented by one relative to the previous file. On Unix, this is the same thing as sending a SIGHUP signal to the mysqld server (except on some Mac OS X 10.3 versions where mysqld ignores SIGHUP and SIGQUIT).If the server is writing error output to a

In one of the servers we have an issue that happens to one of the servers that some items that have the status of "freeing items" and "Sending data" are just stuck there, causing a lot of locks on the server, and the load of the server drops to almost 0. The server then wouldn't restart, and the only solution is to kill the mysqld process, and fix the crashed tables that result from the kill.

Are you starting a new software project? Don't reinvent the wheel. Before committing to some hand made procedure, you should really consider the combination of Bazaar and Launchpad. Handling the source code is not enough. A software project requires planning, defect handling, coordination between bugs and blueprints, a visual roadmap, and all the above in relation to your code branches. Don't forget about mailing lists, FAQ, documentation, which are integral part of a project. Whether you are participating to an existing project or starting a new one, Launchpad and Bazaar are a powerful combination for your productivity.

Are you starting a new software project? Don't reinvent the wheel. Before committing to some hand made procedure, you should really consider the combination of Bazaar and Launchpad. Handling the source code is not enough. A software project requires planning, defect handling, coordination between bugs and blueprints, a visual roadmap, and all the above in relation to your code branches. Don't forget about mailing lists, FAQ, documentation, which are integral part of a project. Whether you are participating to an existing project or starting a new one, Launchpad and Bazaar are a powerful combination for your productivity.