Reputation
12,040
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 13 35
Newest
 Revival
Impact
~763k people reached

2d
comment invalid default value (mysql 5.7) for timestamp field
Further review of the 5.7.8 release notes suggests that one change was reverted, but that you may need to to remove NO_ZERO_DATE, which is now part of the default configuration. Can you confirm? Please SELECT @@SQL_MODE;.
Aug
31
answered mysql error handling in function
Aug
29
comment invalid default value (mysql 5.7) for timestamp field
This issue is documented... but first, which release of MySQL 5.7 are you using (particularly relevant, since 5.7 isn't yet GA as of now)? and there was an ill-conceived change introduced in 5.7.4 that was reverted in 5.7.8, that would explain this. Please confirm your version.
Aug
29
comment MySQL connection process slow for non-root user
Or use --skip-name-resolve to disable the lookups, which are not usually all that useful. dev.mysql.com/doc/refman/5.6/en/host-cache.html
Aug
29
comment Amazon AWS RDS Aurora Row size too large (VB5)
I'm not sure there's a tidy solution for using this table structure with Aurora. This table... it's pretty hideous, to be honest, and seems like it's almost begging to be twisted 90°. But, since it appears to be a commercial product, have you checked with the vendor whether Aurora is a supported back-end? Having only tinkered with Aurora in preview, I can't say conclusively, but I'm skeptical whether it can be made to work without some refactoring, unless Aurora supports ROW_FORMAT=COMPRESSED, which I doubt, in spite of the suggestion in the error message.
Aug
29
comment Amazon AWS RDS Aurora Row size too large (VB5)
If I remember correctly from observations during the Aurora preview, MyISAM tables are coerced to InnoDB with a warning when the table is created. Aurora most definitely has no support for MyISAM, which makes perfect sense given that it almost certainly does its scaling magic internal to InnoDB.
Aug
21
comment pt-online-schema-change deleted our data
Your question is unclear, but it sounds as if you ran it against a slave server, not against the master... thereby changing the slave's schema so that it no longer matched the master. If so, why would you do this?
Aug
21
comment How to optimise MySQL query that uses dependent subquery
The multi-column primary keys are not doing anything useful for you, since they include an auto-increment. You don't seem to need the "id" in "seen" at all, unless a user could have "seen" an image more than once, which this design does not prevent.
Aug
20
comment Active-active Cluster In MySQL
@tesla747 "master/master" is circular, as described above, though could refer to a ring of 2 or more masters, in a circle. Multi-master has been used to describe the same thing (circular/ring), but depending on context, it is likely to refer to fan-in replication, where one slave is a slave to two or more masters, and those masters are totally unaware of each other and have no conflicting schema+table identifiers among them, also called multi-source. MariaDB implemented this first, and now Oracle is trying to catch up, introducing it in MySQL 5.7.
Aug
19
comment Replicate existing database live
Happy to help point you in the right direction, but it seems a little superfluous to post (essentially) "use replication" as an answer to the question "how do I replicate?" MySQL replication is a stable technology, and the details on configuring it are in the documentation as noted, so I'm voting to close this question. If you get stuck in the process, there are a number of existing Q&A here on the topic. If you encounter any issues that haven't been addressed on the site, feel free to post a new question on the specific issue.
Aug
19
comment Replicate existing database live
If you aren't going to change the data on B, then it sounds like you are looking for asynchronous replication. (Async? Yes, trust me for a moment). If you are going to change data on B, then, your question is unclear because "all changes ... should be reflected ... in real time." If you change data on B, directly, then reflecting all changes from A becomes undefined (e.g. delete row X on B, update row X on A, server B will not contain the updated value from A, since there was nothing on B to update).
Aug
19
comment Speeding Up MySQL Full Text Search
@ChrisMuench MATCH ... AGAINST has something of a double role. In addition to being a search operator, if you evaluate it as an expression in a numeric context , it returns a relevance score for each row. If instead of relevance, we call that value "weight," then "heavier" must mean "more relevant." Hence ORDER BY (MATCH (...) AGAINST (...)).
Aug
16
comment query optimization of a left join
A potentially noteworthy red flag is that the query also isn't actually returning anything particularly meaningful. It's counting the users who are activated and not suspended, deleted or hidden... whether or not they have a photo with main = 'Y'. If a user has more than one photo with main = 'Y' it will count that user more than once.
Aug
13
awarded  Revival
Aug
12
awarded  Nice Answer
Aug
11
reviewed Close query that does functionality of listagg without use of it
Aug
11
comment mysql 100% usage on all cpu
Thank you for the edit. I have removed my down-vote, but I don't believe an up-vote is necessarily merited. innodb_thread_concurrency = 0 does not mean "disabled," it means "infinite." The suggestion "check the slow query log" is not necessarily useful, as you can see that it is enabled and OP mentioned having checked the log without fully understanding the implications, about 3 hours before you posted. Answers need to focus on solutions, rather than suggestions, and in this case, we don't really have enough background info to find and solve a problem.
Aug
11
answered Prepared statement execution with variable number of parameters to be bound
Aug
11
comment mysql 100% usage on all cpu
I am not sure why you would believe that advertising your services in the body of an answer would be helpful or acceptable here. If you want to provide valuable and useful answers, we welcome that. If you want to mention your services on your profile, that's acceptable, too... but if you are looking for a place to gratuitously include links to your web site under the auspices of an answer, I would not recommend the Stack Exchange sites. This will not be well-received.
Aug
11
comment mysql 100% usage on all cpu
@mysql_user please don't recommend mysqltuner or other tuning scripts. They tend to provoke people to make uninformed changes, and they often offer very ridiculous recommendations that can degrade performance, sometimes more often than not. Parameter is tunable != parameter should be tuned. Also, 40GB buffer pool on a 48GB server dedicated to MySQL is perhaps slightly large, but isn't going to increase CPU utilization. Poorly-written queries need to be found and fixed.