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 70539

An evaluation of whether a system works well enough to be fit for purpose. Normally performance refers to the speed with which a system completes an operation or set of operations over time.

1
vote
I'd agree with comment that asks for "purpose" of the mysql instance though these days you get decent configuration in-built provided with my.cnf. You should look to use them, my-large/huge/medium.c …
answered Nov 17 '15 by mysql_user
3
votes
(Seems like I'm able to post detailed answer here today... let me know if this has helped you) Here is a test output for you... mysql> truncate table t1; Query OK, 0 rows affected (0.07 sec) mysql> …
answered Sep 24 '15 by mysql_user
3
votes
It is obvious to have better performance for the value of innodb_flush_log_at_trx_commit as 2 than 1. As commit operations are fairly dependent on underlying system even fooling-by-OS is an extra … / fake ) } Also your tests you performed contains multiple parameters for comparisons. You might also want to test with sync_binlog and flush_method changes. Mainly consider variable optimizations for better performance. …
answered Oct 8 '15 by mysql_user
1
vote
"I know its different for every application" 15G is not a large data-set unless you tell me it's a single table! Your data can be contained in innodb-buffer-pool and performance should be better …
answered Oct 29 '15 by mysql_user
2
votes
innodb_flush_log_at_trx_commit = 1 wear out SSDs more than innodb_flush_log_at_trx_commit = 2?" -> Regardless of disk type, value of 1 is bound to do more work (disk ops) than value of 2 and hence the performance difference. …
answered Nov 25 '16 by mysql_user