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 32061

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.

0
votes
This setting will provide the best protection from data loss in case of power failure when DB transactions are being performed. I am assuming you are using innodb engine. This will protect committed …
answered Jun 9 '17 by Allen King
0
votes
You can enable slow query log to get more details on slow queries. slow_query_log=1 slow_query_log_file="queries-slow.log" min_examined_row_limit=5000 The last setting, please tweak number of rows …
answered Jul 2 '17 by Allen King
1
vote
1answer
MySQL master has a table Products that has triggers on update and delete. Deleted/Updated records are stored in ProductsUpdatedDeleted tab. When a record is deleted, the operation is replicated …
asked Oct 24 '17 by Allen King
0
votes
In addition to @jehad's answer, execute these (or add them in MYSQL config file and restart DB). set global innodb_flush_log_at_trx_commit=2 set global general_log=0 This should make insertions faster. …
answered Jul 2 '17 by Allen King
1
vote
InnoDB https://www.percona.com/blog/2007/11/01/innodb-performance-optimization-basics/ Please also review https://stackoverflow.com/questions/45001764/should-mysql-take-this-long-or-is …
answered Jul 9 '17 by Allen King