Re: MY SQL Slave Server

2010-02-07 Thread Thiyaghu CK
Hi Vikram, Download some other version and install. Use the higher version as slave. Regards, Thiyaghu CK On Sat, Feb 6, 2010 at 10:08 PM, Vikram A vikkiatb...@yahoo.in wrote: I tried to install once again mysql at vista? but deducts the previous installation. and it is ask for the modify ,

Does the order of tuples in a bulk insert impact query performance?

2010-02-07 Thread Anthony Urso
Does the order of tuples in a bulk insert impact later query performance? E.g. will sorting the rows before a bulk insert cause queries to perform better for indexed or non-indexed fields? Thanks, Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Does the order of tuples in a bulk insert impact query performance?

2010-02-07 Thread Tom Worster
On 2/7/10 7:28 AM, Anthony Urso antho...@cs.ucla.edu wrote: Does the order of tuples in a bulk insert impact later query performance? E.g. will sorting the rows before a bulk insert cause queries to perform better for indexed or non-indexed fields? when i load a large body of data (using

How do I get a list of all defined UDF's known to the system?

2010-02-07 Thread Sir Wally Lewis
How do I get a list of all defined UDF's known to the system? Kind Regards, Robert. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: How do I get a list of all defined UDF's known to the system?

2010-02-07 Thread Suresh Kuna
Hi Robert, We can see the functions by using the below command Show function status ; -- Suresh Kuna MySQL DBA On Mon, Feb 8, 2010 at 10:37 AM, Sir Wally Lewis robert.gill...@basx.com.au wrote: How do I get a list of all defined UDF's known to the system? Kind Regards, Robert.

Re: How do I get a list of all defined UDF's known to the system?

2010-02-07 Thread Sir Wally Lewis
Thanks Suresh Kuna sureshkumar...@gmail.com wrote in message news:23397e991002072211l95b2063i40876e0ada93e...@mail.gmail.com... Hi Robert, We can see the functions by using the below command Show function status ; -- Suresh Kuna MySQL DBA On Mon, Feb 8, 2010 at 10:37 AM, Sir Wally

ERROR

2010-02-07 Thread Krishna Chandra Prajapati
Hi List, I am getting the below error on my rhel server. Mysql is running on this box. Due to below error server hangs and stop responding. After system reboot it's working. Feb 7 02:38:29 DCTNMVH1 kernel: mysqld invoked oom-killer: gfp_mask=0x201d2, order=0, oomkilladj=0 Feb 7 02:39:16