Re: MY SQL Slave Server
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 , repire and remove options You said that we can install any number of setups in a same system. Is there any other way to install? Please help me thank you -- *From:* Thiyaghu CK theyaho...@gmail.com *To:* Vikram A vikkiatb...@yahoo.in *Sent:* Sat, 6 February, 2010 3:05:25 PM *Subject:* Re: MY SQL Slave Server Hi Vikram, Ya sure, slave can be in vista. Yes, you can install 2 or more setups in same system but port has to be different, and if its linux platform change the sock name too. Regards, Thiyaghu CK www.mafiree.com On Sat, Feb 6, 2010 at 2:09 PM, Vikram A vikkiatb...@yahoo.in wrote: Dear Thiyagu! Thank you for the information. I will do the experiment. and let you know the further details. Is it possible making slave at windows vista? As per your information, th emysql has to be installed once again another port; Is it possible to install 2 setups in a same system? Thank you VIKRAM A -- *From:* Thiyaghu CK theyaho...@gmail.com *To:* Vikram A vikkiatb...@yahoo.in *Cc:* mysql@lists.mysql.com *Sent:* Sat, 6 February, 2010 1:03:34 PM *Subject:* Re: MY SQL Slave Server Hi Vikram, So as my understanding you need to have a master slave setup in a single machine(FEDORA 11). 1. Make the already running mysql instance as Master 2. Install a new mysql in the same machine in different port which will be your slave 3. Replicate 4.You can also add more slave in same machine or in different machine and make more copy. Note: Slave should be of same version or higher. For replication steps you can refer http://www.mafiree.com/docs.html or http://www.howtoforge.com/mysql_database_replication Let me know for more details. Regards, Thiyaghu CK www.mafiree.com On Sat, Feb 6, 2010 at 12:33 PM, Vikram A vikkiatb...@yahoo.in wrote: Dear Experts, I would like to configure the slave for my main server. My server is running in the FEDORA 11. I would like to make another mirror of the DB in the same server/ The copy of the DB can be kept at win server / another Fedora server. Can you suggest how to do the above? Thank you VIKKI A The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/ -- The INTERNET now has a personality. YOURS! See your Yahoo! Homepagehttp://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/ . -- Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!http://in.rd.yahoo.com/tagline_ie8_new/*http://downloads.yahoo.com/in/internetexplorer/ .
Does the order of tuples in a bulk insert impact query performance?
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 unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Does the order of tuples in a bulk insert impact query performance?
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 INFILE), i remove the indexes before the load and add them back after. i work on the assumption that if the data is sorted already then the recreation of the indexes in the last step is faster. but then if you have orthogonal indexes, you have to choose one to sort the rows by. as for performance on accessing the table later in normal use, i guess it depends on the usage patterns. if there's a lot of clustered or sequential table reads then caching might be more effective if the rows are sorted. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
How do I get a list of all defined UDF's known to the system?
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?
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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
Re: How do I get a list of all defined UDF's known to the system?
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 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ERROR
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 DCTNMVH1 kernel: Feb 7 02:39:54 DCTNMVH1 kernel: Call Trace: Feb 7 02:40:01 DCTNMVH1 kernel: [800c6076] out_of_memory+0x8e/0x2f3 Feb 7 02:40:06 DCTNMVH1 kernel: [8002e2f2] __wake_up+0x38/0x4f Feb 7 02:40:06 DCTNMVH1 kernel: [8009fc0d] autoremove_wake_function+0x0/0x2e Feb 7 02:40:06 DCTNMVH1 kernel: [8000f487] __alloc_pages+0x245/0x2ce Feb 7 02:40:07 DCTNMVH1 kernel: [80012e03] __do_page_cache_readahead+0x96/0x179 Feb 7 02:40:07 DCTNMVH1 kernel: [80013765] filemap_nopage+0x14c/0x360 Feb 7 02:40:07 DCTNMVH1 kernel: [8000898c] __handle_mm_fault+0x1fa/0xf99 Feb 7 02:40:07 DCTNMVH1 kernel: [80066b25] do_page_fault+0x4cb/0x830 Feb 7 02:40:07 DCTNMVH1 kernel: [8009fc0d] autoremove_wake_function+0x0/0x2e Feb 7 02:40:07 DCTNMVH1 kernel: [80128659] file_has_perm+0x48/0xa3 Feb 7 02:40:07 DCTNMVH1 kernel: [8005dde9] error_exit+0x0/0x84 Feb 7 02:40:07 DCTNMVH1 kernel: Node 1 Normal per-cpu: Feb 7 02:40:07 DCTNMVH1 kernel: cpu 0 hot: high 186, batch 31 used:0 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 0 cold: high 62, batch 15 used:0 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 1 hot: high 186, batch 31 used:40 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 1 cold: high 62, batch 15 used:15 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 2 hot: high 186, batch 31 used:0 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 2 cold: high 62, batch 15 used:0 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 3 hot: high 186, batch 31 used:56 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 3 cold: high 62, batch 15 used:14 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 4 hot: high 186, batch 31 used:0 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 4 cold: high 62, batch 15 used:0 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 5 hot: high 186, batch 31 used:61 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 5 cold: high 62, batch 15 used:14 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 6 hot: high 186, batch 31 used:0 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 6 cold: high 62, batch 15 used:0 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 7 hot: high 186, batch 31 used:2 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 7 cold: high 62, batch 15 used:58 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 8 hot: high 186, batch 31 used:0 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 8 cold: high 62, batch 15 used:0 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 9 hot: high 186, batch 31 used:25 Feb 7 02:40:07 DCTNMVH1 kernel: cpu 9 cold: high 62, batch 15 used:44 Is the error related to mysql. Any body else facing similar issues. Thanks, Krishna