Bug #38090 | "show variables" command is very slow in ndb 6.2, ndb 6.3 | ||
---|---|---|---|
Submitted: | 14 Jul 2008 4:44 | Modified: | 18 Jan 2009 14:07 |
Reporter: | ws lee | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S2 (Serious) |
Version: | ndb 6.2, ndb 6.3 | OS: | Any (Linux, Solaris) |
Assigned to: | Assigned Account | CPU Architecture: | Any |
[14 Jul 2008 4:44]
ws lee
[15 Jul 2008 17:47]
Hartmut Holzgraefe
With ndb handler compiled in but not used SHOW VARIABLES times on my box are constantly at 0.3s instead of 0.00 - 0.01 as they used to be, with ndb handler enabled and two data nodes running on the same box times are between 0.3s (typical) and almost 2s (worst case seen so far). Same for SELECT * FROM INFORMATION_SCHEMA.SESSION_VARIABLES
[16 Jul 2008 0:42]
ws lee
To. Hartmut Holzgraefe Thanks for your check. Are you run test-runtime-mysql5.1.23.sh? You must run this script in ndbcluster compiled with 「--with-innodb compile option.」and in ON state of innodb engine. P.S) Where can i Bug Triage's definition?
[18 Dec 2008 10:27]
Jonas Oreland
no clue to why this is... needs investigation to determine E/R
[19 Jan 2009 0:02]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".