High volume low speed database.

[afsoongar_ghadiri]

hi there
my database file size is up to 4 gig and this lead to a overload to server
and my account should be suspended soon
is there any way to make this out?!?
i mean about the database size and maintaince
let me know please, or my account will be suspenede soon
regards,

[h=3]General Statistics[/h]
Database size:	4.96 Gb
Total news:	959771
News published:	959770
Published in the main:	947146

[/TR]
[/TABLE]
http://www.raredown.com

 

[mintcold]

You need to check which queries are causing the overhead , mysql database should not take up a lot of memory by itself unless queried for .

You can cache DB results instead running the same queries repeatedly .

Also , change your storage engine to Innodb , if you are not using it already .

Read this post to for running a stable and efficient Innodb database -- windows - Howto: Clean a mysql InnoDB storage engine? - Stack Overflow

 

[afsoongar_ghadiri]

HI

Database Type MyISAM

dle_post	959,979	MyISAM	cp1251_general_ci	4.7 GiB
dle_post_extras	959,863	MyISAM	cp1251_general_ci	62.2 MiB
dle_tags	3,231,213	MyISAM	cp1251_general_ci	153.8 MiB

 

[SavkeUltras]

Optimize DLE in admin panel.

 

[Tango]

Don't Optimize tables that size on shared hosting, you will be suspended. If the host is online monitoring the server they may kill the process (or automated) and the table will be corrupt.

Ask the webhost to backup the database for you then move to a VPS

 

[cvrle77]

In case you need instructions http://www.wjunction.com/13-tutorials-guides/182273-convert-mysql-db-innodb-myisam-vice-versa.html

 

[afsoongar_ghadiri]

i changed the DB type
but the tables size doubled!
as well I do DLE optimize
but it seemed that has no effect
any other solution will be appreciated
thanks in advanced