Hello all,
I am facing a problem regarding uploading to our mysql server.
We have a lamp server in cloud.Our problem is that our designer team is uploading various images,text to that serevr constantly,but at random time the server not responds and they are not able to upload. But after some time server becomes normal and they can upload with no problem.
I have used mysqltuner and these are the outputs------
[OK] Currently running supported MySQL version 5.5.34
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
[--] Data in InnoDB tables: 450M (Tables: 379)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] Total fragmented tables: 379
-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 5d 23h 18m 16s (7M q [15.210 qps], 3M conn, TX: 8B, RX: 2B)
[--] Reads / Writes: 99% / 1%
[--] Total buffers: 168.0M global + 2.8M per thread (151 max threads)
[OK] Maximum possible memory usage: 583.2M (14% of installed RAM)
[OK] Slow queries: 0% (19/7M)
[OK] Highest usage of available connections: 19% (30/151)
[OK] Key buffer size / total MyISAM indexes: 8.0M/121.0K
[OK] Key buffer hit rate: 100.0% (14M cached / 74 reads)
[!!] Query cache is disabled
[OK] Sorts requiring temporary tables: 0% (38 temp sorts / 2M sorts)
[!!] Joins performed without indexes: 4651
[OK] Temporary tables created on disk: 0% (7K on disk / 3M total)
[!!] Thread cache is disabled
[!!] Table cache hit rate: 6% (400 open / 5K opened)
[OK] Open file limit used: 1% (16/1K)
[OK] Table locks acquired immediately: 100% (20M immediate / 20M locks)
[!!] InnoDB buffer pool / data size: 128.0M/450.2M
[OK] InnoDB log waits: 0
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
Adjust your join queries to always utilize indexes
Set thread_cache_size to 4 as a starting value
Increase table_open_cache gradually to avoid file descriptor limits
Read this before increasing table_open_cache over 64:
http://bit.ly/1mi7c4C
Variables to adjust:
query_cache_size (>= 8M)
join_buffer_size (> 128.0K, or always use indexes with joins)
thread_cache_size (start at 4)
table_open_cache (> 400)
innodb_buffer_pool_size (>= 450M)
Can anyone explains what are the probable reasons and how should I troubleshoot the problem. Thank you