Introduction Although there is an SQL Standard, every relational database is ultimately unique, and you need to adjust your data access layer so that you get the most out of the relational database in use. In this article, we are going to see what you can do to boost up performance when using MySQL with … Continue reading 9 High-Performance Tips when using MySQL with JPA and Hibernate →
10 Older Entries »
Introduction Dealing with time zones is always challenging. As a rule of thumb, it’s much easier if all date/time values are stored in the UTC format, and, if necessary, dealing with time zone conversations in the UI only. This article is going to demonstrate how you can accomplish this task with JDBC and the awesome … Continue reading How to store date, time, and timestamps in UTC time zone with JDBC and Hibernate →
Oracle University recently unveiled a new online training offering – the MySQL Learning Subscription. The combination of freely-accessible and compelling paid content makes this an exciting development to me, and should prove valuable to the community and customer base alike. This post will briefly explore this new MySQL educational resource.
The subscription content is organized into topical “channels”. Current top-level channels are:
- Getting Started
These channels have sub-channels as well – for example, the Getting Started channel includes Getting Started With MySQL New Features and MySQL For Beginners, …[Read more]
Too often developers and DBAs struggle to pinpoint the root cause of MySQL database performance issues, and then spend too much time in trying to fix them. Wouldn’t it be great to bypass wasted guesswork and get right to the issue?
In our upcoming webinar Tired of MySQL Making You Wait? we’re going to help you discover how to significantly increase the performance of your applications and reduce database response time.
In this webinar, Principal Architect Alexander Rubin and Database Evangelist Janis Griffin will provide the key steps needed to identify, prioritize, and improve query performance.
They will discuss the following topics:
- Wait time analytics using …
For learning, testing and keep up with things, one might want to install/update the MySQL version to the latest DMR (Development Milestone Release). At the time of this writing the latest DMR for MySQL is MySQL Community Server 5.7.8-rc. Having chosen Ubuntu server as my operating system and since this is a development version hence not yet part of an official Ubuntu release, you have to install
Sometimes it's useful to have a set of data prepared to be used on a fresh MySQL install for testing purposes. Or you might be preparing some training or workshop and want to prepare examples with fake information. For MySQL there are some choices available:
Employees Sample Database: provides a combination of a large base of data (approximately 160MB) spread over six separate tables and
Because interactivity with the trainer (our classes are not dry lectures) and discussions are an important and intrinsic part of our teaching approach, we’ve long tracked development of technologies for online training, but previously were not satisfied.
High costs of various corporate offerings would negatively impact our pricing, given the relatively small scale use and our purposely small classes. The student system requirements would often be problematic – obviously students use different operating systems (Windows, Mac, Linux) and we cannot prescribe that people use a particular OS.
Big Blue Button has long looked like it had the right potential, and it’s now developed to a point where were happy with it. For more tech and practical details, see our Interactive Online Training page.
After our successful trial runs, we have the following …[Read more]
From left: Liz van Dijk, Frédéric Descamps and Kenny Gryp
If you’re following this blog, it’s quite likely you’re already aware of the Percona Live London 2014 conference coming up in just a few days. Just in case, though (you know, if you’re still looking for an excuse to sign up), I wanted to put a spotlight on the tutorial to be delivered by my esteemed colleagues Frédéric Descamps (@lefred) and Kenny Gryp (@gryp), and …[Read more]
Stored routines give you the ability to create a statement in one application (MySQL) that can be used in multiple client applications that use different programming languages or work on different platforms.
Take the MySQL for Developers course to learn more about stored routines and other key topics. This will build your expertise as a MySQL Developer.
You can take this 5-day instructor-led course as a:
- Live-Virtual Event: Attend a live-event from your own desk, no travel required. Choose from a selection of events already on the schedule to suit different timezones.
- In-Class Event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule.
The MySQL for Database Administrators training course is one of the most popular courses at Oracle. This is not surprising since it provides a comprehensive range of administration skills to those using the world's most popular open source database.
You can travel to an education center to take this 5-day instructor-led course, and as shown in the table below, events are currently scheduled for delivery in 8 languages (Arabic, Brazilian Portuguese, English, French, Hebrew, Italian, Spanish, Turkish).
If you want to take this training from your own desk, you have two options:
- Training-on-Demand: Start training within 24 hours of registration, following training at your own pace.
- Live-Virtual Event: Follow a live event …
10 Older Entries »