Hi,

I run a E450 4xSparc II 400 and 4GRam. 6scsi hd-drives.

The system serves an Apache 2.2 PHP 5 and MySQL on Solaris 10.

The system is really slow, it takes over 20 seconds to fetch and
transfer a PHP page from the database.

Could somebody give I hint what could I do or what could be the
problem.

Thanks
j.

"Juergen Sievers" <JSievers@t-online.de> wrote in message
news:1150422222.102228.244360@i40g2000cwc.googlegr oups.com...
> Hi,
>
> I run a E450 4xSparc II 400 and 4GRam. 6scsi hd-drives.
>
> The system serves an Apache 2.2 PHP 5 and MySQL on Solaris 10.
>
> The system is really slow, it takes over 20 seconds to fetch and
> transfer a PHP page from the database.
>
> Could somebody give I hint what could I do or what could be the
> problem.
>
> Thanks
> j.
>

Cound be your database.
We had the same problem some time ago.
The solution was to define more primary keys.
Might not apply to your situation but it made a world of difference to us.

On Fri, 16 Jun 2006, A.S wrote:

> Cound be your database.

AGreed. In my experience, MySQL does not scale very well.

> We had the same problem some time ago.
> The solution was to define more primary keys.

My solution was to adopt Postgres (which has other advantages too). :-)

--
Rich Teer, SCNA, SCSA, OpenSolaris CAB member

President,
Rite Online Inc.

Voice: +1 (250) 979-1638
URL: http://www.rite-group.com/rich