SMF Support > Server Performance and Configuration

MySQL on Windows 2000 server

<< < (2/5) > >>

alura:

--- Quote from: [Unknown] on March 02, 2005, 03:04:19 AM ---Likely because tables are being locked. It's also possible you may not have indexes set up properly..

--- End quote ---

Is smf that lock tables ? How I can control table locking ?

How I can check/verify/repair that ?

My database was imported by yabb->yabbSE->smf rc1->smf 1.0.2

Take in consideration that I check&optimize (and backup) tables every week. Also I defrag the partition with the database (yes, i'm using a dedicated partition for mysql).


--- Quote from: [Unknown] on March 02, 2005, 03:04:19 AM ---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.

--- End quote ---

Ok... I will try...

Thank's for your time  ;)

alura:

--- Quote from: alura on March 02, 2005, 03:14:51 AM ---Ok... I will try...

Thank's for your time  ;)

--- End quote ---

Tried... it seems a bit faster.

I you have any idea (ie why table locking during search) I'm here  ;D

[Unknown]:

--- Quote from: alura on March 02, 2005, 03:14:51 AM ---Is smf that lock tables ? How I can control table locking ?
--- End quote ---

Table locking is done automatically when a table is needed to be looked through.  It's hard to avoid, but full text can help - a feature 1.1 has.  Even so, I know of larger forums running 1.0.2 with 512 megs of ram and a slower processor that do fine....


--- Quote ---My database was imported by yabb->yabbSE->smf rc1->smf 1.0.2
--- End quote ---

That shouldn't cause any problems...

If those helped, you might also try.... log_actions, log_activity, log_search, log_floodcontrol, sessions, and settings.

-[Unknown]

alura:
Thanks'... seem that also using --low-priority-updates in mysql help a bit on win32.

Marco

alura:

--- Quote from: [Unknown] on March 02, 2005, 06:59:28 AM ---If those helped, you might also try.... log_actions, log_activity, log_search, log_floodcontrol, sessions, and settings.

-[Unknown]

--- End quote ---

I've modified also that tables... and performance increase is visible :D

So, let me understand... InnoDB tables are memory based ? You think that all small tables can be stored as InnoDB (pratically all but messages) ?

Reading mysql documentation, is clear that mysql on Linux (or any unix OS) perform much better then Win32 version but I've no possibility for now to migrate my server on linux.

Thank's again !  ;)

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

Navigation

[0] Message Index

[#] Next page

[*] Previous page