AW: HELP... lot of Load !

2001-12-11 Thread Daniel Backhausen
Hello Benjamin. Thanks a lot. Yes, you are right. It is a search engine. But I can?t get rid of the OR expressions, cause it is implemented in the search formular mask. So the User can choose any search criteria, which he wants. Neverthe- less I will follow your hint and check out these queries m

AW: HELP... lot of Load !

2001-12-10 Thread Daniel Backhausen
Hi Benjamin I have enabled the log for slow queries with following result. --- /usr/sbin/mysqld, Version: 3.23.46-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgum

AW: HELP... lot of Load

2001-12-10 Thread Daniel Backhausen
Hi Benjamin. Thank you for your fast reply. I have another two small detailed questions. 1st: Do you think, if I compile the mysql source on my own it should be better ? I readed, that RedHat 7 has pre-compiled the mysql with an errorous version of gcc. ... so I would compile it on my own. 2nd: Y