First meetup!

Lets get the first one done. We're seeking the use of some facilities in the area but failing that we can resort to the Watershed which is a great meetup venue anyway.

I'd like to open with finding out about who's out there, what use is MySQL in this part of the world? Are you using MySQL in a heterogenous environment or are you purist RDBMS users without need of noSQL paradigm?

We've got great sponsors lined up with some superb prizes to raffle off including a Percona Live London ticket for this year. We've got t-shirts and books also coming. What are you waiting for? :)

If you have any suggestions or a burning desire to present something at our user group meeting please get in touch.

 

 

Join or login to comment.

  • A former member
    A former member

    Well as you are asking ;) .... I have a requirement for transitory tables (ones that hold information whilst the system is up, then can be disposed of if MySQL is taken down). Back in MySQL 4.1, I looked at HEAP tables as I wanted them to remain in memory and not hit disk at all. However, they were slower than disk tables back then !

    Do you know if HEAP has been improved, or if there is a better way to hold temporary information in RAM, without using disk access ?

    August 16, 2013

    • Andrew M.

      Adrian, HEAP tables, now known as MEMORY still exist. When you mention they were slower I can't really comment. I'm aware that over version upgrades I've seen that MEMORY engine has had some improvements. It's also worth mentioning that MEMORY locks at table level, so the same limitations around concurrency as MyISAM. I'd say worth a test and we can chat about the results next meetup ;-)

      August 16, 2013

  • Ben M.

    Ahh that's a shame, it's cool you're looking at InnoDB though, it would be great to hear how you get on in the next meetup. In the meantime, if you have any questions, feel free to post to the discussions, or mail us.. ..also if you find it generates any topics you'd like to discuss in the next session or if there are any other topics that come up that you'd like to look at, just let us know..

    August 16, 2013

  • A former member
    A former member

    Thanks for the info Ben :) ... I am in the process of mucking about with InnoDB. Had a look at TokuDB, but the downloads are Linux only, we work in Windows :(((

    August 16, 2013

  • Ben M.

    Cont....

    When it comes to configuration the MySQL documentation has a great reference (I bookmark this and look it up regularly to clarify different options/variables):

    http://dev.mysql.com/doc/refman/5.5/en/mysqld-option-tables.html

    Also, Adrian, in addition to InnoDB you might want to check out the TokuDB storage engine as well as it could be very suited to the usage you described..

    http://www.tokutek.com/products/tokudb-for-mysql/


    Hope this is useful, again it was great to see you all and I'll be looking forward to the next meetup.

    August 16, 2013

  • Ben M.

    Hey all, I just thought I'd include some linkage for some of the topics we touched on.. A couple of posts on InnoDB vs MyISAM:
    http://www.mysqlperformanceblog.com/2009/01/12/should-you-move-from-myisam-to-innodb/
    https://blogs.oracle.com/MySQL/entry/comparing_innodb_to_myisam_performance

    A good overview of InnoDB, and how it works:
    http://vimeo.com/20990641
    http://www.mysqlperformanceblog.com/wp-content/uploads/2010/04/InnoDB_int.png

    Percona Toolkit (and direct link to pt-query-digest):
    http://www.percona.com/software/percona-toolkit
    http://www.percona.com/doc/percona-toolkit/2.2/pt-query-digest.html

    Another toolkit we didn't mention but is also good to review is the OpenArk toolkit:
    http://openarkkit.googlecode.com/svn/trunk/openarkkit/doc/html/introduction.html

    1 · August 16, 2013

  • Marti

    Very informative and open to questions of all sorts, thanks guys!

    August 16, 2013

  • Andrew M.

    Gents (and any ladies planning on attending), we're currently in the Watershed in the corridor-esc area out the back (past the bar). It's quiet with room to swing a few cats at the moment. I elected not to wear the previously advertised t-shirt but keep your best eye out for sticker-littered laptops. :)

    A

    August 15, 2013

  • Andrew M.

    Hey guys, I'm going to get there early enough to get some good real estate. Outside the old 'red carnation' wearing technique, I'll probably have on a white T-Shirt with 'Love your Data' on the back and I'll likely be tapping away on my laptop with loads of stickers on the lid. Failing that, watch my twitter account @mysqlboy and I'll post exactly my location. Grazi! Andy

    August 15, 2013

  • A former member
    A former member

    Im planning to be there :) As per Marti's question, where am I going once in the Watershed ? Is there going to be any signs ?

    August 15, 2013

  • Ben M.

    Hey guys, just to confirm I'm going to attend to, see you there at 7pm!

    August 15, 2013

  • Marti

    Hi guys, I am planning on coming along tonight. Can you confirm that it is 7pm and is there a special room or right in the bullpit of the upstairs cafe? I don't know what any of you look like apart from meetup photos! Cheers

    1 · August 15, 2013

  • Andrew M.

    Agenda(ish), or something to think about in advance;

    MySQL is a freebie from the internet and for some reason people think they can deploy it in large scale environments. Some people even struggle with it in small scale deployments. What are they doing wrong? Configuration is key to survival. We can discuss some of the gotchas from under configuration.

    We'll also give some info about;
    - Upcoming MySQL events of note.
    - MySQL Training and Certification, is it worth it?
    - General MySQL resources, how the MySQL DBA does.

    August 14, 2013

  • A former member
    A former member

    OK see you at the Watershed ? at 7pm on the 15th

    July 30, 2013

    • Andrew M.

      Adrian, are coming along tomorrow?

      August 14, 2013

  • Andrew M.

    Hey all, upcoming meetup this Thursday. I'll be in the Watershed from 6.30ish. I want to get a loose agenda together so please let us know if there are any burning desires to be added. Everything is welcome for discussion, novice to advanced. Looking forward to see in you all there.

    August 13, 2013

  • Andrew M.

    Date adjusted.

    July 30, 2013

  • Andrew M.

    Okay...Ben and Thomas. I want to suggest moving this date back further into August as there's not been much commitment to the date probably because of the time of year, holidays and such. Another member suggested the 15th which is a Thursday + I am awaiting some goodies from some sponsors which would be good to reward you loyalists with. I'll change the date on the meeting if that suits you both? Please let me know.

    July 29, 2013

  • A former member
    A former member

    Thu 15th or 22nd ?

    July 10, 2013

  • A former member
    A former member

    Damn ! Really wanted to attend but in Tunisia 4-14 Aug :(

    July 9, 2013

    • Andrew M.

      Well Adrian we're not stuck on dates. The place holder date was used as a catalyst to attract some members. Please spread the word and let us know what's a good date?

      July 9, 2013

4 went

Our Sponsors

  • Basekit

    Our friends at Basekit host our meetups and provide refreshments++

  • Percona

    Percona are offering lots of goodies,tshirts,prizes and guest speakers.

  • Pythian

    Pythian are kindly sending over some SWAG from the HQ in Ottawa, Canada

  • Oracle

    Oracle's community manager Dave '@Stoker' Stokes is going to send stuff!

People in this
Meetup are also in:

You don't have to be an expert to start your own Meetup G roup

Get started Learn more
Katie

I'm surprised by the level of growth I've seen since becoming an organizer, it's given me more confidence in my abilities.

Katie, started NYC ICO

Start your Meetup today

Act now and get 50% off.
Until February 1.

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy