473,321 Members | 1,708 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

Myisachk

Hello,

When I run a script to issue myismchk against the tables in my database,
I get the following..

[root@MIS01TC07927 scripts]# ./check_mysql_tables
myisamchk: MyISAM file /var/lib/mysql/telaurus/Admin.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table
properly
MyISAM-table '/var/lib/mysql/telaurus/Admin.MYI' is usable but should be
fixed
myisamchk: MyISAM file /var/lib/mysql/telaurus/Customer.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table
properly
MyISAM-table '/var/lib/mysql/telaurus/Customer.MYI' is usable but should
be fixed

This db is ver 3.23 and replicates from another db.

What causes the tables to be "1 clients is using or hasn't closed the
table properly"

I do have PHP web sites that pull data from this db, am I perhaps not
closing the tables after I access them from the PHP with select queries?
If that's the case, why are tables I never touch with the website
getting this error, does replication have something to do with it?

How can I tell what clients are currently using the tables?

Thanks,

Jeff McKeon

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 1445

This thread has been closed and replies have been disabled. Please start a new discussion.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.