Reputation
5,917
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 8 15
Newest
 Revival
Impact
~581k people reached

9h
answered What is happening when Seconds_Behind_Master oscillates between two very different sets ov values?
9h
comment Generating a sequence of values
Needed 204, not 205 for the last line.
11h
answered Generating a sequence of values
11h
comment Generating a sequence of values
U and R are irrelevant to the problem, correct?
11h
answered Innodb table is taking randomly long time to execute the insert query and in show processlist showing as queryend/updating
11h
answered Should the Redo log on a production MySQL server be configured to another location?
12h
comment How can I get the latest value per unique ID, then count the number of entries with that value?
What do you mean by "current network setting"? What determines "current"?
12h
comment How can I get the latest value per unique ID, then count the number of entries with that value?
Don't use DISTINCT when you need GROUP BY (because of MAX).
12h
comment Migrating all MySQL databases from from one server another. Getting error during import
Run suitable GRANTs before trying to reload.
12h
comment Error 1241 When Calculating Percentages
+ instead of , ???
12h
answered Tuning MySQL query from explain
12h
answered Mac OS X 10.10 mySQL 5.6.26 accessible from CLI but not port 3306
13h
comment MySQL Commited data not seen to select query
You tagged it 5.5, but mentioned 5.6; which is it? Is replication involved?
13h
comment MySQL Commited data not seen to select query
That's a dump of the binlog, not the general log, correct? Can we see the general log, which will include the SELECT.
13h
comment HeidiSQL: Import CSV
And enclosed by ". It is unclear whether "escaped" is set correctly.
13h
comment Write operations on the RDS Mysql Database becomes Slow during long run load test
Grrrr... Why is this on Hold? Performance issues are a common topic of this forum. This is merely a different cause of such.
13h
comment Write operations on the RDS Mysql Database becomes Slow during long run load test
Is each INSERT its own transaction? How big is innodb_buffer_pool_size? innodb_log_file_size?
13h
comment Write operations on the RDS Mysql Database becomes Slow during long run load test
Could Amazon be deliberately throttling? Were you initially using more than the promised throughput -- if so, they have a right to throttle.
13h
answered MYSQL find if a default value has been set for a table (DateTime Specifically)
14h
answered MySQL: is it more efficient to query for duplicate row or insert(update) on duplicate?