Joseph Scott pointed me to a little tidbit hidden in the latest Percona Server release notes: “Percona Server for MySQL will now be shipped with the libjemalloc library.” Percona published the results of some testing of various malloc libraries on their MySQL High Performance Blog last year, and it looks like this will have a very positive impact on performance.
I’m currently using MariaDB, so I’m hoping they pick up this change as well.
Do not forget to register for the MySQL Community Reception by Oracle.
Lots of giveaways and one very cool dolphin but space is limited so RSVP Today!
Monday, April 22, 2013
6:30 P.M. – 8:30 P.M. PDT
TechMart Santa Clara
5201 Great America Parkway
Santa Clara, CA, USA
Join Oracle’s MySQL Team on April 22, 2013, as we celebrate the general availability of MySQL 5.6. With product demos and fun activities in a relaxing atmosphere, this is the party for the MySQL community to get together and have a toast on the work all of us did to make MySQL 5.6 the best release ever. Whether you are an attendee at Percona Live, a member of local MySQL user groups, a MySQL user in the Bay Area, or …
[Read more]
One major problem in terms of MySQL
performance that still stands in the way of InnoDB scalability is
the trx_list scan on consistent read view creation.
It was originally reported as a part of MySQL bug
#49169 and can be described as follows. Whenever a connection
wants to create a consistent read, it has to make a snapshot of
the transaction states to determine which transactions are seen
in the view later. To this end, InnoDB scans
trx_list (i.e. the list of currently open
transactions) and copies IDs of transactions that have not yet
been committed at the current point in time, and thus should not
be visible in the consistent read. For the
REPEATABLE_READ isolation level, the snapshot is
created on the first SELECT …
Finish off the day and week with Continuent-sponsored Biergarten!
You state that one of your configurations was a RAID configuration consisting of "2 RAID DISKS (1027 GB,733.9GB)". But I only see that -backup-dir only takes one argument. How do you write to two different RAID filesystems?
For example, I have a database that I want to backup to
/home/backups/raid1 and /home/backups/raid2 where raid1 and raid2
are two different groups of physical disks. Ideally, I
would:
./mysqlbackup -uroot –backup-dir=/home/backups/raid1
–backup-dir=/home/backups/raid2 --read-threads=3
--process-threads=4 --write-threads=2 backup
I’m planning my calendar and thought I’d share what talks I’d be giving in Santa Clara in a couple of weeks for the Percona Live MySQL Conference & Expo 2013 and the MySQL & Cloud Database Solutions Day 2013. Its going to be a busy April 22-26 2013.
Like in love there is no precondition, there are no limits held when it comes to the labor of love called as blogging. Lovingly this Log Buffer edition brings you some more roses from database arena.
Oracle:
Marco Vigelini shares as how to duplicate a production database on a different server mantaining the same SID and directory structures with ‘duplicate’ RMAN command and how to resynchronize a duplicated remote database using RMAN backups.
…
[Read more]If you are looking for a class that is designed to jump-start your knowledge on MySQL 5.6 features, a class that provides hands-on labs, and a class that shows various migration methods – look no further.
We have been hard at work building a new class to ensure you have the knowledge and skills needed to verify your applications, and plan for the migration to MySQL 5.6. The class is called Moving to MySQL 5.6 and is a 2-day workshop.
The Moving to MySQL 5.6 workshop is being offered over the summer in numerous European countries and throughout …
[Read more]
As a former Oracle DBA, I know how the system and the database
are linked.
The first one who told me that the installation of
Oracle has never been a problem is a liar!
Yes, your database and your system are the best of friends,
you must respect that.
I’d make a list of linux system settings to configure a MySQL
databases server and share my sources with you.
In return, I would like you to share your sources with the
community by publishing your tips in the comments.
swappiness
Do you need run multi-master MySQL database clusters across sites? In this webinar we build on the multi-master capabilities of Continuent Tungsten, covered in our advanced replication topologies course, to help you build and manage systems that spread data across dozens or even hundreds of sites. We cover topics such as large scale topologies, transaction filtering, security, and moving
