Server issue needs to be fixed.

[freecartoonporn]

This is an automated message notifying you that the 5 minute load average on your system is 10.68.
This has exceeded the 10 threshold.

One Minute - 23.73
Five Minutes - 10.68
Fifteen Minutes - 6.12

top - 22:46:38 up 10 days, 10:53, 0 users, load average: 23.73, 10.68, 6.12
Tasks: 418 total, 1 running, 417 sleeping, 0 stopped, 0 zombie
Cpu(s): 13.8%us, 1.6%sy, 0.1%ni, 63.3%id, 21.2%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 8052740k total, 7995348k used, 57392k free, 12716k buffers
Swap: 4192956k total, 4192472k used, 484k free, 606852k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
8013 mysql 15 0 1601m 1.1g 3996 S 122.2 14.8 1093:42 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/www.websitevaluecalculator.net.err --pid-file=/var/lib/mysql/www.websitevaluecalculator.net.pid --socket=/var/lib/mysql/mysql.sock

mysql is eating up resources.

[root@www public_html]# uptime
13:46:47 up 11 days, 1:53, 1 user, load average: 3.61, 4.31, 4.81

--------------------------------------------------------------------
contact me with quote only if you can fix it.
one time job.
Server is unmanaged.

thanks for your time.

[London Banker]

Server is unmanaged.

[xXXtesy10]

What a fucking cheap bastard.

[freecartoonporn]

What a fucking cheap bastard.

there are companies out there, which dont provide "managed services" at any cost.
thanks

[StariaDaniel]

Well, in most cases like this it's not a real "server issue", but either mysql isn't configured to use the server's ressources correctly or mysql statements are not optimized.

Due to the unclear amount of work (depends a lot on the scripts used, if slow query logs are already in place, etc.) you won't get a "fixed price quote" from anyone with experience in this field. It would be possible to split the quote into 2 "jobs" - for once analyzing the server config / scripts - and after that one could estimate the hours to fix the issues.

If you want someone to look into it and aren't afraid of prices above indian level feel free to hit me up [email protected] - I've optimized a lot of large DBs in the past and I've also experience with various script languages accessing MySQL (which usually can be optimized as well)

[freecartoonporn]

Well, in most cases like this it's not a real "server issue", but either mysql isn't configured to use the server's ressources correctly or mysql statements are not optimized.

Due to the unclear amount of work (depends a lot on the scripts used, if slow query logs are already in place, etc.) you won't get a "fixed price quote" from anyone with experience in this field. It would be possible to split the quote into 2 "jobs" - for once analyzing the server config / scripts - and after that one could estimate the hours to fix the issues.

If you want someone to look into it and aren't afraid of prices above indian level feel free to hit me up [email protected] - I've optimized a lot of large DBs in the past and I've also experience with various script languages accessing MySQL (which usually can be optimized as well)

contacting you now.

[critical]

How about move your server over to us and I'll fix it for you. :-)

Skype: critical.net
AIM: NJesterIII

[Net Money]

there are companies out there, which dont provide "managed services" at any cost.
thanks

You're right, and people that cannot manage their own server are stupid if they haost there. Oh Hows your server going?? hahahaha

[RyuLion]

[StariaDaniel]

contacting you now.

Didn't get an email from you? Let me know if there was a problem contacting me.

[HostedinVegas]

What does your my.cnf look like? Please post it.

[freecartoonporn]

What does your my.cnf look like? Please post it.

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
innodb_flush_log_at_trx_commit=2
innodb_buffer_pool_size=1024M
innodb_log_file_size=64M
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

here it is.

[freecartoonporn]

Didn't get an email from you? Let me know if there was a problem contacting me.

on icq..

[HostedinVegas]

Try this:

[mysqld]
skip-locking
query_cache_limit=1M
query_cache_size=16M
query_cache_type=1
max_user_connections=100
max_connections=120
interactive_timeout=100
wait_timeout=10
connect_timeout=10
thread_cache_size=96
key_buffer=8M
join_buffer=1M
max_allowed_packet=8M
table_cache=1024
record_buffer=1M
sort_buffer_size=1024K
read_buffer_size=1024K
max_connect_errors=60
read_rnd_buffer_size=1024K
myisam_sort_buffer_size=16M
max_heap_table_size=256M
tmp_table_size=256M
old_passwords=1
local-infile=0
skip-innodb

[mysql.server]
user=mysql

[safe_mysqld]
open_files_limit=15000

[mysqldump]
quick
max_allowed_packet=8M
max_allowed_packet=8M

[mysql]
no-auto-rehash

[isamchk]
key_buffer=16M
sort_buffer=16M
read_buffer=8
write_buffer=8M

[myisamchk]
key_buffer=16M
sort_buffer=16M
read_buffer=8M
write_buffer=8M

[mysqlhotcopy]
interactive-timeout



Don't forget to restart mysql after saving the changes.


Anthony

[Nookster]

