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.
Recent Posts
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.
Dev MySQL Feed
MySQL (dev.mysql.com)
Pound Bang Whack Feeds
Linux Bash MySQL
Recent Articles
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...
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...
Translator
Woot Watcher
SOLD OUT