• Percona Live: MySQL Conference And Expo 2012 - a note on proposals

    November 29, 2011

    As a member of the conference committee I review the session and tutorial proposals for the Percona Live MySQL conference in Santa Clara, 2012. The sessions are expected to be technical, and I'm happy the proposals follow this guideline. I use Giuseppe's and Baron's general guidelines for submitting a proposal. I wish to humbly add […]

  • Reading results of SHOW statements, on server side

    November 25, 2011

    SHOW statements are show stoppers on server side. While clients can get a SHOW statement as a result set just as any normal SELECT, things are not as such on server side. On server side, that is, from within MySQL itself, one cannot: SELECT `Database` FROM (SHOW DATABASES); One cannot: DECLARE show_cursor CURSOR FOR SHOW […]

  • Xfce is the new Gnome 2

    November 22, 2011

    I've recently had it with Ubuntu's Unity. Wait, why Unity? Because my gdm was consuming so much CPU my laptop had its fan working non-stop. I've researched and tweaked and installed and removed - and finally moved to Unity to solve that. There may have been another solution, but that's an old story now. Thing […]

  • Quoting text JavaScript/Python style

    November 15, 2011

    Unless your MySQL is configured to use ANSI_QUOTES in sql_mode, you are able to quote your text in one of two forms: using single quotes or double quotes: UPDATE world.Country SET HeadOfState = 'Willy Wonka' WHERE Code='USA' UPDATE world.Country SET HeadOfState = "Willy Wonka" WHERE Code="USA" This makes for JavaScript- or Python-style quoting: you quote […]

  • Oracle ACE

    November 4, 2011

    I am honored to have been nominated for, and to have received the Oracle ACE award. Nomination for this award is made by Oracle community members, and in this case those being Oracle employees Keith Larson and Dave Stokes. The award is given by Oracle for my involvement in the Oracle/MySQL community and for my […]

  • Self throttling MySQL queries

    November 1, 2011

    Recap on the problem: A query takes a long time to complete. During this time it makes for a lot of I/O. Query's I/O overloads the db, making for other queries run slow. I introduce the notion of self-throttling queries: queries that go to sleep, by themselves, throughout the runtime. The sleep period means the […]

Powered by Wordpress and MySQL. Theme by openark.org