Reputation
11,460
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 9 24
Newest
 Mortarboard
Impact
~809k people reached

15h
comment insufficient history for index
Dup of stackoverflow.com/questions/35196489/…
15h
comment Error: “mod_fcgid: can't apply process slot for” makes my server unresponsive for a period of time
How many requests do you get per second?
15h
answered Improve performance of query with multiple group by column and count function in select
16h
answered Memory Table and Disk Table
16h
answered Retrieving most recent X rows for each given user from a table
16h
revised Retrieving most recent X rows for each given user from a table
wrap
22h
answered Store massive values data from remote controllers
1d
comment how to change relay log fie name on “Adding Slaves to a Replication Environment”?
I think so, and I don't recall any problem, except for some confusion.
1d
comment What are the advantages of Packet Inspection and SHOW FULL PROCESSLIST over PERFORMANCE_SCHEMA?
5.1 is End-of-Life. 5.5 and 5.6 and 5.7 are out there. The longer you take to upgrade, the harder the upgrade will be.
1d
comment MySQL replication - invalidating query cache entries (table)
2 does an fsync once a second. 0 hopes that the OS eventually flush things. fsync flushes pending writes to disk.
2d
comment Avoid using Many to Many Relationship
(The alternatives are even more clumsy.)
2d
comment Access a remote mysql from a remote node application
GRANT; also read related manual pages.
2d
comment MySQL replication - invalidating query cache entries (table)
=2 is arguably slightly better than =0. =1 leads to a lot of I/O for security. However, the Slave is not your only source for the data, so a crash that corrupts stuff is not the end of the world.
2d
answered Getting error while starting mysql by just typing in mysql terminal
2d
awarded  Mortarboard
2d
comment Sql multiple table checks for polling
If there is a "push" technology across http, I would like to hear about it. This "poll" is messy and costly. (But probably a lot 'safer'.)
2d
comment Sql multiple table checks for polling
The question is "how to discover something to update" and "where to store the flag". I'm suggesting TRIGGER(s) for the 'how'. Maybe a PHP $_SESSION value would be the lightest weight for the 'where'. (If you are using PHP.)
2d
awarded  Nice Answer
2d
comment Sql multiple table checks for polling
I would have the db stuff boil it down to "user#1234" has something to update. The AJAX call asks "Does user#1234 have anything?". If the answer is 'yes', then a second AJAX call asks "What do you have?". This triggers multiple SELECTs into multiple tables.
2d
comment Sql multiple table checks for polling
Look at the code right here (stackexchange); it is doing something like that to get the number of comments and reputation points periodically. I, alone, have about a dozen window open; I assume they are all polling. Obviously SE has licked the scaling problem in some way. (Note: the timers ("23 seconds ago") are probably done in Javascript without touching the SE servers.)