bisa bantuin terangin cara optimalinnya lagi ? karena ini udah mentok optimalnya mungkin ada yang kurang
thx On 6/7/06, m Ilhami <[EMAIL PROTECTED]> wrote:
On 6/6/06, Mirza Khadnezar <[EMAIL PROTECTED]> wrote: > lupa informasiin spek server > ini ada sedikit cuplikan email dari salah seorang temen saya > "The bottleneck is IO and the fact that MySQL only can have 1000 > connections at the same time. All queries etc are optimized, so the > problem is not there. We are looking into getting an even better > server. Kalo bottleneck di IO justru karena query belum optimal. Table2 nya belum diindex secara tepat. Coba di aktifkan log slow query nya. Query yang lambat tsb diteliti. The DB server that we are using right now is a real monster, > dual Xeon 3 GHz processors, I think it has about 3 HD's with Raid 0+1 > and 2 disks with Raid 1 running the OS. Ini sih masih kacang goreng... > Our server is a really hard case becase everything is very live. We > have consulted huge firms that deal with scaling and optimization and > they havnt been able to help us to scale in a good fashion. > > The solution that we are looking for right now is to get even more > disks into the server to ease the IO load on each disk." Dicoba dulu aja pakai raid, supaya IO nya terbagi rata. -- FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab Unsubscribe: kirim email ke [EMAIL PROTECTED] Arsip dan info milis selengkapnya di http://linux.or.id/milis
-- FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab Unsubscribe: kirim email ke [EMAIL PROTECTED] Arsip dan info milis selengkapnya di http://linux.or.id/milis
