Best filesystem for MySQL ?

2002-06-26 Thread Sébastien DIDIER
Hi, I wonder which is the best filesystem to use with MySQL (to increase performances). And which mounting option should be used ? According to the documentation, the best system is SuSE Linux 7.1, 2.4 kernel, and ReiserFS. I currently use ReiserFs with noatime option. But it seems (according to

RE: Thank you!I need your help!

2002-06-24 Thread Sébastien DIDIER
You need libtermcap. (libtermcap-2.0.8-28.i386.rpm) You are running a Redhat 7.2 box, use binary distribution instead of source package if you're not familiar with building programs. Regards, Sébastien > > > please tell what mean the follow: > [root@guanqun zsj]# cd /usr/local/src > [root@guanq

RE: Replication problem >> Timeout in MySQL

2002-06-14 Thread Sébastien DIDIER
Ok. So i'm a bit confused with all the timeout values. My replication process is killed because of a net_read_timeout which is 30 secondes . I think there's at least three different timeouts : net_read_timeout : The process will be killed if it doesn't receive data during net_read_timeout secs.

Replication problem

2002-06-14 Thread Sébastien DIDIER
Hi, I used replication as a real-time backup for months and I'am now trying to configure a two-way replication between two MySQL servers (srv1 and srv2). So, srv1 replicates from srv2 and srv2 replicates from srv1 (They are both master and slave). The One-way replication is working fine from srv1

RE: adding a user to a database

2002-03-09 Thread Sébastien DIDIER
Hi, Try this request: grant all on db.bsd to shadowgrl@'%' identified by "testing123" with grant option; Regards, Sébastien > -Message d'origine- > De : Michael Sharp [mailto:[EMAIL PROTECTED]] > Envoyé : samedi 9 mars 2002 13:08 > À : [EMAIL PROTECTED] > Objet : adding a user to a dat

RE: storing files in mySQL

2002-03-04 Thread Sébastien DIDIER
l Regards, Sébastien DIDIER Zarcrom SAS - Web Hosting www.zarcrom.fr > -Message d'origine- > De : Dang Nguyen [mailto:[EMAIL PROTECTED]] > Envoyé : lundi 4 mars 2002 20:05 > À : Mysql List (E-mail) > Objet : storing files in mySQL > > > Hi everyone, > > I'