For the sake of getting things done and not having projects
succumb to bit-rot (in the case of MySQLBind), today I have
released DBD::mysql 4.0.23 and MySQLBind with prepared-statement
support.
DBD::mysql
DBD::mysql is the Perl driver for MySQL. I have been maintaining
this project now for almost 10 years. I work on a lot of
different projects and various languages, but Perl is very dear
to me and so many things taken for granted that we use in the
technical world use it and it Just Works (TM). MySQL is of course
dear to me as well, and Perl talking to MySQL is of utmost
importance, hence why I love maintaining this driver. I know the
code in my sleep as well! This version includes various changes
from contributors in the Open Source community who I am very
grateful to. Please see the change log for details!
Also-- this is very important -- I want to thank Sveta Smirnova
(Спасибо Света!) as …
MySQL Connector/Net 6.7.1, a new version of the all-managed .NET
driver for MySQL has been released. This is the second of
two alpha releases intended to introduce users to the new
features in the release. This release is not feature
complete and there are significant limitations but it should be
stable enough for users to understand the new features and how we
expect them to work. As is the case with all non-GA
releases, it should not be used in any production environment.
It is appropriate for use with MySQL server versions
5.0-5.6
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
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.
- MariaDB Cassandra Interoperability with Sergei Petrunia on 23 April 1:20pm – 2:10pm @ Ballroom D
- MariaDB BoF on 23 April 6:00pm – 7:00pm @ Ballroom F
- …
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]