'No InnoDB Support Enabled' in 5.5
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Tuning Primer Script |
Fix Released
|
Critical
|
TodoInTX |
Bug Description
hi,
iit iseems it does not recognize innodb enabled for some reason.
I'm using version is 1.6-r1, released on on 2011-08-06
See,
# ./tuning-primer.sh innodb
-- MYSQL PERFORMANCE TUNING PRIMER --
- By: Matthew Montgomery -
MySQL Version 5.5.14-55-log i686
Uptime = 0 days 0 hrs 12 min 2 sec
Avg. qps = 0
Total Questions = 15
Threads Connected = 1
Warning: Server has not been running for at least 48hrs.
It may not be safe to use these recommendations
To find out more information on how each of these
runtime variables effects performance visit:
http://
Visit http://
for info about MySQL's Enterprise Monitoring and Advisory Service
No InnoDB Support Enabled!
----
, and when I run it with sh -x , I can see:
...
+ check_innodb_status
+ '[' 050514 -lt 50603 ']'
+ mysql_variable ''\''have_
++ mysql -Bse 'show /*!50000 global */ variables like '\''have_
++ awk '{ print $2 }'
+ local variable=YES
+ export have_innodb=YES
+ have_innodb=YES
+ '[' 050514 -lt 50500 ']'
+ '[' 050514 -ge 50500 ']'
+ '[' 050514 -lt 50512 ']'
+ '[' 050514 -ge 50600 ']'
+ '[' '' = 1 ']'
+ cecho 'No InnoDB Support Enabled!' boldred
+ local 'default_msg=No message passed.'
+ message='No InnoDB Support Enabled!'
----
My environment:
# mysql -Bse 'show /*!50000 global */ variables like '\''have_
have_innodb YES
# mysql -Bse 'select version()'
5.5.14-55-log
# cat /etc/redhat-release
CentOS release 5.6 (Final)
Changed in mysql-tuning-primer: | |
status: | New → Fix Committed |
importance: | Undecided → Critical |
assignee: | nobody → TodoInTX (matt-day32) |
Please grab revision 27