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

Older Posts

Recent Articles


Wordpress Idea’s Password Suggestion

I was looking around Wordpress.org at idea's, that the community was suggesting. I took the Password Suggestion idea and made a small change to 2 of the core scripts. This ...
Post on 7th of March 2010
Continue Reading...

My Plugin Stats

Description: My Plugin Stats, will show the download stats of your custom plugins. It pull the information from wordpress.org. It creates a dashboard widget and you can monitor many plugins at ...
Post on 23rd of February 2010
Continue Reading...

Disk Raid Levels

This article talks about raid levels and how they work. I like to use raid 5 and raid 10, this is based on performance testing that reads are faster on ...
Post on 20th of February 2010
Continue Reading...

MySQL Memory Settings

These are some settings values I look at when I start up a new MySQL instance. Not all instances of MySQL will have the same, so I tweak until I ...
Post on 19th of February 2010
Continue Reading...

Wordpress Woot Watcher

2-17-2008 TODAY Wordpress.org posted woot watcher!!!!!!!!!!!! Check it out here Woot Watcher Description: Wordpress Woot Watcher, will monitor and check woot, shirt woot, kids woot, wine woot and sellout for new products ...
Post on 16th of February 2010
Continue Reading...

Help to make your database and wordpress secure

Every now and then you see a site that has been hacked due to lack of security. I make it a practice to update my pass and secure my configuration ...
Post on 9th of February 2010
Continue Reading...

Having is not a replacement for a where clause!

Even a query that is checking against an good index will result in a table scan if it is poorly written.  It seems some people think that HAVING can be ...
Post on 6th of February 2010
Continue Reading...

MySQL Regular Expressions

I added a page with a reg expression cheat sheet, so I wanted to post how MySQL can use reg expressions in select queries. I use these and they can ...
Post on 5th of February 2010
Continue Reading...

Why is the dev.mysql.com link so important?

What is a link? A link is a reference on a web page that references some other place on the same page or somewhere else on the Internet. If text is ...
Post on 4th of February 2010
Continue Reading...

MySQL Rotate Tables C program

I have written a little c program that will rotate tables and keep older tables for specified time. I use this program in a few environments where we have data ...
Post on 2nd of February 2010
Continue Reading...

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

Switch to our mobile site