Hi,

I have 1 Master site and 3 slave sites in same database. My site provider did shut my sites down, because my database confused their system? My database had too many queries and it overloads.

I don't know what to do with this problem.

Our web host support said that they will not let us open our site, before we solve our database problems. -- There is more than 5000 tables in my database and we have about 1500 to 2000 visitor in every day.

Will it help if I move slave sites to theur own databases, or what will I do?

This is the problem, but I don't understand it?

| 15725117 | autoviih_autovii | localhost | autoviih_autohifi | Query |
5 | update | INSERT INTO master_sef_sm_cache_items set id ='308', ordering='712', name='G88A SMIN-20P Blade sulak |
| 15726429 | autoviih_autovii | localhost | autoviih_autohifi | Query |
4 | end | update tronica_joomlawatch_info set value = value+1 where (`group` = '4' and name = '4' and date = ' |
| 15726592 | autoviih_autovii | localhost | autoviih_autohifi | Query |
4 | statistics | SELECT oldurl, newurl FROM master_redirection WHERE oldurl = 'Autosoittimet/Pioneer-DEH-4200SD-CD-vi |
| 15726593 | autoviih_autovii | localhost | autoviih_autohifi | Sleep |
4 | | |
| 15726595 | autoviih_autovii | localhost | autoviih_autohifi | Query |
4 | Opening tables | SELECT oldurl, dateadd FROM master_redirection WHERE newurl = 'index.php?option=com_jcomments&lang=f |
| 15726670 | autoviih_autovii | localhost | autoviih_autohifi |
Query | 4 | Opening tables | SELECT * FROM
master_session WHERE session_id = '11a84c4d657db7b8da9db5a56a566be0'
| 15726676 | autoviih_autovii | localhost | autoviih_autohifi |
Query | 1 | Opening tables | SELECT * FROM
master_session WHERE session_id =
'11a84c4d657db7b8da9db5a56a566be0' |
| 15726677 | autoviih_autovii | localhost | autoviih_autohifi |
Query | 0 | Opening tables | SELECT * FROM
master_session WHERE session_id = 'b79dbe4e011a9fa2e2f21db74a1bfe0d'
| 15726680 | autoviih_autovii | localhost | autoviih_autohifi |
Query | 0 | Opening tables | SELECT * FROM
master_session WHERE session_id =
'b79dbe4e011a9fa2e2f21db74a1bfe0d' |
| 15726681 | autoviih_autovii | localhost | autoviih_autohifi |
Query | 0 | Opening tables | SELECT * FROM
master_session WHERE session_id = '11a84c4d657db7b8da9db5a56a566be0'

I don't understand why your hosting provide complain because you have plenty of MySQL tables.
5000 table is acceptable. This correspond to 15,000 files in a same directory (DB) on the disk.
MySQL use 3 files for each table.

Concerning the queries, it seems related to the SEF extension and its cache.

I don't know which SEF extension you are using but if your hosting provider complain this is perhaps because the SEF cache store plenty of information in the DB.
The table used seems "master_sef_sm_cache_items" and "master_redirection".
The other queries seems relative to the read of the session from the DB
master_session

Based on the info that you provide here, all the request concern the same website (the "master_") and I don't see what could change if you have the "master" alone in the DB.

You can always make each website to have its own DB.
Up to you to see if you are sharing extension and therefore MySQL tables.

Hi,

I use SH404SEF newest version.

The host told me that there is 5000 tables and only 300 are in use. But all those 5000 tables make queries for those 300 tables and that cause overload to server.

This problem have come two weeks ago

The table name that you provided to me are SEF related.

The 5000 tables that make queries for the other one are perhaps the links to share the data.
This may be normal if you shared extensions.