how we can decrease mysql CPU load

2010-03-29 Thread F.A.I.Z.A.L
Hi All please help me to reduce mysqld cpu load. mysql 4.1 running on solaris 10 with 4gb ram. front end apps is php (apache server). everyday mysql reach about 100% cpu load. can one help to fix this issue... thank you. Cheers Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com

RE: timezone questions

2010-03-29 Thread Daevid Vincent
> -Original Message- > From: Elim PDT [mailto:e...@pdtnetworks.net] > Sent: Monday, March 29, 2010 5:57 PM > To: mysql@lists.mysql.com > Subject: timezone questions > > data from one server in timezone A ported to another server > in timezone B, what will happen for the records with date

timezone questions

2010-03-29 Thread Elim PDT
data from one server in timezone A ported to another server in timezone B, what will happen for the records with datetime columns? What is the recommended way of handling this kind of issues? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: mysqld_safe

2010-03-29 Thread Colin Streicher
Yeah, its just a shell script that acts as a wrapper around the mysql processes on debian systems( maybe others, I'm not sure) You can read it at 'less /usr/bin/mysqld_safe' Colin On March 29, 2010 11:51:36 am Glyn Astill wrote: > --- On Mon, 29/3/10, Brown, Charles wrote: > > Hello All. wh

Re: mysqld_safe

2010-03-29 Thread Glyn Astill
--- On Mon, 29/3/10, Brown, Charles wrote: > Hello All.  when I issued this > command: ps -e | grep,  I noticed that mysqld_safe was > up running in my system. > My question is:  what is mysqld_safe and why was it > running. Please help. > > > [sp...@naxbmisq03 ~]$ ps -e | grep -i mysql > 11989

mysqld_safe

2010-03-29 Thread Brown, Charles
Hello All. when I issued this command: ps -e | grep, I noticed that mysqld_safe was up running in my system. My question is: what is mysqld_safe and why was it running. Please help. [sp...@naxbmisq03 ~]$ ps -e | grep -i mysql 11989 ?00:00:00 mysqld_safe 12025 ?13:28:39 mysqld