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

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

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