Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2017-11-07, 21:33:24

Author Topic: Dimana letak my.cnf  (Read 1288 times)

0 Members and 1 Guest are viewing this topic.

Offline deprie

  • Junior Member
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Dimana letak my.cnf
« on: 2016-03-31, 10:45:22 »
Mohon maaf saya baru di server dan menggunakan kloxo, saya cari my.cnf tapi tidak ketemu sudah coba etc/my.cnf tapi tidak ada juga. mohon bantuannya
« Last Edit: 2016-04-01, 04:19:05 by deprie »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Dimana letak my.cnf
« Reply #1 on: 2016-03-31, 14:29:25 »
Seharusnya adalah /etc/my.cnf baik untuk mysql maupun mariadb. Biarpun demikian, untuk mariadb maka /etc/my.cnf akan mengarah ke direktori /etc/my.cnf.d and Kloxo-MR menggunakan /etc/my.cnf.d/server.cnf untuk setting.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline deprie

  • Junior Member
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Re: Dimana letak my.cnf
« Reply #2 on: 2016-04-01, 03:37:11 »
saya menggunkan mariadb, berikut tampilan service.cnf saya
Code: [Select]
 this is only for the mysqld standalone daemon
[mysqld]
default-storage-engine=innodb
#skip-innodb
performance_schema=on
#OpenVZ AIO bug fix
innodb_use_native_aio=0

# this is only for embedded server
[embedded]

# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]

# This group is only read by MariaDB-10.0 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.0]


kemaren saya tambahkan beberapa konfig dasar mysql, tapi malah g jalan. mohon bantuan cara settingnya

Offline masnggakdiajak

  • Valuable Member
  • *
  • Posts: 125
  • Karma: +0/-0
    • View Profile
Re: Dimana letak my.cnf
« Reply #3 on: 2016-04-01, 04:01:33 »
bisa di tampilkan errornya apa? bisa lihat di log mysql atau ketika stat mysqlnya muncul apa? dan tujuan edit my.cnf apa? mungkin mau optimasi atau yang lainnya  :D

Offline deprie

  • Junior Member
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Re: Dimana letak my.cnf
« Reply #4 on: 2016-04-01, 04:16:34 »
saya mau optimasi mysqlnya. bagaimana cara optimasinya ?
beriluk tampilan  sh /script/sysinfo server saya
Code: [Select]
A. Control Panel:
   - Kloxo-MR: 7.0.0.b-2016032701
   - Web: hiawatha-10.1.0-f.6.mr.el6.x86_64
   - PHP: php54s-5.4.45-1.ius.el6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.7 (Final) x86_64
   - Hostname: server.aplikasi-online.com
C. Services:
   1. MySQL: MariaDB-server-10.0.24-1.el6.x86_64
   2. PHP:
      - Branch: php54-cli-5.4.45-1.ius.el6.x86_64
      - Multiple:
        * php52m-5.2.17-102.mr.el6
        * php53m-5.3.29-1.ius.el6
        * php54m-5.4.45-1.ius.el6
        * php55m-5.5.33-1.ius.el6
        * php56m-5.6.19-1.ius.el6
        * php70m-7.0.4-1.w6
      - Used: php54m
   3. Web Used: hiawatha
     - Hiawatha: --used--
     - Lighttpd: --uninstalled--
     - Nginx: --uninstalled--
     - Httpd: --uninstalled--
       - PHP Type: php-fpm_worker
   4. WebCache: trafficserver
     - ATS: trafficserver-5.3.0-1.el6.x86_64
     - Squid: --uninstalled--
     - Varnish: --uninstalled--
   5. Dns: nsd
     - Bind: --uninstalled--
     - DJBDns: --uninstalled--
     - NSD: nsd-4.1.7-3.el6.x86_64
     - PowerDNS: --uninstalled--
     - Yadifa: --uninstalled--
   6. Mail: qmail-toaster-1.03-1.3.55.mr.el6.x86_64
      - pop3/imap4: courier-imap-toaster-4.1.2-1.3.18.mr.el6.x86_64
      - spam: bogofilter
D. Memory:
                total       used       free     shared    buffers     cached
   Mem:          1024        647        376         69          0        374
   -/+ buffers/cache:        272        751
   Swap:         1024         25        998
E. Disk Space:
   Filesystem         Size  Used Avail Use% Mounted on
   /dev/ploop32226p1   20G  3.0G   16G  16% /
