MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:monloi perez Date:September 16 2010 12:22pm
Subject:Re: skip locking
View as plain text  
Any idea on this?


From: Michael Satterwhite <michael@stripped>
To: mysql@stripped
Sent: Mon, September 13, 2010 1:07:38 AM
Subject: Re: skip locking


On Sunday, September 12, 2010 09:32:12 am monloi perez wrote:
> Hi All,
> Sorry if I posted on the wrong list.
> I've had this issue with my previous server already, seems like
> skip-locking configuration does not seem to work on myisam tables.
> Also what is the difference between myisam and innodb tables. The reason I
> wanted to know is that I think skip-locking works better in InnoDB. Or
> perhaps the right question is when do I choose myISAM and when do I choose
> InnoDB. My current server is running on an 8-core cpu with 32G of memory
> and only running CMS or news based web applications. What do you suggest
> that we use for the storage engine?
> Thanks,
> Mon

MySQL General Mailing List
For list archives:
To unsubscribe:

skip lockingmonloi perez12 Sep
  • Re: skip lockingMichael Satterwhite12 Sep
    • Re: skip lockingmonloi perez16 Sep
      • Re: skip lockingNilton Moura16 Sep
        • Update query problemAndy Wallace16 Sep
          • RE: Update query problemTravis Ard16 Sep
Re: skip lockingNilton Moura18 Sep