Re:An open MySQL bug receives a real Birthday cake
by famousactress on Friday June 28, 2013 @02:57PM
(#5959735)
I think gittip is great, and I understand this is the opposite of their philosophy, but I want a well-used bounty program for these things.
I mentioned some Django bugs that are huge for us that were finally fixed in 1.6 in another thread [1]. I'd have personally pledged a couple hundred dollars to have them fixed, and probably could have gotten considerably more pledged from my company. Does this tool/platform exist and I just don't know about it?
Thanks for the replies. Pledgie and bountysource look interesting and I suppose really close to what I was imagining, in spirit. Fundamentally, I'd like to see something well-executed help formalize the process behind what motivated Andrew's awesome Django migrations kickstarter [2]. I really like the way that came together because it had the buy-in of the team, and there-by inspired confidence in potential backers.
1) Someone places a bounty for a problem (tipically an issue registered on an issue tracker)
2) More people might want to sponsor the same issue
3) A developer solves the issue
4) The sponsors verify the solution and pay the developer
The FreedomSponsors website itself is an open source web application, written in Django.
Funny fact - some of its own issues have been sponsored in the website.
Re:An open MySQL bug receives a real Birthday cake
by famousactress on Friday June 28, 2013 @11:37PM
(#5961424)
Hi Tony! Sorry, getting to this late. freedomsponsers.org looks totally in line with what I was imagining. I presume you built it, so thanks! I hope it gets traction.
[Totally unsolicited... I'd vote to change it's name. I know it seems silly/shallow but I thought of a million and a half things that it might be before I clicked he link, and none of them were even close to what it is. (Mostly I would have assumed it to be a Koch Brothers fundraising organization)]
Re:An open MySQL bug receives a real Birthday cake
by foobarbazqux on Friday June 28, 2013 @04:02PM
(#5960059)
I'm not convinced Oracle (ORCL), listed on both the S&P-500 and the NASDAQ-100, needs or will accept bug fixing donations, especially since MySQL is a competitor to their flagship Oracle DB and there was quite a lot of disgruntlement around the acquisition. Maybe if you gave money to MariaDB it would work.
Re:An open MySQL bug receives a real Birthday cake
by famousactress on Friday June 28, 2013 @04:31PM
(#5960199)
Agreed, fuck 'em (not that you were saying that, but I am). My point was I want something like this for projects and bugs I care about in general. I don't care about this bug, but can relate to the cake-maker.
To anyone not yet familiar, Maria is a really exciting fork of MySQL - https://mariadb.org/
Re:An open MySQL bug receives a real Birthday cake
by lvillani on Saturday June 29, 2013 @10:01AM
(#5962400)
> It's recently replaced mysql in redhat builds, so it's definitely on the up.
"Red Hat's Director of Product Marketing, Mark Coggin, told various media outlets that the company has not made any decision or made an announcement about which database technology will be in Red Hat Enterprise Linux 7."
Re:An open MySQL bug receives a real Birthday cake
by tonylampada on Friday June 28, 2013 @09:01PM
(#5961133)
Oracle might not accept bug fixing donations.
But it should accept bug fixing patches from an independent developer. And that developer might accept a bug fixing donation.
Re:An open MySQL bug receives a real Birthday cake
by dragonwriter on Friday June 28, 2013 @04:37PM
(#5960229)
> MySQL is a competitor to their flagship Oracle DB
Does it really? I mean, sure, they are both RDBMS's, but that's a pretty broad market. Are there really that many use cases where, with the current market, people who are using MySQL would have Oracle as their next choice or vice versa?
I can see an argument that MySQL competes with some of the same products that Oracle DB competes with (but in different market segments than where Oracle DB does), but I don't see them as directly competitive in any significant sense.
Re:An open MySQL bug receives a real Birthday cake
by tomphoolery on Friday June 28, 2013 @07:11PM
(#5960812)
To me, that's kind-of like saying the MacBook Air is a competitor to Apple's flagship MacBook Pro. They're two different products, made by the same company, doing pretty much the same thing but designed for different use cases. It's the way I always felt about Oracle vs. MySQL, even back before Oracle owned MySQL, that they are two different RDBMS platforms designed for two different use cases.
These days, that line may be blurred a little bit, and you can see how both paradigms (and more!) can be combined into a single product with PostgreSQL, but I feel like the MacBook analogy really sums up the way I feel about these two systems.
Re:An open MySQL bug receives a real Birthday cake
by xroja on Friday June 28, 2013 @05:02PM
(#5960324)
My project is in that position. We have access to an Oracle site license so we use it. However, we're considering move to a "competing" db, probably postgresql or mysql.
I'm not a certified DBA so take this with a grain of salt, but it seems that any non-trivial use of Oracle systems ramp up in cost very quickly. Both in terms of hard cash and time in education/training.
Re:An open MySQL bug receives a real Birthday cake
by dragonwriter on Friday June 28, 2013 @05:23PM
(#5960423)
> We have access to an Oracle site license so we use it. However, we're considering move to a "competing" db, probably postgresql or mysql.
Good point; I was considering mostly the situation where there isn't something already on hand, but it makes sense that there would be quite a lot of times where MySQL and Oracle DB are considered alternatives for a new project/application by shops who already have an existing installation of one or the other.
Re:An open MySQL bug receives a real Birthday cake
by SoftwareMaven on Friday June 28, 2013 @09:15PM
(#5961175)
Given there are more engineers working on MySQL now than any time in its history, I think Oracle is pretty committed to it. MySQL is about fast, OracleDB is about enterprise. A great many companies will run MySQL for things like web applications (especially those that need scale) while running the critical internal systems on OracleDB.
I don't think the MBPro/MBAir comparison is quite right. I think it's more like MBAir versus Mac Pro: it is very easy to see a single person having both of them and utilizing both of them extensively.
Re:An open MySQL bug receives a real Birthday cake
by philwelch on Saturday June 29, 2013 @01:37AM
(#5961578)
> Are there really that many use cases where, with the current market, people who are using MySQL would have Oracle as their next choice or vice versa?
Re:An open MySQL bug receives a real Birthday cake
by lotsofcows on Saturday June 29, 2013 @11:13AM
(#5962595)
Fortunately, lots of people other than Oracle work on the MySQL code. They would be susceptible to bug fixing donations. Hell, you could outright hire a Percona consultant.
Re:An open MySQL bug receives a real Birthday cake
by falcolas on Friday June 28, 2013 @05:22PM
(#5960420)
There are companies which you can pay to produce mysql fixes you specify. One of which is Percona. Won't be as cheap as gittip or something similar, but you'll get the results without relying on a bug hitting the top of someone elses' priority list.
Re:An open MySQL bug receives a real Birthday cake
by tonylampada on Friday June 28, 2013 @09:07PM
(#5961151)
So Percona is able to create a customized fork of MySQL for you? won't that create a maintenance problem in the future?
I mean, you won't be able to get official update releases anymore.
Re:An open MySQL bug receives a real Birthday cake
by gaadd33 on Saturday June 29, 2013 @05:31PM
(#5963767)
Percona already runs their own MySQL fork. (http://www.percona.com/software/percona-server) They include various patches that their customers have asked for and also update it every time Oracle releases a new MySQL version.
Re:An open MySQL bug receives a real Birthday cake
by olalonde on Saturday June 29, 2013 @10:15AM
(#5962434)
Yes, I was going to add a note on that but then I realized this problem (people cheating) would exist anyways as long as there isn't a trusted third party to handle conflicts. I don't think this would be a common issue though as most open source developers are not driven by the money and I don't think there would be enough money to attract scammers (would someone really get into the trouble of writing an open source software hoping to one day cheat people out of their money when they submit bug bounties?).
Re:An open MySQL bug receives a real Birthday cake
by famousactress on Friday June 28, 2013 @03:21PM
(#5959856)
You mean sending a polite email offering a couple hundred dollars to fix a bug? I haven't. In addition to seeming tacky, I think the idea behind a bounty system is that it provides a way to crowd-source the effort and I wonder if having more demonstrated skin in the game around key issues might help reduce bike-shedding, or better convey the tangible value an issue has to users.
Re:An open MySQL bug receives a real Birthday cake
by bhauer on Friday June 28, 2013 @04:01PM
(#5960052)
It's interesting that you mention a feeling of "tackiness" with respect to directly funding something via a bounty system. Although my personal project [1] isn't necessarily about providing incentives to open source software development, I did recently launch a new subsection focused on motivating businesses to act out of a motive other than the profit motive alone.
The motivational approach I took was slightly different than crowdfunding. Instead of directly funding the tasks you want to see completed, the bounties are donations to charity made on behalf of the tasks. They can be either made immediately to establish your level of seriousness or made when the task completes, to provide ongoing motivation.
Since I am focused primarily on motivating city governments and businesses, I felt the same way as you: direct funding is not the right thing to do. These governments and businesses already have funds. If I want to sway their decision-making processes in some unusual way, my experiment is using public charitable donations.
Just as a demonstration, I just created a task for this (admittedly, not really what I have in mind for my site, but I'll take whatever eyeballs I can get) [2].
Re:An open MySQL bug receives a real Birthday cake
by famousactress on Friday June 28, 2013 @04:29PM
(#5960189)
That's really cool! To be clear though, I felt it tacky to pick a core dev and email them directly as opposed to making a more public and transparent commitment in some other forum.
Still, I like your project quite a bit. Looks very nicely executed.
Re:An open MySQL bug receives a real Birthday cake
by GuiA on Friday June 28, 2013 @03:30PM
(#5959893)
Yes, that's what I meant. Why is it tacky? Sure, if there were a public "official" way to do so, it'd be preferable, but if you really need a Django bug fixed ASAP, there's nothing wrong with sending a nice email to a django core dev saying "Would you be open to fixing it soon, and we'll pay you $X?".
Open source developers don't bite, and they never say no to a bit of extra cash :)
Re:An open MySQL bug receives a real Birthday cake
by embwbam on Friday June 28, 2013 @03:52PM
(#5960017)
Wait! Read "Drive" first. Open Source is a textbook example of people working for intrinsic motivation. While offering money might make that bug get fixed sooner, it very often reduces their drive to work on the open source project in the long run.
Re:An open MySQL bug receives a real Birthday cake
by hackiavelli on Friday June 28, 2013 @05:21PM
(#5960412)
I can definitely see it having a negative effect. I don't do bounties anymore. It was too easy to get ripped off. They're basically a freelance gig with no guarantee of getting paid and no deposit to protect you when the person disappears after the work is done.
Thing is I likely would have done the work anyway. Bugs are community issues that effect everyone and contributing fixes for them keeps an open source project vibrant and active. But instead of feeling good about fixing some obscure bug I felt like I'd been used by someone who didn't want to pay for a developer.
Re:An open MySQL bug receives a real Birthday cake
by famousactress on Friday June 28, 2013 @03:42PM
(#5959956)
Still feels icky to me. I'd rather this stuff be public and done in a way that the community and the rest of the core team know what's going on. I'd worry that backdoor payments done this way would negatively affect the spirit of how these projects are run.
Also, I wonder why he chose to record it in his bathroom. Those are definitely shower curtains and the echo is definitely bathroom-esque. Maybe for acoustics.
Re:An open MySQL bug receives a real Birthday cake
by shdon on Friday June 28, 2013 @06:22PM
(#5960624)
That's also listed in the comments for the bug, as well as some (contrived) examples as to when it wouldn't work. Surprising it hasn't been fixed, considering how simple the true fix is.
Re:An open MySQL bug receives a real Birthday cake
by GICodeWarrior on Saturday June 29, 2013 @03:01PM
(#5963424)
I was curious about your comment so I did a few searches, and it looks like a major decomposition product is hydrogen fluoride.
According to Wikipedia: "Hydrogen fluoride is a highly dangerous gas, forming corrosive and penetrating hydrofluoric acid upon contact with tissue. The gas can also cause blindness by rapid destruction of the corneas."
Re:An open MySQL bug receives a real Birthday cake
by jevinskie on Saturday June 29, 2013 @01:09AM
(#5961550)
IIRC the components of "air duster" are heavier than air (they settle in the bottom of the lungs and are hard to exhale) while also a trigger of cardiac issues. I wouldn't want to inhale the uncombusted gas!
Re:An open MySQL bug receives a real Birthday cake
by morgo on Friday June 28, 2013 @03:22PM
(#5959862)
I have a rudimentary knowledge of MySQL Internals, so I am going to take a guess why it has taken so long.
They want to implement this feature server side, which means that they either have to add:
(1) A new server setting (SET SHOW_CREATE_TABLE_FORMAT = Blah)
-or-
(2) New syntax (SHOW CREATE TABLE NOAUTOINC mytable).
Adding new settings is always evil, and adds to product confusion/complexity.
Adding new syntax is a bit evil in MySQL's case since they use a generic yacc parser, and might have to add a new reserved word (truthfully, I'm not 100% sure on that one). There is also a preference to only add reserved words to major new versions.
Re:An open MySQL bug receives a real Birthday cake
by erikkay on Friday June 28, 2013 @07:43PM
(#5960917)
Of all of the things I've done in technology, this was not near the top of the list of things that I thought would be on the top of hacker news (no, I didn't do the cake, just filed the bug 7 years ago).
Re:An open MySQL bug receives a real Birthday cake
by croisillon on Friday June 28, 2013 @05:13PM
(#5960371)
And, cross-commenting from the Tau Manifesto post, "tau" means "for you" in lithuanian, so go ahead and have a delicious slice of HN homepage for your birthday.
Re:An open MySQL bug receives a real Birthday cake
by binarymax on Friday June 28, 2013 @03:12PM
(#5959820)
For those unclear of the reasons this is bad (aside from the assumption that the pure raw data structure should not have any artifacts of custom data definition) - it is probably something in code or, more likely, initialisation data, that is expecing the Id to be something. This may be a file of SQL inserts that is run after the database is created, with hardcoded primary keys. This is an antipattern of course, but it doesn't excuse the fact that pure structure dumps should remain as such. (disclaimer - I have little experience with mysql, but have seen these same antipatterns in SQL server, oracle, and db2 data init scripts far too often).
Re:An open MySQL bug receives a real Birthday cake
by dangrossman on Friday June 28, 2013 @03:15PM
(#5959828)
`mysqldump` is a utility included with MySQL to dump a copy of tables and their data to a text file of SQL queries. Tables may contain a column with the AUTO_INCREMENT property where values in that column are generated from a sequence (i.e. 1, 2, 3, 4, 5).
The bug requests that the table definition written to the dump file by this utility not contain the current value of the AUTO_INCREMENT sequence when the option to dump only definitions, not data, is used.
Re:An open MySQL bug receives a real Birthday cake
by samcrawford on Friday June 28, 2013 @06:28PM
(#5960644)
I disagree that any serious installation is using innodb_file_per_table. It does have downsides.
In our use case we're making very heavy usage of table partitioning (over 500 partitions for some of our very large tables). Because each partition is effectively another table under the covers, if we were to use innodb_file_per_table then we'd have tens of thousands of files. This means a lot more file handles being opened/closed (as well as the obvious ulimit gotchas for the uninitiated). This noticeably hampered query performance when seeking data from random partitions.
Re:An open MySQL bug receives a real Birthday cake
by dmourati on Friday June 28, 2013 @06:41PM
(#5960689)
I've managed many non-trivial MySQL installations that didn't set file_per_table. I agree it is a step towards fixing the problem but can create potentially other issues.
Current shop is not running file_per_table, and has little reason to do so at ~30GB database file size. Still, dropping the table and not reclaiming any space was a rude awakening. Combine that the fact that storage was an AWS EBS sized pretty close to its limit (50GB). I could not perform two iterations of a test import without first rm'img the file. Lame.
Re:An open MySQL bug receives a real Birthday cake
by druiid on Friday June 28, 2013 @03:40PM
(#5959947)
Sadly MySQL has a history of bugs like this. There are a few we have run across that have probably been open longer than this bug, and yet have not been fixed. I'd have to look the bug numbers up from e-mail, but yeah.. there are tons of mines out there in MySQL just waiting for you to hit them, and upon further discovery, someone else found out about it years ago!
Re:An open MySQL bug receives a real Birthday cake
by kryten on Friday June 28, 2013 @03:47PM
(#5959985)
I've had many experiences like this as well. Even some of our paid for software gets scared if you use a buggy MySQL version (TeamCity for example refuses to start on certain MySQL versions).
Re:An open MySQL bug receives a real Birthday cake
by kryten on Saturday June 29, 2013 @06:53AM
(#5962019)
Seriously?
I find it much easier from an admin and dev perspective. It is less forgiving, that is correct, but that's a good thing. Oh and the documentation is wonderful compared to MySQL.
Re:An open MySQL bug receives a real Birthday cake
by druiid on Friday June 28, 2013 @07:12PM
(#5960818)
shrug Everyone hates on MySQL, and I have my periods of hate as well (mostly I think they boil down to actually hating the Developers of MySQL, not the actual software)... But the thing is that for our purposes MySQL works and works well 99.9% of the time. Additionally the actual big, real issues/beefs people have with MySQL are mostly fixed in 5.6 (multi-threaded slaves (really guys, you should have fixed that years ago), online ALTER TABLE (again... wtf, why was that not fixed years ago)).
He also is hating on PHP in that article, which seems like prime HN bait, because as it does every time there is a PHP hate article on here, everyone actually doing real work comes and and says 'Okay, have fun with your rubies and nodes'.
With all that said, recently a lot of our data has started to be organized outside of MySQL (a lot more Couchbase and Solr usage), but MySQL is still there driving the core data. I'd say it all boils down to right tool for the job.
Re:An open MySQL bug receives a real Birthday cake
by lcampbell on Friday June 28, 2013 @03:47PM
(#5959986)
Well, I just took 10 minutes to write an ad-hoc parser that will probably fix the bug (it works around the tricky test cases in the thread)[1]. I don't really understand why they want to move stuff onto the server-side, there may be some other trickery I'm missing.
Please feel free to use as-is and integrate it into mysqldump. I can't be bothered to create an account on bugs.mysql.com.
Re:An open MySQL bug receives a real Birthday cake
by AaronBBrown on Friday June 28, 2013 @03:51PM
(#5960009)
While I agree it has potential to be annoying in some environments, it's also trivially simple to work around.
for tbl in $(mysql -BNe "SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE EXTRA = 'auto_increment' AND TABLE_SCHEMA = 'mydb'"); do
mysql -e "ALTER TABLE ${tbl} AUTO_INCREMENT=1" mydb
done
Run that just after importing your new schema.
Note: That code will require a bit of modification if you make the mistake of having spaces in your table name.
Re:An open MySQL bug receives a real Birthday cake
by ars on Friday June 28, 2013 @03:45PM
(#5959972)
I store the dump of the database in source control, so several years ago I made a small program mysqldump_ddl to strip out all ephemeral data that clutters up the changes:
Re:An open MySQL bug receives a real Birthday cake
by bcoates on Friday June 28, 2013 @03:01PM
(#5959759)
I don't believe in autoincrement so I'm not up to date on the evil things you can do with it, so I'm unclear why this bug matters: All it does is change the arbitrarily chosen start value for new rows, what could that break?
The existing behavior makes more sense anyway, as it preserves 'truncate table' <=> 'restore nodata dump' equivalence better.
Re:An open MySQL bug receives a real Birthday cake
by Dylan16807 on Friday June 28, 2013 @03:24PM
(#5959866)
It's less that it would break anything and more that it's philosophically wrong to be outputting what's basically a historical max value field when asked not to output data.
Re:An open MySQL bug receives a real Birthday cake
by pagekicker on Saturday June 29, 2013 @12:46PM
(#5962938)
I just had occasion to use mysqldump --no-data a few days ago, and then came across this today. Not a good feeling! C'mon, mySQL devs ... fix it already.
I mentioned some Django bugs that are huge for us that were finally fixed in 1.6 in another thread [1]. I'd have personally pledged a couple hundred dollars to have them fixed, and probably could have gotten considerably more pledged from my company. Does this tool/platform exist and I just don't know about it?
[1] https://news.ycombinator.com/item?id=5958281
[Edit]
Thanks for the replies. Pledgie and bountysource look interesting and I suppose really close to what I was imagining, in spirit. Fundamentally, I'd like to see something well-executed help formalize the process behind what motivated Andrew's awesome Django migrations kickstarter [2]. I really like the way that came together because it had the buy-in of the team, and there-by inspired confidence in potential backers.
[2] http://www.kickstarter.com/projects/andrewgodwin/schema-migr...
This is how it works:
1) Someone places a bounty for a problem (tipically an issue registered on an issue tracker)
2) More people might want to sponsor the same issue
3) A developer solves the issue
4) The sponsors verify the solution and pay the developer
The FreedomSponsors website itself is an open source web application, written in Django. Funny fact - some of its own issues have been sponsored in the website.
The source code - along with instructions on how to run it - can be found on Github. https://github.com/freedomsponsors/www.freedomsponsors.org
[Totally unsolicited... I'd vote to change it's name. I know it seems silly/shallow but I thought of a million and a half things that it might be before I clicked he link, and none of them were even close to what it is. (Mostly I would have assumed it to be a Koch Brothers fundraising organization)]
To anyone not yet familiar, Maria is a really exciting fork of MySQL - https://mariadb.org/
-- "Red Hat Says No MariaDB/MySQL Decision Made." The H Online, 18 June 2013 (http://www.h-online.com/open/news/item/Red-Hat-says-no-Maria...)
That's where a service like http://freedomsponsors.org comes in handy ;-)
Does it really? I mean, sure, they are both RDBMS's, but that's a pretty broad market. Are there really that many use cases where, with the current market, people who are using MySQL would have Oracle as their next choice or vice versa?
I can see an argument that MySQL competes with some of the same products that Oracle DB competes with (but in different market segments than where Oracle DB does), but I don't see them as directly competitive in any significant sense.
These days, that line may be blurred a little bit, and you can see how both paradigms (and more!) can be combined into a single product with PostgreSQL, but I feel like the MacBook analogy really sums up the way I feel about these two systems.
I'm not a certified DBA so take this with a grain of salt, but it seems that any non-trivial use of Oracle systems ramp up in cost very quickly. Both in terms of hard cash and time in education/training.
Good point; I was considering mostly the situation where there isn't something already on hand, but it makes sense that there would be quite a lot of times where MySQL and Oracle DB are considered alternatives for a new project/application by shops who already have an existing installation of one or the other.
I don't think the MBPro/MBAir comparison is quite right. I think it's more like MBAir versus Mac Pro: it is very easy to see a single person having both of them and utilizing both of them extensively.
RDS users?
https://www.catincan.com/
http://bountyoss.com/
http://funding.openinitiative.com/
In development: https://snowdrift.coop/
The motivational approach I took was slightly different than crowdfunding. Instead of directly funding the tasks you want to see completed, the bounties are donations to charity made on behalf of the tasks. They can be either made immediately to establish your level of seriousness or made when the task completes, to provide ongoing motivation.
Since I am focused primarily on motivating city governments and businesses, I felt the same way as you: direct funding is not the right thing to do. These governments and businesses already have funds. If I want to sway their decision-making processes in some unusual way, my experiment is using public charitable donations.
Just as a demonstration, I just created a task for this (admittedly, not really what I have in mind for my site, but I'll take whatever eyeballs I can get) [2].
[1] https://www.brianstaskforce.com/
[2] https://business.brianstaskforce.com/task/385/oracle-address...
Still, I like your project quite a bit. Looks very nicely executed.
Open source developers don't bite, and they never say no to a bit of extra cash :)
Thing is I likely would have done the work anyway. Bugs are community issues that effect everyone and contributing fixes for them keeps an open source project vibrant and active. But instead of feeling good about fixing some obscure bug I felt like I'd been used by someone who didn't want to pay for a developer.
http://www.youtube.com/watch?v=oAiVsbXVP6k
It's got a real Joker laugh going on toward the end.
Also, I wonder why he chose to record it in his bathroom. Those are definitely shower curtains and the echo is definitely bathroom-esque. Maybe for acoustics.
Only posting this because I've done that before :)
According to Wikipedia: "Hydrogen fluoride is a highly dangerous gas, forming corrosive and penetrating hydrofluoric acid upon contact with tissue. The gas can also cause blindness by rapid destruction of the corneas."
They want to implement this feature server side, which means that they either have to add: (1) A new server setting (SET SHOW_CREATE_TABLE_FORMAT = Blah) -or- (2) New syntax (SHOW CREATE TABLE NOAUTOINC mytable).
Adding new settings is always evil, and adds to product confusion/complexity.
Adding new syntax is a bit evil in MySQL's case since they use a generic yacc parser, and might have to add a new reserved word (truthfully, I'm not 100% sure on that one). There is also a preference to only add reserved words to major new versions.
What does this bug cause?
The bug requests that the table definition written to the dump file by this utility not contain the current value of the AUTO_INCREMENT sequence when the option to dump only definitions, not data, is used.
Nonetheless, it's a lot more complicated than it would seem to "just reclaim the space".
In our use case we're making very heavy usage of table partitioning (over 500 partitions for some of our very large tables). Because each partition is effectively another table under the covers, if we were to use innodb_file_per_table then we'd have tens of thousands of files. This means a lot more file handles being opened/closed (as well as the obvious ulimit gotchas for the uninitiated). This noticeably hampered query performance when seeking data from random partitions.
Current shop is not running file_per_table, and has little reason to do so at ~30GB database file size. Still, dropping the table and not reclaiming any space was a rude awakening. Combine that the fact that storage was an AWS EBS sized pretty close to its limit (50GB). I could not perform two iterations of a test import without first rm'img the file. Lame.
Switched to postgresql now - just works!
Also, the SQL syntax is usually a pain to get it first (MySQL is much more tolerant for a newcomer)
And yes, PSQL commands usually work in MySQL (except for the specific stuff, like \dt but that's not even SQL so...)
I find it much easier from an admin and dev perspective. It is less forgiving, that is correct, but that's a good thing. Oh and the documentation is wonderful compared to MySQL.
Plus it works properly.
http://grimoire.ca/mysql/choose-something-else
He also is hating on PHP in that article, which seems like prime HN bait, because as it does every time there is a PHP hate article on here, everyone actually doing real work comes and and says 'Okay, have fun with your rubies and nodes'.
With all that said, recently a lot of our data has started to be organized outside of MySQL (a lot more Couchbase and Solr usage), but MySQL is still there driving the core data. I'd say it all boils down to right tool for the job.
Please feel free to use as-is and integrate it into mysqldump. I can't be bothered to create an account on bugs.mysql.com.
--
[1] http://pastie.org/8092330 (EDIT: The parser wasn't fully correct, use [2])
[2] http://pastie.org/8092403
Note: That code will require a bit of modification if you make the mistake of having spaces in your table name.
The existing behavior makes more sense anyway, as it preserves 'truncate table' <=> 'restore nodata dump' equivalence better.