Posts by Tim Procter
The Ottawa Perl Mongers will be meeting once again at the Pythian headquarters. There will be two presentations given: Yanick Chanpoux will be presenting on Moose. Tim Procter (myself) will be presenting on Portable Perl Daemons. The focus is on developing light-weight background processes that will be compatible with both Unix and Windows systems. Additionally, I will be demonstrating communications with the daemon and child processes over TCP from an independent controller. The presentations are now available online thanks to Andrew Ross at the Free and Open Source Software Learning Centre. Comments are welcome.
Here is the perl script referred to by mysql-memory-usage-profile.
I’m not going to try to post a comprehensive mysql tuning manual here. This post is about taking a snapshot profile of a mysql instance that will allow you to define what type of instance you are dealing with, and give you some idea about whether the current configurations are stable or not.
Finding duplicates with RANK – If you’ve made the mistake of forgetting a primary key on your table, it can be frustrating to find a way to delete all of the duplicate rows without deleting the initial instances. This query selects all of the ‘extra’ rowids and removes them.
Pythian News is now using WordPress to transform our Industry News section into a group blog of articles relevant to the DBA community at large. We hope this will allow readers from throughout the DBA industry to get involved and not only view our blogs, but also be able to contribute to the discussions.