Hardware improvements would certainly help.
There are two things that immediately spring to mind
1) double or quadruple the ram
2) increase/change your discs - add high speed SCSI/SATA putting the
database and swap space on these discs.
The final option is to look at a two processor mother board upgrade. If
you're P3 is slot1 you can pick an ATX motherboard up on ebay for about
35UKP if it's a s370 then you're going to have more problems - still do able
but they don't come up as often. Then you need to add another processor
about another £35UKP - for a s370 P3, I've not seen many 733/133 slot1 P3's
advertised.
Alternatively, keep an eye out for a dual P3 server going cheap - again they
do come up.
All our servers here are dual P4's with hyper-threading and we have problems
connecting MySqlCC or the New MySqlAdministrator and doing a 'show tables'
when a database instance is heavily loaded.
Kevin Cowley
R&D
Tel: 0118 902 9099 (direct line)
Email: [EMAIL PROTECTED]
Web: http://www.alchemetrics.co.uk
> -Original Message-
> From: Ender Güler [mailto:[EMAIL PROTECTED]
> Sent: 25 January 2005 19:10
> To: mysql@lists.mysql.com
> Subject: server performance
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hello,
>
> I use a mysql server on red hat 9 linux box with PIII 733 Mhz cpu and
> 256 MB memory. On this machine we use an adserver with a mysql
> backend. All click and view logs are kept in mysql tables. The number
> of the advertisements are increasing and so do the server's overhead.
> Some times I can not connect the box via ssh because of the overhead.
>
> First, I want to ask that the overhead will be over or not if I
> upgrade the hardware? Will hardware upgrade solve the problem?
>
> If another solution is possible, what is it? I'm new to mysql and also
> database stuff. So you want some server logs or status query results?
> Which are the most important infos for finding the problem and finding
> a way to solution. Could you please help me? Thanks in advance..
>
> Best Regards
>
> Ender Guler
>
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.2.1 (GNU/Linux)
> Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
>
> iD8DBQFB9pltFcK2rO6AhukRAuDzAJ0Vl5kfGcpaH1PNQ0OJUyKBXSo+bACfQNFD
> 5zGosOgXzfBv6vLTYf+pfZI=
> =6r1A
> -END PGP SIGNATURE-
>
**
ALCHEMETRICS LIMITED (ALCHEMETRICS)
Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX
Tel: +44 (0) 118 902 9000Fax: +44 (0) 118 902 9001
This e-mail is confidential and is intended for the use of the addressee only.
If you are not the intended recipient, you are hereby notified that you must
not use, copy, disclose, otherwise disseminate or take any action based on this
e-mail or any information herein.
If you receive this transmission in error, please notify the sender
immediately by reply e-mail or by using the contact details above and then
delete this e-mail.
Please note that e-mail may be susceptible to data corruption, interception and
unauthorised amendment. Alchemetrics does not accept any liability for
any such corruption, interception, amendment or the consequences thereof.
**
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
