Here are the slides and video for my MySQL UC ignite talk on measuring the performance of SSDs.
You can find this talk and other mostly technical material at http://tokutek.com/technology/.
This research was funded in part by the National Science Foundation.
My new job with Calpont has me scrambling to learn all the facets
of the InfiniDB storage engine. For those of you new to
the scene, InfiniDB is column-orientated as opposed to
row-orientated and is designed for data warehouses and business
intelligence. Most MySQL DBAs are probably not used to thinking
sideways and hopefully this series of postings will change
that.
To make things interesting, I am using real data from BP's
Statistical Review of World Energy 2009. The
data is a historical information on various forms of energy. And
it is free to download and comes in Excel workbook format. I
wanted data that was unfamiliar to me and in a format that would
be commonly used in a BI setting.
The first step is to obtain and install the …
Did you ever have the need to find the maximum value of an integer in MySQL? Yeah, me neither. Anyway, some people seem to need this, and this is what I came up with:
[Read more]
SELECT ~0 as max_bigint_unsigned
, ~0 >> 32 AS max_int_unsigned
, ~0 >> 40 AS max_mediumint_unsigned
, ~0 >> 48 AS max_smallint_unsigned
, ~0 >> 56 AS max_tinyint_unsigned
, ~0 >> 1 AS max_bigint_signed
, ~0 >> 33 AS max_int_signed
, ~0 >> 41 AS max_mediumint_signed
, ~0 >> 49 AS max_smallint_signed
, ~0 >> 57 AS max_tinyint_signed
\G
*************************** 1. row ***************************
max_bigint_unsigned: 18446744073709551615
max_int_unsigned: 4294967295 …
Moving, copying or renaming database is a very basic activity. I have just noted a few commands for reference to quickly follow the required operation. 1. Rename database on Linux…
The post Steps to Move Copy Rename MySQL Database first appeared on Change Is Inevitable.
One of my first angel investments, GroupCard, has been acquired by InComm as announced on their blog, VentureBeat, and TechCrunch. It’s been a pleasure watching their team and business grow and I look forward to seeing what they come up with in the future. Hat tip to my consigliere, Matt Bartus, for the original introduction.
If you were at last month's MySQL conference, you might have seen a small flyer we were distributing, titled "A brief introduction to Goal-Driven Performance Optimization." This is a super-compressed technical introduction to one of the methods we use to solve problems as quickly and efficiently as possible. We've just posted this on a new white-paper section of our website. No registration is required; it's just a downloadable PDF.
Entry posted by Baron Schwartz | No comment
Add to: …
[Read more]If you’re on software with a support contract, you should get support, right?
If the software you have support on has a documented feature that’s not working as documented, then you would expect to get a fix, a workaround, or even perhaps an explanation to the effect that you misunderstood the documentation in the first place, and the feature in fact does something else. Correct?
And if the feature in question is a customization facility, then you wouldn’t expect support on the customization itself, but you would expect the customization interface to work as documented, right?
So in summary, if you ran into an issue with a customization interface not working as the documentation says, you’d expect support to fix the interface, suggest a workaround, or provide additional documentation?
Well, I would.
SugarCRM appears to see things …
[Read more]| After the MySQL Conference, while most of my European colleagues were busy with volcanic disruptions and seeking alternative routes to the Old Continent, I headed to Las Vegas, to attend Collaborate10 a conference different from the ones I have been used so far. |
Collaborate10 is the conference of the Oracle Users Groups. I had been asked to participate with a few talks on MySQL, and I was curious of meeting this for me new organization. I prepared three talks, one introduction to MySQL and two advanced ones, and thus equipped I ventured …
[Read more]| After the MySQL Conference, while most of my European colleagues were busy with volcanic disruptions and seeking alternative routes to the Old Continent, I headed to Las Vegas, to attend Collaborate10 a conference different from the ones I have been used so far. |
Collaborate10 is the conference of the Oracle Users Groups. I had been asked to participate with a few talks on MySQL, and I was curious of meeting this for me new organization. I prepared three talks, one introduction to MySQL and two advanced ones, and thus equipped I ventured …
[Read more]| After the MySQL Conference, while most of my European colleagues were busy with volcanic disruptions and seeking alternative routes to the Old Continent, I headed to Las Vegas, to attend Collaborate10 a conference different from the ones I have been used so far. |
Collaborate10 is the conference of the Oracle Users Groups. I had been asked to participate with a few talks on MySQL, and I was curious of meeting this for me new organization. I prepared three talks, one introduction to MySQL and two advanced ones, and thus equipped I ventured …
[Read more]