Merhaba bende yardiminizi alabilirmiyim mysql ayarlarindan hic anlamiyorum .
Sistemimiz,
Parallels Plesk Panel version 9.0.1
Operating system Linux 2.6.18-92.el5PAE
CPU GenuineIntel, Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz
Average load 1.58; 1.24; 0.97
4 GB RAM
Delicated server uzerinde suan tek sitemiz bulunmaktadir.
[1;34m-- MYSQL PERFORMANCE TUNING PRIMER --
- By: Matthew Montgomery -
MySQL Version 5.0.45 i686
Uptime = 14 days 5 hrs 6 min 59 sec
Avg. qps = 87
Total Questions = 107259074
Threads Connected = 16
Server has been running for over 48hrs.
It should be safe to follow these recommendations
[31mTo find out more information on how each of these
[31mruntime variables effects performance visit:
[1;34mhttp://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
[1;34mVisit http://www.mysql.com/products/enterprise/advisors.html
[1;34mfor info about MySQL's Enterprise Monitoring and Advisory Service
[1;34mSLOW QUERIES
The slow query log is [1;31mNOT enabled.
Current long_query_time = 10 sec.
You have [1;31m453 out of [1;31m107259108 that take longer than 10 sec. to complete
[31mYour long_query_time may be too high, I typically set this under 5 sec.
[1;34mBINARY UPDATE LOG
The binary update log is [1;31mNOT enabled.
[31mYou will not be able to do point in time recovery
[33mSee http://dev.mysql.com/doc/refman/5.0/en/point-in-time-recovery.html
[1;34mWORKER THREADS
Current thread_cache_size = 0
Current threads_cached = 0
Current threads_per_sec = 14
Historic threads_per_sec = 12
[31mThreads created per/sec are overrunning threads cached
[31mYou should raise thread_cache_size
[1;34mMAX CONNECTIONS
Current max_connections = 100
Current threads_connected = 10
Historic max_used_connections = 101
The number of used connections is [31m101% of the configured maximum.
[31mYou should raise max_connections
[1;34mMEMORY USAGE
Max Memory Ever Allocated : 289 M
Configured Max Per-thread Buffers : 268 M
Configured Max Global Buffers : 17 M
Configured Max Memory Limit : 286 M
Physical Memory : 3.94 G
[32mMax memory limit seem to be within acceptable norms
[1;34mKEY BUFFER
Current MyISAM index space = 55 M
Current key_buffer_size = 7 M
Key cache miss rate is 1 : 362
Key buffer free ratio = 0 %
[1;31mYou could increase key_buffer_size
It is safe to raise this up to 1/4 of total system memory;
assuming this is a dedicated database server.
[1;34mQUERY CACHE
[31mQuery cache is supported but not enabled
[31mPerhaps you should set the query_cache_size
[1;34mSORT OPERATIONS
Current sort_buffer_size = 2 M
Current read_rnd_buffer_size = 256 K
[32mSort buffer seems to be fine
[1;34mJOINS
Current join_buffer_size = 132.00 K
You have had 484 queries where a join could not use an index properly
[31mYou have had 40 joins without keys that check for key usage after each row
You should enable "log-queries-not-using-indexes"
Then look for non indexed joins in the slow query log.
If you are unable to optimize your queries you may want to increase your
join_buffer_size to accommodate larger joins in one pass.
[1;31mNote! This script will still suggest raising the join_buffer_size when
[1;31mANY joins not using indexes are found.
[1;34mOPEN FILES LIMIT
Current open_files_limit = 65535 files
[33mThe open_files_limit should typically be set to at least 2x-3x
[33mthat of table_cache if you have heavy MyISAM usage.
[32mYour open_files_limit value seems to be fine
[1;34mTABLE CACHE
Current table_cache value = 64 tables
You have a total of 800 tables
You have [1;31m64 open tables.
Current table_cache hit rate is [1;31m0%, while [1;31m100% of your table cache is in use
[31mYou should probably increase your table_cache
[1;34mTEMP TABLES
Current max_heap_table_size = 16 M
Current tmp_table_size = 32 M
Of 1098615 temp tables, 17% were created on disk
[33mEffective in-memory tmp_table_size is limited to max_heap_table_size.
[32mCreated disk tmp tables ratio seems fine
[1;34mTABLE SCANS
Current read_buffer_size = 128 K
Current table scan ratio = 83 : 1
[32mread_buffer_size seems to be fine
[1;34mTABLE LOCKING
Current Lock Wait ratio = [31m1 : 64
You may benefit from selective use of InnoDB.
If you have long running SELECT's against MyISAM tables and perform
frequent updates consider setting 'low_priority_updates=1'
If you have a high concurrency of inserts on Dynamic row-length tables
consider setting 'concurrent_insert=2'.
My.conf
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
ne tur bir ayar yapmam gerekmektedir yardimci olacak arkadaslara tesekkur ederim.