Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 114578

All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.

3
votes
2answers
mysql data dir and start with an empty database, it will eventually catch up with the rest of the cluster. Hence it sounds like we could tweak performance by turning off options for ensuring local … are in different server centers. I find it hard to think of anything that would cause two nodes to go down simultaneously - except a serious mysql bug, how likely is that? Admittedly, two of the nodes …
asked Jan 10 '17 by tobixen
0
votes
3answers
General problem: I want to do a left join on two huge tables, but there is no matching key - I want to join the left table with the "nearest" row in the right table. In this example I want to join us …
asked Jan 6 '18 by tobixen
1
vote
more proper fix would have been to redirect the mysql traffic to the one server that wasn't clogged and wait for the others to calm down by themselves. $ mysqld --version mysqld Ver 5.7.23-23-57 for …
answered Nov 29 '18 by tobixen
0
votes
Think I figured out of this - it seems quite easy to fix this through a subquery: SELECT transaction.*, (SELECT rate FROM rate WHERE rate.timestamp<transaction.timestamp and rate.currency=trans …
answered Jan 7 '18 by tobixen
3
votes
and innodb_flush_log_at_trx_commit on the affected node - just remember to use one of the other nodes for bootstrapping should the whole cluster fail. # echo "[server]" >> /etc/mysql/conf.d … /temp_perfomance_hax.cnf # echo "innodb_doublewrite = 0" >> /etc/mysql/conf.d/temp_performance_hax.cnf # echo "innodb_flush_log_at_trx_commit = 2" >> /etc/mysql/conf.d/temp_performance_hax.cnf # systemctl …
answered Jan 11 '17 by tobixen