Performance and the my.cnf file

2001-06-19 Thread David Allen
Hi, I have several problems to do with tuning mysql to run on a Sun E450. Firstly, I cannot get the mysql to read the my.cnf file. If it is installed in the data directory, mysql boots OK but ignores it, while if I copy it into the /etc directory I get the following error Starting mysqld daemon

my.cnf and tuning

2001-06-18 Thread David Allen
Hi, Could someone please e-mail me a copy of the example cnf files, as they did not come with my distribution. Thanks. For a Sun E450 with a single 300Mhz processor and 256Mb of RAM which .cnf file would you suggest I used? The machine is being used for a MRP server as well as a ODBC mysql

Re: CPU usage running mysql

2001-05-21 Thread David Allen
and it is driving me crazy... thanks randy -Original Message- From: David Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 8:59 AM To: [EMAIL PROTECTED] Subject: CPU usage running mysql Hi, We run mysql V3.22.32 (solaris 2.5.1 version ) on a Solaris 2.6 box. The top

Re: CPU usage running mysql

2001-05-21 Thread David Allen
I wish it was! See my note below, the 7 box runs at about 0.5% but the 2.6 box runs at 99%! David Simon Green wrote: Is that not 98% idle and mysqld using 5% of the total CPU use! i.e. you are looking at vary different things? Simon -Original Message- From: David Allen [mailto

Re: CPU usage running mysql

2001-05-21 Thread David Allen
Green wrote: Is that not 98% idle and mysqld using 5% of the total CPU use! i.e. you are looking at vary different things? Simon -Original Message- From: David Allen [mailto:[EMAIL PROTECTED]] Sent: 21 May 2001 12:42 To: Randy Johnson; [EMAIL PROTECTED] Subject: Re: CPU usage

CPU usage running mysql

2001-05-18 Thread David Allen
Hi, We run mysql V3.22.32 (solaris 2.5.1 version ) on a Solaris 2.6 box. The top command shows the mysqld running at 98.3% of cpu time when the system is idling. On a Solaris 7 box runnning Solaris 7 running mysql-3.22.32 (solaris 7 version) but also idle, the top command shows 0.5% for the

Design philosophy

2001-02-06 Thread David Allen
Hi, Because of various political issues during the development of our web site, it has been suggested that the web server and php scripts should be connected to the database server via a shared 2Meg WAN connection. As I am rather green when it comes to setting up internet sites which use