‘MySQL’ Category

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 ...
Post on 9th 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 ...
Post on 5th 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 ...
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 ...
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 ...
Post on 31st of January 2010
Continue Reading...