oli's blog

1450 - 1499 1550 - 1599

• Error: 1500 SQLSTATE: HY000 (ER_SUBPARTITION_ERROR)

1400 - 1449 1500 - 1549

• Error: 1450 SQLSTATE: HY000 (ER_FORBID_SCHEMA_CHANGE)

1350 - 1399 1450 - 1499

• Error: 1400 SQLSTATE: XAE09 (ER_XAER_OUTSIDE)

1300 - 1349 1400 - 1449

• Error: 1350 SQLSTATE: HY000 (ER_VIEW_SELECT_CLAUSE)

1250 - 1299 1350 - 1399

• Error: 1300 SQLSTATE: HY000 (ER_INVALID_CHARACTER_STRING)

1200 - 1249 1300 - 1349

• Error: 1250 SQLSTATE: 42000 (ER_TABLENAME_NOT_ALLOWED_HERE)

1150 - 1199 1250 - 1299

  Error: 1200 SQLSTATE: HY000 (ER_BAD_SLAVE)
  Message: The server is not configured as slave; fix in config file or with CHANGE MASTER TO

How does the MySQL error message look like?

1100 - 1149 1200 - 1249

• Error: 1150 SQLSTATE: HY000 (ER_DELAYED_CANT_CHANGE_LOCK)

1050 - 1099 1150 - 1199

• Error: 1100 SQLSTATE: HY000 (ER_TABLE_NOT_LOCKED)

1000 - 1049 1100 - 1149

Error: 1050 SQLSTATE: 42S01 (ER_TABLE_EXISTS_ERROR)

1050 - 1099

• Error: 1000 SQLSTATE: HY000 (ER_HASHCHK)

  Message: hashchk

Just a general rule with error messages: Usually they are not as good as they could be. But nevertheless read them carefully. Most of the time they tell you what you need to know…

FromDual is a support partner of MariaDB plc, Codership Oy and Oracle Corporation. This gives us the opportunity to offer you customized enterprise support subscriptions for your mission-critical MariaDB, Galera or MySQL databases for all three vendors.

We dug some further with this problem of too big rows. The results you can find below.

Further discussion we had about PBXT MEMORY tables partitioned:

Q: Is there a good case where partitioned PBXT MEMORY tables could make sense?

Hi Stewart,

Thanks for your comment. Paul made some similar conclusions:

At the DOAG 2010 we found that there are already a lot of Plugins etc. for MySQL available. Therefor it will be a good time to start with a collection of Plugins, UDF’s etc. available.

Hi Baomin Wang,

After some thinking an talking to some colleagues I found the answer:

Hi Baomin Wang,

1. I come back with an answer later…

PBXT Maatkit tools Sandbox InnoDB plugin vs. built-in NF 5.5