Multiple connections not happenning

Hello, I run a PHP/MySQL environment. This may be more of a PHP question, but I'll take my chance here. I have 3 different servers: - 1 running apache2 + php4 - 1 running mysql 5.0 - 1 running mysql 4.1 On the web server, I run multiple php applications which all connect to the MySQL databa

RE: database corruption ? how to fix ?

Sorry it is */*.MYI instead of */*.MYD > -Original Message- > From: Gregory Machin [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 22, 2007 12:02 PM > To: Jean-Sebastien Pilon > Cc: mysql@lists.mysql.com > Subject: Re: database corruption ? how to fix ? > >

RE: database corruption ? how to fix ?

- Stop you mysql server - change working directory to $MYSQL_DATA_DIR - run myisamchck with */*.MYD This will run a check on all your table files > -Original Message- > From: Gregory Machin [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 22, 2007 8:41 AM > To: mysql@lists.mysql.com

Innodb corruption help needed!

See below for mysql startup log What should I do next ? Please let me know if you need any additionnal information, such as log files etc... Thanks, Jean-Sebastien Pilon *** LOG *** Mar 10 17:57:21 db01-mtl mysqld_safe[3579]: started Mar 10 17:57:21 db01-mtl mysqld

RE: Does MySQL require patch for Daylight Savings Time 2007 change

You ran your zdump -v against this file ? > -Original Message- > From: Jerry Schwartz [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 28, 2007 1:41 PM > To: Jean-Sebastien Pilon; mysql@lists.mysql.com > Subject: RE: Does MySQL require patch for Daylight Savings >

RE: Does MySQL require patch for Daylight Savings Time 2007 change

on Systems Administrator Penson Financial Services Canada Inc. % Tel.: 514.841.9724 #269 % Cell: 514.771.0365 > -Original Message- > From: Jerry Schwartz [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 28, 2007 12:13 PM > To: Jean-Sebastien Pilon; 'Causevic, Dze

RE: Does MySQL require patch for Daylight Savings Time 2007 change

I don't believe so, since the version of MySQL you are using relies on the system's time. I am using 4.1 and I am setup to use system's time and my timezone tables in the mysql schema are empty. I would take a look at those on your installation. You can also run the 2nd command below to see if the

RE: Does MySQL require patch for Daylight Savings Time 2007 change

Version < 4.1.3 -> relies on the O/S for DST Quote from http://dev.mysql.com/doc/refman/4.1/en/time-zone-support.html "For versions of MySQL older than 4.1.3 that do not have time zone support, the server always tracks the operating system time (much like a time zone setting of SYSTEM in 4.1.3 a

RE: Growing innodb size

EMAIL PROTECTED] > > Sent: Wednesday, February 21, 2007 11:33 AM > > To: mysql@lists.mysql.com > > Subject: Re: Growing innodb size > > > > Hi, > > > > Jean-Sebastien Pilon wrote: > > > I would like to grow my innodb table space, the only > > pro

Mysql on linux - choosing the right filesystem

Hello, I would like to get some of your input on file systems to use with mysql. Should I use a journaling filesystem ? Should I choose a different one based on what I store (log files, myisam dbs, innodb datafiles, etc ) ? Is there any file system tweaks you recommend ? TIA NOTICE: This email

RE: Growing innodb size

[EMAIL PROTECTED] > Sent: Wednesday, February 21, 2007 11:33 AM > To: mysql@lists.mysql.com > Subject: Re: Growing innodb size > > Hi, > > Jean-Sebastien Pilon wrote: > > I would like to grow my innodb table space, the only > problem that I have > > is that I did not

Growing innodb size

Hello list, I would like to grow my innodb table space, the only problem that I have is that I did not declare any size in the config file since we were not using it to start with. If I modify the config file, will this override the current innodb file or will it grow it ? Or should dump all the