MRatWork Forum by Mustafa Ramadhan - Dimana letak my.cnf

Sponsor:
Server and Web Integrator
Link:
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:

MRatWork Forum | Please login or register. | 2017-11-07, 21:33:26

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- Dimana letak my.cnf

« previous next »

- Print

Pages: [1] Go Down

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

0 Members and 1 Guest are viewing this topic.

#### deprie

- Junior Member
- Posts: 5
- Karma: +0/-0

##### 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 »
Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### 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.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### deprie

- Junior Member
- Posts: 5
- Karma: +0/-0

##### 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
Logged

#### masnggakdiajak

- Valuable Member
- Posts: 125
- Karma: +0/-0

##### 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
Logged

#### deprie

- Junior Member
- Posts: 5
- Karma: +0/-0

##### 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 »
Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### 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'.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### deprie

- Junior Member
- Posts: 5
- Karma: +0/-0

##### 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)

Logged

#### masnggakdiajak

- Valuable Member
- Posts: 125
- Karma: +0/-0

##### 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
Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### 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.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

- Print

Pages: [1] Go Up
« previous next »

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- Dimana letak my.cnf

Top 4 Global Search Engines: Google Bing Baidu Yahoo

- Design By SMFSimple.com
- SMF 2.0.14 | SMF © 2017, Simple Machines

Page created in 0.039 seconds with 17 queries.

Mirror created by MasterkinG32.CoM