Using MySQL Table Checksum
The MySQL Table Checksum , part of the MySQL Toolkit (having to be renamed soon ) is an invaluable community tool for use with MySQL. Most sites or installations of any volume will use MySQL Replication for one purpose or another, be it for read scalability, backups, testing, upgrading etc.
Read moreFunny command line option for the day
I needed to start mysql without privileges after a database restore today, and while confirming the correct option which was –skip-grant-tables I came across an option which made me laugh.
Read moreMySQL Conference Submissions have closed
If you didn’t get your proposal in for MySQL Conference 2008 , that’s too bad. I often wondered from past conferences why submissions were needed so early, like 5 months before.
Read moreHacking my iPhone
I’ve finally taken the plunge after wanting to for some time. This is what I did, all steps are from using the iPhone directly, no computer required. NOTE: I can’t take responsibility for anything that happens to your iPhone.
Read moreGoogle Maps at Halloween
If you didn’t spot it Google Maps – Street View had a Halloween icon. You can see it clearly below as I dragged it over a clear space.
Read moreUbuntu Tricks today
ctrl-alt-l – Lock Screen ctrl-alt-d – Desktop # Multi Cut-Paste History apt-get install glipper Add to System|Preferences|Sessions|Startup Programs Thanks Yves
Read morePerl Tricks
perl_modules.pl #!/usr/bin/perl use ExtUtils::Installed; my $instmod = ExtUtils::Installed->new(); foreach my $module ($instmod->modules()) { my $version = $instmod->version($module) || "???"; print "$module -- $versionn"; } remove_perl_module.pl #!/usr/bin/perl -w use ExtUtils::Packlist; use ExtUtils::Installed; $ARGV[0] or die "
Read moreBan the Backquote
I really don’t like the backquote character (`). This is primarily due to it’s use by MySQL in internal and community tools. MySQL allows objects, .e.g table names, column names etc to contain both reserved words and spaces, providing they are appropriately surrounded by backquotes, so tools now simply enclose everything with backquotes.
Read moreNY Users Group – Analyzing MySQL Status and your SQL
This month I continued my Performance Analysis talks at the Local NY MySQL Meetup . Previous discussions can be found here . Our focus was a more in-depth look at gathering and reviewing MySQL Status and your applications SQL statements using MySQL Proxy .
Read moreUbuntu 7.04 Fiesty
I upgraded my work laptop to Ubuntu 7.04 Fiesty . The process was not as smooth as I expected. First it complained about not enough space on /var, so I cleaned up sufficient space.
Read moreLAST_INSERT_ID(expr) – The lesser known usage
I am of the attitude, the day you stop learning something is the day you die. I’m not prepared to induce MySQL into both sides of that equation, however some days it never ceases to amaze me what little thing I didn’t know about MySQL.
Read moreMySQL Camp II – Memorable Quotes Day 1
Better late then never, this week I finally have the chance to catch up on some overdue posts. At the first MySQL Camp I made a list of memorable Quotes, see Day 1 , Day 2 , Day 3 .
Read moreDateTime vs Timestamp
I was asked a question today, “DATETIME vs TIMESTAMP. When to use which & why?” It’s a good MySQL introduction question, here are some general considerations for choosing one. Do you need Date values other then an EPOCH value?
Read more