Releasing and announcing software is win! I’ve had this bumming around for a bit, and for me (and I think others hacking on MySQL) it’s been rather useful. Simple plugin that takes each email in an mbox, applies the patch and commits it with the correct author to a bzr repo. Very useful if you use quilt and bzr together (“quilt mail –mbox” and then “bzr importmbox”).
I finally published it up at:
http://launchpad.net/bzr-importmbox
enjoy.
When I did NDB Cluster engagements, it happened a few time that I had to cover the NDB API. Once, a customer asked an example on how to perform a simple scan. Remembering that some examples are within the NDB source tree, under ./storage/ndb/ndbapi-examples/ and I decided to take a look, why writing something when a good example already exists... I was not expecting what I found!
1. Missing headers
$ make
g++ -g -O0 -c -Wall -fno-rtti -fno-exceptions -I/usr/include
-I../../../../include -I../../../../storage/ndb/include
-I../../../../storage/ndb/include/ndbapi ndbapi_scan.cpp
ndbapi_scan.cpp: In constructor ‘Car::Car()’:
ndbapi_scan.cpp:111: error: ‘memset’ was not declared in this
scope
ndbapi_scan.cpp: In function ‘void drop_table(MYSQL&)’:
ndbapi_scan.cpp:124: error: ‘exit’ was not declared in this
scope
ndbapi_scan.cpp: In function ‘void …
This is far from deeply technical but little things that should
be simple but aren’t annoy me. I found that MySQL
Sandbox --prompt_prefix and
--prompt_body don’t “just work.” I wanted the prompt
to be mysql \v> . So I tried:
make_sandbox_from_source /mysql/src/mysql-4.0.30 single
--prompt_body=' \v> '
sh: -c: line 0: syntax error near unexpected token
`newline'
sh: -c: line 0: `make_sandbox /mysql/src/mysql-4.0.30/4.0.30
--prompt_body= \v> '
Maybe my shell knowledge is more terrible than I realize so I
verified that ‘ \v> ‘ does not need special
escaping:
echo ' \v> '
\v>
Ok, so clearly it’s the fault of
make_sandbox_from_source. I tried and tried to do
this on the command line but …
I'm pleased to announce the release of Memcached Functions for
MySQL version 1.1. I realized in the past few weeks, while
writing my latest book "Expert PHP and MySQL", that there was no way
to obtain the CAS value of a cached item in order to successfully
use the function memc_cas(). So, I decided to create
a new function, memc_get_cas(), which obtains the
CAS value for an item so you can subsequently use this value in a
memc_cas() call, which is shown in the example
below:
mysql> select memc_get_cas('t1');
+--------------------+
| memc_get_cas('t1') |
+--------------------+
| 3 |
+--------------------+
1 row in set (0.00 sec)
mysql> select memc_get('t1');
+----------------+
| memc_get('t1') |
+----------------+
| new value |
+----------------+
1 row in set (0.00 sec) …[Read more]
Welcome to Profiling InfiniDB Multi-Join, part of a series designed to highlight different aspects of the InfiniDB join capabilities. InfiniDB is engineered and optimized to execute join operations for millions or billions of rows using a number of key features:
Hash Joins.
Parallel processing (multi-threaded and optionally
distributed).
Join sequencing to minimize data shipping costs. (Right-deep join
tree instead of left-deep).
InfiniDB multi-join (stream 1 large table past up to 60 hRead
More...
Welcome to Profiling InfiniDB Multi-Join, part of a series designed to highlight different aspects of the InfiniDB join capabilities. InfiniDB is engineered and optimized to execute join operations for millions or billions of rows using a number of key features:
Hash Joins.
Parallel processing (multi-threaded and optionally
distributed).
Join sequencing to minimize data shipping costs. (Right-deep join
tree instead of left-deep).
InfiniDB multi-join (stream 1 large table past up to 60 hRead
More...
You can now yum (RPM) or apt-get (DEB) MariaDB 5.1.39, courtesy of OurDelta and in close cooperation with Monty Program Ab. Simply follow the info on the CentOS, Debian or Ubuntu pages.
(note: give the mirrors some hours to sync up)
Quick overview
You used to use mk-query-digest to aggregate and report on MySQL’s slow query log. Then it got the ability to grab query events from polling SHOW PROCESSLIST. Next we thought, really, how hard can it be to implement the libmysql wire protocol, so we can sniff TCP packets? … it’s hard, but not that hard as it turns out. But why stop there, why not implement memcached protocol too? I think you can see where this is headed.
So now mk-query-digest is a tool that can understand and “do stuff with” a variety of query/response types of information. The latest is HTTP. HTTP traffic is just a query-response flow of events, perfectly suitable for response-time analysis. Example:
baron@kanga:~$ mk-query-digest sample-http.txt --type http
# 1.6s user time, 100ms system time, 14.20M rss, 17.07M vsz
# Overall: 56 total, 30 unique, 1.27 QPS, 0.06x concurrency ______________
# …[Read more]
Last week I attended the Enterprise LAMP Summit and Camp in Nashville, Tennessee. I enjoyed the event and met or reconnected with a lot of great people. I was glad to be able to spend time with some folks from the Postgres community. My own sessions focused on MySQL.
During the Summit I tried to help people understand how to think about performance, and made the case that the Percona versions of the MySQL server are not only the highest-performance available, but uniquely provide the instrumentation necessary to follow a disciplined performance optimization process such as Method R or Goal-Driven Performance Optimization.
At the Camp the next day, there were several sessions on MySQL. My talk was later in the day, so I elected to skip …
[Read more]We’ve been trying to get the OSX version of Kontrollbase off the ground and running for those of you who run OSX or OSX Server but have run into various issues. As such, we’re looking for a talented PHP and/or Perl coder that knows the internals of OSX so that he/she can maintain a branch [...]