"server error 500" load 2.000 record mariadb+php+nginx centos 7

Discussion in 'Masalah Teknik dan Keamanan' started by Dika Haris, 7 Mar 2016.

Thread Status:
Not open for further replies.
  1. Dika Haris

    Dika Haris Apprentice 1.0

    Messages:
    299
    Likes Received:
    25
    Trophy Points:
    28
    Selamat pagi semuanya.

    Saya disini ingin berbagi masalah, mungkin ada mastah yang bisa memberikan pencerahan. :D

    Masalahnya : "server error 500" load 2.000 record mariadb+php-+nginx centos 7
    Settingan my.cnf dengan spek server RAM 8GB, 12 Core
    Code:
    [mysqld]
    query_cache_size = 256M
    query_cache_limit = 256M
    join_buffer_size = 256M
    thread_cache_size = 4
    
    innodb_buffer_pool_instances = 4
    innodb_buffer_pool_size = 4G
    innodb_log_buffer_size=2G
    innodb_log_file_size=1G
    
    
    Tapi ketika dicoba pake : Windows dengan paketan XAMPP berjalan normal. tapi prosesnya lama baget. :18:

    Atau harus disetting juga di nginx.conf dan php-fpm.conf ?? :39:
     
  2. pedagang

    pedagang Expert 1.0

    Messages:
    674
    Likes Received:
    109
    Trophy Points:
    43
    daripada pusing, mengapa nggak dibikin default aja (kosongan) karena default itu untuk standar 4-8G ram
     
  3. Dika Haris

    Dika Haris Apprentice 1.0

    Messages:
    299
    Likes Received:
    25
    Trophy Points:
    28
    Masalahnya untuk menampilkan 1000 record saja kalau pake default lama. Karna ini saya relasi ke 20 tabel. kalau pake Apache+php+MySQL kemarin lancar. cuma saya pengen lagi coba-coba pake nginx+mariadb+php. :D
     
  4. junior riau

    junior riau Hosting Guru Web Hosting

    Messages:
    3,229
    Likes Received:
    515
    Trophy Points:
    113
    max execution time php nya sama timeout nginx nya udah di besarin?
     
    Dika Haris likes this.
  5. Dika Haris

    Dika Haris Apprentice 1.0

    Messages:
    299
    Likes Received:
    25
    Trophy Points:
    28
    Kalau di nginx sudah, nah kanyanya di php belum.
    saya coba dulu ya mas. Nanti saya kabari lagi. Nuhun.. :D
     
  6. junior riau

    junior riau Hosting Guru Web Hosting

    Messages:
    3,229
    Likes Received:
    515
    Trophy Points:
    113
    monggo ;)
     
  7. masiqbal

    masiqbal Expert 2.0

    Messages:
    865
    Likes Received:
    249
    Trophy Points:
    43
    Karena sepertinya banyak pakai join maka harus cek index2 yg perlu di mariadb.
     
    Dika Haris likes this.
  8. mustafaramadhan

    mustafaramadhan Hosting Guru

    Messages:
    3,237
    Likes Received:
    857
    Trophy Points:
    113
    Nginx hanya 'bisa' pakai php-fpm sedangkan ada bermacam-macam 'model' untuk 'connection' ke php.

    Jika katanya pakai apache bisa, apakah pakai php-fpm juga?.
     
  9. Dika Haris

    Dika Haris Apprentice 1.0

    Messages:
    299
    Likes Received:
    25
    Trophy Points:
    28
    Untuk index, alhamdulillah sudah. Tapi nanti coba saya chek lagi dan optimasi untuk indexnya lagi takutnya ada yg kelupa di table yang lainnya. Trimakasih mas!
     
  10. Dika Haris

    Dika Haris Apprentice 1.0

    Messages:
    299
    Likes Received:
    25
    Trophy Points:
    28
    Iya mas, yg pake nginx memang pakai php-fpm. nah untuk yang di apache kayanya engga pake php-fpm. Saya lupa lagi soalnya. :rolleyes::D
     
Loading...
Thread Status:
Not open for further replies.

Share This Page

Loading...