MySQL ‘de max_connection değerini artırmak

MySQL’de max_connection(aynı anda izin verilen en çok bağlantı sayısı) değerini artırmak icin /etc/rc.conf dosyasına mysql_args=”-O max_connections=XXXX” ifadesi eklenir.

Örneğin bu değeri 1000 yapmak için:
mysql_args=”-O max_connections=1000″

cdn tests at mailman

# wget -O /dev/null http://speedtest.voxcdn.com/test_tenmb.data
# wget -O /dev/null http://cachefly.cachefly.net/10mb.test
# wget -O /dev/null http://bitcast-a.bitgravity.com/bitgravity/10MB
# wget -O /dev/null http://test.vo.llnwd.net/o1/sales/tenmegfile.wmv
# wget -O /dev/null http://74.63.66.114/100MBtest.zip
# wget -O /dev/null http://www.tranxactglobal.com/speedtest/11mbtest
# wget -O /dev/null http://arpnetworks.com/100mb.bin
# wget -O /dev/null http://lg.denver.fdcservers.net/10MBtest.zip
# wget -O /dev/null http://www.put.io/dl/speedtest.bin

[16:20:29] wget -O /dev/null http://speedtest.voxcdn.com/test_tenmb.data
–2009-01-06 16:20:34– http://speedtest.voxcdn.com/test_tenmb.data
Resolving speedtest.voxcdn.com… 208.122.31.15, 208.122.31.16, 208.122.31.17, …
Connecting to speedtest.voxcdn.com|208.122.31.15|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 10485760 (10M) [text/plain]
Saving to: `/dev/null’

100%[==>] 10,485,760 813K/s in 18s 2009-01-06 16:20:54 (560 KB/s) – `/dev/null’ saved [10485760/10485760]
100%[==>] 10,485,760 1.68M/s in 6.4s 2009-03-01 02:12:09 (1.55 MB/s) – `/dev/null’ saved [10485760/10485760]

[16:20:54] wget -O /dev/null http://cachefly.cachefly.net/10mb
–2009-01-06 16:20:56– http://cachefly.cachefly.net/10mb.test
Resolving cachefly.cachefly.net… 205.234.175.175
Connecting to cachefly.cachefly.net|205.234.175.175|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 10485760 (10M) [application/octet-stream]
Saving to: `/dev/null’

100%[==>] 10,485,760 610K/s in 19s 2009-01-06 16:21:15 (548 KB/s) – `/dev/null’ saved [10485760/10485760]

[16:21:6] wget -O /dev/null http://bitcast-a.bitgravity.com/bitgravity/10MB
–2009-01-06 16:21:16– http://bitcast-a.bitgravity.com/bitgravity/10MB
Resolving bitcast-a.bitgravity.com… 208.67.237.237
Connecting to bitcast-a.bitgravity.com|208.67.237.237|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 10240000 (9.8M) [application/octet-stream]
Saving to: `/dev/null’

100%[==>] 10,240,000 1.03M/s in 10s 2009-01-06 16:21:27 (1001 KB/s) – `/dev/null’ saved [10240000/10240000]
100%[==>] 10,240,000 1.18M/s in 11s 2009-03-01 02:21:27 (904 KB/s) – `/dev/null’ saved [10240000/10240000]

[16:21:36] wget -O /dev/null http://test.vo.llnwd.net/o1/sales/tenmegfile.wmv
–2009-01-06 16:21:36– http://test.vo.llnwd.net/o1/sales/tenmegfile.wmv
Resolving test.vo.llnwd.net… 87.248.218.23, 87.248.218.247
Connecting to test.vo.llnwd.net|87.248.218.23|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 11049222 (11M)
Saving to: `/dev/null’

100%[==>] 11,049,222 1008K/s in 12s 2009-01-06 16:21:49 (930 KB/s) – `/dev/null’ saved [11049222/11049222]
100%[==>] 11,049,222 2.14M/s in 5.1s 2009-03-01 02:26:33 (2.05 MB/s) – `/dev/null’ saved [11049222/11049222]
100%[==>] 11,049,222 2.89M/s in 4.1s 2010-01-24 03:58:14 (2.58 MB/s) – `/dev/null’ saved [11049222/11049222]

[00:42:00] wget -O /dev/null http://74.63.66.114/100MBtest.zip
–2009-04-14 00:42:03– http://74.63.66.114/100MBtest.zip
Connecting to 74.63.66.114:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 104857600 (100M) [application/zip]
Saving to: `/dev/null’

100%[==>] 104,857,600 763K/s in 3m 5s 2009-04-14 00:45:09 (552 KB/s) – `/dev/null’ saved [104857600/104857600]

[00:45:46] wget -O /dev/null http://www.tranxactglobal.com/speedtest/11mbtest
–2009-04-14 00:50:52– http://www.tranxactglobal.com/speedtest/11mbtest
Resolving www.tranxactglobal.com… 207.210.69.73
Connecting to www.tranxactglobal.com|207.210.69.73|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 11814847 (11M) [text/plain]
Saving to: `/dev/null’

100%[==>] 11,814,847 880K/s in 14s 2009-04-14 00:51:07 (804 KB/s) – `/dev/null’ saved [11814847/11814847]

[03:16:52] wget -O /dev/null http://arpnetworks.com/100mb.bin
–2010-01-24 03:21:33– http://arpnetworks.com/100mb.bin
Resolving arpnetworks.com… 208.79.89.243
Connecting to arpnetworks.com|208.79.89.243|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 104857600 (100M) [application/octet-stream]
Saving to: `/dev/null’

100%[==>] 104,857,600 1.14M/s in 92s 2010-01-24 03:23:05 (1.09 MB/s) – `/dev/null’ saved [104857600/104857600]

[03:30:19] wget -O /dev/null http://lg.denver.fdcservers.net/10MBtest.zip
–2010-01-24 03:30:34– http://lg.denver.fdcservers.net/10MBtest.zip
Resolving lg.denver.fdcservers.net… 76.73.0.4
Connecting to lg.denver.fdcservers.net|76.73.0.4|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 10485760 (10M) [application/zip]
Saving to: `/dev/null’

100%[==>] 10,485,760 68.7K/s in 2m 20s 2010-01-24 03:32:55 (73.1 KB/s) – `/dev/null’ saved [10485760/10485760]

[10:50:57] wget -O /dev/null http://www.put.io/dl/speedtest.bin
–2010-04-09 10:51:55– http://www.put.io/dl/speedtest.bin
Resolving www.put.io… 95.211.93.131
Connecting to www.put.io|95.211.93.131|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 104857600 (100M) [application/octet-stream]
Saving to: `/dev/null’

100%[==>] 104,857,600 2.43M/s in 66s 2010-04-09 10:53:01 (1.52 MB/s) – `/dev/null’ saved [104857600/104857600]

[10:50:57] wget -O /dev/null http://www.put.io/dl/speedtest.bin
–2010-04-09 10:53:30– http://www.put.io/dl/speedtest.bin
Resolving www.put.io… 95.211.93.131
Connecting to www.put.io|95.211.93.131|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 104857600 (100M) [application/octet-stream]
Saving to: `/dev/null’

100%[==>] 104,857,600 11.2M/s in 8.9s 2010-04-09 10:53:42 (11.2 MB/s) – `/dev/null’ saved [104857600/104857600]