ERROR

[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 DCTNMVH1 kernel:
Feb  7 02:39:54 DCTNMVH1 kernel: Call Trace:
Feb  7 02:40:01 DCTNMVH1 kernel:  []
out_of_memory+0x8e/0x2f3
Feb  7 02:40:06 DCTNMVH1 kernel:  [] __wake_up+0x38/0x4f
Feb  7 02:40:06 DCTNMVH1 kernel:  []
autoremove_wake_function+0x0/0x2e
Feb  7 02:40:06 DCTNMVH1 kernel:  []
__alloc_pages+0x245/0x2ce
Feb  7 02:40:07 DCTNMVH1 kernel:  []
__do_page_cache_readahead+0x96/0x179
Feb  7 02:40:07 DCTNMVH1 kernel:  []
filemap_nopage+0x14c/0x360
Feb  7 02:40:07 DCTNMVH1 kernel:  []
__handle_mm_fault+0x1fa/0xf99
Feb  7 02:40:07 DCTNMVH1 kernel:  []
do_page_fault+0x4cb/0x830
Feb  7 02:40:07 DCTNMVH1 kernel:  []
autoremove_wake_function+0x0/0x2e
Feb  7 02:40:07 DCTNMVH1 kernel:  []
file_has_perm+0x48/0xa3
Feb  7 02:40:07 DCTNMVH1 kernel:  [] 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

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

[Sir Wally Lewis]

Thanks

"Suresh Kuna"  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 
> > 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

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

[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  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
>
>

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

[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: Does the order of tuples in a bulk insert impact query performance?

[Tom Worster]

On 2/7/10 7:28 AM, "Anthony Urso"  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

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

[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 unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MY SQL Slave Server

[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  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 
> *To:* Vikram A 
> *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  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 
>> *To:* Vikram A 
>> *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  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! 
>> Homepage
>> .
>>
>
>
> --
> Your Mail works best with the New Yahoo Optimized IE8. Get it 
> NOW!
> .
>