Re: login issue..pls help

This particular reference is little too vague to be of much use. MyISAM may outperform innodb in signle process situations but in contentious mixed read/write traffic (suchas a typical webapp), innodb is much faster for a variety of reasons. > > 13.1. Comparing Transaction and Nontransaction Engin

RE: login issue..pls help

hi Faizal, in this case, usualy we choose the MyISAM engine, as it will more fast than the innodb. here is the comparision for hte MyISAM vs InnoDB for you reference. 13.1. Comparing Transaction and Nontransaction Engines http://dev.mysql.com/doc/refman/5.1/en/storage-engine-compare-

RE: The Execute from the command line

Mysql -vv See mysql --help for more info Regards, Gavin Towey -Original Message- From: lucas.ctr.heu...@faa.gov [mailto:lucas.ctr.heu...@faa.gov] Sent: Friday, October 02, 2009 2:20 PM To: mysql@lists.mysql.com Subject: The Execute from the command line I am using linuxmachine:/var/w

The Execute from the command line

I am using linuxmachine:/var/wwwdev/lucas# mysql -udatabase -ppassword -e "LOAD DATA LOCAL INFILE '/var/wwwdev/lucas/cardreaderimport/update.csv' into table Project.testtest fields terminated by ',' lines terminated by '\n' (Id,LastName,MiddleName,FirstName,TimeStamp,Ext,Status,Location,Expi

Re: many-inserts go faster the second time

On Fri, October 2, 2009 12:28, Bennett Haselton wrote: > At 02:53 AM 10/2/2009, Joerg Bruehe wrote: >>Hi Bennett, all! >> >> >>Bennett Haselton wrote: >> > At 08:24 AM 9/25/2009, Dan Nelson wrote: >> >> In the last episode (Sep 25), Bennett Haselton said: >> >> > I have a script that runs several

Re: many-inserts go faster the second time

At 02:53 AM 10/2/2009, Joerg Bruehe wrote: Hi Bennett, all! Bennett Haselton wrote: > At 08:24 AM 9/25/2009, Dan Nelson wrote: >> In the last episode (Sep 25), Bennett Haselton said: >> > I have a script that runs several times in the evening, and on each >> run it >> > adds several thousand en

Re: Another Join Problem

Thanks V On Fri, Oct 2, 2009 at 11:08 AM, Mark Goodge wrote: > Victor Subervi wrote: > >> Hi; >> I get the following error: >> >> *SQL query:* >> >> SELECT ID, Item >> FROM products >> JOIN categories ON categories.ID = products.Category >> LIMIT 0 , 30; >> >> *MySQL said:* >> #1052 - Column '

Re: disk space on arbitrary rows

Claudio Nanni wrote: A very first thing you should do is to evaluate the storage needed by a single row. This can be done by summing up all columns data types length in bytes and index lenght as well. This should be quite accurate. Just a tip to start: http://dev.mysql.com/doc/refman/5.0/en/st

Re: Another Join Problem

Victor Subervi wrote: Hi; I get the following error: *SQL query:* SELECT ID, Item FROM products JOIN categories ON categories.ID = products.Category LIMIT 0 , 30; *MySQL said:* #1052 - Column 'ID' in field list is ambiguous Please note the error is about ambiguity. "products" has an ID fiel

Re: Another Join Problem

Victor Subervi wrote: Hi; I get the following error: *SQL query:* SELECT ID, Item FROM products JOIN categories ON categories.ID = products.Category LIMIT 0 , 30; *MySQL said:* #1052 - Column 'ID' in field list is ambiguous Please note the error is about ambiguity. "products" has an ID fiel

Re: Another Join Problem

Qualify the column names. EG SELECT categories.ID, products.Item FROM products JOIN categories ON categories.ID = products.Category LIMIT 0 , 30; Regards John Daisley > Hi; > I get the following error: > > *SQL query:* > > SELECT ID, Item > FROM products > JOIN categories ON categories.ID =

Re: Another Join Problem

On Fri, Oct 2, 2009 at 10:53 AM, Victor Subervi wrote: > Hi; > I get the following error: > > *SQL query:* > > SELECT ID, Item > FROM products > JOIN categories ON categories.ID = products.Category > LIMIT 0 , 30; > > *MySQL said:* > #1052 - Column 'ID' in field list is ambiguous > > Please note

Another Join Problem

Hi; I get the following error: *SQL query:* SELECT ID, Item FROM products JOIN categories ON categories.ID = products.Category LIMIT 0 , 30; *MySQL said:* #1052 - Column 'ID' in field list is ambiguous Please note the error is about ambiguity. "products" has an ID field and so does "categorie

Re: Nested Joins

Thanks! Got it! I was missing the word "from"... select * FROM %s c ... Thanks again ;) V On Thu, Oct 1, 2009 at 5:08 PM, Gavin Towey wrote: > Victor, > > > > Just noticed, the join condition from client to productions should be > changed: > > > > select * from ben_franklin_planners c join prod

Re: many-inserts go faster the second time

Hi Bennett, all! Bennett Haselton wrote: > At 08:24 AM 9/25/2009, Dan Nelson wrote: >> In the last episode (Sep 25), Bennett Haselton said: >> > I have a script that runs several times in the evening, and on each >> run it >> > adds several thousand entries to a table. >> > >> > On the first run,

Re: upgrading from 4.1 to 5.4

Hi! I don't do DBA work, so my info may be incomplete: monem mysql wrote: > Hello > > > I have to upgrade many mysql databases from mysql 4 and 4.1 to 5.4 with a > large size 2.7 TB > > [[...]] > > > The official method takes too much time. But I've read that we can use '*dump > and reload'