The perl script is mainly created to avoid manual Mysql Server Maintenance. The script uses Perl module DBI. You need to provide access credentials and database name(optional). Regarding Analyse, Optimize…

The post Perl Script for Analyze – Optimize – Repair Mysql Databases first appeared on Change Is Inevitable.

Here the division between td1.c1 and td2.c2 is correct:

select td1.c1, td2.c2, td1.c1/td2.c2, -99 / 0.03    
  from testdata td1,         
       testdata td2   
 where td1.c1 = -99 
   and td2.c2 = 0.03 
 limit 1;

+------+------+---------------+------------+
| c1   | c2   | td1.c1/td2.c2 | -99 / 0.03 |
+------+------+---------------+------------+
|  -99 | 0.03 |    -3300.0000 | -3300.0000 |
+------+------+---------------+------------+
1 row in set (0.00 sec)

Here DISTINCT is added to the query.  The result is incorrect:

select distinct td1.c1, td2.c2, td1.c1/td2.c2, -99 / 0.03    
  from testdata td1,         
       testdata td2   
 where td1.c1 = -99 
   and td2.c2 = 0.03 
 limit 1;

+------+------+---------------+------------+
| c1   | c2   | td1.c1/td2.c2 | -99 / 0.03 |
+------+------+---------------+------------+
|  -99 | 0.03 |     -999.9999 | -3300.0000 |
+------+------+---------------+------------+
1 row in set (0.00 sec)

…

This post is for people who are trying to roll back unwanted modifications to their MySQL database. You cannot use the binary logs to undo unwanted changes to your data. The binary logs are for redoing statements, not undoing them. If you have a backup, you may be able to restore the backup and then replay binary logs to roll forward to the desired state. But you cannot roll backwards with the binary logs.

MySQLPreacher has only started ten days ago, but despite it has limited viewers so far it would still like to wish all readers a great new year full of joy and happiness, with no deadlocks or failing backups, no overloaded slowquery logs. Hope it will be a year with an enviable uptime!

The gearmand job server written in Perl (current production server from Danga):

mysql> SELECT length(gman_do("reverse", repeat('x',10000000))) AS test;
+----------+
| test     |
+----------+
| 10000000 |
+----------+
1 row in set (49.08 sec)

The new gearmand job server written in C:

mysql> SELECT length(gman_do("reverse", repeat('x',10000000))) AS test;
+----------+
| test     |
+----------+
| 10000000 |
+----------+
1 row in set (0.30 sec)

Mmm, efficiency. Oh, and are those some new MySQL UDFs? Much more coming soon…

Its been a while since I blogged.. and my new year's resolution would be to blog more.

• I could say that I have been very busy at work. I can't really say that I haven't been using MySQL, since I've been using it more these days than I have in my entire career.
• I could say that I am noticing a trend to blog less in the MySQL community. I could be wrong about that, but I definitely don't see the same names blogging as the ones I used to see a year ago. But that could be that some people just moved on.
  
• I could say that I have just been lazy. My blog statistics certainly reflect that.
• Finally, I could say that I lost a bit of enthusiasm for blogging about MySQL. This could be that my priorities have shifted slightly, but I plan to get myself a bit more involved with database developing/administrating in the very near future.

Other things on my list for the …

Hi all,

This is my last blog entry for the year 2008. I've blogged 227 times this year, about a variety of topics (mostly NetBeans). I enjoy blogging. It puts me in touch with the community, making me much more approachable by community members.

2008 was a great year. Here is a sample of what I was able to witness or take part in (I've tried to put them in chronological order):

• Sun's acquisition of MySQL
• NetBeans switching from CVS to Mercurial
• Sun presentations in Second Life
• 100th NetBeans Community Docs contribution
• The release of NetBeans 6.0.1
• The creation of a NetBeans Community Docs blog
• New Woodstock components in the NB Palette
• My visit to St. Petersburg, Russia
• Big Database changes in NetBeans IDE (ongoing)
• The release of NetBeans 6.1
• A new Contribution Coordinator for NetBeans …

Sun has invited me to showcase Maatkit at the dot-org pavilion at the upcoming MySQL Conference and Expo 2009. At this time it’s really hard to say what I’ll be demoing! Development on Maatkit is accelerating and I don’t look for that to change, so who knows what we’ll have done by then. [...]

I want you to tell me the story of how you got started with the Net.

Tell me how your passion was sparked and why it keeps coming to full flame.

Tell me why the Net matters to you, even after all of the long days, short nights and wrecked weekends.

I’ve been writing my story because I need to understand why I care deeply for what the Net is and what it means.

I want to read your story for the same reason.

Don’t hold out on me now. I can see your data trails in my server logs: a few hundred of you trudging in from RSS subscriptions, the PHP, Mozilla and MySQL planets, Boris’ …

Hello everyone! Before I move to the seasonal greetings, let me share some exciting news.

2008 was quite remarkable for Pythian and, in addition to our ongoing success and growth, we established Pythian Europe back in May. To top it off, we have now laid the foundation for Pythian East Asia Pacific.

Pythian Australia Pty Ltd was incorporated and started official operations in Australia this month, taking over service delivery for the region. We have a few local clients and already signed some new ones, so this is quite an exciting beginning.

Today, there are three of us working in Sydney office:

A little bit of history. Pythian has operated in Australia for almost three years by now (well, longer than …