|Showing entries 1 to 15|
While wearing my hat of Sales Engineer, I have been asked several times what is the difference between InnoDB and MySQL Cluster/NDB and when it makes sense to use one storage engine or the other. Some may probably think that this is a trivial question: the two engines are so different that there is really no point to compare them. The reality is not so clear though: there are many situations where I have found InnoDB stretched to the point where MySQL Cluster would have been a perfect fit, and other occasions were users implemented a solution based on MySQL Cluster and InnoDB would have been the perfect choice.
This is the reason behind my talk at the MySQL User Conference in Santa Clara: InnoDB vs NDB. I will co-present the session with my good old friend and ex-colleague Johan Andersson – if you know Johan, you may guess who will take[Read more...]
MySQL stored routines (functions, procedures, triggers and events) can be useful. But many casually written stored routines are unnecessarily slow. The[Read more...]
mysqldumpcommands for backing up individual partitions of the tables in the current schema. The script is maintained as a snippet at MySQL Forge.
Dear Kettle & MySQL fans!
I’m really looking forward to go to the MySQL User Conference next week, not just because I’m speaking in 2 sessions again, but perhaps also because these are “interesting” times for MySQL and Sun Microsystems. Pivotal times it would seem.
Here are the 2 sessions I’m going to do:
My name is Karl Van den Bergh — I do Business Development here at Kickfire. I’ll be joining Raj on our corporate blog adding my comments to what is happening at our company and in our marketplace.
What a great conference (my first) and what a great venue it was to have launched our company and beta product.
Now that I have switched from the dark side of commercial software to the open source world, my eyes have been opened to the power of the community. Specifically, the success of our launch can, to a large degree, be attributed to the community.
Over the last couple of weeks I have heard comments in the blogosphere to the effect that Kickfire has a great marketing machine. One blog noted that Kickfire had “brought Web 2.0 Marketing to the Database World.” Whereas our marketing team will certainly take pride in these comments (and should for all the hard work that went[Read more...]
TABLE_CONSTRAINTStable in the MySQL
information_schema. The task was:
CASEstatement syntax: the so-called simple case and the searched case.
WHEN...THENbranch by comparing the value [Read more...]
|Showing entries 1 to 15|