Slow searchs

minskog · June 07, 2005, 06:42:03 AM

I migrate a big forum from phpbb and all ok but the searchs.

The forum have more than 830.000 posts, 27.000 threads and 3.000 users. When i make one search the cpu goes to 100% and need over 50/60 seconds to show the results. Anyone knows how to fix it?

Ben_S · June 07, 2005, 07:09:26 AM

SMF 1.1 has greatly improved search performance, untill that comes out though I guess you are kind of stuck $:-\$ .

Enigma · June 07, 2005, 09:49:26 AM

just out of curiousity, what are the specs of the coputer that hosts your forum?

minskog · June 07, 2005, 09:54:33 AM

Pentium 4 2.8 HT, 1 gb ram ecc, hd sata. Load average 0.35

[Unknown] · June 07, 2005, 02:55:03 PM

Have you converted any of the tables - notably, such as log_search - to InnoDB?

-[Unknown]

Ben_S · June 07, 2005, 02:57:51 PM

Quote from: [Unknown] on June 07, 2005, 02:55:03 PM
Have you converted any of the tables - notably, such as log_search - to InnoDB?

I can't beleive I forgot to ask that. In fairness though I did actually do some work in work today.

minskog · June 07, 2005, 05:21:22 PM

Quote from: [Unknown] on June 07, 2005, 02:55:03 PM
Have you converted any of the tables - notably, such as log_search - to InnoDB?

-[Unknown]

No, i use isam. There are very differerence of perfomance from isam?

[Unknown] · June 07, 2005, 08:25:00 PM

Yes. If you make the smf_log_search table InnoDB, for example, searches should see a performance improvement.

Only certain tables should be changed. Please search for "InnoDB" for a list.

-[Unknown]

minskog · June 07, 2005, 08:49:10 PM

Quote from: [Unknown] on June 07, 2005, 08:25:00 PM
Yes. If you make the smf_log_search table InnoDB, for example, searches should see a performance improvement.

Only certain tables should be changed. Please search for "InnoDB" for a list.

-[Unknown]

Tomorrow try it, and comment the disaster here

, now are 02:47 a.m, i need sleep

minskog · June 13, 2005, 03:32:50 AM

I see that innodb gives more perfomace when writes, but less perfomance in reads. I have the same results, 60 seconds for a search

[Unknown] · June 13, 2005, 04:33:44 AM

Which tables did you change? Just smf_log_search?

-[Unknown]

minskog · June 13, 2005, 05:08:17 AM

Quote from: [Unknown] on June 13, 2005, 04:33:44 AM
Which tables did you change? Just smf_log_search?

-[Unknown]

Yes, and now, this table have 0 regs

[Unknown] · June 14, 2005, 04:58:54 PM

I have no idea what you mean by "regs".

Well, 1.1 has much improved search performance, but changing that table should usually help.

Do you know if MySQL is properly configured to use your ram? The file /etc/my.cnf should be configured to use more than the default (small) amount of ram.

-[Unknown]

News:

Slow searchs