Проблема с многими таблицами с префиксом *cache*

[Николай Сипко]

"Ries van Twisk
Tue, 19 June 2007 14:15

Hey,

check your uptime... And see if somebody restarted your server.
also check your HD space left on your devices, you have may run out
of it.
Check if MySQL has been crashed (I never sen that, but you never know).

If something happens, MySQL always have a hard time recovering and
you will get these 'in use' tables. The good thing is that you don't
notice
much when using typo3.

On a occasion this simply happens with MySQL, most of the times with
a reason,
sometimes without a reason.

What I did the last time is stop MySQL, delete the tables start MySQL
and re-create them.
The only contain cache information and can be re-build by TYPO3.

Ries"

https://forum.typo3.org/index.php?t=msg&goto=347609&

P.S. К теме вопроса это не относится, но в новых версиях TYPO3 в Install:

Clear tables
=======
Use with care! Clearing tables here can have a negative impact on your site functionality. You could log out all users, delete all their basket data, and lose logging information!

Some database tables in TYPO3 CMS hold semi-temporary data that is not deleted when clicking "Clear all cache" in the backend. Those can be cleared here, effectively removing all rows from it. This can be useful in rare cases.
be_sessions Rows: 2

Description: Backend user sessions
cache_md5params Rows: 0

Description: Frontend redirects
fe_sessions Rows: 0

Description: Frontend user sessions
fe_session_data Rows: 0

Description: Frontend user session data
sys_history Rows: 42

Description: Tracking of database record changes through TYPO3 backend forms
sys_lockedrecords Rows: 1

Description: Record locking of backend user editing
sys_log Rows: 93

Description: General log table
tx_extensionmanager_domain_model_extension Rows: 0

Description: List of TER extensions
tx_rsaauth_keys Rows: 0

Description: Login process key storage
=======

Благодаря очистке этих таблиц размер базы данных не разрастается со временем до чудовищных размеров.
В старых версиях их можно и нужно очищать вручную.