Threads > 1024 & statically linking against linuxthreads library

SQL 4.0.2 is topping out at 1024 threads' but that don't help me). Does anyone have any notes/pointers/info/idiot's guide in this regard? Thanks, -- Willem Roos "Per sercas vi malkovri" - JS Bach (freely translated) Disclaimer http://www.shoprite.co.za/

RE: Losing some records

Losing some message body too :-? > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: 18 June 2004 13:11 > To: [EMAIL PROTECTED] > Subject: Losing some records > > > Disclaimer http://www.shoprite.co.za/disclaimer.html -- MySQL General Mailing List For list

RE: Can't start server: Bind on TCP/IP port: Address already in use

You are only listing processes owned by you. ps -e will show all processes, add -f for a full listing. > -Original Message- > From: Tobias Bohlin [mailto:[EMAIL PROTECTED] > Sent: 07 June 2004 11:30 > To: [EMAIL PROTECTED] > Subject: Can't start server: Bind on TCP/IP port: Address > alre

subquery and order by

database where entries are stored with the IP address, but which I want to search using the hostname. The second query wants to order the output by date but to my big surprise does not give any results. When I extend the query with a select on a second field and do the 'order by date' I do get a result. Am I missing something here? Thanks, Willem

ip range lookup

t contains the 'leftmost' byte of the ip - and index that ? Thanks, Willem Bison -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

"Commands out of sync" using PHP

I'm getting lots of random "Commands out of sync; You can't run this command now" errors when calling mysql_query(). I'm pretty sure this has started after upgrading to PHP 4.2.3. The only way to stop it is restarting apache. I can't see any pattern in the errors: it happens on different tables, l

Tables keeps crashing...

hello, we are using mysql on a windows98 machine. But a lot of times the tables in the database keep crashing. When checking it says: 1 client did not close connection... table marked as crashed (not always this line) with different tables does anyone had this problem also? Willem

varchar to char in table with several varchar's

I have a table with several columns of type 'varchar'. How can I change all columns to fixed width char's ? Doing a 'alter' from varchar to char has no effect since the column is changed back to varchar. - Before posting, plea

Converting from myisam to InnoDB

I'm trying to switch from myisam to InnoDB. I've edited my.cnf (see below). When I try to start mysql-max: [root@db1 mysql]# safe_mysqld --skip-bdb Starting mysqld-max daemon with databases from /home/dbclnbs/mysql/ 011203 15:00:00 mysqld ended Error log: 011203 14:59:54 mysqld started InnoD

error code: 10060

I get this error message when trying to log in to remote MySQL database server... what does this mean? how can I solve this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mys

Update locking table forever

My site regularly gets extremely slow. When I check the running queries with 'show processlist;' I get this: update XYZ set ... where id=... select ... from XYZ where id=... select ... from XYZ where id=... select ... from XYZ where id=... [...100's of similar selects...] in other words: a single

Blocked because of connection errors

When we increase the number of connections our 3.22.25 server 'hangs': mysql> show status; No connection. Trying to reconnect... ERROR 1129: Host 'xxx is blocked because of many connection er rors. Unblock with 'mysqladmin flush-hosts' ERROR: Can't connect to the server This happens when we inc