Support Forum
interesting that a feed reader increases the queries (not sure why)??
there is nothing special about the feed, especially if only 5 items? way less complex a query than you forum front page... and getting several times an order of magnitude less than that myself...
may need Andy to jump in here, but when you do it on your staging server, can you have it do an explain? will give more info about what the query is trying to do and may offer insight...
also might be useful to see your keys for the sfgroup, sfforum and sftopic tables... make sure indexes look right... though if not, would expect the main forum view queries to be very poor then...
Visit Cruise Talk Central and Mr Papa's World
here is the explain
1 | SIMPLE | rufus_sfgroups | ALL | PRIMARY | NULL | NULL | NULL | 3 | Using temporary; Using filesort |
1 | SIMPLE | rufus_sfforums | ref | PRIMARY,groupf_idx | groupf_idx | 8 | snapshot_kvr28.rufus_sfgroups.group_id | 5 | Using where |
1 | SIMPLE | rufus_sfposts | ref | topicp_idx,forump_idx | forump_idx | 8 | snapshot_kvr28.rufus_sfforums.forum_id | 1138 | |
1 | SIMPLE | rufus_sftopics | eq_ref | PRIMARY | PRIMARY | 8 | snapshot_kvr28.rufus_sfposts.topic_id | 1 | |
1 | SIMPLE | rufus_sfmembers | eq_ref | PRIMARY | PRIMARY | 8 | snapshot_kvr28.rufus_sfposts.user_id | 1 |
a temp table and filesort, eh? seems bit overkill, but as I said, may need input from Andy...
are you suing MyISAM or InnoDB tables?
oh,and can you paste in your my.ini setup? be sure no passwords or other private info in what you post...
Visit Cruise Talk Central and Mr Papa's World
Mixture? How would the sfxxxx tables not all be the same?
my.ini will vary based on server os.. Usually /etc
There are some config options in the else for memory and things... Might be worth tweaking....
Visit Cruise Talk Central and Mr Papa's World
dunno, all are Myisam except for sflinks, sfoptions, sfpostattachments, and sfposts, those are InnoDB, we use wp-engine, we had the issue with the sql query error with the search function when we first started using SP until yellow fixed the issue so it worked with the way wp-engine has the tables set up
I will hunt down the my.ini
Have to wonder if the mixed table types are contributing to this... Seems odd, but perhaps okay...
On your test site, might be worth downloading are plugin (on download page) for converting tables to InnoDB and see if it matters...
Visit Cruise Talk Central and Mr Papa's World
1 Guest(s)