just managed to run the first join inside the data-nodes.
the query correspondce to
SELECT t1.*, t2.*
FROM T1 t1
LEFT OUTER JOIN T1 t2 on t1.pk = t2.pk
WHERE t1.pk = avalue
- the code inside the data-nodes is general...but incomplete (e.g
leaks memory, doesnt handle error correctly...)
- there is no ndbapi and no SQL,the program testing is a
hard-coded c-program sending messages using the ndb-cluster
wire-protocol
- the result-set is not managed (the c-program just hangs)
Summary:
- there is *many* things left to do, when this will actually hit
a release is very uncertain (or if it ever will...)
- this is the coolest thing i implemented in a long long
time
Details:
- the code is written so that the query and the parameters are
sent separately so that we in the future could have the queries
permanently stored in the data …
I caught up with Marc Delisle (we have a relatively old interview with him on the MySQL DevZone) recently, and got him to give us an introduction to phpMyAdmin, the several books he’s written, and how the project gets new features from the Google Summer of Code. What’s really impressive? They continue winning awards (Marc won one from MySQL in 2009 as well!), and have a user base of nearly 18.5 million (this is downloads — not just users, considering how common it is in shared hosting environments). Watch the video for more.
…
[Read more]At the 2009 MySQL Conference and Expo I presented to a full room on MySQL Monitoring 101.
This presentation focused on the following four goals.
- Know what to monitor
- Know how you can monitor
- Learn practices to diagnose problems
- Have a foundation of historical information
MySQL Monitoring 101 View more presentations from Ronald Bradford.
Video for the presentation at the 2009 MySQL Camp:
Top 10 MySQL Pet Peeves and How to Workaround Them
Jeremy Zawodny
Watch it online here:
Download the 106 Mb .mov file at <
Earlier today I did the presentation Memcached Meet Flash, the pluggable engine interface, and if you missed it you can download the slides. It is kind of fun to think back on the hackathon at the users conference the last year when Toru shared his ideas about a storage interface, followed by the interesting discussion I had with Matt during the OpenSolaris summit down in Santa Clara. I didn't know back then that I would present this at the users conference this year :-)
My brother came down for my presentation and took the following picture with his iPhone during the session:
If you have any questions regarding the slides, come look me …
[Read more]The penultimate day of UC exams is slowly coming to an end. A fresh crop of Developer, DBA, and Cluster DBAs certifications have been earned in the eighty plus exams taken today. Tomorrow is the last day for the deeply discounted price of $25 for the examinations. Your Certification Team will be ready at eight tomorrow!
No, this is not about some weird socket issue or a misspelling of
SpockProxy or something like that. I'm talking
about socks.
As some of my readers know, I've been on a backpacking tour across the United States and
Canada visiting universities talking about MySQL. So yes, I'm
literally travelling with a backpack and have all my clothes on
my back. Well. No longer. Apparently my socks have been left
somewhere inbetween Chicago and California. Damn you Sock Gnomes!
It's okay. Rich Taylor of MySQL came to my rescue. I am now sock
happy. Lots of technical MySQL Conf articles, lots of angst right
now, I thought I would post a non-traditional MySQL UC story.
Death to Sock Gnomes!!!!!
The Memcached talk went down well and I was pleased that a number of people said how they could now understand how memcached could help them in their applications. This is really why I do these things - so that others can see the benefits of tools like memcached. It has worked well for us at MySQL.com and it obviously worked well for its originators at livejournal.
Original post blogged on b2evolution.
A complete and unadulterated dump of what was being talked about, I hope I got the right names and people, comment if anything out of sorts here, the Forge links talked about are here: http://forge.mysql.com/wiki/Contributing
The BoF session was hosted by Lenz Grimmer and Tomas Ulin of
MySQL
MySQL Community contributor BoF. About 15 people.
Lenz: Trying to open up, make internal processes trasnsparent,
make discussions public, how does code evolve, reviewed etc
before release. Lenz shows the "golden rules"
transparency - what's going to happen, how it will be accepted,
make it clear to the contributor.
dialog - Lenz admits many patches during the review over the last
few months haven't even been acknowledged and are going through
the backlog to discover whether any dialog has been done wven if
it is to …
Today Allan and I presented "Optimizing MySQL Performance with ZFS" talk at MySQL Conference 2009. You can get the slides here (I have uploaded it to the conference website also)
Like I said during the talk, I will blog about ZFS comparisons with EXT3 when I have a chance to do the tests. Thanks for attending!