|
Planet MySQL
|
Planet MySQL - http://www.planetmysql.org/
|
-
Farewell CHM, hello EPUB!
For a long time, the MySQL Documentation Team has been providing CHM files for most MySQL documentation we publish. Like many other formats, CHM-format docs can be downloaded from http://dev.mysql.com/doc. CHM (Compiled HTML Help) has been the de facto standard help file format on Windows since 1997, but the technology behind it is outdated and has all kinds of quirks. The successor format introduced with Windows Vista is AP Help, but it hasn't taken off in practice so far. So, with CHM being outdated and AP Help spread anything but widely, lots of vendors have started providing documentation on Windows...
-
VLDB 2010
I will be at VLDB 2010 next week. If anyone on this blog is attending and wants to catch up to discuss start ups and innovation in DB, NoSQL, Big Data etc drop me a line and I will try to meet up.
-
XS4ALL offer IPv6 connectivity to retail customers
Good news. I was told by a colleague that the Dutch ISP XS4ALL is offering IPv6 connectivity to its retail customers. You can see here although the comments are in Dutch. They also provide a list of ADSL routers which should work for their service. The Cisco name may not be surprising but this is good publicity for Draytek and AVM FRITZ!box for their products. Hopefully it will also stimulate other SOHO router providers into the act to get their names on the list. Let us hope that more ISPs start to offer this sort of service to their customers.
I’m...
-
Integrating MySQL and Hadoop - or - A different approach on using CSV files in MySQL
We use both MySQL and Hadoop a lot. If you utilize each system to its strengths then this is a powerful combination. One problem we are constantly facing is to make data extracted from our Hadoop cluster available in MySQL.
The problem
Look at this simple example: Let’s say we have a table customer:
CREATE TABLE customer {
id UNSIGNED INT NOT NULL,
firstname VARCHAR(100) NOT NULL,
lastname VARCHAR(100) NOT NULL,
city VARCHAR(100) NOT NULL,
PRIMARY KEY(id)
}
In addition to that we store orders customers made in Hadoop. An order includes: customerId, date, itemId, price. Note that these structures...
-
Micro-benchmarking pthread_cond_broadcast()
In my work
on group
commit for MariaDB, I have the following situation:
A group of threads are going to participate in group commit. This means that
one of the threads, called the group leader, will run
an fsync() for all of them, while the other threads wait.
Once the group leader is done, it needs to wake up all of the other threads.
The obvious way to do this is to have the group leader
call pthread_cond_broadcast() on a condition that the other
threads are waiting for with pthread_cond_wait():
bool wakeup= false;
pthread_cond_t wakeup_cond;
pthread_mutex_t wakeup_mutex
Waiter:
pthread_mutex_lock(&wakeup_mutex);
while (!wakeup)
...
|
