Should Joins always be using an index? (where possible?)

I'm have a query like so select A, index_A from tableA join tableB on tableB.indexA = tableA.indexA select A, index_A from tableA join tableB on tableB.A = tableA.A whcih would be more efficient? using the where clause which uses the index or the one which isn't index? -- MySQL General Maili

Re: confirm unsubscribe to mysql@lists.mysql.com

On Sunday 20 August 2006 05:36, [EMAIL PROTECTED] wrote: > To confirm that you would like > > [EMAIL PROTECTED] > > removed from the mysql mailing list, please click on > the following link: > > http://lists.mysql.com/u/mysql/44e7d8d08e557788/wolfgang=rohdewald.de > > This confirmation serv

Re: MySQL Cluster 5.0.24 (Import) Slow

Hi, Its saying as (unknown error 1 in ndb cluster) please report a bug to mysql.bug. Thanks & Regards Dilipkumar - Original Message - From: "Dan Trainor" <[EMAIL PROTECTED]> To: Sent: Sunday, August 20, 2006 2:06 AM Subject: Re: MySQL Cluster 5.0.24 (Import) Slow Dilipkumar wrote

Re: MySQL Cluster 5.0.24 (Import) Slow

Dilipkumar wrote: Hi everybody I am running linuz AS-4 with 5.0.24 max version MySQL Cluster i am able to create all the table as ndb but when comming to the import i am not able to import 20 lakhs of record for a table.please help to solve the problem . Any suggestions?... Hi - D

MySQL Cluster 5.0.24 (Import) Slow

Hi everybody I am running linuz AS-4 with 5.0.24 max version MySQL Cluster i am able to create all the table as ndb but when comming to the import i am not able to import 20 lakhs of record for a table.please help to solve the problem . Any suggestions?... Thanks & Regards Dilipkumar

Re: help needed to mount data from /var/lib/mysql

if i search for any process running i am getting following thing. [EMAIL PROTECTED] mysql]# ps -ef | grep mysqld root 18389 1 0 13:09 pts/300:00:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid mysql18422 18389 0 13:09 pts/300

Re: help needed to mount data from /var/lib/mysql

I am unable to start server after shifting to new location. i tried to start 'mysqld' but it was failed. A blank mysql.sock file is creating. Entries of log files are also not reporting any problem.

Re: More than 4 CPUs?

On 8/19/06, Wai-Sun Chia wrote: On 8/19/06, Jochem van Dieten wrote: Tweakers.net did a benchmark comparing a trace of the queries generated by their own website on a T1 to a dual Opteron. The article is in Dutch, but the graphs speak for themselves: http://tweakers.net/reviews/633/7 http://twe

Re: Managing big mysqldump files

At 4:03 PM +0530 8/19/06, Anil wrote: Hi List, We are facing a problem of managing mysqldump out put file which is currently of size 80 GB and it is growing daily by 2 - 3 GB, but we have a linux partition of only 90 GB.. Our backup process is first generate the mysqldump file of total data

RE: Managing big mysqldump files

Hi Anil, Why not pipe the mysqldump direct into gzip? eg: mysqldump etc ... | gzip -c Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/***

Managing big mysqldump files

Hi List, We are facing a problem of managing mysqldump out put file which is currently of size 80 GB and it is growing daily by 2 - 3 GB, but we have a linux partition of only 90 GB.. Our backup process is first generate the mysqldump file of total database and then compress the dump file and

Re: help needed to mount data from /var/lib/mysql

Hi All, Thank you for u r reply. But i am unable to find my.cnf, is i need to create this file.

Query needed to convert varchar to int ....sorry previous posting was incomplete

Dear all, I have a table with the following structure. ield Type CollationNullKey Default Extra Privileges Comment --- -- -- --- --

Query to convert a varchar into int

Dear all, I have a table with the following structure. ield Type CollationNullKey Default Extra Privileges Comment --- -- -- --- --

Re: help needed to mount data from /var/lib/mysql

Hello, You can change the MySQL data path in /etc/my.cnf by editing the configuration parameter "datadir" with new data path. Once you done the changes in my.cnf, reboot the MySQL server. Thanks, ViSolve DB Team - Original Message - From: "balaraju mandala" <[EMAIL PROTECTED]> To

Parameterized stored procedures via ADO Command Object

Hi, I have been trying very hard to get this working but I have NOT been able to call the stored procedures in my MySQL database using the ADO (**NOT** Ado.NET) Command object. I want to use stored procedures 'cos I want to restrict access to stored procedures and views only. However, it seems l

Re: help needed to mount data from /var/lib/mysql

On 8/19/06, balaraju mandala <[EMAIL PROTECTED]> wrote: Hi Everybody, I need small help from you. In my Linux box i have limitation of Size in partition. I have only 5 GB space for /var. MySQL is installed in this partition only. I want to give another path like /home, where i have 120GB of spac