One of you is gonna fall and die, and I'm not cleaning it up!

Mal ,'War Stories'


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 3:00:25 pm PDT #5357 of 10000

A reboot is pretty much impossible given the current situation.

I'm having trouble buying into the "it's a code issue" when ita closed this place and it still happened. If the code were truly so buggy that five users could max out our connections, we wouldn't have those three weeks in between when things were just hunky dory.


Liese S. - Oct 20, 2003 5:18:44 pm PDT #5358 of 10000
"Faded like the lilac, he thought."

Yeah, I agree, Kristen.


P.M. Marc - Oct 20, 2003 6:28:58 pm PDT #5359 of 10000
So come, my friends, be not afraid/We are so lightly here/It is in love that we are made; In love we disappear

Huh.

I just got (blink out of reality)

There has been an error. It's of the type we call fatal. Please don't be scared. You're not the one that's going to die.

But not the error string.


P.M. Marc - Oct 20, 2003 6:39:31 pm PDT #5360 of 10000
So come, my friends, be not afraid/We are so lightly here/It is in love that we are made; In love we disappear

I notice I get it whenever someone is posting in any thread.

The standard too many connections, that is.


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?