joomla database problem

i got this from the support now

We could see that the database solar_joomla causing overload on the server. We have disabled the database now. Please review the details below and get back to us with a resolution for this.

+++++++++++++++++++++++
29021 mido 18 0 45520 20m 6764 R 36.2 0.5 0:01.37 /usr/bin/php /home/mido/public_html/index.php

|
| 12 | mido_mido | localhost | solar_joomla | Sleep | 6 | | |
| 14 | mido_mido | localhost | solar_joomla | Sleep | 6 | | |
| 15 | mido_mido | localhost | solar_joomla | Query | 6 | closing tables | SELECT * FROM jos_seyret_items WHERE published='1' AND featured = '1' ORDER BY RAND() LIMIT 0, 1 |
| 16 | mido_mido | localhost | solar_joomla | Query | 5 | Opening tables | select t.name from jos_tag_term as t left join jos_tag_term_content as c on c.tid=t.id where c.cid= |
| 17 | mido_mido | localhost | solar_joomla | Sleep | 6 | | |
| 18 | mido_mido | localhost | solar_joomla | Sleep | 7 | | |
| 19 | mido_mido | localhost | solar_joomla | Query | 5 | Opening tables | SELECT * FROM jos_session WHERE session_id = 'e86707e669270dc5d1290ce213f16f17' |
| 20 | mido_mido | localhost | solar_joomla | Query | 4 | Opening tables | SELECT * FROM jos_session WHERE session_id = 'fbf2b9fe71c5fa7626092b3eb7fbb0f3' |
| 21 | colegios_copp1 | localhost | colegios_copp1 | Query | 3 | Opening tables | delete from `colegios_copp1`.cpg_sessions where time<1253775784 and remember=0 |
| 22 | mido_mido | localhost | solar_joomla | Query | 3 | Opening tables | SELECT * FROM jos_session WHERE session_id = 'cea61226060be6ed59ed5f7240d33c25' |
| 23 | mido_mido | localhost | solar_joomla | Query | 3 | Opening tables | SELECT * FROM jos_session WHERE session_id = 'b6a6a16321dbe7dfb4b05b7ed89c240c' |
| 24 | mido_mido | localhost | solar_joomla | Query | 3 | Opening tables | SELECT * FROM jos_session WHERE session_id = '94f62590fe1995e482d6fc85d8c78a92' |
| 25 | mido_mido | localhost | solar_joomla | Query | 1 | Opening tables | SELECT * FROM jos_session WHERE session_id = '63150ed7c136639ee5cce5f1466ac465' |
| 26 | mido_mido | localhost | solar_joomla | Query | 0 | Opening tables | SELECT * FROM jos_session WHERE session_id = '871d66b5fffeb3d5f42e8f873c43b0bd' |
| 27 | root | localhost | | Query | 0 | | show


i dont know what to do please advise !

 

Did you get a DDOS attack? ( Distributed Denial of Service )

 

no i just got more visitors to my site and it makes the site slow and takes more server resources . is there any tips to decrease database load ??

 

Yes, but you probably will not like the answer. You can disable some plugins/extensions.

 

how i can pick the plugins/extensions that causes the load !

 

Or goto phpmyadmin, select all tables and click on optimize.
Are you using any stats addon?
Delete the old stats in that case.

 

how many times i need to optimizie tables through phpmyadmin monthly ?
i just installed joomlastats lately but the db issue is old, also im using google analyhtics, what you mean by deleting the old stats !

 

Everytime you feel a slow down.

 

i did not get it yet , can you explain more!

 

When we install add ons, and uninstall, and with regular use, databases get messy, and should be optimized from time to time. There's no definite period, it depends upon your site.

 

oh yeah thank you but is this also related to deleting the old stats or what !

 

No no, since you already deleted joomla stats, this isn't required. Did you also delete the tables for it in the db?

 

i did not deleted joomla stats ! i just installed it 2 days ago since i have the database for 6 days im sure joomla stats is not the reason .

 

Are you on shared hosting?

 

i have a reseller

 

probably one of your joomla extensions causes this. Upgrade Joomla and all the extensions to the latest versions! If you don't need somthing (plugin for example) deactivate it