General Chat Topic

[Cam]

Yeah, I sure am. I did a little bit of secret Christmas shopping for my wife today and she did the same for me too. After that we went out on a date. I knew you would do good on your final exam and I know you'll do well on your other final exam on Thursday too. :wink:

Sounds like fun. What did you get her?

 

[Cryckit]

Sounds like fun. What did you get her? :wink:

Just some small gifts and a few stocking stuffers to start off with. Some new dish towels and dish rags, crossword puzzle books, a cross stature, etc.

 

[Cam]

Just some small gifts and a few stocking stuffers to start off with. Some new dish towels and dish rags, crossword puzzle books, a cross stature, etc.

Sounds sweet. I'm sure she'll love that stuff.

 

[s3_gunzel]

So I just did 150,000 odd queries on an SQL server at once without meaning to.

Well, I did. It came out as 110k lines of array which I now have to write two update queries for.

 

[Cryckit]

Sounds sweet. I'm sure she'll love that stuff.

Oh yeah, my wife will most definitely will love love all that stuff. Are you getting your new girlfriend anything for Christmas this year?

 

[Cam]

Oh yeah, my wife will most definitely will love love all that stuff. Are you getting your new girlfriend anything for Christmas this year?

I still haven't gotten her anything, but I'll definitely be getting a few things over the next week or so.

 

[Cryckit]

I still haven't gotten her anything, but I'll definitely be getting a few things over the next week or so. :yum:

That works buddy. I'm sure she'll like whatever you get her. How was you your day by the way? :smiley:

 

[Cam]

I hope everyone is having an awesome weekend. Christmas Eve is literally one week away now.

 

[s3_gunzel]

So I just did 150,000 odd queries on an SQL server at once without meaning to.

Well, I did. It came out as 110k lines of array which I now have to write two update queries for.

Update queries now done. Running at home while I’m out. Was at 100% CPU on the MySQL server for a bit there at 70 SELECTs a second

 

[Friendly Survival]

Update queries now done. Running at home while I’m out. Was at 100% CPU on the MySQL server for a bit there at 70 SELECTs a second

You may wish to be careful to be sure that your loads aren't in the "danger zone" for long. Or else your server may eventually not work (generally logically speaking however it can indeed result the server to "bricking" altogether if it get to such dangerous loads).

 

[s3_gunzel]

You may wish to be careful to be sure that your loads aren't in the "danger zone" for long. Or else your server may eventually not work (generally logically speaking however it can indeed result the server to "bricking" altogether if it get to such dangerous loads).

Seriously? Try again without the “I know better than you”.

 

[Friendly Survival]

Seriously? Try again without the “I know better than you”.

Please be informed that I did not meant it like that. I were just saying that you may experience such problems and why.

 

[s3_gunzel]

Please be informed that I did not meant it like that. I were just saying that you may experience such problems and why.

That is not how it works. You’ll experience no issues unless you’re hammering it 24/7 for months at a time. 15 minutes worth of database querying isn’t going to cause a problem.

 

[Friendly Survival]

That is not how it works. You’ll experience no issues unless you’re hammering it 24/7 for months at a time. 15 minutes worth of database querying isn’t going to cause a problem.

What about concerning the OS and anything else need CPU as well? I could get a burst since I am fairly certain that the CPU does boast a tiny "buffer" but could it really "buffer" these other processes for a whole 15 minutes without slowness?

 

[s3_gunzel]

What about concerning the OS and anything else need CPU as well?

CPU load includes the OS by default. It's not just the MySQL "job".

I could get a burst since I am fairly certain that the CPU does boast a tiny "buffer" but could it really "buffer" these other processes for a whole 15 minutes without slowness?

I'm not on a CPanel server; I own the hardware, ergo, burst isn't really relevant here. Legitimately surprised you didn't work that one out.

 

[Friendly Survival]

CPU load includes the OS by default. It's not just the MySQL "job".



I'm not on a CPanel server; I own the hardware, ergo, burst isn't really relevant here. Legitimately surprised you didn't work that one out.

Okay now I fully realized what happened here. I must've had a "brain fart" as they says.

 

[Cryckit]

Hey guys. How has your weekend been? :smiley:

 

[ChrisG2010]

Hey guys. How has your weekend been? :smiley:

I've worked all weekend, so the normal. xD

 

[Friendly Survival]

I've worked all weekend, so the normal. xD

Also known as "we all know and love" of owning your own business right?

 

[ChrisG2010]

Also known as "we all know and love" of owning your own business right? :smiley:

I also have a full time job in Law Enforcement - Security Division which requires 12 hour shifts, every other weekend off.