Joyce: Dawn, you be good. Xander: We will. Just gonna play with some matches, run with scissors, take candy from some guy, I don't know his name.

'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.

To-do list


Kristen - Oct 20, 2003 7:39:49 pm PDT #5361 of 10000

I get it even when there's no new posts. It's the most insane thing ever.


§ ita § - Oct 20, 2003 7:57:31 pm PDT #5362 of 10000
Well not canonically, no, but this is transformative fiction.

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 |
+-----------------------+------------+


bon bon - Oct 20, 2003 8:09:46 pm PDT #5363 of 10000
It's five thousand for kissing, ten thousand for snuggling... End of list.

I exited, errors stopped.

Ah-ha!


§ ita § - Oct 20, 2003 8:11:40 pm PDT #5364 of 10000
Well not canonically, no, but this is transformative fiction.

Shawn, you're way too bored.


bon bon - Oct 20, 2003 8:17:18 pm PDT #5365 of 10000
It's five thousand for kissing, ten thousand for snuggling... End of list.

Quit trying to distract us from the TRUTH!


Tom Scola - Oct 21, 2003 1:22:04 am PDT #5366 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.

When you connect to MySQL from the command-line, are you using the same username that you use when you connect from PHP?


Cindy - Oct 21, 2003 2:20:43 am PDT #5367 of 10000
Nobody

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


Nilly - Oct 21, 2003 3:58:10 am PDT #5368 of 10000
Swouncing

For the record, I get the errors when I'm nearly the only awake Buffista, and there are no new posts anywhere.


§ ita § - Oct 21, 2003 4:11:15 am PDT #5369 of 10000
Well not canonically, no, but this is transformative fiction.

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.


Tom Scola - Oct 21, 2003 4:15:09 am PDT #5370 of 10000
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.

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?