One command, which few people realize exists is SHOW OPEN TABLES – it allows you to examine what tables do you have open right now: mysql> show open tables from test; +———-+——-+——–+————-+ | Database | Table | In_use | Name_locked | +———-+——-+——–+————-+ | test | a | 3 | 0 | +———-+——-+——–+————-+ 1 row in [...]
Looking for MySQL 4.0 Support post EOL ?
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 [...]

