Yeni Cevap 
 
Konuyu Değerlendir
  • 0 Oy - 0 Ortalama
  • 1
  • 2
  • 3
  • 4
  • 5
MySql overload
Yazar Mesaj
Braxton Çevrimdışı
Member
***

Mesajlar: 20
Katılım: May 2018
Rep Puanı: 0
Mesaj: #1
MySql overload
Hi,

We are looking for a specific solution related to our MySql database which is effecting our server performance.

We have a social networking website which is database intensive (the max. load is on the database server i.e MySql).

It so happens that our MySql load reaches 70-85% on an average. More of this happens because we complie some reports on a daily basis where we have to create about 60,000 records everyday (10,000 records x 6 tables). Each cron here takes about 30-40 minutes to generate these 10,000 records and we have to run 6 crons daily. While we have checked slow queries, but these queries are optimized. However, due to the nature of these customized reports, it takes quite a load on the MySql server.

What could be a possible solution for us to reduce the load:
1. Do we host a database on an alternate server, then generate records to this database?
2. Do we run a mirror database on another server and run our queries there?

Any other possible solution where we could pull more data from MySql whenever required without effecting the normal performance of the database while end users are using the site?

I didn't find the right solution from the Internet.

References:
https://www.club-oracle.com/threads/mysq...load.7875/
Explainer Video Production Company


Thanks
11-05-2018 13:50
Bu kullanıcının gönderdiği tüm mesajları bul Bu mesajı alıntı yap
Yeni Cevap 


Benzer Konular...
Konu: Yazar Cevaplar: Gösterim: Son Mesaj
  Doesn't work MySQL properly. Braxton 0 12 11-05-2018 13:51
Son Mesaj: Braxton
  mysql komutları hosting 2 4,475 26-09-2014 16:21
Son Mesaj: butamedya
  MySQL Veri Tabanınızı ORACLE ile Hızlandırın Bertan İlhan 4 7,012 15-08-2012 23:15
Son Mesaj: narkoz_39
  mySQL 5.5.x ve oscommerce snowbird 0 2,241 27-10-2011 11:38
Son Mesaj: snowbird
  Ajax tabanlı MySql Web Admin snowbird 0 2,722 28-08-2010 11:22
Son Mesaj: snowbird

Foruma Git:


Bu konuyu görüntüleyen kullanıcı(lar): 1 Ziyaretçi