XFileSharing Pro - Ubuntu =! CentOS - Page 2

[Stefanzm]

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 .

[Stefanzm]

Raising the ulimits didn't help at all . It even made it worst . Index.cgi builds up to 250 times now .

[chrda]

run mysqltuner.pl on your server and make sure its tuned.

[Stefanzm]

Hello chrda , i`ll test the mysqltuner shortly.
However i`m starting to think someone flooding me somehow .
From 200 builded index.cgi it gone down to 1 on its own .
Still trying to figure out whats going on , but there is not single IP to reappear on the access_log enough times to look into it .

[chrda]

If mysql is getting slow due peak hours, your amount of delayed index.cgi will just grow.

[Stefanzm]

[--] 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 .

[chrda]

1. Do you run web and fileserver on the same server?

2. Do you use nginx mod?

3. you can install CSF firewall and use the connect tracker function to limit connections per IP

[Stefanzm]

1. Its only web server , no fileserver on it.
2. Yes , nginx is enabled and running .
3. I think i need tool to see which IP`s have connected to the web server or to the machine . The load go from 250 to 5 and then builds back up.

[chrda]

Code: Select all

netstat -ntu | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n

[Stefanzm]

7 ******
7 ******
7 *******
8 ******
8 ******
2944
4393 Home-IP

Those 2944 comes up empty , no address or anything . The 4393 has the server ip address .

[chrda]

Install CSF firewall, tune the incoming and outgoing ports, run it in test mode first. Then run it in production mode when you are sure its working.

All servers should have a firewall running on it.

Hard to say what the blank connections is. maybe ipv6?