Using mysql command line utility to get recordsets, the data rows alignment and line breaks are often a mess. You can use the command line tool on a mysql database server to get a set of rows into an output TSV file like so: shell> mysql -u your_user -p < your_statement.sql > data.csv I came up with the following python script to grab the output file and pretty print:
You can put your own
Booking.com, one of the world’s leading e-commerce companies, helps travels book nearly 1 million rooms per night. Established in 1996, Booking.com B.V. guarantees the best prices for any type of property, from small, family-run bed and breakfasts to executive apartments and five-star luxury suites.
The travel website is also a dedicated contributor to the MySQL and Perl community. Other open source technologies include CentOS Linux, Nginx, python, puppet, Git and more.
A Diamond sponsor of Percona Live Amsterdam Sept. 21-23, you can meet the people who power Booking.com at booth 205. Enter promo code “BlogInterview” at registration to save €20!
In the meantime, meet Jean-François Gagné, a system engineer at Booking.com. He’ll be presenting a couple of talks: “ …
[Read more]
Hi Daniël,
Very good point, and apologies for not replying sooner, holidays,
but more importantly, I wanted to reply with a confirmation:
you’re absolutely right. I upgraded my old workbench to 6.3.4,
which comes with SYS 1.4.0 and hey presto, 19 new tables in SYS,
of which:
+————–+———————+————–+
| column_name | table_name | table_schema |
+————–+———————+————–+
| waiting_pid | innodb_lock_waits | sys |
| blocking_pid | innodb_lock_waits | sys |
| waiting_pid | x$innodb_lock_waits | sys |
| blocking_pid | x$innodb_lock_waits | sys |
+————–+———————+————–+
I’ll see if we can get/propose something similar for NDB tables &
locks…
Thanks.
Today, Devart is proud to announce the release of a new product – dbForge Data Generator for MySQL v1.0!
There can be a lot of confusion and lack of planning in Percona XtraDB Clusters in regards to nodes becoming desynchronized for various reasons. This can happen a few ways:
When I say “desynchronized” I mean a node that is permitted to build up a potentially large wsrep_local_recv_queue while some operation is happening. For example a node taking a backup would set wsrep_desync=ON during the backup and potentially fall behind …
[Read more]
A couple of months ago I wrote about how you can use the MDX
functions Ancestors() and Ascendants to retrieve the full lineage of
members. (See: "MDX: retrieving the entire hierarchy path with
Ancestors()".)
As you might recall, the immediate reason to write about those
functions was to find a pure MDX solution to implement the "Show
Parents" / "Hide Parents" functionality offered by OLAP cube
browsers. To recap, developers of MDX-based pivot tables face a
challenge when rendering the result of a query like this:
[Read more]
SELECT CrossJoin(
[Product].[Product].Members,
…
We will have three presentations about new coming Galera Cluster 4.0. The presenter will be Seppo Jaakola, CEO and co-founder of Codership and Philip Stoev, QA and Release Manager for Galera Cluster for MySQL
Big Transactions on Galera Cluster
22 September 3:10PM – 4:00PM @ Lausanne
Big and long term transactions have traditionally not behaved well in Galera Cluster. Large replication data sets have resulted in symptoms like elevated conflict rate, increased memory consumption, even OOM kill may happen, flow control pausing, cluster freezing… To deal with these issues, Galera users have been adviced to split large transactions in “reasonable size”. There is also cluster configuration option for rejecting too large transactions, as a safe guard.
This presentation explains the new large transaction replication method in Galera Cluster 4.0, which can now replicate transactions of any size, with minimal …
[Read more]In my last Booking.com Hackathon, I worked on MyISAM vs InnoDB for data loading (LOAD DATA IN FILE) and bulk index creation. My motivation was the following: knowing that some are still using MyISAM for this particular use-case, I wanted to verify/understand if/why InnoDB is slower than MyISAM. I do not yet have complete results on this specific subject but I found some interesting things that
This Log Buffer Edition covers Oracle, MySQL, and SQL Server blog posts from the last week.
Oracle: