SMF Support > Server Performance and Configuration

MySQL on Windows 2000 server

(1/5) > >>

alura:
I'm running smf (www.ilpistone.com [nofollow]) on a Windows 2000 server (is a virtual hosting, done with vmware on a dual processor Xeon 2.8 MHz shared in 4 virtual machine).

I've installed Apache 1.3.3, PHP 4.3.10, Zend Optimizer 2.5.7 and MySQL 4.1.10, ad running SMF 1.0.2

All works smooth on surfing the board, but when someone make a new post there are big slow down and the couse seem to be the mysql server that rise cpu activity to 100% for some second. Simultaneos post make long delay. I can see page generated in up 40 seconds after someone make a post (normally page generation is about 0.6 - 0.9 second).

I've tried different version of mysql, changed buffers, cache, also disable concurrent inserts (this seem help a bit) but I can't have good performance after posts.

Any help ?

Thank's in advance

Marco (alura)
www.ilpistone.com [nofollow]

Ben_S:
Tried optimizing your tables?

[Unknown]:
You're actually running a server within VMware?

Forgive me if I can't imagine that being efficient, but doing so isn't much different from using less ram and a slower processor/processors.

Regardless, you can try using InnoDB for some tables, but even then it probably won't affect insertion times.  If you look at the processlist, what query or queries is it being held up by?

-[Unknown]

alura:

--- Quote from: Ben_S on March 01, 2005, 02:04:39 PM ---Tried optimizing your tables?

--- End quote ---

Thank's Ben, but tables are optimized.


--- Quote from: [Unknown] on March 01, 2005, 05:38:42 PM ---You're actually running a server within VMware?

Forgive me if I can't imagine that being efficient, but doing so isn't much different from using less ram and a slower processor/processors.

Regardless, you can try using InnoDB for some tables, but even then it probably won't affect insertion times. If you look at the processlist, what query or queries is it being held up by?

-[Unknown]

--- End quote ---

Yes, unknown, I'm using a double xeon 2.8 server split in four virtual machine (i have 512 mbyte of ram on my virtual machine). As I can see it is little slower then my laptop (a athlon xp 2.8 + with 512mbyte ram).

I have made some test on my laptop. If I run a search in smf on one IE window (it will take up 20 second, taking about 100% processor that slow down all OS) and then open a borad index in another window, the second is stuck until search completes.

It seems that I was not able to do simultaneos operation on mysql (also with "concurrent inserts" enabled).

Related InnoDB, what table you suggest to convert ? All ? Only message ?

Note: my board has 295130 posts and 14043 threads.

Thank's.

Marco (alura)
www.ilpistone.com [nofollow]

[Unknown]:

--- Quote from: alura on March 02, 2005, 02:43:14 AM ---I have made some test on my laptop. If I run a search in smf on one IE window (it will take up 20 second, taking about 100% processor that slow down all OS) and then open a borad index in another window, the second is stuck until search completes.

--- End quote ---

Likely because tables are being locked.  It's also possible you may not have indexes set up properly..

I suggest you try making topics, log_topics, attachments, members, log_boards, and log_mark_read InnoDB for a start.  Some tables, such as messages, are usually better of MyISAM.

-[Unknown]

Navigation

[0] Message Index

[#] Next page