| View previous topic :: View next topic |
| Author |
Message |
VanDan
Guru
Joined: 30 Sep 2002
Posts: 586
Location: Australia
|
 Posted: Mon Sep 08, 2003 4:06 am Post subject: MySQL starting with '--skip-locking' switch. Help! |
 |
|
Hi!
I just ran 'ps ax' and noticed that our MySQL database is starting with the '--skip-locking' switch. This MUST be removed.
I had a look in the /etc/init.d/mysql script, and couldn't see any mention of it.
WTF?
Is this included at build time or something? |
|
| Back to top |
|
 |
nitro322
Guru
Joined: 24 Jul 2002
Posts: 596
Location: USA
|
| Posted: Mon Sep 08, 2003 3:09 pm Post subject: |
|
|
| try looking in /etc/mysql/my.conf. Most switches are in there. |
|
| Back to top |
|
|
VanDan
Guru
Joined: 30 Sep 2002
Posts: 586
Location: Australia
|
| Posted: Mon Sep 08, 2003 11:55 pm Post subject: |
|
|
Yeah I checked there - no mention of it.
Does anyone have MySQL running without the --skip-locking switch?
Maybe I should compile it myself... |
|
| Back to top |
|
|
devon
l33t
Joined: 23 Jun 2003
Posts: 943
|
| Posted: Tue Sep 09, 2003 12:08 am Post subject: |
|
|
| What about adding "enable-locking" under "[mysqld]" in /etc/mysql/my.cnf? I think that should override the --skip-locking flag in /usr/bin/mysqld_safe. |
|
| Back to top |
|
|
VanDan
Guru
Joined: 30 Sep 2002
Posts: 586
Location: Australia
|
| Posted: Tue Sep 09, 2003 1:52 am Post subject: |
|
|
I'll add that. Thanks.
I'd already added --enable-locking to the startup flags, but I was unsure which one would win. I'll check on the MySQL list.
Just out of interest - is there any reason why we still need to have --skip-locking as the default. If I remember correctly, this was from way back when it ( locking ) was a bit wobbly under the old ( very old ) glibc - or something like that. |
|
| Back to top |
|
|
|
Networking & Security
