hi there...
I recently upgraded from 0.9.9 to 1.0.2 and am having problems with
searching...
Before I upgraded everything was fine.... did I miss something in an
upgrade? I moved s.cgi to my cgi-bin and overwrote my old one... the only
old thing I kept is my configs...
Everytime I run a search via s.cgi, the searchd comes back with:
14784 root 14 0 337M 125M 28 R 0 4.7 50.1 0:05 searchd
The memory goes through the roof and I get "an error has occured" from the
web.
Has anyone seen this happen? Redhat linux 6.2 is the O/S and MySQl:
Server version 3.23.32
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 18 days 4 hours 29 min 24 sec
Threads: 1 Questions: 67543059 Slow queries: 540 Opens: 408 Flush
tables: 1
Open tables: 64 Queries per second avg: 42.984
Here's my database if that helps:
-rw-rw---- 1 root root 180465980 Feb 19 19:50 citation.MYD
-rw-rw---- 1 root root 20218880 Feb 19 19:50 citation.MYI
-rw-rw---- 1 root root 8592 Jan 14 13:27 citation.frm
-rw-rw---- 1 root root 34964 Feb 19 19:50 robots.MYD
-rw-rw---- 1 root root 14336 Feb 19 19:50 robots.MYI
-rw-rw---- 1 root root 8586 Jan 14 13:27 robots.frm
-rw-rw---- 1 root root 5674544 Feb 19 19:51 sites.MYD
-rw-rw---- 1 root root 5444608 Feb 19 19:51 sites.MYI
-rw-rw---- 1 root root 8584 Jan 14 13:27 sites.frm
-rw-rw---- 1 root root 0 Feb 19 19:51 spaces.MYD
-rw-rw---- 1 root root 1024 Feb 19 19:51 spaces.MYI
-rw-rw---- 1 root root 8592 Jan 14 13:27 spaces.frm
-rw-rw---- 1 root root 348532 Feb 19 19:51 stat.MYD
-rw-rw---- 1 root root 1024 Feb 19 19:51 stat.MYI
-rw-rw---- 1 root root 8844 Jan 14 13:27 stat.frm
-rw-rw---- 1 root root 0 Feb 19 19:51 subsets.MYD
-rw-rw---- 1 root root 1024 Feb 19 19:51 subsets.MYI
-rw-rw---- 1 root root 8588 Jan 14 13:27 subsets.frm
-rw-rw---- 1 root root 2411397 Feb 19 19:51 tmpurl.MYD
-rw-rw---- 1 root root 1024 Feb 19 19:51 tmpurl.MYI
-rw-rw---- 1 root root 8586 Jan 14 13:27 tmpurl.frm
-rw-rw---- 1 root root 317975760 Feb 19 19:21 urlword.MYD
-rw-rw---- 1 root root 176052224 Feb 19 21:45 urlword.MYI
-rw-rw-r-- 1 root root 297271296 Feb 19 21:44 urlword.TMD
-rw-rw---- 1 root root 8952 Jan 14 13:27 urlword.frm
-rw-rw---- 1 root root 350314964 Feb 19 19:25 urlwords00.MYD
-rw-rw---- 1 root root 933888 Feb 19 19:25 urlwords00.MYI
-rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords00.frm
-rw-rw---- 1 root root 347779436 Feb 19 19:30 urlwords01.MYD
-rw-rw---- 1 root root 943104 Feb 19 19:30 urlwords01.MYI
-rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords01.frm
-rw-rw---- 1 root root 347084876 Feb 19 19:34 urlwords02.MYD
-rw-rw---- 1 root root 937984 Feb 19 19:34 urlwords02.MYI
-rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords02.frm
-rw-rw---- 1 root root 351470948 Feb 19 19:38 urlwords03.MYD
-rw-rw---- 1 root root 942080 Feb 19 19:38 urlwords03.MYI
-rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords03.frm
-rw-rw---- 1 root root 346606352 Feb 19 19:42 urlwords04.MYD
-rw-rw---- 1 root root 937984 Feb 19 19:42 urlwords04.MYI
-rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords04.frm
-rw-rw---- 1 root root 346113408 Feb 19 19:46 urlwords05.MYD
-rw-rw---- 1 root root 940032 Feb 19 19:46 urlwords05.MYI
-rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords05.frm
-rw-rw---- 1 root root 348837444 Feb 18 14:43 urlwords06.MYD
-rw-rw---- 1 root root 925696 Feb 18 18:41 urlwords06.MYI
-rw-rw-r-- 1 root root 87289856 Feb 19 19:47 urlwords06.TMD
-rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords06.frm
-rw-rw---- 1 root root 344896196 Feb 18 14:43 urlwords07.MYD
-rw-rw---- 1 root root 919552 Feb 18 18:41 urlwords07.MYI
-rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords07.frm
-rw-rw---- 1 root root 348559112 Feb 18 14:43 urlwords08.MYD
-rw-rw---- 1 root root 922624 Feb 18 21:51 urlwords08.MYI
-rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords08.frm
-rw-rw---- 1 root root 345697088 Feb 18 14:43 urlwords09.MYD
-rw-rw---- 1 root root 928768 Feb 18 18:41 urlwords09.MYI
-rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords09.frm
-rw-rw---- 1 root root 349708972 Feb 18 14:43 urlwords10.MYD
-rw-rw---- 1 root root 920576 Feb 18 14:43 urlwords10.MYI
-rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords10.frm
-rw-rw---- 1 root root 349483436 Feb 18 14:43 urlwords11.MYD
-rw-rw---- 1 root root 930816 Feb 18 14:43 urlwords11.MYI
-rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords11.frm
-rw-rw---- 1 root root 348941936 Feb 18 14:43 urlwords12.MYD
-rw-rw---- 1 root root 919552 Feb 18 21:51 urlwords12.MYI
-rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords12.frm
-rw-rw---- 1 root root 345565032 Feb 18 14:43 urlwords13.MYD
-rw-rw---- 1 root root 919552 Feb 18 21:51 urlwords13.MYI
-rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords13.frm
-rw-rw---- 1 root root 350027204 Feb 18 14:43 urlwords14.MYD
-rw-rw---- 1 root root 925696 Feb 18 21:27 urlwords14.MYI
-rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords14.frm
-rw-rw---- 1 root root 348747024 Feb 18 14:43 urlwords15.MYD
-rw-rw---- 1 root root 919552 Feb 18 18:41 urlwords15.MYI
-rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords15.frm
-rw-rw---- 1 root root 4877964 Feb 19 00:02 wordsite.MYD
-rw-rw---- 1 root root 1781760 Feb 19 00:02 wordsite.MYI
-rw-rw---- 1 root root 8580 Jan 14 13:27 wordsite.frm
-rw-rw---- 1 root root 268435996 Feb 18 21:51 wordurl.MYD
-rw-rw---- 1 root root 60120064 Feb 18 21:51 wordurl.MYI
-rw-rw---- 1 root root 8676 Jan 14 13:27 wordurl.frm
-rw-rw---- 1 root root 0 Jan 16 21:45 wordurl1.MYD
-rw-rw---- 1 root root 1024 Jan 16 21:45 wordurl1.MYI
-rw-rw---- 1 root root 8676 Jan 14 13:27 wordurl1.frm
thanks,
Paul Stewart
