I have a new article posted on the Database Journal...

- Abstract -

In the majority of MySQL systems, the schema is always updated and changed based on the needs and focus of the application, making it somewhat difficult to keep up with all of the changes that come down the pipe.

Knowing how to index a schema based on the queries using the system is a great skill to have. In the majority of the systems I have worked on, the schema is always updated and changed based on the needs and focus of the application. That said, it can be somewhat difficult to keep up with all of the changes that come down the pipe, especially if there are many changes every week. To help identify the indexes that are being used there are a few tools out there to help. One of the best resides in the MAAKIT called, …

How I lost 30 pounds in 2010 – a weight loss guide for developers Posted on December 30th, 2010 in blog, personal, zippykid.

2010 was a great year for me, I started a new company, and it’s been profitable since month 2, I closed my consulting company, and most importantly, I lost 30 pounds, and am more mobile/agile than I was in college. I’m 32 and I feel better than I did when I was 24. I’ve talked [...]

View Comments …

When it comes to web page load time, she should always say “wow, that was fast”.

A Quick update based on Frederick’s comment below

** Please do not take these tips as THE answer, this is a complement, not a replacement. I have purposely not given specifics on how to configure anything, or what value to set, because I don’t want people copy pasting things, and then having their site crashing. Regarding mod_pagespeed, I said it’s the most bang for OUR buck.. it’s not recommended in production, nor do we have it on for everyone else. **.

Webpage load time is getting more and more important these days, if you go into Google Webmaster Tools, you’ll see “Site Performance” under the labs link. This is a very good indicator of what Google thinks how fast your site is compared to the rest …

Yesterday one of our computer’s user partition filled up automatically that caused database corruption in the mysql database. After freeing the space from the partition, we ran some commands to repair and recover mysql database. Here is the list what we did yesterday:

1.cd into your directory where your database files are stored. In my case it was in the /usr…/data/mysql/ folder.

2.Then We run this command:
myisamchk *.MYI | grep -3 –color corrupted

3.After running above command this should give you some output on the current state of your database files & indicate which file is corrupted and need to repair. This also gives you the next command to run on the line that is:
Fix it using switch “-r” or “-o”

4.So that is we did
myisamchk -r file.MYI

5.Your database should be repaired

If you are fortunate enough to be in Beijing this week for Oracle Openworld, there are several sessions planned on MySQL to choose from. The English site is somewhat hard to navigate, so I humbly submit a tiny URL that will point you to the appropriate session search results.

Few act from pure motives, and I’m shamelessly plugging my own talks: Improving the Scalability of Web Applications with MySQL Replication, Performance and Scalability Enhancements in MySQL Release 5.5, and MySQL Strategy: What’s Next? (that last I’m merely technical backup for Richard Mason).

There are several other outstanding talks on MySQL migrations, tuning and Cluster as well, and of course an …

It is great to draw inspiration from other Open Source communities. Brad Fitzpatrick recently wrote about Android Strict Mode. His twitter tag line for this post was “I see you were doing 120 ms in a 16 ms zone” which is all I needed to hear from somebody who also worries unreasonably about responsiveness (Web site quote).

How would I apply this to a MySQL context? This is what happens in Android. “Strict Mode lets you set a policy on a thread declaring what you’re not allowed to do on that thread, and what the penalty is if you violate the policy. Implementation-wise, this policy is simply a thread-local integer bitmask. By default everything is allowed and it won’t get in your way unless you want it to”

In a MySQL …

For those that missed it - last week we added training in Frankfurt and London to our website.  This includes our new Operations Training announced in September.

(While in Europe, we'd love to speak at your meetup group on Percona Server and/or MySQL Optimization.  If you're a meetup organizer in London or Paris, please feel free to get in touch.)

Entry posted by Morgan Tocker | …

I am preparing a series of posts related to Sudoku. I am revisiting the “SQL only” solution I posted somewhere else a long time ago…  This time, we’ll get serious and optimize everything we can!  This lemon will be squeezed to the maximum!

Start your Pharo image (not mandatory since I will provide all necessary SQL scripts) and MySQL server as we’ll try to solve some Sudoku puzzles only with one SQL statement (no stored procedures or functions)!

Part 1 coming soon!

The MySQL team has been continuously improving its products on the Windows platform. Along this line, we’ve responded to a request from our users of Workbench on Windows – to provide remote access to Windows Servers using Windows management methods – as an alternative  to SSH.

Managing a MySQL server obviously requires access to the target machine, which usually requires elevated rights for certain tasks like restarting the server or manipulating the configuration file on Windows (where this file is in a protected path). For local connections this is mostly not a big deal. However for remote boxes security measures prevent easy manipulation of such essential things like server processes. In this blog post we discuss native Windows management and how it can be used in MySQL Workbench.

Remote Management

MySQL Workbench first introduced remote access via SSH (secure shell), a widely used and well known …

I’ve just announced a rather large update to the Linux-HA documentation.

We now finally have a Developer’s Guide for OCF resource agent authors and contributors. If you want to write a new resource agent to bundle with your project, or plan to send a patch for an existing resource agent, then this guide is for you.

In addition, we’ve released a new version of the Linux HA User’s Guide, which is the definitive reference and handbook for Heartbeat users.

PDF versions of these are, as always, …