Please i need help with my.cnf

X

xoox

Verified User
Joined
Oct 24, 2008
Messages
52
Hello
Last week installed DIRECTADMIN on LINUX CENTOS 64BIT
Server setup 6GB RAM and Intel® Xeon® Processor X3210 (8M Cache, 2.13 GHz 4 cores).


I have a MyISAM table more than 1 million records and your size about 400MB and then do a table search takes some time and I want to improve it

I want to make changes in my.cnf to exploit better the RAM when working with MYSQL

Where is my.cnf file?
What should and should write there?
 
xoox said:
What should and should write there?
Click to expand...
There should be some sample files at /usr/share/mysql/

To start with when we set up servers we use my-large.cnf but you may need a different one or may want to experiment.

You need to copy the file you want to use to my.cnf, edit it there if necessary, and restart mysqld.

Jeff
 
I've just edited my reply immediately above (post #3). The last line should give you some insight :).

Jeff
 
Code: 
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.14
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 406M (Tables: 1575)
[--] Data in InnoDB tables: 19M (Tables: 104)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 0B (Tables: 2)
[!!] Total fragmented tables: 135

-------- Security Recommendations  -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 3d 0h 35m 45s (9M q [34.629 qps], 1M conn, TX: 30B, RX: 868M)
[--] Reads / Writes: 91% / 9%
[--] Total buffers: 168.0M global + 2.8M per thread (151 max threads)
[OK] Maximum possible memory usage: 583.2M (9% of installed RAM)
[OK] Slow queries: 0% (74/9M)
[OK] Highest usage of available connections: 47% (72/151)
[!!] Key buffer size / total MyISAM indexes: 8.0M/370.1M
[!!] Key buffer hit rate: 86.6% (20B cached / 2B reads)
[!!] Query cache is disabled
[OK] Sorts requiring temporary tables: 0% (1K temp sorts / 723K sorts)
[!!] Joins performed without indexes: 19773
[OK] Temporary tables created on disk: 15% (51K on disk / 330K total)
[!!] Thread cache is disabled
[!!] Table cache hit rate: 1% (400 open / 28K opened)
[OK] Open file limit used: 64% (656/1K)
[OK] Table locks acquired immediately: 99% (7M immediate / 7M locks)
[OK] InnoDB data size / buffer pool: 19.5M/128.0M

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    Enable the slow query log to troubleshoot bad queries
    Adjust your join queries to always utilize indexes
    Set thread_cache_size to 4 as a starting value
    Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
    key_buffer_size (> 370.1M)
    query_cache_size (>= 8M)
    join_buffer_size (> 128.0K, or always use indexes with joins)
    thread_cache_size (start at 4)
    table_cache (> 400)

Now what should I do?
 
Recommendations at the bottom are things you need to change.
 
What commands exactly I need to register and where?
I can not find the file MY.CNF in a directory ETC
 
You must log in or register to reply here.
Back
Top