Latest Announcemnent
New thread

High volume low speed database.

Status
Not open for further replies.
A

afsoongar_ghadiri

Active Member
33
2011
0
0
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]
Code: 
[/TR]
[/TABLE]
http://www.raredown.com
 
6 comments
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
 
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]
 
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
 
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
 
Status
Not open for further replies.
Back
Top