Re: --skip-locking and 'enable locking' in my.cnf

2003-09-09 Thread Jeremy Zawodny
On Tue, Sep 09, 2003 at 01:30:51AM -0500, Matt W wrote: > > > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > > > MySQL 4.0.15-Yahoo-SMP: up 1 days, processed 47,861,708 queries (374/sec. avg) > > Off topic: Been wonderi

Re: --skip-locking and 'enable locking' in my.cnf

2003-09-08 Thread Sergei Golubchik
Hi! On Sep 09, Daniel Kasak wrote: > Paul DuBois wrote: > > >At 12:00 +1000 9/9/03, Daniel Kasak wrote: > > > >>It's been suggested that I add 'enable-locking' to the [mysqld] > >>section of my.cnf. > > > > > >You might want to reconsider. It's disabled by default on all systems > >as of MySQL

Re: --skip-locking and 'enable locking' in my.cnf

2003-09-08 Thread Matt W
- Original Message - From: "Jeremy Zawodny" Sent: Monday, September 08, 2003 11:33 PM Subject: Re: --skip-locking and 'enable locking' in my.cnf > On Mon, Sep 08, 2003 at 10:42:33PM -0500, Paul DuBois wrote: > > > > See: > > > > http://ww

Re: --skip-locking and 'enable locking' in my.cnf

2003-09-08 Thread Jeremy Zawodny
On Mon, Sep 08, 2003 at 10:42:33PM -0500, Paul DuBois wrote: > > See: > > http://www.mysql.com/doc/en/System.html > > Note the part about Linux. Paul, you might update that page. It's extoling the virtues of the 2.2 kernel and SMP. But 2.4 is clearly superior in that department. And the 2GB f

Re: --skip-locking and 'enable locking' in my.cnf

2003-09-08 Thread Paul DuBois
At 13:25 +1000 9/9/03, Daniel Kasak wrote: Paul DuBois wrote: At 12:00 +1000 9/9/03, Daniel Kasak wrote: It's been suggested that I add 'enable-locking' to the [mysqld] section of my.cnf. You might want to reconsider. It's disabled by default on all systems as of MySQL 4, and was disable by d

Re: --skip-locking and 'enable locking' in my.cnf

2003-09-08 Thread Daniel Kasak
Paul DuBois wrote: At 12:00 +1000 9/9/03, Daniel Kasak wrote: It's been suggested that I add 'enable-locking' to the [mysqld] section of my.cnf. You might want to reconsider. It's disabled by default on all systems as of MySQL 4, and was disable by default before that on Linux. I see. I had

Re: --skip-locking and 'enable locking' in my.cnf

2003-09-08 Thread Paul DuBois
At 12:00 +1000 9/9/03, Daniel Kasak wrote: Hi all. I'm using MySQL-4.0.14, compiled by Gentoo's ebuild script. Somewhere along the line, I've picked up a '--skip-locking' flag that I can't find the source of. It's not in the /etc/init.d/mysql script. It's not in my my.cnf. Gentoo has a start-sto

--skip-locking and 'enable locking' in my.cnf

2003-09-08 Thread Daniel Kasak
Hi all. I'm using MySQL-4.0.14, compiled by Gentoo's ebuild script. Somewhere along the line, I've picked up a '--skip-locking' flag that I can't find the source of. It's not in the /etc/init.d/mysql script. It's not in my my.cnf. Gentoo has a start-stop script which is run by scripts in /etc/in