Definitely looks like a script issue, since a properly written script should DEFINITELY not eat that many resources so quickly. I wouldn't be looking for a DBA, I'd look for a programmer to re-write your scripts.

[BIGTYMER]

[freecartoonporn]

Try this:

[mysqld]
skip-locking
query_cache_limit=1M
query_cache_size=16M
query_cache_type=1
max_user_connections=100
max_connections=120
interactive_timeout=100
wait_timeout=10
connect_timeout=10
thread_cache_size=96
key_buffer=8M
join_buffer=1M
max_allowed_packet=8M
table_cache=1024
record_buffer=1M
sort_buffer_size=1024K
read_buffer_size=1024K
max_connect_errors=60
read_rnd_buffer_size=1024K
myisam_sort_buffer_size=16M
max_heap_table_size=256M
tmp_table_size=256M
old_passwords=1
local-infile=0
skip-innodb

[mysql.server]
user=mysql

[safe_mysqld]
open_files_limit=15000

[mysqldump]
quick
max_allowed_packet=8M
max_allowed_packet=8M

[mysql]
no-auto-rehash

[isamchk]
key_buffer=16M
sort_buffer=16M
read_buffer=8
write_buffer=8M

[myisamchk]
key_buffer=16M
sort_buffer=16M
read_buffer=8M
write_buffer=8M

[mysqlhotcopy]
interactive-timeout



Don't forget to restart mysql after saving the changes.


Anthony

thanks for reply.

innodb is a must as the script on server uses innodb dbs.

[freecartoonporn]

Definitely looks like a script issue, since a properly written script should DEFINITELY not eat that many resources so quickly. I wouldn't be looking for a DBA, I'd look for a programmer to re-write your scripts.

i have already contacted the coder and he says , its not the script issue.

thanks

[woj]

what scripts do you run on the server? any of them get decent traffic? which script do you suspect is the problem?

[Nookster]

i have already contacted the coder and he says , its not the script issue.

thanks

Of course he says that. He made it. You should get another opinion from a more reputable coder. The stats from the errors prove a script issue...not a db issue.

[Nookster]

I'm just trying to help. I'm not going to sit and argue about script versus db. I'll leave it at this. A script throttles the db, not the other way around. It's a script issue, period.

[freecartoonporn]

what scripts do you run on the server? any of them get decent traffic? which script do you suspect is the problem?

the server has mechbunny and inxy script, none of them get decent traffic.
but the inxy script uses innodb and has db of size 7 gbs. also few other db are 5-6 gbs. i guess thats the issue

Of course he says that. He made it. You should get another opinion from a more reputable coder. The stats from the errors prove a script issue...not a db issue.

sure thing i would do that.

I'm just trying to help. I'm not going to sit and argue about script versus db. I'll leave it at this. A script throttles the db, not the other way around. It's a script issue, period.

thanks for your opinion, and no i am not arguing, i really appreciate your input.
ill again talk with coder and have him look at server.

thanks

[SpotOnTechSupport]

Could be someone attempting a SQL injection, too.

Declare @q Varchar(8000) Select @q = 0x57414954464F522044454C4159202730303A30303A313527 Exec(@q) --

Will make the MySQL server sleep for 15 seconds. Check your logs for something like that.

[StariaDaniel]

on icq..

Oh ok, I'm not using ICQ regularly, but I'm online now and replied to your message.

Definitely looks like a script issue, since a properly written script should DEFINITELY not eat that many resources so quickly. I wouldn't be looking for a DBA, I'd look for a programmer to re-write your scripts.

i have already contacted the coder and he says , its not the script issue.

Most likely not the script itself, but queries it's launching. Mechbunny is used by a lot of bigger sites and konrad seems to be one of the good programmers - so I'd assume that's properly optimized. Can't speak for the other one as I've never heard of it before.

Anyway, the my.cnf needs to be properly configured too, but i find it kind of risky to make a suggestion for it without knowing details about the database(s) and server hardware. There's definitely no solution that fits every problem ...

[k0nr4d]

If our script is on there, make sure you don't have the caching time in config.php set to some absurdly low level like 5 or 10 seconds.

[freecartoonporn]

If our script is on there, make sure you don't have the caching time in config.php set to some absurdly low level like 5 or 10 seconds.

it says ....

$cache_path = $basepath.'/cache'; //directory for cached files
$video_cache_time = 300; //video page cache time
$overall_cache_time = 3; //cache time for all other pages
$cacheType = 'filesystem'; //can be memcached or filesystem
$memcachedServer = 'localhost'; //server ip for memcached
$memcachedPort = '11211'; //port for memcached

[k0nr4d]

it says ....

$video_cache_time = 3600; //video page cache time
$overall_cache_time = 1800; //cache time for all other pages

[freecartoonporn]

$video_cache_time = 3600; //video page cache time
$overall_cache_time = 1800; //cache time for all other pages

thanks, i guess those all were default values.