« Last Edit: 2016-04-01, 04:19:19 by deprie »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Dimana letak my.cnf
« Reply #5 on: 2016-04-01, 04:23:38 »
Install mysqltuner dengan 'yum install mysqltuner -y.

Setelah itu jalankan dengan 'sh /script/restart-mysql -y; mysqltuner --user root --pass ROOTPASSWORD'. Set mysql root password 'sh /script/reset-mysql-root-password ROOTPASSWORD'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline deprie

  • Junior Member
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Re: Dimana letak my.cnf
« Reply #6 on: 2016-04-01, 04:29:56 »
ini tampilan mysqltuner
Code: [Select]
- For help, type '/script/restart-mysql [--help|-h]'

 >>  MySQLTuner 1.1.1 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering
[OK] Logged in using credentials passed on the command line

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[!!] Your MySQL version 10.0.24-MariaDB is EOL software!  Upgrade soon!
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 13K (Tables: 4)
[--] Data in CSV tables: 0B (Tables: 2)
[--] Data in InnoDB tables: 7M (Tables: 325)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52)
[OK] Total fragmented tables: 0

-------- Security Recommendations  -------------------------------------------
[!!] User '' has no password set.
[!!] User '' has no password set.
Use of uninitialized value in addition (+) at /usr/bin/mysqltuner line 547 (#1)
    (W uninitialized) An undefined value was used as if it were already
    defined.  It was interpreted as a "" or a 0, but maybe it was a mistake.
    To suppress this warning assign a defined value to your variables.

    To help you figure out what was undefined, perl will try to tell you the
    name of the variable (if any) that was undefined. In some cases it cannot
    do this, so it also tells you what operation you used the undefined value
    in.  Note, however, that perl optimizes your program and the operation
    displayed in the warning may not necessarily appear literally in your
    program.  For example, "that $foo" is usually optimized into "that "
    . $foo, and the warning will refer to the concatenation (.) operator,
    even though there is no . in your program.

Use of uninitialized value $myvar{"have_innodb"} in string eq at
        /usr/bin/mysqltuner line 665 (#1)

-------- Performance Metrics -------------------------------------------------
[--] Up for: 3s (9 q [3.000 qps], 7 conn, TX: 17K, RX: 1K)
[--] Reads / Writes: 100% / 0%
[--] Total buffers: 288.0M global + 416.0K per thread (151 max threads)
[OK] Maximum possible memory usage: 349.3M (34% of installed RAM)
[OK] Slow queries: 0% (0/9)
[OK] Highest usage of available connections: 0% (1/151)
[OK] Key buffer size / total MyISAM indexes: 128.0M/21.0K
[OK] Temporary tables created on disk: 0% (0 on disk / 2 total)
[!!] Thread cache is disabled
[OK] Table cache hit rate: 100% (63 open / 0 opened)
[OK] Open file limit used: 0% (10/20K)
[OK] Table locks acquired immediately: 100% (73 immediate / 73 locks)
[!!] Connections aborted: 14%

-------- Recommendations -----------------------------------------------------
General recommendations:
    MySQL started within last 24 hours - recommendations may be inaccurate
    Upgrade MySQL to version 4+ to utilize query caching
    Set thread_cache_size to 4 as a starting value
    Your applications are not closing MySQL connections properly
Variables to adjust:
    thread_cache_size (start at 4)

Offline masnggakdiajak

  • Valuable Member
  • *
  • Posts: 125
  • Karma: +0/-0
    • View Profile
Re: Dimana letak my.cnf
« Reply #7 on: 2016-04-01, 05:04:48 »
hasil mysqltunernya merekomendasikan
Code: [Select]
-------- Recommendations -----------------------------------------------------
General recommendations:
    MySQL started within last 24 hours - recommendations may be inaccurate
    Upgrade MySQL to version 4+ to utilize query caching
    Set thread_cache_size to 4 as a starting value
    Your applications are not closing MySQL connections properly
Variables to adjust:
    thread_cache_size (start at 4)

Bisa dicoba ditambahkan thread_cache_size=4 di /etc/my.cnf.d/server.cnf kemudian di mysqltuner lagi apakah ada Recommendations

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Dimana letak my.cnf
« Reply #8 on: 2016-04-01, 05:27:39 »
Ya ikuti saja recomendasi mysqltuner dan kemudian restart mysql dan jalankan lagi mysqltuner.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix

Page created in 0.038 seconds with 17 queries.

web stats analysis
 
Mirror created by MasterkinG32.CoM