I get it even when there's no new posts. It's the most insane thing ever.
'Beneath You'
Buffistas Building a Better Board
Do you have problems, concerns or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.
Tom, I went into mysql to run SHOW PROCESSLIST, and every single time I tried to use the board when I was in, I got connections exceeded. I've never gotten that many connection errors in a row before. I exited, errors stopped. Still, the list only showed show processlist instead.
Here are the max% results:
+-----------------------+------------+ | Variable_name | Value | +-----------------------+------------+ | max_allowed_packet | 16776192 | | max_binlog_cache_size | 4294967295 | | max_binlog_size | 1073741824 | | max_connections | 750 | | max_connect_errors | 100 | | max_delayed_threads | 20 | | max_heap_table_size | 16777216 | | max_join_size | 4294967295 | | max_relay_log_size | 0 | | max_seeks_for_key | 4294967295 | | max_sort_length | 1024 | | max_user_connections | 100 | | max_tmp_tables | 32 | | max_write_lock_count | 4294967295 | +-----------------------+------------+
I exited, errors stopped.
Ah-ha!
Shawn, you're way too bored.
Quit trying to distract us from the TRUTH!
When you connect to MySQL from the command-line, are you using the same username that you use when you connect from PHP?
I haven't had an error that I can remember, and I've been online since a bit after 3:30am (12:30 board time). Just thought I'd mention it. Of course it doesn't look like many others were here for most of that time, but I've gotten errors in the obscene hours, before.
eta...
I spoke too soon. I just got my first one, trying to threadsuck about 375 posts from Bitches.
Timestamp: October 21, 2003, 4:37 am
For the record, I get the errors when I'm nearly the only awake Buffista, and there are no new posts anywhere.
When you connect to MySQL from the command-line, are you using the same username that you use when you connect from PHP?
Yup, using the same db.
WTF? They're limiting our mysql usage, but they're not giving us any means of monitoring it?
ETA: Does the query "SHOW FULL PROCESSLIST" show anything different?