|
Posted by lark on June 18, 2007, 9:50 am
Please log in for more thread options == Quote from grace (zympoul@gmail.com)'s article
> Ayon kay lark:
> > == Quote from grace (zympoul@gmail.com)'s article
> > > Ayon kay grace:
> > > > i am wondering why my database retrieval becomes too slow...we set up
> > > > a new server (ubuntu, breezy badger) machine where we transferred all
> > > > our files from the old server.. Our new server uses Asus p5pe-vm
> > > > motherboard and an Intel Pentium D 3.0Ghz processor, compared to the
> > > > old one where we uses asrock motherboard and AMD Duron. Both has the
> > > > same version of mysql installed...
> > > >
> > > > To summarized, both machine has the same configuration except for some
> > > > hardware changes and the version of the Ubuntu installed (we used
> > > > ubuntu hoary hedgehog on the old machine).
> > > >
> > > > what would be the cause of our problem? i don't thnk it has someting
> > > > to do with the way i run my queries from my applications since i do
> > > > not encounter such problems on our old machine..Also i tried to
> > > > execute queries from my sqlyog :
> > > > ex:
> > > > select * from db_town
> > > > result: 8902 rows() in 2687 ms
> > > > where on the old server it should take only about 421 ms
> > > >
> > > > select * from diagnostics_detail
> > > > result: 42499 rows() in 27609 ms
> > > > where on the old server it should take only about 4375
> > > > ms
> > > >
> > > > Please please need again ur urgent help...
> > > > grace
> > > when i tried to do some comparisons between my old and my new server
> > > here's the outcome:
> > > NEW SERVER:
> > > Db_town 8902 rows direct from
> > > machine: 50ms from network: 2687ms
> > > Diagnostics_detail 42511 rows direct from machine:
> > > 410ms from network: 27609ms
> > > OLD SERVER:
> > > Db_town 8902 rows direct from
> > > machine: 60ms from network: 421ms
> > > Diagnostics_detail 42511 rows direct from machine:
> > > 410ms from network: 4375ms
> > > hope someone could help me...
> > > grace
> >
> > i don't think this has anything to do with hardware.
> > be sure to run optimize table on all of your tables in the new server and
then
> > post the results back in here.
> > --
> > POST BY: lark with PHP News Reader
> tnx for the advice...
> is it alright to run 'optimize table' while the database is active? -
> meaning while users are using it? to be sure i am planning to do it
> later when they are sure done with it..any results, i would inform
> you..tnx much
yes! it is safe to run optimize table on your tables while it the database server
is active.
--
POST BY: lark with PHP News Reader
| 
XML Sitemap