[ANN] mysql binding for LuaJIT

Hi, I made a new mysql binding for LuaJIT, here it is: https://code.google.com/p/lua-files/wiki/mysql Features: - covers all of the functionality provided by the mysql Connector/C 6.1 API - all data types are supported with multiple options for conversion - prepared statements, avoiding

Re: auto-increment more than one field

From: rounak jain rounak.m...@gmail.com I have a table which needs two fields with auto-increment. I don't know if you have such control over your installation, but you might consider the work-alike MariaDB, which I believe supports auto-increment on multiple fields, as well as a slew of

RE: Dropping column/index from MyISAM table increases disk space without calling optimize

Sorry, I can't address your specific question, but I have several other tips, some of which may save a lot of space... USING HASH -- ignored; presumably BTree is used instead. What Version of MySQL? 5.5(?) can drop an InnoDB (only?) index live. BTrees sometimes grow after any sort of