Server issue needs to be fixed. - GoFuckYourself.com

freecartoonporn · 08-29-2012, 11:45 AM

Quote:

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 · 08-29-2012, 11:49 AM

Quote:

Originally Posted by freecartoonporn

Server is unmanaged.

xXXtesy10 · 08-29-2012, 11:53 AM

What a fucking cheap bastard.

freecartoonporn · 08-29-2012, 12:00 PM

Quote:

Originally Posted by xXXtesy10

What a fucking cheap bastard.

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

StariaDaniel · 08-29-2012, 12:02 PM

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 · 08-29-2012, 12:10 PM

Quote:

Originally Posted by 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)

contacting you now.

critical · 08-29-2012, 12:12 PM

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

Skype: critical.net
AIM: NJesterIII

Net Money · 08-29-2012, 02:41 PM

Quote:

Originally Posted by freecartoonporn

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 · 08-29-2012, 02:45 PM

Quote:

Originally Posted by London Banker

StariaDaniel · 08-29-2012, 04:02 PM

Quote:

Originally Posted by freecartoonporn

contacting you now.

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

HostedinVegas · 08-29-2012, 08:01 PM

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

freecartoonporn · 08-29-2012, 08:25 PM

Quote:

Originally Posted by HostedinVegas

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

Quote:

[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 · 08-29-2012, 08:27 PM

Quote:

Originally Posted by StariaDaniel

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

on icq..

HostedinVegas · 08-29-2012, 08:27 PM

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 · 08-29-2012, 08:49 PM

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 · 08-29-2012, 08:52 PM

Quote:

Originally Posted by London Banker

freecartoonporn · 08-29-2012, 08:53 PM

Quote:

Originally Posted by 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

thanks for reply.

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

freecartoonporn · 08-29-2012, 08:56 PM

Quote:

Originally Posted by 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.

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

thanks

woj · 08-29-2012, 08:59 PM

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

Nookster · 08-29-2012, 09:04 PM

Quote:

Originally Posted by freecartoonporn

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 · 08-29-2012, 09:10 PM

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 · 08-29-2012, 09:21 PM

Quote:

Originally Posted by woj

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

Quote:

Originally Posted by Nookster

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.

Quote:

Originally Posted by 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.

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 · 08-29-2012, 09:26 PM

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 · 08-30-2012, 02:34 AM

Quote:

Originally Posted by freecartoonporn

on icq..

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

Quote:

Originally Posted by 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.

Quote:

Originally Posted by freecartoonporn

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 · 08-30-2012, 02:59 AM

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 · 08-30-2012, 03:35 AM

Quote:

Originally Posted by 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.

it says ....

Quote:

$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 · 08-30-2012, 03:39 AM

Quote:

Originally Posted by freecartoonporn

it says ....

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

freecartoonporn · 08-30-2012, 05:54 AM

Quote:

Originally Posted by k0nr4d

$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.

08-29-2012, 11:53 AM	#3
xXXtesy10 Fakecoin Investor Industry Role: Join Date: Jul 2012 Location: New Delhi, IN Posts: 7,127	What a fucking cheap bastard. __________________ WARNING: Stay Away From Marlboroack aka aka Brandon Ackerman https://gfy.com/21169705-post8.html Donny Long is Felon, Stalker, Scammer & Coward http://www.ripoffreport.com/reports/...lon-int-761244

08-29-2012, 12:02 PM	#5
StariaDaniel Confirmed User Join Date: Oct 2007 Location: Netherlands Posts: 415	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) __________________ YezzClips.com - Sell your clips and photosets - Promote YezzClips Clipstores and get 20% revshare for life YooGirls.com - Sell your non-nude content - Promote Yoogirls Clipstores and get 20% revshare for life [email protected] • ICQ #464114379

08-29-2012, 08:01 PM	#11
HostedinVegas Confirmed User Industry Role: Join Date: Feb 2011 Posts: 110	What does your my.cnf look like? Please post it. __________________ Now Part of the Your Hosting Solutions / Hosting for a Dollar Network.Affordable Hosting Solutions Shared Hosting, VPS, Dedicated Servers, and More !!

08-29-2012, 08:27 PM	#14
HostedinVegas Confirmed User Industry Role: Join Date: Feb 2011 Posts: 110	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 __________________ Now Part of the Your Hosting Solutions / Hosting for a Dollar Network.Affordable Hosting Solutions Shared Hosting, VPS, Dedicated Servers, and More !!

08-29-2012, 08:49 PM	#15
Nookster Confirmed IT Professional Industry Role: Join Date: Nov 2005 Location: Hollywood, CA Posts: 3,744	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. __________________ The Best Affiliate Software, Ever.

08-29-2012, 12:12 PM	#7
critical Confirmed User Join Date: Aug 2009 Posts: 478	How about move your server over to us and I'll fix it for you. :-) Skype: critical.net AIM: NJesterIII

08-29-2012, 08:59 PM	#19
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	what scripts do you run on the server? any of them get decent traffic? which script do you suspect is the problem? __________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

08-29-2012, 09:10 PM	#21
Nookster Confirmed IT Professional Industry Role: Join Date: Nov 2005 Location: Hollywood, CA Posts: 3,744	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. __________________ The Best Affiliate Software, Ever.

08-29-2012, 09:26 PM	#23
SpotOnTechSupport Confirmed User Industry Role: Join Date: Mar 2011 Location: Mansfield, Ohio Posts: 119	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. __________________ 'cuz you're too busy dealing with other stuff to mess around with bad hosting! Prices start at $2.99 for shared hosting, $80 for managed dedicated!

08-30-2012, 02:59 AM	#25
k0nr4d Confirmed User Industry Role: Join Date: Aug 2006 Location: Poland Posts: 9,228	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. __________________ Mechanical Bunny Media Mechbunny Tube Script \| Mechbunny Webcam Aggregator Script \| Custom Web Development