Server Setup For MySQL + High Bandwidth

Jun 15, 2008

if I could get some input on this. Currently I'm running an Opteron 246, 2GB RAM with 2TB bandwidth/mo. I run a single site which is currently 99% HTML, along with an invision forum which is fairly popular. I get about 300-400k pageviews per day.

Right now the server is able to handle this stuff without much of a problem, and the average CPU load is between .5 and 3 (after a TON of tweaking!) - the only exception is when the forum db is being backed up/optimized, which isn't a huge problem since it happens during the off hours.

The problem is that I'm running out of bandwidth quickly, and need to come up with some kind of solution soon. My current provider offers bandwidth at $1/GB, which to me seems crazy compared to other providers, so that's not really an option.

I was thinking about switching to a more affordable provider and upgrading hardware, but I'm not sure what the best approach would be. I'm in the process of moving my HTML content over to a PHP-powered CMS, so I need to make sure whatever I do can handle that... What might be a decent setup for a site like mine which consumes a lot of bandwidth and will probably need more CPU power in the near future for PHP/MySQL stuff?

View 8 Replies


ADVERTISEMENT

Server High Load/high Mysql Usage

Jul 2, 2009

I have a site that is eating up my server resources and need to know what the best solution for this is. I'm thinking of getting another server just for mysql but do not know what specs the server should be to handle the current traffic/database load and have the site run smoothly without slowing down to a snail's pace.

An alternative is to get another server just for the videos being served and leave the database and html on the current server. This is where I'm stuck and don't know what route to take with this.

My current server stats:

Dual Xeon 5130
4GB RAM
250GB
50 Mbit/sec
CentOS 3.9

Website traffic stats:

15,000 visitors/day
150,000 pageviews/day
Serving videos

I've attached screenshots of top and bandwidth usage per day. Hopefully with this information you could tell me if I need another server or if there are any things I can do to the current server to help things move faster.

View 13 Replies View Related

Extremely High Bandwidth Server

May 1, 2008

