Friday, January 19, 2018

GC MySQL Database Optimized

Recently, GoldenChoco MySQL server has troubled for consuming too much memory. It caused by GoldenChoco Portal Web (http://www.goldenchoco.web.id) WordPress. When it loads MySQL consuming much memory, in actual there's not too much connection in the same time. Just for 1 client it can consumed much memory, while at the same time more than 1 connection it can caused server crashed.

Then we found that trouble from MySQL server didnt have any cache option for it when it loads query from client. 

From Internet we found some information about what MySQL server did when it consumed more memory:


  • MySQL default cache settings are not too tight on Ubuntu/Debian, making it suitable for moderate loads, not low loads. If you don’t have much content, everything is just kept in memory (even if not needed)
  • MySQL uses round robin for connections and if there is 100 max connections it will allocate a thread stack for each connection (someone please confirm this – I found contracting infos).
It mentioned about option to reduce memory consumption when MySQL loaded. Here some tips we found:

MySQL is mostly configured in /etc/mysql/my.cnf on Ubuntu / Debian.
  • Let’s set key_buffer from 16M to 8M. It is used by MyISAM table cache.
  • Set the query_cache_size. query_cache_size  = 8M. Also, decrease query_cache_limit to 512 K.
  • Each connection, even if idle, will have 256 KB buffer. Decrease the number of max. connections. (XXX: not sure about this). Drop max connections from 100 -> 30, as we do not have that many concurrent visitors on the site. Also, set less aggressive thread_stack size.
After we followed that tips, we found our MySQL memory consumption be more moderate. 

Source: http://fwd.rf.gd/7k-f1

Tuesday, November 07, 2017

GoldenChoco Server Outage


Selasa, 7 November 2017 (00.54)
Saat ini server utama GoldenChoco sedang mengalami gangguan, sedang dalam penanganan teknis, kemungkinan seluruh service di GoldenChoco akan terganggu. Diperkirakan dibutuhkan waktu hingga besok sore untuk perbaikan server GoldenChoco.

Status semua service GoldenChoco: OFFLINE

Selasa, 7 November 2017 (01.12)

Shutdown webserver and database server

Status semua service GoldenChoco: OFFLINE

Service yang tidak terdampak:
1. Blog Sekar92
2. sl2.goldenchoco.web.id
3. Blog status
4. GoldenChoco Box (server 4, 5, 6, 7, 8)

Selasa, 7 November 2017 (01.39)

Attempting restart all service...

Status semua service GoldenChoco: ONLINE

Tuesday, October 17, 2017

Portal Maintenance (17 Oktober 2017)

Portal saat ini sedang dalam perbaikan tema, kami akan kembali lagi 2 hari kemudian.

Sunday, September 10, 2017

Portal Scheduled Maintenance


As we knows that GoldenChoco Portal had been slow to access since its get updates from the last Themes. So, we'll change the portal themes with the new one. Meanwhile we are testing the new themes for the smoothness access, we'll inform that portal now been closed for a while. All information on the main domain of GoldenChoco (http://www.goldenchoco.web.id) aren't accessible, but all services on secondary domain such as, forums, GMV, GC Gallery are remain accessible and work properly. Keep in touch with us if you want to access to our content on main portal by contacting us to our forums (www.goldenchoco.web.id/board/). Thanks for your kindness and patient. We'll looking forward to the new look of our portal too, so please be back again soon. ETA for testing the new themes is about 4 days.

Sekar.W.

Thursday, March 23, 2017

GoldenChoco Mayor Outages by CDN Failure


Telah terjadi kegagalan sistem CDN kami yang disediakan oleh Incapsula. Saat ini beberapa sub-domain yang dilayani oleh Incapsula tidak dapat di akses. Sementara ini DNS kami masih di edit untuk di arahkan kembali ke server tanpa melalui Incapsula.

Mungkin akses ke website GoldenChoco akan mengalami pelambatan apabila di akses melalui jaringan IIX, dikarenakan tidak adanya layanan CDN pull-origin dari server kami ke remote client.

Kesalahan murni terjadi dikarenakan Incapsula. Bukan dari kesalahan kami.

Tuesday, March 14, 2017

Soft Launching GoldenChoco Music Videos


Kabar gembira bagi kita semua~

Kini GoldenChoco Music Videos (http://mv.goldenchoco.web.id) sudah di launching dan sudah Online selama 1 minggu di domain GoldenChoco.

Thursday, February 23, 2017

Portal Maintenance (23 Februari 2017)

Portal sedang offline karena sedang perbaikan layout dan mencoba tema baru, kemungkinan online kembali nanti malam.