Re: Mysql update query gives error of lock wait timeout

Hi, You are right. The storage engine i m using is InnoDB. but then my concern is why this simple update query takes so long. Is it true that if its innodb table then even after specifying where condition it scans all indexed rows. I am bit confused as mysql.com have mentioned on there site that e

Re: Mysql update query gives error of lock wait timeout

On Sat, Aug 29, 2009 at 12:09 PM, Manasi Save < manasi.s...@artificialmachines.com> wrote: > Hi All, > > I have a query which gives an error of lock wait timeout only this > transaction is running with 2 records in the table. > > The query is : > > Update Test > Set TestFlag = 1 > Where TestID

Mysql update query gives error of lock wait timeout

Hi All, I have a query which gives an error of lock wait timeout only this transaction is running with 2 records in the table. The query is : Update Test Set TestFlag = 1 Where TestID = 5; Can this one transaction lock my entire table? -- Thanks and Regards, Manasi Save Artificial Machines

Re: Fail to change MySQL data directory on ubuntu

That is likely the case. As you said, I do not use innodb tables. Best, Jia On Fri, Aug 28, 2009 at 8:25 AM, Johnny Withers wrote: > Maybe you do not use innodb tables, in that case there would be no data loss. > > On Thursday, August 27, 2009, Jia Chen wrote: >> Thanks for the tips. Where can I

Re: Very Slow Query

Hi Dan and John, Thanks for your time! You guys are right. I did not index any columns when I created these tables. After I indexed assignee columns in both tables, the select clause runs in seconds. Best, Jia Dan Nelson wrote: In the last episode (Aug 28), Jia Chen said: Thanks for re

RE: Very Slow Query

Can you show us the output of SHOW CREATE TABLE for the tables in your query? Looks like you just need some indexing! Regards John John Daisley MySQL & Cognos Contractor Certified MySQL 5 Database Administrator (CMDBA) Certified MySQL 5 Developer (CMDEV) IBM Cognos BI Developer Telephone +44 (

Re: Very Slow Query

In the last episode (Aug 28), Jia Chen said: > Thanks for reply! > > Yes, it is very slow too if I just execute the "select ..." part. > > When I run > mysql> explain extended select a.*, b.assname, b.cname, b.cusip, b.own, > b.pname, b.sname from nber1999.pat1 as a inner join nber1999.compusta

Re: Very Slow Query

Thanks for reply! Yes, it is very slow too if I just execute the "select ..." part. When I run mysql> explain extended select a.*, b.assname, b.cname, b.cusip, b.own, b.pname, b.sname from nber1999.pat1 as a inner join nber1999.compusta1 asb on a.assignee=b.assignee; I got ++---

Re: Very Slow Query

In the last episode (Aug 28), Jia Chen said: > One seemingly simple query that joins two tables takes a long time for me. > > This is my library. > > mysql> show table status from nber1999; > +---++-++--++-+--

Very Slow Query

Hi all, One seemingly simple query that joins two tables takes a long time for me. This is my library. mysql> show table status from nber1999; +---++-++--++-+--+--+---++--

Re: Write IF condition in Query , and mysql Search function

bharani kumar wrote: Hi All , Am working on the autosuggestion program SELECT $field2,$field1 FROM $tblname where locate('$q', $field2) > 0 OR locate('$q', $field1) > 0 order by locate('$q', $field2), $field2 limit " . ($pagesize * $page) . "," . $pagesize This is my query , Example

SQL statement to populate Start and End dates Everyday with an Interval of certain day(s)

I had the following fields for my calendar: start_date = "08/01/09" (starts on) end_date = "08/31/09" (ends on) the_length = "1" (everyday) repeat_every = "2" (with an interval of 2 days) Now, I want to use SQL statement to populate "daily" but with an interval of "2" days, star

Re: upgrading from 4.1 to 5.0 "trick"

Hank wrote: Hello All, I'm in the process of upgrading my database from 4.1 to 5.0 on CentOS. I've been testing the "mysqlcheck --check-upgrade --auto-repair" command, and on one of my MYISAM tables, it's taking forever to upgrade the table. It has about 114 million rows, and I'm guessing i

Re: Fail to change MySQL data directory on ubuntu

Maybe you do not use innodb tables, in that case there would be no data loss. On Thursday, August 27, 2009, Jia Chen wrote: > Thanks for the tips. Where can I find more details about the ibdata file? > > After I changed the data dir, hese file did get recreated. So far, I have not > noticed any

press-release devart

Hi, Could you please add our new press-release: ADO.NET Data Providers Work with Visual Studio 2010 Beta Devart has recently announced the release of dotConnect products for Oracle, MySQL, PostgreSQL, and SQLite, ADO.NET providers that offer Entity Framework support, LINQ to SQL support, and c

MySQL University session on September 3: New features in Connector/NET 6.1

New features in Connector/NET 6.1 http://forge.mysql.com/wiki/New_Features_in_Connector/NET_6.1 Next Thursday (September 3, 13:00 UTC), we'll resume MySQL University sessions after the summer break with Reggie Burnett, head of Connector/NET development, giving a session on new features in Connecto

lock wait timeout try restrating transaction

Hi All, Can anyone provide me any input on in what all senerios one can get this error. I have innodb tables, I am updating one table but I am getting error lock wait timeout try restarting transaction. Also the parameter innodb_lock_wait_timeout is set to 50 default. what will be the effect of in