Any tech guy who can finetune a sql server for me? - GoFuckYourself.com

mrthumbs · 03-16-2006, 04:25 AM

This thing keeps giving me issues.. im about to shoot myself.

Freebsd.. sql5.. paypal payments!

icq 160272407 or [email protected]

FuqALot · 03-16-2006, 04:29 AM

Needed this done the other day, I hit up the hosting guy (webair) and they optimized it for me. It is only one file (my.cnf), I believe, that needs to be edited.

PussyTeenies · 03-16-2006, 04:53 AM

hit up that dutch guy!

mrthumbs · 03-16-2006, 05:12 AM

Quote:

Originally Posted by PussyTeenies

hit up that dutch guy!

I did.. and we had an appointment he would fix shit yesterday 14:00.......

Mike Seth · 03-16-2006, 05:42 AM

WTF is SQL5? MySQL5?

Dirty F · 03-16-2006, 05:53 AM

Darksoul does good work.

mrthumbs · 03-16-2006, 06:35 AM

Quote:

Originally Posted by Mike Seth

WTF is SQL5? MySQL5?

Yes!!!!!!!!!

Mike Seth · 03-17-2006, 02:56 PM

Quote:

Originally Posted by Franck

Darksoul does good work.

Darksoul from emuadmin.com? That is true, and I can attest to that. The setup that I've seen is very tight.

Mike Seth · 03-17-2006, 02:57 PM

Quote:

Originally Posted by mrthumbs

Yes!!!!!!!!!

If you could possibly more specific about what is the trouble you're having then someone would've been able to help you.

fris · 03-17-2006, 02:57 PM

just increase max connections allowed, and the default is 8M memory size. should be at least 64m

mrkris · 03-17-2006, 03:55 PM

hit me up on icq - 342500546

PR_EZEKIEL · 03-17-2006, 04:04 PM

Quote:

Originally Posted by Mike Seth

If you could possibly more specific about what is the trouble you're having then someone would've been able to help you.

It sounds like he needs someone to help him with it...i'm sure if he knew more specifically what the problem was then he'd have said so.

Mike Seth · 03-17-2006, 05:51 PM

Quote:

Originally Posted by PR_EZEKIEL

It sounds like he needs someone to help him with it...i'm sure if he knew more specifically what the problem was then he'd have said so.

With MySQL, you do not normally touch the server settings unless you know precisely what is it that you're trying to achieve. "Finetuning" a server is a very uncommon operation. If there is a performance problem chances are it has something to do with the database structure and the way the client application makes queries and as such, thus the first thing to be done is consulting with a competent developer, not a system administrator.

He said "issues". What kind of issues?

mrthumbs · 03-17-2006, 06:12 PM

Quote:

Originally Posted by Mike Seth

With MySQL, you do not normally touch the server settings unless you know precisely what is it that you're trying to achieve. "Finetuning" a server is a very uncommon operation. If there is a performance problem chances are it has something to do with the database structure and the way the client application makes queries and as such, thus the first thing to be done is consulting with a competent developer, not a system administrator.

He said "issues". What kind of issues?

The fact you refused to interpret my "sql5" as "mysql5" displays you are not constructive towards my 'issue'. Actually you're quite annoying although i appreciate your attempts for clarification.

