Hello trinsic ,
[root@ ~]# ulimit -Hn
4096
[root@ ~]# ulimit -Sn
1024
[root@~]# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 62470
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 1024
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
However in /etc/sysctl.conf i have no such settings , will need to read a little to find how exactly to increase those .
XFileSharing Pro - Ubuntu =! CentOS - Page 2
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.66
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 15M (Tables: 104)
[--] Data in InnoDB tables: 46M (Tables: 192)
[!!] Total fragmented tables: 196
-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 19m 53s (174K q [146.603 qps], 50K conn, TX: 44M, RX: 11M)
[--] Reads / Writes: 63% / 37%
[--] Total buffers: 178.0M global + 2.7M per thread (151 max threads)
[OK] Maximum possible memory usage: 583.8M (7% of installed RAM)
[OK] Slow queries: 0% (0/174K)
[OK] Highest usage of available connections: 11% (18/151)
[OK] Key buffer size / total MyISAM indexes: 16.0M/7.4M
[OK] Key buffer hit rate: 97.4% (105K cached / 2K reads)
[OK] Query cache efficiency: 24.2% (3K cached / 16K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 15 sorts)
[OK] Temporary tables created on disk: 10% (3 on disk / 30 total)
[OK] Thread cache hit rate: 99% (170 created / 50K connections)
[OK] Table cache hit rate: 97% (328 open / 335 opened)
[OK] Open file limit used: 2% (260/10K)
[OK] Table locks acquired immediately: 99% (32K immediate / 32K locks)
[OK] InnoDB data size / buffer pool: 46.7M/128.0M
That is the status of mysqltuner after i changed few stuff . Need to wait 24 hours to show more accurate info. The occupied RAM increased probably from the new cache settings for mysql .
But still index.cgi continue to builds up .
[OK] Currently running supported MySQL version 5.1.66
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 15M (Tables: 104)
[--] Data in InnoDB tables: 46M (Tables: 192)
[!!] Total fragmented tables: 196
-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 19m 53s (174K q [146.603 qps], 50K conn, TX: 44M, RX: 11M)
[--] Reads / Writes: 63% / 37%
[--] Total buffers: 178.0M global + 2.7M per thread (151 max threads)
[OK] Maximum possible memory usage: 583.8M (7% of installed RAM)
[OK] Slow queries: 0% (0/174K)
[OK] Highest usage of available connections: 11% (18/151)
[OK] Key buffer size / total MyISAM indexes: 16.0M/7.4M
[OK] Key buffer hit rate: 97.4% (105K cached / 2K reads)
[OK] Query cache efficiency: 24.2% (3K cached / 16K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 15 sorts)
[OK] Temporary tables created on disk: 10% (3 on disk / 30 total)
[OK] Thread cache hit rate: 99% (170 created / 50K connections)
[OK] Table cache hit rate: 97% (328 open / 335 opened)
[OK] Open file limit used: 2% (260/10K)
[OK] Table locks acquired immediately: 99% (32K immediate / 32K locks)
[OK] InnoDB data size / buffer pool: 46.7M/128.0M
That is the status of mysqltuner after i changed few stuff . Need to wait 24 hours to show more accurate info. The occupied RAM increased probably from the new cache settings for mysql .
But still index.cgi continue to builds up .
Code: Select all
netstat -ntu | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n