|
What do you find is the optimal setting for mysql slow query log parameter, and why?
Started by Subimage on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Most heavily used production servers execute far too many queries to log them... .
It depends on the kind in increments of 1 second, which is too slow for some people.
Whatever time /you/ feel is unacceptably slow for a query on your systems.
|
|
On my Macbook, Firefox is slow. Really slow. It takes about 30 minutes to start up - when I wake up, I start it, and once I am done breakfast, it's usually done. And, it takes a super-duper long time to shut down - I haven't shut it down one, I just force...
Started by Isaac Waller on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at superuser):
The easiest way.
I would try to disable all extensions and see if it is still slow.
That does not behave.
|
|
Dear god, I've made the biggest mistake of my life moving broadband provider to Plusnet from Virgin Media. If I'd realised it was BT before I'd signed up, I would never have done it.
Since signing up in August my broadband speed has halved... I'm lucky...
Started by granthampie on
, 5 posts
by 3 people.
Answer Snippets (Read the full thread at plus):
Options now are:
1) go out and buy another router @ £100? and if the broadband speed is still slow.
|
Ask your Facebook Friends
|
Do you have any formal or informal standards for reasonably achievable SQL query speed? How do you enforce them? Assume a production OLTP database under full realistic production load of a couple dozen queries per second, properly equipped and configured...
Started by le dorfier on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
And anything worse like N^2 will eventually be too slow..
|
|
This is a question about tradeoffs.
Imagine a social network. Each user has a status message, that he can change anytime. Whenever he does change it, all his friends are notified through a wall (like in Facebook).
To make this work. We have 3 tables Users...
Started by niaher on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Regarding slow updates, status updates on social networking sites.
Plus, as your site scales efficiently query for recent data .
A few orders of magnitude.
Updates are very slow compared to SELECTs ...
|
|
I have a 2 gb mysql table with 500k rows and I run the following query on a system with no load.
select * from mytable where name in ('n1', 'n2', 'n3', 'n4', ... bunch more... ) order by salary
It takes a filesort and between 50 and 70 seconds to complete...
Started by CharlesS on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Here's the pseudocode:
create temporary table names (name varchar(255)); insert into names values... .
This way is much faster than combing that entire list for each row .
Drop the list of names into a temporary table and then do an inner join on the two tables .
|
|
At times I have to connect to work through a VPN, and sometimes the connection is slow. However, I've noticed that when the network is slow, EVERYTHING on the computer is slow. For example, navigating around my local C: drive is slow, even though nothing...
Started by Jim on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
It ....
It's set by default and directs all network traffic over the VPN, not just traffic destined for that subnet .
FWIW, I've found my computer having lots of issues if I don't set the VPN connection to not use the VPN as the gateway when I'm connected .
|
|
Slow connectivity in Kloof area - is anyone else experiencing slow speeds? From around 15/01/2011 to 17/01/2011 - Slow connectivity in Kloof area - getting around only 380-512K on a 4MB uncapped line (MWEB).
Initially I waited a couple of days to see ...
Started by Pete_A on
, 15 posts
by 4 people.
Answer Snippets (Read the full thread at za):
There isnt any packet loss as....
It affects both local and international sometime.
Originally Posted by Pete_A From around 15/01/2011 to 17/01/2011 - Slow connectivity in Kloof area to see if it improves but I am still getting slow traffic.
|
|
You're right. It's not well liked, and it doesn't work at all well. In fact, it sucks. I'm stuck in an endless loop with an AdSense issue. However, that wasn't my point. I was showing a counter example to your comment " I don't know of any IT company ...
Started by gohighvoltage on
, 4 posts
by 2 people.
Answer Snippets (Read the full thread at jaguarpc):
Hopefully now, you will make some....
Google support for ALL their products is very bad, if not, non-existent .
Thousands of others don't have that luck or patience.
Hey Bell! Amazing! I am happy for you that you were able to get it resolved!!! You did well .
|
|
How slow is to slow
I loaded 3.4 grains of Trail Boss (measured with rcbs scale) under 125 gr. Rainier ccrn and fired it into my test hole. (Ruger LCR 357 mag) The load was so mild I checked down the barrel to make sure the bullet went through. I don...
Started by crooked stripe on
, 13 posts
by 7 people.
Answer Snippets (Read the full thread at thehighroad):
Where to turn now??? Check all your really light loads, but is getting close to too slow....
And if I remember that is slow.
What OAL did you use? Too slow at 661 fps.
Max is 5.3 at only 1035'/sec, 17900 CUP, @ 1.158" for this bullet .
|
