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,

[TABLE="width: 100%"]
[TR]
[TD="colspan: 2"][h=3]General Statistics[/h][/TD]
[/TR]
[TR]
[TD]Database size:[/TD]
[TD="width: 80, align: right"]4.96 Gb[/TD]
[/TR]
[TR]
[TD]Total news:[/TD]
[TD="width: 80, align: right"]959771[/TD]
[/TR]
[TR]
[TD]News published:[/TD]
[TD="width: 80, align: right"]959770[/TD]
[/TR]
[TR]
[TD]Published in the main:[/TD]
[TD="width: 80, align: right"]947146[/TD]

[/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

[TABLE="class: data"]
[TR="class: even"]
[TH]dle_post
[/TH]
[TD="class: value tbl_rows"]959,979[/TD]
[TD="class: nowrap"]MyISAM[/TD]
[TD="class: nowrap"]cp1251_general_ci[/TD]
[TD="class: value tbl_size"]4.7 GiB[/TD]
[/TR]
[TR="class: odd"]
[TH]dle_post_extras
[/TH]
[TD="class: value tbl_rows"]959,863[/TD]
[TD="class: nowrap"]MyISAM[/TD]
[TD="class: nowrap"]cp1251_general_ci[/TD]
[TD="class: value tbl_size"]62.2 MiB[/TD]
[/TR]
[TR="class: odd"]
[TH]dle_tags
[/TH]
[TD="class: value tbl_rows"]3,231,213[/TD]
[TD="class: nowrap"]MyISAM[/TD]
[TD="class: nowrap"]cp1251_general_ci[/TD]
[TD="class: value tbl_size"]153.8 MiB[/TD]
[/TR]
[/TABLE]

 

[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