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?
SMF 1.1 has greatly improved search performance, untill that comes out though I guess you are kind of stuck :-\.
just out of curiousity, what are the specs of the coputer that hosts your forum?
Pentium 4 2.8 HT, 1 gb ram ecc, hd sata. Load average 0.35 ::)
Have you converted any of the tables - notably, such as log_search - to InnoDB?
-[Unknown]
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.
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?
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]
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 :D, now are 02:47 a.m, i need sleep :P
I see that innodb gives more perfomace when writes, but less perfomance in reads. I have the same results, 60 seconds for a search :'(
Which tables did you change? Just smf_log_search?
-[Unknown]
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 ??? ??? ???
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]