Subquery performance slow to non-existent...

2010-01-19 Thread Nick Torenvliet
Hey all... I am having a problem with sub-queries that I cannot trouble shoot. I run query a: select symbol from names where market like 'NYMEX' and name like 'natural gas {%'; and get 168 names that I manually insert into query b: select * from endOfDayData where endOfDayData.market like

mysql.sock error

2001-09-13 Thread Nick Torenvliet
I'm trying to start my first ever installation of mysql, so I've installed the tar.gz (3.23.42 on Linux) and I've run ./configure from /mysqlhome when I try to star the server I get the following message Can't connect ot local MySQL server through socket '/tmp/mysql.sock' When I do a find I