Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

Geek Culture / Don't take my Forum Away again!

Author
Message
BatVink
Moderator
21
Years of Service
User Offline
Joined: 4th Apr 2003
Location: Gods own County, UK
Posted: 22nd Jul 2005 19:13
Link
Do you know what it's like to wake up and find that your lifeline has been removed! I've been a quivering wreck all morning. I'm on my fifth can of coke already, I can't eat, I won't sleep tonight from the shock.

2 Months notice, next time, please.



BatVink
Back to top
Profile PM Email
Richard Davey
Retired Moderator
22
Years of Service
User Offline
Joined: 30th Apr 2002
Location: On the Jupiter Probe
Posted: 22nd Jul 2005 19:25
Link
No promises this will remain stable - for some reason MySQL keeps peaking out at 99.9% CPU time and then dropping off again. When this happens I dare say you'll all get "unable to connect" style errors. Don't bother telling me, there's nothing I have time to do about it right now, and the new servers are only a matter of hours away (the problem being, I don't know HOW many hours.. we ordered specific custom built servers, so we might have to put up with flaky box here for the weekend).
My suggestions to everyone? COPY your message to your clipboard before clicking "Post" - because theres a very good chance it'll die.

A great many people think they are thinking when they are really rearranging their prejudices.
Back to top
Profile PM Email Website
Dave J
Retired Moderator
21
Years of Service
User Offline
Joined: 11th Feb 2003
Location: Secret Military Pub, Down Under
Posted: 22nd Jul 2005 21:05
Link
Quote: "My suggestions to everyone? COPY your message to your clipboard before clicking "Post" - because theres a very good chance it'll die."


Pfft, like I have the time to do that?


"Computers are useless, they can only give you answers."
Back to top
Profile PM Email
Nicholas Thompson
20
Years of Service
User Offline
Joined: 6th Sep 2004
Location: Bognor Regis, UK
Posted: 22nd Jul 2005 21:16
Link
assume its a windows server rich... Thats a strange one! I remember I had a similar problem with Explorer.exe once. It used to just sit there doing 99.9% CPU and gradually eating more memory up too (I woke up one morning to see Explorer.EXE using abuot 2Gb RAM and my remaining hard disk space being substantially lower!!).

Would a MySQL reinstall not help?

My Website:
Back to top
Profile PM Email Website
BatVink
Moderator
21
Years of Service
User Offline
Joined: 4th Apr 2003
Location: Gods own County, UK
Posted: 22nd Jul 2005 21:24
Link
Quote: "Quote: "My suggestions to everyone? COPY your message to your clipboard before clicking "Post" - because theres a very good chance it'll die."

Pfft, like I have the time to do that?
"


CTRL-A CTRL-C Done!

BatVink
Back to top
Profile PM Email
Dave J
Retired Moderator
21
Years of Service
User Offline
Joined: 11th Feb 2003
Location: Secret Military Pub, Down Under
Posted: 22nd Jul 2005 21:30
Link
Quote: "CTRL-A CTRL-C Done!"


Like I said, too much effort.


"Computers are useless, they can only give you answers."
Back to top
Profile PM Email
Hamish McHaggis
21
Years of Service
User Offline
Joined: 13th Dec 2002
Location: Modgnik Detinu
Posted: 22nd Jul 2005 21:37
Link
I always do that anyway. I've lost many a 5000 word essay that way.

More tea Vicar?
Back to top
Profile PM Email Website
Nicholas Thompson
20
Years of Service
User Offline
Joined: 6th Sep 2004
Location: Bognor Regis, UK
Posted: 22nd Jul 2005 22:24
Link
You lost them my copying to the clipboard? Hehe...

The amount of times I've done the Ctrl A, Ctrl C things but missed the C and hit the X and crapped myself when all my work dissapeared!

My Website:
Back to top
Profile PM Email Website
Neofish
20
Years of Service
User Offline
Joined: 7th Apr 2004
Location: A swimming pool of coke
Posted: 22nd Jul 2005 22:27
Link
fool

van: i have more than that much coke just to get me into the computer chair!!

Back to top
Profile PM Email Website
Frozen Flame
20
Years of Service
User Offline
Joined: 22nd Jul 2004
Location:
Posted: 22nd Jul 2005 23:17
Link
its.. control c, control v

now let me go copy this message so i can tell it to you again when this is over.


School is supposed to be teaching our kids how to read and write. Not about dangerous drugs like PHP.
Back to top
Profile PM Email Website
Kentaree
22
Years of Service
User Offline
Joined: 5th Oct 2002
Location: Clonmel, Ireland
Posted: 22nd Jul 2005 23:25
Link
Ctrl a is to select all the text

Desktop: AMD Athlon XP2800+,Radeon 9800 128MB, 1GB DDR RAM
Laptop: AMD Athlon 64M 3000+,Mobility Radeon 9700 128MB, 512MB DDR RAM
Back to top
Profile PM Email Website
adr
21
Years of Service
User Offline
Joined: 21st May 2003
Location: Job Centre
Posted: 22nd Jul 2005 23:46 Edited at: 22nd Jul 2005 23:47
Link
Quote: "Would a MySQL reinstall not help?"

