helloo....
i started my site few days back.. even i got users as well but now i am facing the problem about server... i am paying a lot to server for hosting... even they r giving good sevice but the problem is .. They r saying that my script giving them a problem to mysql server.. here is the email which i have got from them
We are notifying you that your account, or a portion or feature of your account has caused an overload on one of our servers. We have a shared hosting environment that we must maintain at a certain level of performance. This performance is monitored and balanced by us, however there are times when accounts can cause the server’s load to increase degrading the performance for all other customers on this server.
To protect your account from further action you must agree to our request for compliance. Please respond to this message stating your intent to do so. You may either log into your control panel with us, and access this ticket via the 24/7 help desk, or provide this ticket number to our Live Chat or phone representatives.
Most common queries humtum_***:
1.Time: 17% (4000 sec)
Amount: 15% (140 queries)
Rows Examined/Sent: 129 / 129
Avg. Query Exec/Lock Time: 28 / 11 sec.
Used databases: [humtum_allnew]
Query example: use humtum_allnew; SELECT uid FROM ibwf_ses WHERE id='f156cd9df3ed461fc1a12b4b3868c9af';
2.Time: 11% (2754 sec)
Amount: 13% (121 queries)
Rows Examined/Sent: 0 / 120
Avg. Query Exec/Lock Time: 22 / 9 sec.
Used databases: [humtum_allnew]
Query example: use humtum_allnew; SELECT COUNT(*) FROM ibwf_users WHERE id='6071';
3.Time: 11% (2556 sec)
Amount: 11% (99 queries)
Avg. Query Exec/Lock Time: 25 / 11 sec.
Used databases: [humtum_allnew]
Query example: UPDATE ibwf_users SET browserm='Nokia6600', ipadd='125.18.239.135' WHERE id='5410';
4.Time: 7% (1687 sec)
Amount: 7% (65 queries)
Rows Examined/Sent: 0 / 64
Avg. Query Exec/Lock Time: 25 / 13 sec.
Used databases: [humtum_allnew]
Query example: use humtum_allnew; SELECT id FROM ibwf_users WHERE name='jogi';
5.Time: 3% (896 sec)
Amount: 3% (35 queries)
Avg. Query Exec/Lock Time: 25 / 12 sec.
Used databases: [humtum_allnew]
Query example: use humtum_allnew; DELETE FROM ibwf_ses WHERE expiretm<'1215583207';
6.Time: 3% (758 sec)
Amount: 3% (33 queries)
Rows Examined/Sent: 0 / 30
Avg. Query Exec/Lock Time: 22 / 8 sec.
Used databases: [humtum_allnew]
Query example: SELECT name FROM ibwf_users WHERE id='3839';
7.Time: 2% (674 sec)
Amount: 3% (31 queries)
Rows Examined/Sent: 0 / 31
Avg. Query Exec/Lock Time: 21 / 5 sec.
Used databases: [humtum_allnew]
Query example: use humtum_allnew; SELECT lastact FROM ibwf_users WHERE id='2467';
8.Time: 3% (786 sec)
Amount: 2% (22 queries)
Rows Examined/Sent: 0 / 22
Avg. Query Exec/Lock Time: 35 / 16 sec.
Used databases: [humtum_allnew]
Query example: SELECT hvia FROM ibwf_users WHERE id='281';
/// s
so they chmoded my databse to 0
plz help me how to sort out my problem..
how can i make my site more afficiant so that my script doest overload on thier server
THANKS IN ADVANCE
i started my site few days back.. even i got users as well but now i am facing the problem about server... i am paying a lot to server for hosting... even they r giving good sevice but the problem is .. They r saying that my script giving them a problem to mysql server.. here is the email which i have got from them
We are notifying you that your account, or a portion or feature of your account has caused an overload on one of our servers. We have a shared hosting environment that we must maintain at a certain level of performance. This performance is monitored and balanced by us, however there are times when accounts can cause the server’s load to increase degrading the performance for all other customers on this server.
To protect your account from further action you must agree to our request for compliance. Please respond to this message stating your intent to do so. You may either log into your control panel with us, and access this ticket via the 24/7 help desk, or provide this ticket number to our Live Chat or phone representatives.
Most common queries humtum_***:
1.Time: 17% (4000 sec)
Amount: 15% (140 queries)
Rows Examined/Sent: 129 / 129
Avg. Query Exec/Lock Time: 28 / 11 sec.
Used databases: [humtum_allnew]
Query example: use humtum_allnew; SELECT uid FROM ibwf_ses WHERE id='f156cd9df3ed461fc1a12b4b3868c9af';
2.Time: 11% (2754 sec)
Amount: 13% (121 queries)
Rows Examined/Sent: 0 / 120
Avg. Query Exec/Lock Time: 22 / 9 sec.
Used databases: [humtum_allnew]
Query example: use humtum_allnew; SELECT COUNT(*) FROM ibwf_users WHERE id='6071';
3.Time: 11% (2556 sec)
Amount: 11% (99 queries)
Avg. Query Exec/Lock Time: 25 / 11 sec.
Used databases: [humtum_allnew]
Query example: UPDATE ibwf_users SET browserm='Nokia6600', ipadd='125.18.239.135' WHERE id='5410';
4.Time: 7% (1687 sec)
Amount: 7% (65 queries)
Rows Examined/Sent: 0 / 64
Avg. Query Exec/Lock Time: 25 / 13 sec.
Used databases: [humtum_allnew]
Query example: use humtum_allnew; SELECT id FROM ibwf_users WHERE name='jogi';
5.Time: 3% (896 sec)
Amount: 3% (35 queries)
Avg. Query Exec/Lock Time: 25 / 12 sec.
Used databases: [humtum_allnew]
Query example: use humtum_allnew; DELETE FROM ibwf_ses WHERE expiretm<'1215583207';
6.Time: 3% (758 sec)
Amount: 3% (33 queries)
Rows Examined/Sent: 0 / 30
Avg. Query Exec/Lock Time: 22 / 8 sec.
Used databases: [humtum_allnew]
Query example: SELECT name FROM ibwf_users WHERE id='3839';
7.Time: 2% (674 sec)
Amount: 3% (31 queries)
Rows Examined/Sent: 0 / 31
Avg. Query Exec/Lock Time: 21 / 5 sec.
Used databases: [humtum_allnew]
Query example: use humtum_allnew; SELECT lastact FROM ibwf_users WHERE id='2467';
8.Time: 3% (786 sec)
Amount: 2% (22 queries)
Rows Examined/Sent: 0 / 22
Avg. Query Exec/Lock Time: 35 / 16 sec.
Used databases: [humtum_allnew]
Query example: SELECT hvia FROM ibwf_users WHERE id='281';
/// s
so they chmoded my databse to 0
plz help me how to sort out my problem..
how can i make my site more afficiant so that my script doest overload on thier server
THANKS IN ADVANCE
Comment