‘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...

Archives
- March 2010 (1)
- February 2010 (10)
- January 2010 (3)
- October 2009 (1)
- September 2009 (3)
- August 2009 (1)

Log In

Username
Password
	Remember Me Lost your password? Register

Translator

By N2H

Designed by: MySQL How 2

Switch to our mobile site