It's not running on windows you know - magical fixes like that don't exist on Linux servers. At least, as far as I can remember this is running on a Linux server... Perhaps an optimise tables would help, but I'm guessing that's what happened during the downtime.

Richard Davey

Dunno if you've already tried this, but add in the following lines into my.cnf and do a graceful restart, a log will appear with all the queries which took longer than long_query_time to complete.

[mysqld]
log_slow_queries=/var/log/slow-queries.log
long_query_time=2

Also, depending on how you measure CPU usage under linux, my understanding is that it can encompass a couple of bottlenecks. For example, if a process is always waiting for disk access, then that can contribute to its processor usage; the time spent on the process in question is longer because of slow disc access. So try out some profiling on disk, memory and CPU.

It also might be worth taking an offline backup of the tables and running a repair on them. Naturally, you couldn't use the repaired tables (because repairs can take days), but an analysis would show if MySQL is suffering from corrupted indices. When using myisamchk you pass in "-n" as a switch. This forces the repair to take place entirely on disk. Believe it or not, for large tables this is faster than using memory because the keys are not being paged in and out of memory all the time. I found this out when trying to repair a 55 million row table.

New 'n' Improved sig details how little I accomplish
Back to top
Profile PM Website
Hawkeye
21
Years of Service
User Offline
Joined: 19th Sep 2003
Location: SC, USA
Posted: 23rd Jul 2005 00:01
Link
Rich, you are aware that I have no life beyond the forums, right? So how am I supposed to "get on with life for a day/evening" when... well, you get it


meh blog
Back to top
Profile PM Email Website
Nicholas Thompson
20
Years of Service
User Offline
Joined: 6th Sep 2004
Location: Bognor Regis, UK
Posted: 23rd Jul 2005 00:20
Link
wow - adr, you seem to know your stuff!

I am aware that simple fixes dont exist in linux, thats why whenever I get something done in linux, even if its a simple thing like installing an RPM, I get a real sense and feeling of achievement Hehe.

I personally never understand why people CHOSE to run a server with windows on it, unless they really REALLY need a specific server deamon to run on it that wont under linux (maybe for some wierd game?!).

Nick

My Website:
Back to top
Profile PM Email Website
soapyfish
21
Years of Service
User Offline
Joined: 24th Oct 2003
Location: Yorkshire, England
Posted: 23rd Jul 2005 00:30
Link
Quote: "Rich, you are aware that I have no life beyond the forums, right? So how am I supposed to "get on with life for a day/evening" when... well, you get it "


You could always do some coding.

Formely play2kill

When the power of love overcomes the love of the power... the world will know peace. - Jimi Hendrix
Back to top
Profile PM Email Website
Hawkeye
21
Years of Service
User Offline
Joined: 19th Sep 2003
Location: SC, USA
Posted: 23rd Jul 2005 00:32
Link
No, you misunderstand, I have no life beyond the forums...


meh blog
Back to top
Profile PM Email Website
IanM
Retired Moderator
22
Years of Service
User Offline
Joined: 11th Sep 2002
Location: In my moon base
Posted: 23rd Jul 2005 01:23
Link
You don't need a life to code ... in fact, I've found out that coding can be a complete replacement for life ... er, hmmm

*** Coming soon - Network Plug-in - Check my site for info ***
For free Plug-ins and source code http://www.matrix1.demon.co.uk
Back to top
Profile PM Email Website
Jake Blues
20
Years of Service
User Offline
Joined: 19th Jun 2004
Location: United States
Posted: 23rd Jul 2005 01:27
Link
Quote: "You don't need a life to code ... in fact, I've found out that coding can be a complete replacement for life ... er, hmmm "


IanM's Social Life:
hey cube, wanna go out somewhere tonight?




---->http://www.freewebs.com/neodragon64
http://neodragon64.proboards41.com/<----
Back to top
Profile PM Email Website
adr
21
Years of Service
User Offline
Joined: 21st May 2003
Location: Job Centre
Posted: 23rd Jul 2005 01:40
Link
Quote: "wow - adr, you seem to know your stuff!"

Cheers, but I actually can't stand doing any complex linux admin. If it doesn't work out the box I'm always in fear that the solution will involve compiling & installing 3rd party libraries - yuk. I tried to get a webcam working and it took me a week or something silly. God bless WinXP for its user-facing simplicity.


All that knowledge has just come from working in a High-Load LAMP environment for a couple of years. You can't beat paid-for MySQL support - those guys rock.

New 'n' Improved sig details how little I accomplish
Back to top
Profile PM Website
Jeku
Moderator
21
Years of Service
User Offline
Joined: 4th Jul 2003
Location: Vancouver, British Columbia, Canada
Posted: 23rd Jul 2005 12:59
Link
@Rick - New servers---- hmmmmm---- does this mean the new version of the forum code, too?

One can only hope.


My "everyone else has one so why can't I?" blog: http://www.jeku.com/blog/
Back to top
Profile PM Website
Back to top

Login to post a reply

Server time is: 2024-11-27 22:53:37
Your offset time is: 2024-11-27 22:53:37