Re: R: Multiple instances howto

2008-03-29 Thread toutiao
Nanni, Thanks for the advices. How to make an installation? I use Fedora Core 8 where MySQL comes with the bundle. Do you think I should download the source code and compile it and configure it using ./configure? I did changed the cnf file to have 2 different configurations: [EMAIL PROTECTED] m

Re: procedure locks all statemens

2008-03-29 Thread Baron Schwartz
It is probably keeping a global lock on something else: perhaps the MyISAM key buffer is at fault. Try loading this table's indexes into a different key buffer and see what happens. On Fri, Mar 28, 2008 at 2:39 PM, Saravanan <[EMAIL PROTECTED]> wrote: > It doesn't lock single table it locks all o

Re: [OT] When MySQL Bites: Quirks to Watch Out For

2008-03-29 Thread Baron Schwartz
On Fri, Mar 28, 2008 at 3:46 PM, obed <[EMAIL PROTECTED]> wrote: > Hi all, i'm not trying to make trouble or bother someone with this > information, I'm a mysql user and I love it, I just wanna know your > point of view about it. > > http://use.perl.org/~Smylers/journal/34246 When you're talkin

Re: [OT] When MySQL Bites: Quirks to Watch Out For

2008-03-29 Thread paul rivers
Ofer Inbar wrote: It appears to be an article for perl programmers not familiar with MySQL, warning them of MySQL quirks they should be aware of. If you write a perl script with DBD::MySQL and try one of the examples he gave, and check your return status to see if the statement succeeded, does i