Any my 'issue'? Penis size problems.. as usual :-(

MrKris: hitting you up.

Linguist · 03-17-2006, 06:19 PM

Quote:

Originally Posted by mrthumbs

The fact you refused to interpret my "sql5" as "mysql5" displays you are not constructive towards my 'issue'. Actually you're quite annoying although i appreciate your attempts for clarification.

Any my 'issue'? Penis size problems.. as usual :-(

MrKris: hitting you up.

Saying sql5 shows your ignorance rather than his. There is no such thing as sql5. SQL is a general language, MySQL is a specific implementation of it.
Why would he readily interpret it as MySQL? There's a crapload of DB servers for freebsd.

mrthumbs · 03-17-2006, 06:30 PM

Quote:

Originally Posted by Linguist

Saying sql5 shows your ignorance rather than his. There is no such thing as sql5. SQL is a general language, MySQL is a specific implementation of it.
Why would he readily interpret it as MySQL? There's a crapload of DB servers for freebsd.

Well let me say this: if i knew all that and was as tech-literate as you i wouldnt be asking stupid questions on this forum!!

Linguist · 03-17-2006, 06:42 PM

Quote:

Originally Posted by mrthumbs

Well let me say this: if i knew all that and was as tech-literate as you i wouldnt be asking stupid questions on this forum!!

nah, i'm just saying that you shouldn't slam him for interpreting it incorrectly. He had a good guess that it was mysql5 but you went out all hostile on him AFTER he gave you quite a sound advice. I'd actually consider his advice before/after tuning your server.. it may be an application issue

mrthumbs · 03-17-2006, 06:47 PM

Quote:

Originally Posted by Linguist

nah, i'm just saying that you shouldn't slam him for interpreting it incorrectly. He had a good guess that it was mysql5 but you went out all hostile on him AFTER he gave you quite a sound advice. I'd actually consider his advice before/after tuning your server.. it may be an application issue

You people take me way too serious haha.

But you're right.. i could have been an application issue.. it could have been a hardware issue.. but from my first post it should have been quite obvious im a clueless moron and i need someone to check THAT out..

woj · 03-17-2006, 06:55 PM

Quote:

Originally Posted by mrthumbs

The fact you refused to interpret my "sql5" as "mysql5" displays you are not constructive towards my 'issue'. Actually you're quite annoying although i appreciate your attempts for clarification.

Any my 'issue'? Penis size problems.. as usual :-(

MrKris: hitting you up.

He is actually right, most of the time problems are due to poorly designed db tables or inefficient coding.

woj · 03-17-2006, 06:59 PM

This is kinda like looking into the engine or transmission because the car is "slow " when really the problem is the driver. If you put an old lady in a race car, it won't go very fast no matter how much you tune the car.

Mike Seth · 03-18-2006, 03:26 AM

I don't mean to offend anyone, but "issues" is simply not a valid description of a problem. It is an equivalent of "my website doesnt work". How do you know you have a problem? How does it express itself? What did you change prior when the problem appeared? I can't help you unless you give me something to work with. Seriously, you can't just expect to post about "issues" and have a flock of mind-readers fix your DB problems with the power of a thought.

prime · 03-18-2006, 08:02 AM

this one is goood!
i want some more drama...

Mike Seth · 03-18-2006, 03:39 PM

Quote:

Originally Posted by prime

this one is goood!
i want some more drama...

http://www.ljdrama.org

03-16-2006, 04:25 AM	#1
mrthumbs salad tossing sig guy Join Date: Apr 2002 Location: mrthumbs*gmail.com Posts: 11,702	Any tech guy who can finetune a sql server for me? This thing keeps giving me issues.. im about to shoot myself. Freebsd.. sql5.. paypal payments! icq 160272407 or [email protected]

03-16-2006, 04:53 AM	#3
PussyTeenies Confirmed User Join Date: Feb 2005 Location: Haarlem and Amsterdam, capital of the porn world ;-) Posts: 6,496	hit up that dutch guy! __________________ Need adult hosting? Contact us! WARM Hosting Need an IT solution? or someone to check your site and security? Nossie - IT Professional

03-16-2006, 05:42 AM	#5
Mike Seth Registered User Join Date: Feb 2006 Location: TEH PIT Posts: 88	WTF is SQL5? MySQL5? __________________ Mike Seth - 274-570-412 <mikeseth at gmail.com>

03-17-2006, 02:57 PM	#10
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,372	just increase max connections allowed, and the default is 8M memory size. should be at least 64m __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

03-17-2006, 03:55 PM	#11
mrkris Confirmed User Join Date: May 2005 Posts: 2,737	hit me up on icq - 342500546 __________________ PHP-MySQL-Rails \| ICQ: 342500546

03-16-2006, 04:29 AM	#2
FuqALot Confirmed User Join Date: Dec 2001 Location: Malibu Posts: 3,817	Needed this done the other day, I hit up the hosting guy (webair) and they optimized it for me. It is only one file (my.cnf), I believe, that needs to be edited.

03-16-2006, 05:53 AM	#6
Dirty F Too lazy to set a custom title Industry Role: Join Date: Jul 2001 Posts: 59,204	Darksoul does good work.

03-17-2006, 06:59 PM	#20
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	This is kinda like looking into the engine or transmission because the car is "slow " when really the problem is the driver. If you put an old lady in a race car, it won't go very fast no matter how much you tune the car. __________________ 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

03-18-2006, 03:26 AM	#21
Mike Seth Registered User Join Date: Feb 2006 Location: TEH PIT Posts: 88	I don't mean to offend anyone, but "issues" is simply not a valid description of a problem. It is an equivalent of "my website doesnt work". How do you know you have a problem? How does it express itself? What did you change prior when the problem appeared? I can't help you unless you give me something to work with. Seriously, you can't just expect to post about "issues" and have a flock of mind-readers fix your DB problems with the power of a thought. __________________ Mike Seth - 274-570-412 <mikeseth at gmail.com>

03-18-2006, 08:02 AM	#22
prime Confirmed User Join Date: Feb 2005 Location: Manila Posts: 400	this one is goood! i want some more drama... __________________ \| offshore solutions \| manual labor \| staff leasing \| and more! Dedicated -Motivated-Managed Employees icq.: 309570461 live chat