We've just released the Community Edition of Citrus Replay which gives you all the features of the Professional Edition, but supports only native connections to MySQL and Firebird Embedded or Firebird Server databases.
I’ve integrated HailDB into our Hudson setup (haildb-trunk on Hudson). I’ve also made sure that Hudson is tracking the compiler warnings. We’ve enabled more compiler warnings than InnoDB has traditionally been compiled with – this means we’ve started off with over 4,300 compiler warnings! Most of those are not going to be anything remotely harmful – however, we often find that it’s 1 in 1000 that is a real bug. I’ve managed to get it down to about 1,700 at the moment (removing a lot of harmless ones).
I’ve also enabled a cppcheck run on it. Cppcheck is a static analysis tool for C/C++. We’ve also enabled it for …
[Read more]
As a followup to my previous post about comparing numeric values,
I've since discovered a little more about the problem. To repeat
my original problem: certain numeric field values that should be
equal are being detected as different in the Filter rows step. I
think it's important to be able to perform accurate comparisons
since it is a frequent task in data quality analysis.
Originally, I assumed this had something to do with jdbc.
However, since I can re-produce the issue without any SQL, I'm
sure this has nothing to do with the version of the MySQL
Connector/J jdbc driver. I tried the 5.0.8 version of the driver
and I observed the same behavior. I couldn't even get my
transform to work correctly with the 5.1.12 version of the
connector -- it does not recognize column aliases in my SQL
query.
Now for the rest of the …
Is MariaDB really a drop in replacement for MySQL? I’m running CentOS 5.4. What happens if…
And the install start mysql up again. Wow. That’s “Drop in”.
If your reading this, you’re seeing it works.
…[Read more]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]