While coding, every second counts. And when the complexity of the database increases, you need to find new ways of speeding up your coding workflow. Let us admit it, we developers prefer to get all our work done using keyboard shortcuts, without having to switch to the mouse.

To streamline your entire coding experience and to speed up database navigation, here are a couple of useful keyboard shortcuts to make the most out of object browser filter in SQLyog.

Keyboard shortcuts:

1. Ctrl + B – sets focus on object browser for operations related to Object Browser.
2. Ctrl + [Up arrow] – brings focus to server/top-most element in Object Browser.
3. Ctrl + E – sets focus to Query Editor to write queries.
4. Ctrl + Shift + B – brings cursor focus on Object Browser filter.
5. Right Arrow – Expand treeview element
6. Left Arrow – Collapse treeview element
…

The Bulgarian Oracle Users Group is holding its spring conference on 17-19 May. I'll be speaking about MySQL 5.6 and MySQL security on it.

There's still time to register (registration ends on 7 May). And the venue is great during this time of the year !

The MariaDB Foundation have just issued press release about the new Governance in the Foundation.  A lot of the new things that is happening in the MariaDB adoption comes thanks to the work we have done in the Foundation.

The Foundation is also happy to announce that is has now 2 senior MySQL (now MariaDB) developers on board, Alexander Barkov and Sergey Vojtovich and a documentation writer, Ian Gilfillan.

The foundation is also helping founding the new Connect engine, which allows you to use MariaDB with a lot of different formats (XML, CVS, DBF,...), and connections, including ODBC. (Documentation will appear shortly …

This blog post is part two of two. Like part one, published Wednesday, this is a cross-post from Groupon’s engineering blog. Thanks again to Kyle Oppenheim at Groupon. And one more reminder that I’ll be at the Percona Live MySQL Conference and Expo next week in Santa Clara, California so look for me there. You can checkout the sessions I’ll be leading here.

In my last post, I described a solution for keeping the caches of a MySQL standby server hot using MySQL slow logs with …

Adzuna is a fast growing search engine for classified ads specialized in jobs, properties and cars. Headquartered in the UK and launched in 2011, Adzuna searches thousands of sites and tens of millions of ads to make it very easy to find the perfect job, home or car locally. It furthermore provides a wealth of statistics such as salaries trends graphs and comparisons, geographic jobs maps, house prices...and more. Additionally, Adzuna is integrated with Facebook and LinkedIn and shows open vacancies one is connected to through his/her own network. The search engine powers a number of government applications and is integrated into the UK's Prime Minister economic dashboard.

Challenges

• When Adzuna's founders were selecting the database powering the search engine's architecture, they were planning for scalability and reliability. Not only did they expect fast …

The MariaDB Foundation, stewards of the community-maintained open source MariaDB database that is sweeping the Internet, announced today the next steps towards a community-managed governance structure. With the appointment of a new, enlarged Board of Directors and a new interim chief executive, the MariaDB Foundation is now on track to a fully member-led governance in the second half of 2013.

The Board members are now Rasmus Johansson, Andrew Katz, Simon Phipps, Michael “Monty” Widenius, and Jeremy Zawodny. The first act of the new interim Board was to appoint Johansson as Chair and Phipps as Secretary and Chief Executive Officer.

The Board bring together a wealth of experience. Johansson is an experienced leader within the MariaDB developer community. Katz is a well-known expert in open source legal matters and has been acting as COO of the Foundation until now. Phipps brings experience of IBM and Sun Microsystems as well as …

There was once a big hooplah about the MySQL Storage Engine Architecture and how it was easy to just slot in some other method of storage instead of the provided ones. Over the years I’ve repeatedly mentioned how this wasn’t really …

While Domas may have rather effictively trolled the discussion with his post on howto configure table/user statistics (which gave me a good chuckle I do have to say), it’s at least incorrect for Percona Server as you have to enable the “userstat” server option :)

That being said, once enabled there are no extra configuration variables to think about. This is a huge advantage over configuring PERFORMANCE_SCHEMA - which has a total of THIRTY configuration options (31 if you include the global enable/disable option).

Some of these thirty odd configuration variables are only going to matter if you’re loading your own plugins, and even then, it’s probably only going to matter if they use the MySQL mutex implementations rather than, …

Next week is the Percona Live MySQL Conference and Expo 2013.

Davi Arnaut and I are co-presenting InnoDB: A journey to the core, based on my InnoDB blog series by the same name. We will (fairly quickly) cover InnoDB’s storage formats as described in those posts, but in an interactive format. There will be some new material that hasn’t been blogged yet (mostly stuff that is more difficult to explain or has been incompletely described in innodb_diagrams). Most importantly, Davi and I will be available for questions, and hopefully some of the InnoDB developers …

Join Oracle’s MySQL team on April 22 to celebrate the general availability of MySQL 5.6. Get together in a relaxed atmosphere—make a toast, enjoy product demos and fun activities, and celebrate the MySQL community effort and contributions that made the latest release possible. Register here today!

Date: Monday, April 22, 2013
6:30 PM – 8:30 PM

Location: TechMart Santa Clara
5201 Great America Parkway
Santa Clara, CA, USA
(1-minute walk from Hyatt Regency Santa Clara)

Don't miss the opportunity to enjoy an evening of casual but informative conversation, with complimentary food and refreshments from Oracle! Walk-ins are also welcome.