SMF Support > Server Performance and Configuration

"Server Load" Advice

<< < (2/2)

el-brujo:
High...

Maybe you have a big forum or too many websites in the server...

But don't worry, i have 1 gb ram and my MySQL can do 150 querys per second (but with problems) xD

So remember depends of many factors, not only querys per seconds (SCSI disk, size of tables, etc).

[Unknown]:
That is rather high.  Your hits seem to be comparable to Ben_S's:

http://www.redandwhitekop.com/forum/index.php

More or less.  Although he has a ton more topics than you do.  You might want to look at this topic for some tips on server tweaking:

http://www.simplemachines.org/community/index.php?topic=23245.new#new

I'd also appreciate seeing mysqladmin stat, and uptime values.  If you want, I can also try to track down what's hogging your CPU/memory - it's quite possible it's MySQL, in which case slow query logging should help track it down.

-[Unknown]

Ben_S:
I would imagine flash chat is probably the problem if you have a lot of users online, disable it for 10 mins or so and see what happens to the load.

ldk:

--- Quote from: [Unknown] on January 12, 2005, 09:12:43 AM ---I'd also appreciate seeing mysqladmin stat, and uptime values.  If you want, I can also try to track down what's hogging your CPU/memory - it's quite possible it's MySQL, in which case slow query logging should help track it down.

-[Unknown]

--- End quote ---

I turned on "log slow queries" just now and restarted mySQL.  The "long query time" variable was already set to "10" -- does that seem right or should I bump it down to something lower?

[Unknown]:
Well, we have ours here set to 4... and logging enabled currently.  But, 10 isn't a bad value either - the idea is to catch slow queries, or locked queries, etc.

-[Unknown]

Navigation

[0] Message Index

[*] Previous page