Although it is possible to create a view with a nonexistentHow can this be possible?
DEFINERaccount, an error occurs when the view is referenced if the
SQL SECURITYvalue is
DEFINERbut the definer account does not exist.
Interesting question on human mistakes was posted on the DBA Managers Forum discussions today.
As human beings, we are sometimes make mistakes. How do you make sure that your employees won’t make mistakes and cause downtime/data loss/etc on your critical production systems?
I don’t think we can avoid this technically, probably working procedures is the solution.
I’d like to hear your thoughts.
I typed my thoughts and as I was finishing, I thought that it makes sense to post it on the blog too so here we go…
The keys to prevent mistakes are low stress levels, clear communications and established processes. Not a complete list but I think these are the top things to reduce the number of mistakes we make managing data infrastructure or for[Read more...]
Can database performance improvements be achieved with zero code changes? Learn how to use one simple advanced technique to make better MySQL indexes and improve your queries by 500% or more. Even with a highly indexed schema as shown in our 10 table join example, significant improvements in performance can be achieved.
This presentation introduces the approach for correct identification and verification of problem SQL statements and then describes the means of identifying index choices for optimization. Then discussed is not only how to apply indexes to improve query performance, but how to apply[Read more...]
drop table if exists logs;[Read more...]
create table logs (t mediumtext) engine=innodb;
drop function if exists exceeded_logs_quota ;
create function exceeded_logs_quota()
WHEN (DATA_LENGTH + INDEX_LENGTH) > (25*1024)
So your not a MySQL DBA, but you have to perform like one. If you have a production environment that’s running now, what are the first things you do when it’s not running or reported as not running?
After you do this manually more then[Read more...]
If you’re new to the MySQL DBA role, you’ll be excited to learn about the Maatkit toolset. It provides a whole host of valuable functionality and fills many of the DBAs day-to-day needs.
Welcome to my new Production DBA blog, through this blog I aim to fully explore and understand some of the common tasks undertaken when administering MySQL in a production environment. I’ll be looking at options for backups, high availability, scalability, and monitoring, as well as various other general administration tasks in between.
mysqldumpcommands for backing up individual partitions of the tables in the current schema. The script is maintained as a snippet at MySQL Forge.
At the recent FOSDEM 2010 event, I presented in my keynote Dolphins, now and beyond a option which I termed the “Blue Pill” or the “Red Pill”. The following slide produced noticed interest in a packed room, and subsequent conversation.
While the ownership of MySQL has changed, the option between MySQL and Oracle as a product for use still remains. While MySQL is the most popular for modern online applications, Oracle continues to have the widely used enterprise database product and has a large number of Oracle DBAs in the IT marketplace.
Over the past 5 years I have presented a number of topics on MySQL for Oracle[Read more...]