+- MyBB.de Forum (https://www.mybb.de/forum)
+-- Forum: Archiv (https://www.mybb.de/forum/forum-57.html)
+--- Forum: MyBB 1.6.x (https://www.mybb.de/forum/forum-58.html)
+---- Forum: Allgemeiner Support (https://www.mybb.de/forum/forum-59.html)
+---- Thema: SQL Error 1203 - max_user_connections (/thread-16729.html)
SQL Error 1203 - max_user_connections - happyspeedy - 12.08.2010
Folgende Fehlermeldung hab ich schon seit längerem, diese tritt immer häufiger auf:
Zitat:MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1203 - User web1501 already has more than 'max_user_connections' active connections
Query:
[READ] Unable to connect to MySQL server
Hab den Support mal angeschrieben meines Hosters, ob er max. connection vielleicht erhöhen kann, dieser befindet sich in Amerika und gab mir diese Antwort:
Zitat:Thank you for contacting us. The max connection allowed per user is 15 and will not be raised. This is a setting set at the root level of the shared hosting server. This is to allow other users on the serve the same opportunity to connect to the server by not allow another to use all connections to himself.
What is happening is your MySQL user is connecting to the server and the query is taking too long. Ideally the query should take less than 1/2 second. You can review the /tmp/mysql_slow_queries to determine which query is running longer than normal and optimize it. If the tables are not indexed, this can take longer to query.
Another solution is to use persistent MySQL connection. Instead of multiple connections to the server by the same user, you have just one connecting to the server to run these multiple queries.
Ich verstehe das leider nicht so ganz, was und wie ich es optimieren muss, hat jemand eine Idee ???
Das aktuelle Log-File dazu:
Code:
# Fri Dec 19 09:40:40 2008
# Query_time: 34 Lock_time: 0 Rows_sent: 110 Rows_examined: 110
SELECT *,
`TABLE_SCHEMA` AS `Db`,
`TABLE_NAME` AS `Name`,
`ENGINE` AS `Engine`,
`ENGINE` AS `Type`,
`VERSION` AS `Version`,
`ROW_FORMAT` AS `Row_format`,
`TABLE_ROWS` AS `Rows`,
`AVG_ROW_LENGTH` AS `Avg_row_length`,
`DATA_LENGTH` AS `Data_length`,
`MAX_DATA_LENGTH` AS `Max_data_length`,
`INDEX_LENGTH` AS `Index_length`,
`DATA_FREE` AS `Data_free`,
`AUTO_INCREMENT` AS `Auto_increment`,
`CREATE_TIME` AS `Create_time`,
`UPDATE_TIME` AS `Update_time`,
`CHECK_TIME` AS `Check_time`,
`TABLE_COLLATION` AS `Collation`,
`CHECKSUM` AS `Checksum`,
`CREATE_OPTIONS` AS `Create_options`,
`TABLE_COMMENT` AS `Comment`
FROM `information_schema`.`TABLES`
WHERE BINARY `TABLE_SCHEMA` IN ('web1501')
LIMIT 250 OFFSET 0
# Fri Dec 19 09:40:40 2008
# Query_time: 33 Lock_time: 0 Rows_sent: 110 Rows_examined: 110
use web1501;
SELECT *,
`TABLE_SCHEMA` AS `Db`,
`TABLE_NAME` AS `Name`,
`ENGINE` AS `Engine`,
`ENGINE` AS `Type`,
`VERSION` AS `Version`,
`ROW_FORMAT` AS `Row_format`,
`TABLE_ROWS` AS `Rows`,
`AVG_ROW_LENGTH` AS `Avg_row_length`,
`DATA_LENGTH` AS `Data_length`,
`MAX_DATA_LENGTH` AS `Max_data_length`,
`INDEX_LENGTH` AS `Index_length`,
`DATA_FREE` AS `Data_free`,
`AUTO_INCREMENT` AS `Auto_increment`,
`CREATE_TIME` AS `Create_time`,
`UPDATE_TIME` AS `Update_time`,
`CHECK_TIME` AS `Check_time`,
`TABLE_COLLATION` AS `Collation`,
`CHECKSUM` AS `Checksum`,
`CREATE_OPTIONS` AS `Create_options`,
`TABLE_COMMENT` AS `Comment`
FROM `information_schema`.`TABLES`
WHERE BINARY `TABLE_SCHEMA` IN ('web1501')
LIMIT 250 OFFSET 0
# Fri Dec 19 09:45:50 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 110 Rows_examined: 110
use web1501;
SELECT *,
`TABLE_SCHEMA` AS `Db`,
`TABLE_NAME` AS `Name`,
`ENGINE` AS `Engine`,
`ENGINE` AS `Type`,
`VERSION` AS `Version`,
`ROW_FORMAT` AS `Row_format`,
`TABLE_ROWS` AS `Rows`,
`AVG_ROW_LENGTH` AS `Avg_row_length`,
`DATA_LENGTH` AS `Data_length`,
`MAX_DATA_LENGTH` AS `Max_data_length`,
`INDEX_LENGTH` AS `Index_length`,
`DATA_FREE` AS `Data_free`,
`AUTO_INCREMENT` AS `Auto_increment`,
`CREATE_TIME` AS `Create_time`,
`UPDATE_TIME` AS `Update_time`,
`CHECK_TIME` AS `Check_time`,
`TABLE_COLLATION` AS `Collation`,
`CHECKSUM` AS `Checksum`,
`CREATE_OPTIONS` AS `Create_options`,
`TABLE_COMMENT` AS `Comment`
FROM `information_schema`.`TABLES`
WHERE BINARY `TABLE_SCHEMA` IN ('web1501')
LIMIT 250 OFFSET 0
# Fri Dec 19 09:46:15 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 110 Rows_examined: 110
SELECT *,
`TABLE_SCHEMA` AS `Db`,
`TABLE_NAME` AS `Name`,
`ENGINE` AS `Engine`,
`ENGINE` AS `Type`,
`VERSION` AS `Version`,
`ROW_FORMAT` AS `Row_format`,
`TABLE_ROWS` AS `Rows`,
`AVG_ROW_LENGTH` AS `Avg_row_length`,
`DATA_LENGTH` AS `Data_length`,
`MAX_DATA_LENGTH` AS `Max_data_length`,
`INDEX_LENGTH` AS `Index_length`,
`DATA_FREE` AS `Data_free`,
`AUTO_INCREMENT` AS `Auto_increment`,
`CREATE_TIME` AS `Create_time`,
`UPDATE_TIME` AS `Update_time`,
`CHECK_TIME` AS `Check_time`,
`TABLE_COLLATION` AS `Collation`,
`CHECKSUM` AS `Checksum`,
`CREATE_OPTIONS` AS `Create_options`,
`TABLE_COMMENT` AS `Comment`
FROM `information_schema`.`TABLES`
WHERE BINARY `TABLE_SCHEMA` IN ('web1501')
LIMIT 250 OFFSET 0
# Fri Dec 19 09:48:58 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_attachments'
# Fri Dec 19 09:49:06 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_banned'
# Fri Dec 19 09:49:16 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_downloads'
# Fri Dec 19 09:49:23 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_fc_config'
# Fri Dec 19 09:49:32 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_fc_gossip'
# Fri Dec 19 09:49:49 2008
# Query_time: 14 Lock_time: 0 Rows_sent: 148533 Rows_examined: 148533
SELECT * FROM `web1501`.`mybb_fc_patterns`
# Fri Dec 19 09:49:53 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_fc_templates'
# Fri Dec 19 09:49:59 2008
# Query_time: 6 Lock_time: 0 Rows_sent: 22634 Rows_examined: 22634
SELECT * FROM `web1501`.`mybb_fc_templates`
# Fri Dec 19 09:50:01 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_fc_thatindex'
# Fri Dec 19 09:50:09 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_games_cats'
# Fri Dec 19 09:50:18 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_icons'
# Fri Dec 19 09:50:26 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_moderatorlog'
# Fri Dec 19 09:50:34 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_pollvotes'
# Fri Dec 19 09:52:03 2008
# Query_time: 88 Lock_time: 0 Rows_sent: 47380 Rows_examined: 47380
SELECT * FROM `web1501`.`mybb_posts`
# Fri Dec 19 09:52:21 2008
# Query_time: 17 Lock_time: 0 Rows_sent: 6078 Rows_examined: 6078
SELECT * FROM `web1501`.`mybb_privatemessages`
# Fri Dec 19 09:52:29 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_searchlog'
# Fri Dec 19 09:53:23 2008
# Query_time: 54 Lock_time: 0 Rows_sent: 22897 Rows_examined: 22897
SELECT * FROM `web1501`.`mybb_searchlog`
# Fri Dec 19 09:53:49 2008
# Query_time: 25 Lock_time: 0 Rows_sent: 32272 Rows_examined: 32272
SELECT * FROM `web1501`.`mybb_sessions`
# Fri Dec 19 09:53:51 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_settinggroups'
# Fri Dec 19 09:53:58 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_tasks'
# Fri Dec 19 09:54:10 2008
# Query_time: 3 Lock_time: 0 Rows_sent: 6124 Rows_examined: 6124
SELECT * FROM `web1501`.`mybb_threads`
# Fri Dec 19 09:54:14 2008
# Query_time: 3 Lock_time: 0 Rows_sent: 48808 Rows_examined: 48808
SELECT * FROM `web1501`.`mybb_threadsread`
# Fri Dec 19 09:54:20 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_tournaments'
# Fri Dec 19 09:54:25 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 7511 Rows_examined: 7511
SELECT * FROM `web1501`.`mybb_userfields`
# Fri Dec 19 09:54:27 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_usergroups'
# Fri Dec 19 09:54:38 2008
# Query_time: 10 Lock_time: 0 Rows_sent: 7506 Rows_examined: 7506
SELECT * FROM `web1501`.`mybb_users`
# Fri Dec 19 09:54:44 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_warningtypes'
# Fri Dec 19 09:55:39 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'ajax_chat_bans'
# Fri Dec 19 09:55:48 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_announcements'
# Fri Dec 19 09:55:55 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_badwords'
# Fri Dec 19 09:56:03 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_custom_links'
# Fri Dec 19 09:56:10 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_fc_bans'
# Fri Dec 19 09:56:18 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_fc_connections'
# Fri Dec 19 09:56:30 2008
# Query_time: 5 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT * FROM `web1501`.`mybb_fc_patterns`
# Fri Dec 19 09:56:33 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_fc_templates'
# Fri Dec 19 09:56:40 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_forumsread'
# Fri Dec 19 09:56:47 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_games_settings'
# Fri Dec 19 09:56:56 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_maillogs'
# Fri Dec 19 09:57:05 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_pmarchive'
# Fri Dec 19 09:57:50 2008
# Query_time: 42 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT * FROM `web1501`.`mybb_posts`
# Fri Dec 19 09:57:59 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_searchlog'
# Fri Dec 19 09:58:18 2008
# Query_time: 19 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT * FROM `web1501`.`mybb_searchlog`
# Fri Dec 19 09:58:22 2008
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT * FROM `web1501`.`mybb_sessions`
# Fri Dec 19 09:58:25 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_settings'
# Fri Dec 19 09:59:12 2008
# Query_time: 19 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT * FROM `web1501`.`mybb_users`
# Fri Dec 19 09:59:16 2008
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE TRIGGER_SCHEMA= 'web1501' and EVENT_OBJECT_TABLE = 'mybb_warnings'Aus dem ich überhaupt nicht schlau werde, kann mir jemand vielleicht auf die Sprünge da helfen?
Meine aktuelle MyBB Version ist 1.6.0
PHP Version 5.2.13
SQL Engine MySQL 5.1.47
Hoffe, es kann mir jemand helfen...
RE: SQL Error 1203 - max_user_connections - StefanT - 13.08.2010
Das MyBB baut immer nur eine Verbindung auf, d.h. es können gleichzeitig 15 Benutzer auf die Seite zugreifen. Wenn irgendwelche Codes weitere Verbindungen aufbauen, werden es natürlich weniger.
RE: SQL Error 1203 - max_user_connections - frostschutz - 13.08.2010
Also einige der Queries im Log scheinen mir vom Backup-Task zu stammen, denn etwas anderes gibt es nicht in MyBB das SELECT * FROM mybb_posts macht. Da musst du halt ggf. den Backup-Task abstellen und Backups mit dem phpMyAdmin des Hosters machen (sofern für den die Limits dann nicht gelten, ist bei manchen Hosts so).
Insgesamt klingt mir das aber nach einer ziemlich überladenen Kiste bzw. nach einem Freehost.