Welcome to MySQL How To

    Welcome to the newly revamped MySQL How 2 site. This will express ideas and techniques I use everyday as a MySQL database administrator. There will be tips to maintenance, performance tuning and over all database administration. I will have a do's and dont's section from experiences, and I will post scripts that can be used. The environment that will be referenced is one of the largest. The ideas expressed on this site will be examples of administrations tasks that I use. I will also answer questions , so feel free to send them to me on the Contact form.

    I will have rants of bugs I find and mistakes I make, there will be a section that will talk about my day to day life at the office and home. This could be for good reading, as it is hectic. I will try to give you enjoyable reading and not lose the attention and bore you. Please leave comments, as it will help me write know what the readers are looking for. I would like this be a go to place that other MySQL DBA's can use.

    Creating this site is a side project also for me, as I will use it for issues I have seen and I'm sure I will see some again. Some of the reading will be just notes, check back often as I will update them with out comes and more information. Enjoy reading and thank you.


    About me and my family

    Hello my name is Lee Thompson. I started this website as a fun side project and a place to put notes. I thought some of the notes can be useful for other DBA's. To know more about me go to Linked_in profile

    OK, now let me tell you about my great family. First is my beautiful wife Heather, she has supported me and she is the driver of the family, she is very well rounded person. Heather is currently enrolled in Le Cordon Blue pursuing a associates degree in pattisierie I love you Heather.

    Next is my oldest son Kenny, what to say about a teenager that knows everything. Kenny is a great young man, he likes to swim and hang out and do back flips. Kenny is a very smart student in school and very athletic. Keep up the good work Ken.

    Last but not least, Weslie, well stuck in the preteen stage, he is the most versatile kid I know. He loves to ride his Haro, loves video games. Weslie is great in school and also is a member of the band as the first chair Flute, he has since moved on and now involved in sports and politics at school.

    My family is a normal family and we all like to just hang out, we like to camp and watch movies together. We also love pets 5 dogs 2 cats and a fish..

    Heather, thank you for all your support and love, I could not have done it with out you. Kenny and Weslie, thanks for being the best kids in the world!!!

    I love you all.


    MySQL How 2 Store

Newer Posts

Recent Articles


Following your replication flow

Many environments I manage are large and span over multiple data centers across the world. We replicate data across and sometimes need to have a visual aid to help look ...
Post on 2nd of February 2010
Continue Reading...

Finding cache hit ratio

What is your cache hit ratio. This is a simple bash script to see your cache hit ratio. Data caches that hold often-referenced application data. Code caches that retain often-executed SQL or ...
Post on 31st of January 2010
Continue Reading...

Load Balancing with DSR

I have many environments that use hardware load balancers. This can be very costly sending a lot of traffic through a load balancer. So we are starting to move to ...
Post on 31st of January 2010
Continue Reading...

Kill long sleeping connections

I have many servers that have applications that do not close connections properly or that use a connection pool. Sometimes I get a lot of sleeping connections that I ...
Post on 31st of January 2010
Continue Reading...

What is “ACID “ Compliant?

Atomicity. In a transaction involving two or more discrete pieces of information, either all of the pieces are committed or none are. Consistency. A transaction either creates a new and valid ...
Post on 20th of October 2009
Continue Reading...

Fast rebuild of a MySQL slave server.

We had to rebuild a slave, that mysteriously had the slave reset?!?! This environment is a single master and a single slave. The slave was just a backup server, and ...
Post on 21st of September 2009
Continue Reading...

Memory Usage

These formula's will determine the total memory used. Used MySQL memory: key_buffer + max_connections * (join_buffer + record_buffer + sort_buffer + thread_stack + tmp_table_size) If innodb is enabled. max memory utilization: key_buffer_size + innoDB_buffer_pool_size ...
Post on 10th of September 2009
Continue Reading...

Transferring large files between servers

In some of my environments I have to deal with large data sets that are well over 300GB. In this test I have a master, a read only slave ...
Post on 1st of September 2009
Continue Reading...

What is MySQL

MySQL is a relational database management system. A relational database stores data in separate tables rather than putting all the ...
Post on 25th of August 2009
Continue Reading...

Twitter Delicious Facebook Digg Stumbleupon Favorites More
Designed by: MySQL How 2

Switch to our mobile site