There is a new feature in the MariaDB 10 Beta which caught my
eye: support for returning a result set on delete.
With a 'regular' DELETE operation you only get to know the number
of affected rows. To get more info or actions you have to use a
trigger or a foreign key. Anoter posibility is doing a SELECT and
then a DELETE and with the correct transaction isolation a
transactional support this will work.
With the support for the RETURNING keyword this has become easier
to do and it will probably bennefit performance and save you a
few roundtrips and a few lines of code.
There is already support for RETURNING in PostgreSQL. And
PostgreSQL has an other nifty feature for which RETURNING really
helps: CTE or common table expressions or the WITH keyword. I
really hope to see CTE support in MySQL or MariaDB some
day.
…
|
I'm speaking next week at Percona Live in in London. My talk will be almost about MySQL
Performance (of course), covering major MySQL 5.6
improvements and latest findings made in MySQL 5.7 for today.
Percona Server 5.6 and MariaDB 10 will not be missed as
well.. - we're living very interesting times, and performance
topic is amazing today as never ;-) As usually, I'll tell you "one more thing" about MySQL Performance latest news that you cannot read or find anywhere else.. - so, stay tuned ;-) Rgds, -Dimitri |
Attending Percona Live in London next week?
Don’t miss the chance to hear Tokutek’s Vice President of Engineering, Tim Callaghan, discuss how to use your MySQL knowledge to become an instant MongoDB Guru and the advantages of using Fractal Tree® indexes in MySQL and MongoDB. Tim will be speaking about these topics in two separate sessions at 12:00pm and 5:00pm on November 12.
For more information on these sessions and Percona Live-London, visit https://www.percona.com/live/london-2013/users/tim-callaghan.
The Colorado MySQL meetup is getting together on November 11th.
Location: Oracle 500 Eldorado Boulevard, Broomfield, CO
All MySQL users and interested parties are invited to participate and attend the following activities!
Monday, November 11, 2013
From 6:00PM to 8:30PM
-
Oracle Broomfield Office
Building 1 – Demo 1127 Conference Room
500 Eldorado Blvd
Broomfield, CO 80021Schedule:
6PM Meet, Greet, and Eat
6:30-45 – Intro’s/Updates
6:45-7:30 – Session 1 – MySQL 5.6 and Cluster Update – Lee Stigile, Oracle
7:30-8:15 – Session 2 – MySQL and Hadoop Integration – Dave Smelker, ADURANT Technologies
8:15-8:30 – Closing
For further information, please contact:
George Trujillo
Email: [masked]
Cell: [masked] …
Syndicated from Serge's Blog: http://serge.frezefond.com/2013/11/mariadb-connect-storage-engine-replay...
MariaDB CONNECT Storage Engine replay & slides available
The slides and replay of yesterday’s webinar on the MariaDB
CONNECT storage engine have just been posted. First I want to
thank the numerous attendees.
You have shown great interest on the parallel execution of query
on distributed MySQL Servers. I agree this is cool.
I have just finished the MySQL 5.6 DBA Certification Exam Beta and my best advice is to study, study, study. The exam is in beta which means three things. The first is the exam is three hours long and it took me all that time to finish. Normally I am very fast test taker which has helped me earn three college degrees and enough computer related certifications to wallpaper a decent sized house. So if you are a slow reader, suck down a gallon of high octane coffee before your test appointment.
Secondly consider that some of the question will need to be cut out or reworked as the exam becomes production to fit the normal two hour test window Pearson View prefers. But in the beta period you over test and cut out the questions that prove less than satisfactory. So if you see a questions that triggers the ‘where the heck did they find that?’ reflex, you can hope that it gets determined to be a question to be relegated.
…
[Read more]This week we explore MySQL Workbench further. Ear Candy is Stewart Smith's 'libeatmydata' and At the Movies is a video to help folks familiar with SQL learn how to use Riak's MapReduce.
Events
DB Hangops -
every other Wednesay at noon Pacific time
MySQL Tech Tour Tokyo Nov 27th 2013
MySQL and Linux tech event in Atlanta Dec 5,
2013
There are a number of technologies, apps, and social media creations out there seeking to displace blogs as the mode of sharing between surfers, but blogging has proved hardy. It has proven its mettle and it’s here to stay. This Log Buffer Edition appreciates this strength of the blogs.
Oracle:
Translating Fusion Apps Customizations: Composers mean Usable Apps in Any Language, Ultan o’Broin has more.
Do you find yourself trying several times to explain a problem in a Service Request? Does the support engineer ask more than once for clarification?
What If I Don’t Get An Exam Results …
[Read more]The slides and replay of yesterday’s webinar on the MariaDB CONNECT storage engine have just been posted. First I want to thank the numerous attendees. You have shown great interest on the parallel execution of query on distributed MySQL Servers. I agree this is cool. The ODBC capabilities seems also to generate interest. This make [...]
Fri, 2013-11-08 10:32robertsilenSponsored by Team MariaDB
The MySQL Community Dinner has been moved to Masala Zone in Covent Garden - a good 20 minutes by public transport from Percona Live London.
Not to worry! We've hired a traditional double decker bus to get you to the MySQL Community Dinner in style!
The MariaDB bus will be waiting to take you at 7.30pm outside Hereford Arms pub, the venue for MariaDB's free bar, just around the corner from Percona Live London.
Drop by for a few beers and enter a free prize draw where you could win a cool, BoomBox bluetooth speaker system
What? Free drinks and bus to the MySQL Community
Dinner
When? Free bar from 4pm, prize draw at 6.45pm, bus pick-up
at 7.30pm
Where? Hereford Arms, Gloucester Road - just 2 mins walk
from Percona Live London
P.S. Even if you're not attending to the the MySQL Community Dinner, consider it …
[Read more]