December 14, 2008

SHOW OPEN TABLES – what is in your table cache

Posted by peter |

One command, which few people realize exists is SHOW OPEN TABLES - it allows you to examine what tables do you have open right now:

PLAIN TEXT
SQL:
  1. mysql> SHOW open TABLES FROM test;
  2. +----------+-------+--------+-------------+
  3. | DATABASE | TABLE | In_use | Name_locked |
  4. +----------+-------+--------+-------------+
  5. | test     | a     |      3 |           0 |
  6. +----------+-------+--------+-------------+
  7. 1 row IN SET (0.00 sec)

[read more...]

Posted by peter @ 4:54 pm :: ideas, production :: 2 comments
Print This Post Print This Post book mark SHOW OPEN TABLES – what is in your table cache in del.icio.usdel.icio.us :: submit SHOW OPEN TABLES – what is in your table cache to digg.comdigg

Looking for MySQL 4.0 Support post EOL ?

Posted by peter |

As Giuseppe just reminded MySQL 4.0 is reaching its end of life in about 2 weeks from now. When it becomes unsupported by MySQL via normal support agreements together with 3.23 version.

At Percona we do not have such restriction and we will continue to support your environment even if you're still on MySQL 4 or 3.23 (we indeed do have customers which are still using 3.23 now)
[read more...]

Posted by peter @ 1:07 pm :: percona :: 9 comments
Print This Post Print This Post book mark Looking for MySQL 4.0 Support post EOL ? in del.icio.usdel.icio.us :: submit Looking for MySQL 4.0 Support post EOL ? to digg.comdigg