• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Table locking Issue MySQL on Tiger...
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Table locking Issue MySQL on Tiger...


  • Subject: Re: Table locking Issue MySQL on Tiger...
  • From: Nathan Walker <email@hidden>
  • Date: Thu, 5 May 2005 12:00:12 -0400

I have to use it because I am using stored procedures yes, but I will try changing the tables to InnoDB, is there much I have to do to get all newly created tables to use InnoDB instead of MyISAM ? I'm using Navicat to manage MySQL if you are familiar with that.... Also, I tried switching one of my tables to InnoDB and everytime I view table information on it, it reports a different number of total rows ?? is that normal for InnoDB tables ?? It's very odd... why would it do that ?

thanks for the info,
Nathan


On May 5, 2005, at 8:06 AM, Kieran Kelleher wrote:

Nathan, you are very brave using MySQL 5.0.4 which is not General Release yet ;-) If there is no compelling reason to use 5.0.4 (such as stored procedures), then I think you will definitely solve your problem by switching to the GA of 4.0 or 4.1. On the other hand you could try altering your 5.0.4 tables to use InnoDB engine which does row locks rather than the complete table locks that MyISAM does for a single row read.

Regards,

-Kieran
________________________________________________________________
Blog: http://webobjects.webhop.org/


On May 5, 2005, at 1:39 AM, Nathan Walker wrote:

I am using MySQL 5.0.4 with WebObjects 5.2.4 on Tiger and since the upgrade, I have an issue with Table Locking in MySQL. I get this error if I try to access the table:

Next exception:SQL State:HY000 -- error code: 1099 -- msg: Table 'Invmstr' was locked with a READ lock and can't be updated

I'm not sure if the issue is related to the JDBC driver on Tiger which I'm using 'mysql-connector-java-3.1.7-bin.jar'......or if it is related to the MySQL or if it's related to EOF on Tiger ??
I had been developing this application for a couple months now and have never run into this issue until I did the upgrade. Anybody ever run into this table locking issue with MySQL ?? The tables engines are MyISAM..........


Can anybody shed any light about this ?
thx,
nathan


_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40mac.com


This email sent to email@hidden



_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Follow-Ups:
    • Re: Table locking Issue MySQL on Tiger...
      • From: Kieran Kelleher <email@hidden>
References: 
 >Table locking Issue MySQL on Tiger... (From: Nathan Walker <email@hidden>)
 >Re: Table locking Issue MySQL on Tiger... (From: Kieran Kelleher <email@hidden>)

  • Prev by Date: Re: WO 5.2.4 is here!
  • Next by Date: Re: Table locking Issue MySQL on Tiger...
  • Previous by thread: Re: Table locking Issue MySQL on Tiger...
  • Next by thread: Re: Table locking Issue MySQL on Tiger...
  • Index(es):
    • Date
    • Thread