Mysql Issue

[ilija]

Hello, i got a small problem:

Since i dont have that much ram , i need to clean my char database(cause it is innodb and i set innodb_buffer_pool_size and i want to keep it below) , Now , when im cleaning the char db(yes char data is really deleted!) The innodb data size dont change, according mysqltuner and the files in /var/lib/mysql.

I think the problem is: innodb_file_per_table = 1, but im not sure, so i ask how can i solve that

Rusfighter

[zhenya``]

try mysqlcheck -uroot -ppass characters --optimize .

[ilija]

What does it exactly do? Optimize yes but what is exactly optimized and how?