Here’s your spammy day-of reminder about tonight’s free MySQL meetup. The topic is MySQL Monitoring Bonanza. There will be beer, pizza, pretty charts and graphs, and friends. Free as in beer (and pizza, did I mention that?)!
Further Reading:
One of the most painful troubleshooting tasks with MySQL is
troubleshooting memory usage. The problem usually starts like
this – you have configured MySQL to use reasonable global
buffers, such as
innodb_buffer_size, key_buffer_size etc, you have reasonable
amount of connections but yet MySQL takes much more memory than
you would expect, causing swapping or other problems.
This simple problem on the surface becomes challenge with MySQL because there are no clear resource usage metrics available, and so in most cases you do not know where exactly memory is allocated. This was not much of the problem in MySQL 3.23 when there would only handful of places where memory could be allocated but it is a lot larger problems with MySQL 5.5 with addition of user variables, stored procedures, prepared statements etc which can be a memory hog.
My intent with this post is dual. I would encourage MySQL Team at Oracle, MariaDB team or …
[Read more]Oracle’s European MySQL team is active running many events during the upcoming couple of months. We hope to see you there - Register Now!
Scale with MySQL
Are you looking to scale with MySQL? On-premise or in the cloud? Leveraging SQL and NoSQL Access? Join us for a free Oracle seminar focusing on best practices for MySQL performance and scalability.
MySQL Enterprise Edition Workshop
In this hands-on seminar we will present the MySQL Enterprise Edition management tools under guidance of Oracle’s MySQL experts providing hints and tips.
As you might have noticed, I'm getting further away from MySQL
here. This is just how things are I guess, I just do much less
work with MySQL these days. The first migration was from MySQL to
MongoDB, which was some time back. This was pretty successful,
but note that we still have some data in MySQL, but the bulk of
the data is in MongoDB right now.
Running any database on Amazon (and we run all databases on
Amazon or on Amazon RDS service) may be costly, depending on how
you utilize your resources. The recently announced Amazon
DynamoDB is Amazons NoSQL service offering, but it is not like
MongoDB with a twist, far from it. If you have read what I have
written about MongoDB, I have now and then complained about the
lack of functionality, but to be honest, I have learnt to live
with MongoDB and it's shortcomings, and have started to like many
of the JavaScript features of it (one thing I hate about it, and
about JavaScript in general …
“Server log tables” is one of the finest feature in MySQL 5.1 version but It looks like people are not using this feature regularly or perhaps they are happy with files only. Here, I’m explaining how we can enable that feature, use it and how it will be helpful for filtering the required statements in … Continue Reading …
[Read more]SkySQL has always been committed to the MySQL® community and today we've unveiled a new resource page for the community. This is designed for the community to get a single point of information, assistance, and inspiration. While we are starting quite modestly it is up to you, the community, to make this the best resource for MySQL and related technologies.
A screencast demonstrating the MariaDB Windows installer.
(I recommend watching it in full screen 720p, so you can see the details.)
Some links:
Acknowledgments:
A big thanks to Vladislav Vaintroub, MariaDB’s Windows guru, and to Rasmus Johansson for help with the screencast.
If you still have not signed up for the Percona Live MySQL Conference & Expo (week of April 9th), use the following discount code from SkySQL to receive 10% off when registering:
SKY-PL12
And while you’re there, don’t forget to attend the following events on the day-after (4/13/2012) the Expo:
When I thought to start to write this post, I was thinking about
all the logical reasons why you would consider hiring a part-time
remote MySQL database administrator or MySQL expert.
It then occurred to me that most of the readers, who
are reading this post now, already know or can imagine the
benefits of hiring a DBA to take care of their system.
So what I want to offer is a case based on the emotional benefits
and value a part-time DBA can offer you and your business.
1) Peace of Mind
A DBA can offer you peace of mind that one of your core business
components is being taken care of. It is like maintaining your
house gas boiler or car every now to keep it running in good
working order and preventing it from blowing up. Except that in
this example, if it …
This is another, in-case-you-missed-it, but it is definitely worth mentioning again:
MariaDB 5.3 is now GA
So, if you’re using MariaDB 5.1 or 5.2, I’d definitely recommend upgrading to the new MariaDB 5.3.
Also, if you’re a Windows user using MySQL 5.1, I’d highly consider making the switch to MariaDB 5.3 due to all of the Windows-specific improvements in it.
MariaDB 5.3 Enhancements:
