‘Formulas’ Category

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 ...
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 ...
Post on 5th 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...

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 ...
Post on 10th of September 2009
Continue Reading...

Connect with your Facebook Account or Log in

Share this:

Archives
- September 2010 (1)
- July 2010 (2)
- June 2010 (1)
- April 2010 (1)
- March 2010 (1)
- February 2010 (10)
- January 2010 (3)
- October 2009 (1)
- September 2009 (3)
- August 2009 (1)

Translator

Designed by: MySQL How 2