Table Corruption

[Ramy M. Hassan]

Hi,
After setting up a slave mysql server ( 4.0.17 ) on an SMP linux box (
kernel 2.4.18 SMP ). I noticed that one of my large tables ( 300MB )
started to corrupt regularly ( every day or two day max ). I discover
its corruption after getting the error Got error 127 from table
handler. Repairing table leads to loosing some records , and only helps
for aother day or two then again I get same error and again table needs
repair.
I thought the problem might be in the linux kernel, so I upgraded to the
latest kernel ( 2.4.24 SMP )  but this didn't help and the problem
happened again. Then I found that mysql-4.0.18is released so I upgraded
mysql but next day I found the same problem happening again :-(
I am using binaries from mysql.com and debian 3.0r3 with reiserfs. The
master server is 4.0.12 on freebsd/linuxthread. 
Harware used:
Dual Intel(R) Xeon(TM) CPU 2.80GHz
2GB RAM
3ware Serial ATA RAID controller
 
I appreciate any help.
 
Best regards
Ramy
 

Re: From Windows access to MySQL on Linux

[Ramy M. Hassan]

On Sat, 3 Feb 2001, Kiky wrote:

 Dear all,
 I have to work wih PHP on Win 98/Win 2K, but I have to access
 MySQL on Linux.
 At the first time, I was trying to use ASP and using ODBC to access
 MySQL on Linux, but the problem is that installing additional
 components, even for MySQL driver - ODBC is not allowed by our company
 policy.
 My question is that : is it possible to have a direct access to MySQL on
 Linux, if I use PHP on Windows ?

Yes, you can add a mysql user that has access to mysql server from the
windows host and use this user to create the connection.

 Direct access I mean here is : the same access support if I put PHP and
 MySQL both on Linux (no ODBC needed, etc).
 
 Any help would be very much appreciated.
 
 Sincerely,
 Helen
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php