Mysql 5.5 concurrent_insert different values than previous versions
Bug #803472 reported by
CyberCr33p
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Tuning Primer Script |
Fix Released
|
Medium
|
TodoInTX |
Bug Description
concurrent_insert on mysql 5.5 uses values AUTO, NEVER and ALWAYS, instead of 1, 0 and 2.
Changed in mysql-tuning-primer: | |
importance: | Undecided → Medium |
assignee: | nobody → TodoInTX (matt-day32) |
status: | New → Confirmed |
Changed in mysql-tuning-primer: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
At line 1181 replace:
if [ $concurrent_insert -le 1 ] && [ "$mysql_ version_ num" -gt 050000 ] ; then insert= 2'."
cecho "If you have a high concurrency of inserts on Dynamic row-length tables"
cecho "consider setting 'concurrent_
fi
with:
if [ "$mysql_ version_ num" -gt 050000 ] && [ "$mysql_ version_ num" -lt 050500 ]; then insert= 2'." version_ num" -gt 050500 ] ; then insert" = 'AUTO' ] || [ "$concurrent_ insert" = 'NEVER' ] ; then insert= 2'."
if [ $concurrent_insert -le 1 ] ; then
cecho "If you have a high concurrency of inserts on Dynamic row-length tables"
cecho "consider setting 'concurrent_
fi
elif [ "$mysql_
if [ "$concurrent_
cecho "If you have a high concurrency of inserts on Dynamic row-length tables"
cecho "consider setting 'concurrent_
fi
fi
Thank it should work for MySQL 5.5, too.