dreamhost mysql umu engelledi

dreamhosttan şöyle bir mesaj geldi arkadaşlar lütfen yardımcı olun bana

------------------------------------------------------------------------
- After reading this response, please consider visiting
- the URL below to comment on its quality. Thanks!
-
- http://www.dreamhost.com/survey.cgi?n=20566555&m=544445
------------------------------------------------------------------------

Hello,


I'm writing you about your database, yaptimbilerek. I've had to disable
a table in this database previously and write you, but you have not
responded and have re-enabled the database yourself. The database is
again causing severe server problems, due to a flood of queries on the
server. Looking at the mysql usage:


https://panel.dreamhost.com/index.cgi?tree=status.mysql&


This database is constantly running 4 to 5 million queries a day, an
average of 2,777 queries a minute, or 46 queries a second. This is too
high of usage for shared hosting and is causing high load, slowness and
customer complaints. Disabling your database drops the load from 60 to 2
on the mysql server, so unfortunately it is your database. I'm afraid
your mysql needs have outgrown shared hosting and you will need to update
to a DreamHost MySQL PS or seek out a more powerful VPS or dedicated
solution at another host.


https://panel.dreamhost.com/index.cgi?tree=vserver.provision&


You can write me at justin@dreamhost.com about this issue. I've had to

disable this database until this issue can be addressed. I can provide a

backup of the database, such as to your ftp directory, if you wish. For
reference here are how many of certain queries were being logged to the
mysql slow log in a 30 minute time period.


Count: 71556 Time=0.01s (530s) Lock=0.02s (1135s) Rows=1.0 (69543),
vblog[vblog]@galaxie.dreamhost.com

SELECT * FROM kategoriler WHERE link='S' LIMIT N


Count: 18463 Time=0.13s (2417s) Lock=0.07s (1384s) Rows=0.6 (10655),
vblog[vblog]@galaxie.dreamhost.com

SELECT * FROM videolar WHERE k_link='S' AND v_link='S' AND kod='S'
LIMIT N


Count: 8332 Time=0.01s (103s) Lock=0.02s (142s) Rows=24.0 (199968),
vblog[vblog]@galaxie.dreamhost.com

SELECT * FROM kategoriler WHERE yayinda=N ORDER BY ad ASC LIMIT N


Count: 4296 Time=0.37s (1599s) Lock=0.09s (392s) Rows=8.0 (34397),
vblog[vblog]@galaxie.dreamhost.com

SELECT * FROM videolar ORDER BY rand() LIMIT N,N


Count: 2639 Time=0.09s (238s) Lock=0.03s (75s) Rows=5.9 (15581),
vblog[vblog]@galaxie.dreamhost.com

SELECT * FROM yorumlar WHERE

vidid='S' AND yayinda=N

LIMIT N,N


Count: 1753 Time=0.24s (424s) Lock=0.14s (241s) Rows=10.0 (17523),
vblog[vblog]@galaxie.dreamhost.com

SELECT * FROM videolar WHERE N=N

AND k_link='S'

ORDER BY RAND(), hit DESC

LIMIT N,N


Count: 1210 Time=0.13s (157s) Lock=0.14s (171s) Rows=16.1 (19472),
vblog[vblog]@galaxie.dreamhost.com

SELECT * FROM videolar ORDER BY id DESC LIMIT N,N


Count: 447 Time=0.22s (99s) Lock=0.14s (62s) Rows=19.9 (8878),
vblog[vblog]@galaxie.dreamhost.com

SELECT * FROM videolar WHERE baslik like 'S' OR bilgi like 'S' ORDER
BY hit DESC LIMIT N


Thanks!

Justin K


Bu ne anlama geliyor ne yapmam gerekli arkadaşlar

o siteyi orada barındıramazsın anlamına geliyor kısaca.. istediğin kadar düzenleme yaptım de taktı mı takarlar.