On Sat, Jun 28, 2003 at 01:47:28PM -0400, Wendell Dingus wrote:
> Hello, I've got a situation I'm hoping someone here can help me out with.
We
> have a web server serving up data via some PHP programs pulling from MySQL
> (3.23.56 currently) in INNODB tables. There are 40+ (active) databases
> totalling a bit over 28 Gigabytes at this point. As we add more users
speed
> is beginning to drop...
>
> Currently all this is on a single dual P3 1.26Ghz IBM eServer with 4GB of
> RAM. 4 x 15K RPM drives RAID5. It's hitting load averages >12 during peak
> times and database query speeds are really starting to drag...

p3's are ancient architecture now , but i have found trnasactions and full
text searching to be very cpu intensive

> I've talked some with the consulting folks at MySQL and have the intention
> of contracting them to help analyze our database layout, structure, and
> queries to help optimize things.

hmm the most common thing is to send the list an explain table and maybe the
table layout someone may help out, could be an indexing problem.

> My quandry is this though.. The existing server has 4GB but I can't get
> innodb_buffer_pool_size above about 1.2GB  I'd buy tons more RAM and go
that
> route if it could be utilized, I've not figured out how though and assume
> that's the deal with a 32-bit CPU. Reading some about 64-bit Opterons and
a
> 64-bit address space sounds good.

hey funny u mentioned that i had a read @ thoms hardware i must recommend
this as a worthy read

http://www17.tomshardware.com/cpu/20030422/index.html

ok so basically in a unix environment the opteron blew all over the XEON
especially in the mysql benchmark, so the opteron/linux is going to be the
recommended cheaper alternative server to sun/solaris, although obviouslly
XEON kicked ass in rendering situations on an XP desktop as its optimised
for it , so its the situation really i'm currently investigating in the
right XEON chip and mobo for a XP rendering workstation for audio/video
stuff, but if i were to build a unix server opteron all the way


> I have the bosses ear for hardware _now_ though and want to move
> forward before that opportunity passes. I'll post the database specs
> at the end of this. If you were hosting that much data without a ton
> of inserts all day long but lots of selects where would you
> concentrate your efforts? Speed of CPU or speed/quantity of RAM or
> speed of drives or what?

maybe send a grab of top or something would be good


> Mytop output after about 28 hours of uptime so this is just Friday during
> business hours access primarily:
> MySQL on localhost (3.23.56-Max-log)
> up 1+04:56:30 [13:29:15]
>  Queries Total: 1,783,317      Avg/Sec: 17.12  Now/Sec: 0.40  Slow: 1,046
>  Threads Total: 33        Active: 1     Cached: 0
>  Key Efficiency: 99.99%  Bytes in: 779,059,153  Bytes out: 543,489,706

hmm mytop is a good app



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to