error: 22 when opening ISAM-table

2001-03-18 Thread Issam W. Alameh
I am getting the error error: 22 when opening ISAM-table when trying to do isamchk on sometables any hint Issam

can loggin be done for ony one user

2001-01-14 Thread Issam W. Alameh
hello, can I log the database queries for a specified user? Regards Issam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request thi

Best Configuration an startup arguments

2001-01-14 Thread Issam W. Alameh
hello, what is the best configuration and startup arguments for 512MB memory machine running many many connections for a bulletin board is the following ok? safe_mysqld -O key_buffer=64M -O table_cache=256 -O sort_buffer=4M -O record_buffer=1M how do I understand what is meant by this?? Regar

auto_increment not to start

2001-01-14 Thread Issam W. Alameh
Hello, I am using an auto_increment field, every time I delete from the table, the counter goes back, is there any way to keep the incrementation regardless of the number reached after delete Regards Issam - Before posting, ple

Limit mysql connections by database user?

2001-01-13 Thread Issam W. Alameh
Hello, is there a way to limit the connection which the mysql user can do?? I have a server with 12 database users, and sometimes, one of the users makes large number of connections because of a bulletin board he is using, is there a way to limit the number of connections that he can do? Regar