today i got a message from a client asking about hosting his video himself, catch is, he has a shitload of viewers, im looking at servers in the range of quad core (maybe dual quad), 8gig, 4 hdd raid10, gige uplink, however the kicker, depending on how out of whack my estimates are, 100 to 400mbit SUSTAINED upstream (spiking all the way to max'n that 'little' gige pipe)

Has anyone got suggestions on who i should even consider for this? I'm a bit dumbfounded myself as i'v never even thought about a server on this much sustained bandwidth before today.

View 14 Replies View Related

How To Setup Cluster/High Available Server

Nov 7, 2009

i have ideas about clustering server with spread country/datacenter.

example: i have 5 Server spread around the world, server 1 in US, server 2 in German, and other country for next server.

server 1 will be main server, when server 1 down, it will goes to server 2, and continue to the next server.

all site/file and other stuff will be mirror on all server.

so it will be 100% Uptime!, and never LOSS anything!.

and my question is how to do that, maybe someone expert want to share with me.

View 11 Replies View Related

Server Sending High Outbound Bandwidth

Nov 6, 2008

My datacenter has told me about my server sending high amount of outbound bandwidth from my server:

During the attack time my email logs, I found several messages:
cpdavd failed @ Thu Nov 6 12:21:18 2008. A restart was attempted
automagically.

Question #1. How can I check which user is using cpdavd (connect from their PC to the home folder)

I suspect someone is connecting their PC to my server and uses very high bandwidth!

The datacenter says the attack is still going on when they plug in the server.

Question #2. How can I check what is sending outgoing traffic on the server right now?

View 2 Replies View Related

Is The Bandwidth The Reason Server Prices Are High Or

Sep 12, 2008

Like if you try to make your own server, it would cost a few thousand right? Or bought one from IBM or something. If you rent a server, it could cost you like double that I notice or even more in a period of a year.

I was looking at the prices of Xeon 5420 and they are like only 400 or something. Motherboard, ram, hdd's shouldn't amount to too much right?

And companies are charging like 50 bucks a month for a 2 gigs of ram.

Or am I actually looking at this wrong and actually am looking at desktop components? So is bandwidth the cost for these prices? In the long run aren't people being ripped off?

View 12 Replies View Related

Suspecting Server Is Causing High Bandwidth Usage

Jun 21, 2009

For the past few days, one of the server is causing a bandwidth utilization surge for the entire rack on almost daily basis. It happen for a few minutes and it went off then it will be the same thing again the next day. When the surge is happening, most of the servers on the same segment will be inaccessible for the few minutes.

The bandwidth utilization graph for my rack is recording an abnormal surge from (6mbps --> 90mbps) for the few minutes. My MRTG is showing 2 of the Plesk servers giving the problem but the NOC guys said it the Cpanel that causing the problem.

I tried logging in to both servers but could not find what's the cause for this.

View 2 Replies View Related

Recommend A Dedicated Server For Very High Bandwidth - Serverbeach

Jul 30, 2008

I have a site that uses extreme amounts of bandwidth, I checked some of the popular companies like serverbeach and softlayer. Right now I'm leaning more towards serverbeach because they are cheaper, Are they a good company to go with? Let me know if you have any other recommendations.

View 14 Replies View Related

MySQL Server Uage Very High

Jun 29, 2009

Whenever I run the "top" command, I see that some of the user "mysql" records always have very high CPU usage, anywhere from 20-80% on average (I've seen 100%). There are multiple records that show this, which means that the CPU is always above 100%. My cacti monitoring account also shows messed up CPU statistics.

I am not too knowledgeable with servers, but I believe that this is a problem. How much CPU usage is a mysqld command supposed to use on average? Here is a copy of the top part of a sample top command:

=========

top - 06:54:50 up 92 days, 5:32, 1 user, load average: 3.82, 3.89, 4.24
Tasks: 181 total, 4 running, 176 sleeping, 0 stopped, 1 zombie
Cpu(s): 0.2%us, 18.6%sy, 80.9%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.3%si, 0.0%st
Mem: 2075600k total, 1905400k used, 170200k free, 331912k buffers
Swap: 4096564k total, 104k used, 4096460k free, 1187304k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
21663 mysql 24 6 63032 30m 3004 R 66 1.5 38:24.06 mysqld
28483 mysql 24 6 63032 30m 3004 R 66 1.5 35:52.86 mysqld
20538 mysql 22 6 63032 30m 3004 S 15 1.5 40:29.74 mysqld
20837 mysql 24 6 63032 30m 3004 R 15 1.5 13:44.15 mysqld
1209 mysql 22 6 63032 30m 3004 S 11 1.5 32:46.26 mysqld
20591 mysql 22 6 63032 30m 3004 S 11 1.5 40:02.76 mysqld
20592 mysql 23 6 63032 30m 3004 S 6 1.5 40:48.29 mysqld
15301 apache 19 4 29928 15m 3608 S 3 0.8 0:00.60 httpd
15317 apache 19 4 28380 14m 3640 S 3 0.7 0:00.58 httpd
15249 apache 19 4 28612 14m 3732 S 1 0.7 0:01.49 httpd
15349 apache 19 4 28876 14m 3324 S 1 0.7 0:00.10 httpd
15319 apache 19 4 28368 14m 3528 S 1 0.7 0:00.34 httpd
15334 apache 19 4 28612 14m 3404 S 1 0.7 0:00.35 httpd
12343 root 15 0 2324 1088 804 R 1 0.1 0:03.31 top
15336 apache 19 4 28876 14m 3500 S 0 0.7 0:00.63 httpd
1 root 15 0 2064 588 508 S 0 0.0 1:01.28 init
2 root RT -5 0 0 0 S 0 0.0 0:09.39 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:01.25 ksoftirqd/0
4 root RT -5 0 0 0 S 0 0.0 0:00.00 watchdog/0
=================================

I told my system manager about the cpu problem, and he said that he installed the cpulimit function on my server. I'm not sure if this is a good solution.

View 2 Replies View Related

MySQL High Server Load

Dec 18, 2008

MySQL the last few days seems to be constantly the most demanding process in top, which it never was before. As far as I can tell, nothing has substantially changed with regards to traffic to MySQL driven sites on the server. Is there anything that might be wrong with the databases, etc., that might throw MySQL into a tizzy?

View 8 Replies View Related

High Server Load ... With Mysql Optimization

Apr 21, 2008

So the site got featured on [url]and now the server is drowning...

The Coppermine Gallery usually hovers around 30~50 users daily and now, 1800, and im at a lost as how I should configure mysql to take on such a load. right now it takes about 10 secs or more to load a page and sometimes it would time out. Because it si coppermine, all pages are dynamic and can't be cached -_-"

Here's the my.cnf right now after i played around with the numbers

server spec
Opteron 170 (2ghz)
2gb ram
250 7200rpm

[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
#skip-networking
back_log = 75
key_buffer = 256M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 7200
max_connections = 600
connect_timeout = 100
wait_timeout = 12000
tmp_table_size = 100M
max_heap_table_size = 64M
max_allowed_packet = 15M
max_connect_errors = 9999999
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 40M
query_cache_size = 150M
query_cache_type = 1
query_prealloc_size = 65536
tmp_table_size = 64M
query_alloc_block_size = 131072
default-storage-engine = MyISAM

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
nice = -5
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
httpd.conf

Timeout 20

#
# KeepAlive: Whether or not to allow persistent connections (more than
# one request per connection). Set to "Off" to deactivate.
#
KeepAlive Off

#
# MaxKeepAliveRequests: The maximum number of requests to allow
# during a persistent connection. Set to 0 to allow an unlimited amount.
# We recommend you leave this number high, for maximum performance.
#
MaxKeepAliveRequests 100

#
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout 15

##
## Server-Pool Size Regulation (MPM specific)
##

# prefork MPM
# StartServers: number of server processes to start
# MinSpareServers: minimum number of server processes which are kept spare
# MaxSpareServers: maximum number of server processes which are kept spare
# ServerLimit: maximum value for MaxClients for the lifetime of the server
# MaxClients: maximum number of server processes allowed to start
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule prefork.c>
StartServers 8
MinSpareServers 5
MaxSpareServers 20
ServerLimit 200
MaxClients 200
MaxRequestsPerChild 1500
</IfModule>

# worker MPM
# StartServers: initial number of server processes to start
# MaxClients: maximum number of simultaneous client connections
# MinSpareThreads: minimum number of worker threads which are kept spare
# MaxSpareThreads: maximum number of worker threads which are kept spare
# ThreadsPerChild: constant number of worker threads in each server process
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule worker.c>
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>

View 11 Replies View Related

Apache + MYSQL Optimization For High End Server

Jun 24, 2008

I have a fairly high end server in which I have installed SIM. SIM is restarting Apache up to 10 times a day, presumably due to high load causing un-availability.

On restart, Apache / MYSQL is stable until the load / mem usage begins to climb then it is restarted again. Here are my 'load' stats for today:

Load for today
High (2:18am): 4.63
Low (3:30am): 1.20
Mean: 1.84
Latest: 1.61

Mem usage for today
High (1:36am): 9,192.9 MB
Low (1:48am): 7,995.7 MB
Mean: 8,683.1 MB
Latest: 8,781.7 MB

I have seen it using 20GB RAM before.

I have tried to follow various optimisation guides but these seem tailored to less powerful servers.

The web application I run on this server is almost entirely MYSQL based, with thousands of DB calls a day. Across the entire system I probably get 200,000 bot hits per day or even more. At peak times search engine bots are literally hammering the server.

My server specs are:

# Processor: Quad-Core Xeon Processor * 8
# CPU Speed: 3Ghz
# RAM: 32 GB DDR2
# HDD: 36 GB 15k Raptor X2 + 1TB Sata
# OS: 32Bit CentOS

Changes / optimisation of the actual application is not possible.

My configuration files are:

My.cnf ....

View 11 Replies View Related

Automatically Restart Mysql After High Server Load

Jan 29, 2009

Anyone know a good script that I can run with cron or something? Mysql seems to be the #1 problem with a lot of my web sites, a restart usually fixes it right away for me, but I can't keep restarting my servers everyday manually.

View 1 Replies View Related

Mysql Server Hanging On A High Traffic Site

Feb 28, 2008

My video sharing site has high traffic, alexa rate:3,000

My site has 2 servers to split the load. 2 servers share a mysql server. Using rrdns to load the balance.

Server A running mysql 5.0,lighttpd
Server B running lighttpd.
Server B connect to A's mysql database.

During peak time. B can not connect to A's mysql server. It says server not responding. But A still running fine.
When I check mysql log file.
/usr/libexec/mysqld: Forcing close of thread .....

And when run top, the load average is 20.

The spec of Server A
Intel(R) Xeon(TM) CPU 3.06GHz dual core.
2G Ram.

Here is the my.cnf

Quote:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
max_connections = 1000
wait_timeout=60
connect_timeout=10
interactive_timeout=120
join_buffer_size=1M
query_cache_size=128M
query_cache_limit=2M
max_allowed_packet=16M
table_cache=1024
sort_buffer_size=2M
read_buffer_size=2M

My question, do I need another maching C to run lighttpd, and just keep mysql on A.
Or I can do some mysql optimization on A.

Also, if my site keeps going, can I have 1 mysql server and 5 http servers?

View 11 Replies View Related

Server Optimisation Request/mysql High Memory

Jul 2, 2007

cpu speed/type single or dual cpus): Intel Xeon 2x3.6
how much memory installed: 2048MB
hard drive type/configuration: 2x160GB SATA
linux distributor or windows version: CentOS 4.5 x86_64
apache/IIS version: apache 1.3.37
PHP version: php 4.4.7
MySQL version: 4.1.22-standard

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
19017 teknoloj 16 0 0 0 0 Z 27 0.0 0:00.93 php <defunct>
17751 mysql 15 0 241m 55m 3148 S 25 2.8 0:53.73 mysqld
19025 root 18 0 16204 6104 1392 D 6 0.3 0:00.17 cpcpan_check_in
18968 sohbetgo 16 0 44596 7540 3556 S 5 0.4 0:00.44 php
18552 nobody 15 0 32636 4208 1204 S 2 0.2 0:00.28 httpd
18808 resimsit 17 0 46944 9960 3616 R 1 0.5 0:00.23 php
18896 resimsit 16 0 46944 9984 3616 D 1 0.5 0:00.08 php
18921 resimsit 17 0 46404 9444 3572 R 1 0.5 0:00.09 php
18819 nobody 17 0 32644 4176 1192 S 1 0.2 0:00.06 httpd
18868 haylazt 16 0 0 0 0 Z 1 0.0 0:00.48 php <defunct>
18871 nobody 15 0 32504 4056 1148 S 1 0.2 0:00.06 httpd
18892 root 16 0 6416 1180 756 R 1 0.1 0:00.24 top
18978 nobody 16 0 32504 4028 1132 S 1 0.2 0:00.02 httpd
11 root 5 -10 0 0 0 S 0 0.0 0:24.56 events/1
2638 root 0 -20 0 0 0 S 0 0.0 0:16.96 loop0
2981 named 18 0 88016 2328 1152 S 0 0.1 8:44.12 named
3592 mailman 16 0 50316 2320 1828 S 0 0.1 0:00.78 python2.4

my.cnf

[mysqld]
safe-show-database
skip-innodb
max_connections = 500
key_buffer = 80M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 25
connect_timeout = 10
tmp_table_size = 128M
max_heap_table_size = 128M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_size = 96M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 32768
ft_min_word_len=3
ft_max_word_len=25

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
ft_min_word_len=3
ft_max_word_len=25

[mysqlhotcopy]
interactive-timeout

MySQL 4.1.22-standard uptime 0 0:39:9 Sat Jun 30 21:33:29 2007

__ Key __________________________________________________ _______________
Buffer used 19.34M of 80.00M %Used: 24.17
Current 33.70M %Usage: 42.12
Write hit 32.57%
Read hit 98.45%

__ Questions __________________________________________________ _________
Total 63.26k 26.9/s
Slow 2 0.0/s %Total: 0.00 %DMS: 0.01
DMS 32.14k 13.7/s 50.80

__ Table Locks __________________________________________________ _______
Waited 40 0.0/s %Total: 0.08
Immediate 50.58k 21.5/s

__ Tables __________________________________________________ ____________
Open 486 of 1800 %Cache: 27.00
Opened 702 0.3/s

__ Connections __________________________________________________ _______
Max used 12 of 500 %Max: 2.40
Total 4.33k 1.8/s

__ Created Temp __________________________________________________ ______
Disk table 26 0.0/s
Table 2.23k 1.0/s
File 428 0.2/s


6-7 vbulletin sites-vbseo and other scripts online avarage;
120 registered user ve 500+ unregistered user
cookie timeout : 7200
unique hit : 15000-20000

KeepAlive ON
MaxKeepAliveRequests 100
KeepAliveTimeout 2
MinSpareServers 10
MaxSpareServers 15
StartServers 10
MaxClients 180
Maxrequestsperchild value 1000

[root@server ~]# uname -a

Linux server.xxxxx 2.6.9-55.ELsmp #1 SMP Wed May 2 14:04:42 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux

[root@server ~]# ulimit -aH

core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 4096
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

[root@server ~]# cat /proc/cpuinfo

processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.60GHz
stepping : 10
cpu MHz : 3600.322
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7207.08
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.60GHz
stepping : 10
cpu MHz : 3600.322
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 3
cpu cores : 1
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7199.29
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.60GHz
stepping : 10
cpu MHz : 3600.322
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7509.03
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.60GHz
stepping : 10
cpu MHz : 3600.322
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 3
cpu cores : 1
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7199.26
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:

View 4 Replies View Related

Mysql Deleted Several Tables Under High Server Load

Apr 27, 2007

we have mysql 5 setup and this morning at around 10:07 tables started disappearing as they were being accessed by different clients.

Databases that had 40 tables now had 30, etc. Only the tables that were attempted to be accessed were gone. This is the first time something like this has happened.

The following output was given:

This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware.

We will try our best to scrape up some info that will hopefully help diagnose the
problem, but since we have already crashed, something is definitely wrong and this may fail.

key_buffer_size=8388600
read_buffer_size=131072
max_used_connections=208
max_connections=500
threads_connected=156
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1096188 K
bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

thd=0xaf82930
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...

Cannot determine thread, fp=0xb143932c, backtrace may not be correct.

Stack range sanity check OK, backtrace follows:
0x816b1a0
0xaf1898
0x20
0x81ac49d
0x8182914
0x8189010
0x8189df1
0x818a738
0x818ae5c
0xaeb371
0x9c4ffe
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read [url]and follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0xaf36620 = SELECT * FROM `sessions` WHERE `PHPSESSID` = '5e6775cd3c6f187d8c575127ba73be19'
thd->thread_id=113407
The manual page at [url]contains
information that should help you find out what is causing the crash.
mysqld: my_new.cc:51: int __cxa_pure_virtual(): Assertion `"Pure virtual method called." == "Aborted"' failed.

Number of processes running now: 0
070427 10:07:49 mysqld restarted
070427 10:07:50 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
070427 10:07:53 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 227822203.
InnoDB: Doing recovery: scanned up to log sequence number 0 227822203
070427 10:07:53 InnoDB: Started; log sequence number 0 227822203
070427 10:07:54 [Note] /usr/sbin/mysqld: ready for connections.

View 0 Replies View Related

Does Sql Uses High Bandwidth

Jun 16, 2009

I've a remote download site that uses tons of BW (about 900GB daily), and it uses sql connection quite alot - I've set it to max connection for my current server.

For now, I've the intention of separating main site with download server. where The main site will contains the sql DB. But my concern is, I want to buy a cheap VPS for the main site, but no idea if I need high BW and ram.

View 8 Replies View Related

High Bandwidth VPS

Jan 2, 2009

I host a podcast that's rapidly gaining popularity. At the moment, we push about 100gb/day of transfer for the episodes, but could easily double that in the next few months. I need a host that does at least 2tb a month with the ability to later upgrade to more. My operating budget is about 110$/month, but could go a little higher if needed.

Most of our activity is composed of sending files, so usage is pretty low. I'd probably only need a few gb to store the actual content (30mb mp3 files). It's also important that Adult material is allowed (the content of the audio podcast is explicit).

I'm aware of FDC and AT&T, but would like any other recommendations you guys could give.

View 14 Replies View Related

Best High Bandwidth Providers

Aug 3, 2008

I'm looking to get several dedicated servers, I don't require alot of processing speed or storage. And I'm not really picky about uptime, if the system is down for a few hours in a month its not a problem. What I need is alot of bandwidth. It needs to be quick and unlimited! What provider is going to give me the best deal?

View 14 Replies View Related

High Bandwidth = Unfunctional FTP

Apr 9, 2009

I have an unmetered server capped at 100Mbps.

The server is a media server, used to host heavy media files such as videos, flash and so forth. (there is no website on the server, just media files)

Everything works fine, all the media loads without a problem. Downloads are fast.

However, I have big trouble uploading stuffs. The FTP is either extremely slow or disconnects me.

I talked to my host, and they say the server is hitting 100Mbps bandwidth limit, and I should upgrade to 200Mbps. However, all my videos and media load fine, there are no problems except for the FTP.

Are there any solutions to this? I don't want to spend money on another 100Mbps just for FTP, especially when everything else is working without a glitch.

View 5 Replies View Related

High Bandwidth Log And Tools

Oct 25, 2008

Just an hour ago, my datacenter told me my server (cpanel + with CSF) is using up to 240mbps of inbound

View 3 Replies View Related

High Bandwidth Host

Aug 20, 2008

I have a client who has came to me for advice on his web site. I own a dedicated server and manage it using PLESK. I do pretty well managing it but I'm definitely not an expert on hosting by any means. So I need your help.

He is starting a new web site and he is going to do radio advertising on a lot of stations and expects to get a lot of hits. The web site seems to be pretty small with only a few pages of text and minimal pictures, so I don't think it will use that much just by the site being so small.

But anyway, I want him and me to feel comfortable that the site is not going to go down no matter how many hits he gets. How do I guesstimate this?

What are some good hosting companies that offer high bandwidth and protect you from overage charges -- or at least charge little for overages. I'm looking to spend less than $80/month. Also, do you have any idea: How many users will 10GB bandwidth cover if it's only a 5 page site with one picture on each page and 5 paragraphs of text just to get an idea.

View 9 Replies View Related

Firewall - High Bandwidth

Jan 27, 2007

I know someone is using the wget -r command on my server to recursively grab all files in a directory, I know their IP but I do not want to ban it completely, instead I was wondering is there a way to kill a connection if the bandwidth used by that connection gets too high?

I'm running CentOS 4

View 0 Replies View Related

Cheap High Bandwidth Self Managed

Apr 2, 2009

I'm at leaseweb atm - according to their graphs, I am doing around 17mbps 95th and paying $33/m USD for a C2D+1GB+160G HD. Overages are rather expensive though.

View 11 Replies View Related

I Want Dedicated Servers, High Bandwidth

Oct 23, 2008

I want new company for my servers

My servers for sharing files

So, I want high bandwidth

ex, 10.000GB BW per server out+in

$100-$200

View 14 Replies View Related

Web Hosting That Specializes In High Bandwidth

Sep 14, 2008

I have a dedicated server currently hosted over by Aplus.NET

I have a 3000 GB Monthly Transfer limit and we have been going over this limit for the past few months. This has resulted in a large sum of overage fees.

I am looking to go to another hosting company that is just as good as Aplus.NET, if not better... with a better traffic rate. A friend told me about Choopa.com and I wanted to know how good of a company they were. What are some other top reliable hosting companies with premium servers and that specialize in unmetered bandwidth?

View 20 Replies View Related

Find A High Bandwidth VPS Solution

Nov 28, 2007

I'm picking up a client who is a video production company and hosts a lot of their work for their clients on the web. They have two sites right now for two different branches of what they do, but they are beginning to scale up a bit and want to switch from a local ISP hosting package to something more commercial. I like the idea of a VPS, but their current budget is rather low. Because of that, I am a bit attracted to hosting packages from site5 and dreamhost (both of which I've heard good and bad things about).

Ideally, I would be looking for a VPS along the lines of:

50-75GB disk space
256-512MB RAM
750GB-1TB Bandwidth
Linux OS with Shell Access
cPanel or Plesk Control panel

It'd be nice to keep their budget around $50/mo, but I know that might be asking a lot. They have two websites currently for their production needs. What would be the advantages of a VPS over multiple hosting accounts at Site5 ($7.50/mo) or Dreamhost ($6/mo)?

View 1 Replies View Related

High Volume, Low(er) Cost Bandwidth In Panama

Jul 6, 2009

I'm looking at a project that would need to be located in Panama for server co-location.

It will be very bandwidth intensive, requiring 100 megabits to start and moving up from there. Going with a slightly more "value" oriented provider provided there's a backup (even lower bandwidth) available would be an option, as this application would tolerate limited periods of reduced bandwidth.

Can anybody point me in the direction of some data centers that might be worth looking at? Are there any bandwidth providers down there with a real value focus?

Right now, the best I've seen is $99/megabit from [url] I'm expecting bandwidth to cost more down in Panama, but I'd really like to push this number lower.

View 3 Replies View Related

Cheap High Transfer/bandwidth Hosting

May 22, 2008

I know you get what you pay for with hosting, but with the ridiculous overselling going on I am finding it hard to work out how much bandwidth I can genuinely expect to get with about 500MB space and 99%+ (preferably more like 99.5%) uptime for $5/month.

I will be using all this bandwidth for hosting legal mp3s (sanctioned for promotional use by labels and artists), and would prefer the host to be based in the US or UK.

View 6 Replies View Related

Setup A Bandwidth Cap/throttle

Dec 13, 2007

I'm new to linux and handling my dedicated server. I wanted to know how to setup a bandwidth cap/throttle for the users from my site. I wanted to limit the speeds to 300-400kb/s per user/IP. I've looked around but I haven't found anything really that solves my problem just scripts that protect CPU.

View 3 Replies View Related

Creating A High Traffic Hosting Setup

Oct 3, 2008

creating a setup that will host a site which is expected to receive 50-60K visitors in the first few hours after its launch. The site is membership based and the backend (member system) runs on PHP5-MySQL5.

Here is what I have thought of until now.

Site's sales page (which also happens to be the first page that visitors hit) hosted with Amazon S3 service. All public media files are off loaded to amazon S3 service to keep the number of requests on the hosted setup to minimum.

At the front we can have a high performance firewall like Cisco ASA 5520 followed by two dedicated load balancers in Active/Active state.

Behind the load balancers we have 3 front end servers acting as web-servers. These have SAS disks, 4GB RAM, RAID 1 setup, Dual Xeon Quad core processors each.

Behind the front end servers - we have a dedicated load balancer for the database cluster.

The database cluster consists of 3 Storage/API nodes and one of the front end servers acts as the management node. Each storage node has 8GB RAM, Dual Xeon Quad core processors, 4x RAID 10, SAS setup.

The private network is on a GigaLan.

Do you see any possible/obvious flaw in this design or anything that should be added/subtracted from the setup?

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved