Database / configuration error when forums are active and already running

Does anybody suffers from periodical temporary "database/configuration error" - some kind of database cache overflow, which makes forum anavailable for few (1-15) minutes??

sounds like a server issue, do you know if your database exists in the same physical location as your webserver (the same machine) or if it has to talk across a network?

Same machine.

Polar
in any way it's database problem not miniBB problem. database becomes unavailable for 1-15 minutes on your server.. you can turn on error reporting by adding error_reporting(E_ALL); line into setup_options.php file and add echo mysql_error(); line right after mysql_connect lines on top of the setup_mysql.php file to see what kind of error message does php return when connecting to the database

Ok, i`ll try it.

And this is mysql settings. Possible it will give some key:

back_log: 50
binlog_cache_size: 32768
character_set: cp1251
concurrent_insert: ON
connect_timeout: 5
delay_key_write: ON
delayed_insert_limit: 100
delayed_insert_timeout: 300
delayed_queue_size: 1000
have_isam: YES
interactive_timeout: 28800
join_buffer_size: 131072
key_buffer_size: 268431360
large_files_support: ON
long_query_time: 10
max_allowed_packet: 1047552
max_binlog_cache_size: 4294967295
max_binlog_size: 1073741824
max_connections: 200
max_connect_errors: 10
max_delayed_threads: 20
max_heap_table_size: 16777216
max_join_size: 4294967295
max_sort_length: 1024
max_user_connections: 10
max_tmp_tables: 32
max_write_lock_count: 4294967295
myisam_max_extra_sort_file_size: 256
myisam_max_sort_file_size: 2047
myisam_recover_options: 6
myisam_sort_buffer_size: 67108864
net_buffer_length: 16384
net_read_timeout: 30
net_retry_count: 1000000
net_write_timeout: 60
port: 3306
protocol_version: 10
record_buffer: 2093056
record_rnd_buffer: 2093056
query_buffer_size: 0
safe_show_database: ON
sort_buffer: 2097144
sql_mode: 0
table_cache: 256
table_type: MYISAM
thread_cache_size: 8
thread_stack: 65536
timezone: MSK
tmp_table_size: 209715200
version: 3.23.54
wait_timeout: 60

maybe this line?

max_tmp_tables: 32

Team, after turning on errors - they are almost on every page.
I had to turn it off...

Polar
What kind of errors?

For example: on the statistic page...

Notice: Undefined variable: days in /home/public_html/forum/bb_func_stats.php on line 17

Notice: Undefined variable: top in /home/public_html/forum/bb_func_stats.php on line 25

Notice: Undefined variable: xtr in /home/public_html/forum/setup_mysql.php on line 401

Notice: Undefined variable: list_stats_popular in /home/public_html/forum/bb_func_stats.php on line 55

Notice: Undefined variable: xtr in /home/public_html/forum/setup_mysql.php on line 378

Notice: Undefined variable: list_stats_viewed in /home/public_html/forum/bb_func_stats.php on line 74

Notice: Undefined variable: list_stats_aUsers in /home/public_html/forum/bb_func_stats.php on line 93


On the search page...

Notice: Undefined variable: searchWhere in /home/public_html/forum/bb_func_search.php on line 42

Notice: Undefined variable: searchHow in /home/public_html/forum/bb_func_search.php on line 42

Notice: Undefined variable: searchFor in /home/public_html/forum/bb_func_search.php on line 43

Notice: Undefined variable: days in /home/public_html/forum/bb_func_search.php on line 49

e.t.c...

But, Team, what you can say about mysql settings posted above??

I have set error_reporting(E_ALL); on.
But I don't get errors only if my search has one character.

Polar
Which version of miniBB do you have? 1.7b should work WITHOUT these errors (and as for example, it is working with all errors turned on like on this server).

Team, this is 1.5 and soon i will upgrade it (with your help) to 1.7+
:)

But now i`m very exited with database/configuration. PLEEEEAAASE, check mysql settings posted above!!!

Polar
All I can say - upgrade to 1.7 first, then you will get off of these errors. Second, this error with database, as I might know, could appear when your hosting provider has more than one database, and some of databases (not obligately yours) has very active overload. Try to use command FLUSH HOSTS on mysql.

How to use this command?

Via Mysql Front, for example, PHP My Admin, direct command shell etc.