When I open over nine connections to mysql I see vi.recover in my show databases output. The existing connections stay open and continue to operate. No new database connections can be made at this point. I should be seeing the mysql, phpdig and test databases when performing the query but I only see vi.recover? Any ideas why this happens or how to prevent it?

[EMAIL PROTECTED] jbl]$ uname -a
NetBSD subterrain.net 2.0 NetBSD 2.0 (SUBTERRAIN) #1: Tue Dec 28 22:34:54 EST 2004 [EMAIL PROTECTED]:/usr/src/sys/arch/i386/compile/SUBTERRAIN i386
[EMAIL PROTECTED] jbl]$ ls /var/mysql/
#sql_267_1.MYI ib_logfile0 phpdig
#sql_267_2.MYI ib_logfile1 subterrain.net.err
#sql_267_3.MYI ibdata1 subterrain.net.pid
#sql_2819_2.MYI mysql test
[EMAIL PROTECTED] jbl]$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1180 to server version: 4.1.7


Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+------------+
| Database   |
+------------+
| vi.recover |
+------------+
1 row in set (0.00 sec)

mysql>exit;
[EMAIL PROTECTED] jbl]$ find / -name vi.recover
/var/tmp/vi.recover
[EMAIL PROTECTED] jbl]$ su -
Password:
[EMAIL PROTECTED] root]# /usr/pkg/etc/rc.d/mysqld restart
Stopping mysqld.
Waiting for PIDS: 10265, 10265, 10265.
Starting mysqld.
[EMAIL PROTECTED] root]# exit
[EMAIL PROTECTED] jbl]$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10 to server version: 4.1.7

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+----------+
| Database |
+----------+
| mysql    |
| phpdig   |
| test     |
+----------+
3 rows in set (0.04 sec)

mysql> exit;
[EMAIL PROTECTED] jbl]$

Thanks,
-JBL

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to