MySQL

Blogs are updated every hour. Blogs with voting buttons are updated as soon as an article is published.

0
Percona Live MySQL Conference 2012 Prize Winners and Percona Live New York 2012
I’m pleased to announce a variety of prize winners associated with the Percona Live MySQL Conference and Expo 2012. The following people won prizes in the pre-conference registration promotion:
Kindle Fire Winners:
Tatiana B., Etsy, United States
To...
0   Published 14 hours ago in
MySQL Performance Blog: Profile, Details
0
btrfs – probably not ready yet
Every time I have a conversation on SSD, someone mentions btrfs filesystem. And usually it is colored as a solution that will solve all our problems, improve overall performance and SSD in particular, and it is a saviour. Of course it caught my curiosity ...
0   Published 1 day ago in
MySQL Performance Blog: Profile, Details
0
Intel 520 SSD in MySQL sysbench oltp benchmark
In my raw IO benchmark of Intel 520 SSD we saw that the drive does not provide uniform throughput and response time, but it is interesting how does it affect workload if it comes from MySQL.
I prepared benchmarks results for Sysbench OLTP workload with My...
0   Published 3 days ago in
MySQL Performance Blog: Profile, Details
0
Percona Server 5.5.23-25.3 released!
Percona is glad to announce the release of Percona Server 5.5.23-25.3 on May 16, 2012 (Downloads are available here and from the Percona Software Repositories).
Based on MySQL 5.5.23, including all the bug fixes in it, Percona Server 5.5.23-25.3 is now th...
0   Published 8 days ago in
MySQL Performance Blog: Profile, Details
0
Announcement of Percona XtraDB Cluster 5.5.23
Our previous GA release of Percona XtraDB Cluster caused a lot of interest and feedback. I am happy to announce next version Percona XtraDB Cluster 5.5.23, which comes with bug fixes and improvements.
List of changes:
Fixes merged from upstream (Codership...
0   Published 10 days ago in
MySQL Performance Blog: Profile, Details
0
Benchmarking MySQL Replication With Multi-Threaded Slaves
Benchmarking MySQL Replication With Multi-Threaded Slaves: Mat Keep about the multi-threaded slave replication available in MySQL 5.6:
The multi-threaded slave splits processing between worker threads based on schema, allowing updates to be applied in par...
0   Published 21 days ago in
myNoSQL • NoSQL Databases and...: Profile, Details
0
Zero-Downtime Schema Changes In MySQL
The recording of yesterday’s webinar, as well as a PDF of my slide deck, is now available. You can watch the recording and get the slides here.
I got a lot of questions, and did not have enough time to answer all of them, so let me try to answer som...
0   Published 21 days ago in
MySQL Performance Blog: Profile, Details
0
Testing Intel SSD 520
Following my previous benchmarks of SATA SSD cards I got Intel SSD 520 240GB into my hands. In this post I show the results of raw IO performance of this card.
The benchmark methodology I described in previous posts, so let me jump directly to results.
Fi...
0   Published 22 days ago in
MySQL Performance Blog: Profile, Details
0
Percona Server 5.5.22-25.2 released!
Percona is glad to announce the release of Percona Server 5.5.22-25.2 on April 25, 2012 (Downloads are available here and from the Percona Software Repositories).
Based on MySQL 5.5.22, including all the bug fixes in it, Percona Server 5.5.22-25.2 is now ...
0   Published 27 days ago in
MySQL Performance Blog: Profile, Details
0
Percona Server 5.1.62-13.3 released!
Percona is glad to announce the release of Percona Server 5.1.62-13.3 on April 25, 2012 (Downloads are available here and from the Percona Software Repositories).
Based on MySQL 5.1.62, including all the bug fixes in it, Percona Server 5.1.62-13.3 is now ...
0   Published 27 days ago in
MySQL Performance Blog: Profile, Details
0
Testing STEC SSD MACH16 200GB SLC
Following my previous benchmark of Samsung 830, today I want to show results for STEC MACH16 SATA card, 200GB size, this card is based on SLC, and regarding STEC website, it is an enterprise grade storage.
For tests I use sysbench fileio, 16KiB block size...
0   Published 29 days ago in
MySQL Performance Blog: Profile, Details
0
Testing Samsung SSD SATA 256GB 830 – not all SSD created equal
I personally like PCIe based Flash, but from a pricing point our customers are looking for cheaper alternatives. SATA SSD is an options. There is many products based on MLC technology, and Intel 320 I would say is the most popular. I do not particularly l...
0   Published 29 days ago in
MySQL Performance Blog: Profile, Details
0
Joining many tables in MySQL – optimizer_search_depth
Working on customer case today I ran into interesting problem – query joining about 20 tables (thank you ORM by joining all tables connected with foreign keys just in case) which would take 5 seconds even though in the read less than 1000 rows and d...
0   Published 33 days ago in
MySQL Performance Blog: Profile, Details
0Thumb
Benchmarks challenges of XtraDB Cluster
We are running internally a lot of benchmarks on our recently announced Percona XtraDB Cluster, and I am going to publish these results soon.
But before that I wanted to mention that proper benchmark of distributed system comes with a lot of challenges.
I...
0   Published 34 days ago in
MySQL Performance Blog: Profile, Details
0
PLMCE High Availability Deep Dive slides and Document
The slides and accompanying document of the High availability deep dive tutorial have all been uploaded and can be downloaded from the link below:
http://box.com/perconalive2012
For the slides, you’ll find a PDF and a pptx version, the gdocs animati...
0   Published 35 days ago in
MySQL Performance Blog: Profile, Details
0Thumb
Percona is Speaking At Open Source Data Center Conference in Nuremberg, Germany
Percona has 2 talks lined up at OSDC in Nuremberg, Germany.
- Taking hot backups with XtraBackup by Alexey Kopytov
- Expert Troubleshooting: Resolving MySQL Problems Quickly  by Kenny Gryp
On April 25 & 26, 2012 the Open Source Data Center Conference ...
0   Published 35 days ago in
MySQL Performance Blog: Profile, Details
0
Percona MySQL Training Schedule for May, June, & July
Over the coming three months, Percona will be holding our highly acclaimed MySQL courses in the following cities:
Dallas, Texas – May 14 – 17, 2012
London, England – May 21 – 24, 2012
Orlando, Florida – June 11 – 14, 20...
0   Published 36 days ago in
MySQL Performance Blog: Profile, Details
0
Version 1.0 of Percona Monitoring Plugins Released
I’m happy to announce that version 1.0 of Percona Monitoring Plugins is now available. The Percona Monitoring Plugins are high-quality plugins, templates, and add-ons for Nagios and Cacti, so you can add world-class MySQL monitoring to your existing...
0   Published 37 days ago in
MySQL Performance Blog: Profile, Details
0
Testing Percona Replication Manager (prm) with Vagrant
If you have recently attended some Percona Live events or if you have checked some slides from Yves Trudeau, you may have heard about Percona Replication Manager (PRM), a new high availability tool for MySQL.
Percona Live DC 2012
Percona Live MySQL Confer...
0   Published 37 days ago in
MySQL Performance Blog: Profile, Details
0Thumb
Percona Live MySQL Conference & Expo Was A Great Event
Thanks to all of our sponsors, speakers, speaker selection committee, event staff, and especially the attendees for making last week’s conference a resounding success. With over a thousand people, the event made a good comeback after last year’...
0   Published 37 days ago in
MySQL Performance Blog: Profile, Details
0
Testing Percona XtraDB Cluster with Vagrant
For those wanting to become more familiar with Percona XtraDB Cluster or if you just one to test its capabilities, I have prepared an easy Vagrant setup ready to deploy.
It contains the puppet recipes to install and configure a cluster of 3 nodes and a lo...
0   Published 42 days ago in
MySQL Performance Blog: Profile, Details
0
Percona Announces New Relic Partnership
I’m delighted to announce a partnership with New Relic. The press release has the details (all new Gold and Platinum support contracts get free New Relic subscriptions) but I wanted to add some of the behind-the-scenes context.
The quote from me in ...
0   Published 44 days ago in
MySQL Performance Blog: Profile, Details
0
How We Got Here
We have spent months planning and preparing for the MySQL conference that begins tomorrow. It seems appropriate to reflect on this process, where the open source and business communities are now, and what we have planned for the future.
The annual April M...
0   Published 45 days ago in
MySQL Performance Blog: Profile, Details
0
High Availability Deep Dive tutorial at PLMCE
(a slightly modify rebroadcast of Florian’s post)
If you are interested by High availability solution with MySQL, Florian Haas from and myself myself will be co-presenting next Tuesday a tutorial on the topic. It is never too late to register!
For ...
0   Published 48 days ago in
MySQL Performance Blog: Profile, Details
0
Percona Toolkit 2.1 with New Online Schema Change Tool
I’m proud to announce the GA release of version 2.1 of Percona Toolkit. Percona Toolkit is the essential suite of administrative tools for MySQL.
With this release we introduce a new version of pt-online-schema-change, a tool that enables you to ALT...
0   Published 49 days ago in
MySQL Performance Blog: Profile, Details
0
Join Optimizations in MySQL 5.6 and MariaDB 5.5
This is the third blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. This blog post is targeted at the join related optimizations introduced in the optimizer. These optimizations...
0   Published 49 days ago in
MySQL Performance Blog: Profile, Details
0
Announcing Percona XtraBackup 1.6.6
I am happy to also announce the latest minor release in the Percona XtraBackup 1.6 series. We recognise that not everybody will want or be able to make the leap to our new major release, Percona XtraBackup 2.0 and so we’re also releasing Percona Xtr...
0   Published 50 days ago in
MySQL Performance Blog: Profile, Details
0
Announcing Percona XtraBackup 2.0.0 GA
I’m really excited to today announce the first GA (Generally Available; i.e. stable) release of Percona XtraBackup 2.0. We have worked hard since our last major release on improving the reliability and user experience of Percona XtraBackup as well a...
0   Published 50 days ago in
MySQL Performance Blog: Profile, Details
0
Announcement of Percona XtraDB Cluster 5.5.20 GA release
I am excited to announce the availability of the GA release of our new product Percona XtraDB Cluster.
Percona XtraDB Cluster is a High Availability and Scalability solution for MySQL Users and is based on Percona Server 5.5.20.
With this release we make ...
0   Published 51 days ago in
MySQL Performance Blog: Profile, Details
0
Diamond Keynote Panel, BOFs, Lightning Talks, and McAfee and AOL Sponsorships
I’m excited by all of the recent developments surrounding the Percona Live MySQL Conference and Expo! Our own Baron Schwartz will moderate the Diamond Keynote Panel entitled “Future Perfect: The Road Ahead for MySQL” which will feature a panel of My...
0   Published 52 days ago in
MySQL Performance Blog: Profile, Details
0
Percona XtraBackup 1.9.2 released (Beta)
Percona is glad to announce the release of Percona XtraBackup 1.9.2 on 28th March 2012. Downloads are available from our download site here. This is a late BETA release in the process of going towards Percona XtraBackup 2.0.0.
This is a BETA quality relea...
0   Published 55 days ago in
MySQL Performance Blog: Profile, Details
0
Introducing the pmp-check-mysql-status Nagios Plugin
Most of the Nagios plugins included with the Percona Monitoring Plugins are purpose-built for specific scenarios that I found in my research to be frequent, severe, or subtle causes of problems in MySQL systems. They are intentionally not generic because ...
0   Published 56 days ago in
MySQL Performance Blog: Profile, Details
0
Congratulations to Percona Live Ticket Winners!
It’s taken a little while to sort out the contest logistics, but we’re ready now, so I want to congratulate our three first-prize winners to the Percona Live MySQL Conference and Expo:
David Juntgen
Jeff Hansen
Domenick Petrella
For helping us...
0   Published 56 days ago in
MySQL Performance Blog: Profile, Details
0
InnoDB’s gap locks
One of the most important features of InnoDB is the row level locking. This feature provides better concurrency under heavy write load but needs additional precautions to avoid phantom reads and to get a consistent Statement based replication. To accompli...
0   Published 57 days ago in
MySQL Performance Blog: Profile, Details
0
Community events around Percona Live MySQL Conference and Expo 2012
We’re very pleased with community support for Percona Live MySQL Conference and Expo. We’ve got wonderful speakers providing content of phenomenal session lineup for the conference this year. We have community helping by spreading the world, a...
0   Published 59 days ago in
MySQL Performance Blog: Profile, Details
0
Best kept MySQLDump Secret
Many people use mysqldump –single-transaction to get consistent backup for their Innodb tables without making database read only. In most cases it works, but did you know there are some cases when you can get table entirely missing from the backup ...
0   Published 62 days ago in
MySQL Performance Blog: Profile, Details
0
Speaking at POSSCON
I’m speaking at POSSCON in Columbia,SC next week (March 28). My talk will be about Open Source software Percona Produces – Percona Server, Percona Xtrabackup, Percona Toolkit, Percona XtraDB Cluster. If you want to get a birds eye view a...
0   Published 62 days ago in
MySQL Performance Blog: Profile, Details
0
How FLUSH TABLES WITH READ LOCK works with Innodb Tables
Many backup tools including Percona Xtrabackup, MyLVMBackup and others use FLUSH TABLES WITH READ LOCK to temporary make MySQL read only. In many cases the period for which server has to be made read only is very short, just few seconds, yet the impact...
0   Published 62 days ago in
MySQL Performance Blog: Profile, Details
0
BOFs and Lightning Talks Announced for Percona Live MySQL Conference & Expo
The Percona Live MySQL Conference & Expo is going to be awesome! Great speakers, an A-list of sponsors, countless opportunities to engage with the community, and an enthusiastic crowd of MySQL users ensure this is going to be a great event. The confe...
0   Published 63 days ago in
MySQL Performance Blog: Profile, Details
0
Troubleshooting MySQL Memory Usage
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 ...
0   Published 64 days ago in
MySQL Performance Blog: Profile, Details
0
Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
This is the second blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. This blog post is aimed at the optimizer enhancement Multi Range Read (MRR). Its available in both MySQL 5.6...
0   Published 64 days ago in
MySQL Performance Blog: Profile, Details
0
Announcing Percona Server 5.5.21-25.0
Percona is glad to announce the release of Percona Server 5.5.21-25.0 on March 20th, 2012. Downloads are available here and from the Percona Software Repositories.
Based on MySQL 5.5.21, including all the bug fixes in it, Percona Server 5.5.21-25.0 is now...
0   Published 66 days ago in
MySQL Performance Blog: Profile, Details
0
Free ticket to MySQL User Conference on SF Meetup with talk “Percona XtraDB Cluster”
Just a reminder that I will be giving a talk “Percona XtraDB Cluster” on coming San Francisco MySQL Meetup, next Wednesday, March-21, 2012. Along with talk I will give away one full ticket (tutorials + sessions + expo hall) to Percona Live MyS...
0   Published 69 days ago in
MySQL Performance Blog: Profile, Details
0
ext4 vs xfs on SSD
As ext4 is a standard de facto filesystem for many modern Linux system, I am getting a lot of question if this is good for SSD, or something else (i.e. xfs) should be used.
Traditionally our recommendation is xfs, and it comes to known problem in ext3, wh...
0   Published 70 days ago in
MySQL Performance Blog: Profile, Details
0
Give feedback on a pt-online-schema-change update
I am writing a specification for updating pt-online-schema-change. The outline of the changes I want to make is here: http://www.percona.com/docs/wiki/ptdev:blueprints:redesign-pt-online-schema-change
The idea is to make the tool Do The Right Thing, with ...
0   Published 71 days ago in
MySQL Performance Blog: Profile, Details
0
Win Free MySQL Conference Tickets!
We’re giving away three full conference passes (worth $995 each) to the Percona Live MySQL Conference and Expo, and you can win one simply by sharing the conference with your friends and colleagues! Second prize is one of ten copies of the new High ...
0   Published 70 days ago in
MySQL Performance Blog: Profile, Details
0
A Story of MySQL and InnoDB at Facebook Told by Mark Callaghan
A Story of MySQL and InnoDB at Facebook Told by Mark Callaghan: Just whetting your apetite for this interview with Mark Callaghan about MySQL, InnoDB, and his work at Facebook:
Q: How do you make MySQL both “less slow” and “faster” at the same time?
A: I ...
0   Published 72 days ago in
myNoSQL • NoSQL Databases and...: Profile, Details
0
A Book-Signing Opportunity for Technical Authors
Have you authored a technical book that’s relevant to MySQL users? Want to get great visibility for yourself and your book? We’re planning a book-signing session for the upcoming MySQL conference, and you can participate in it.
In brief, we...
0   Published 72 days ago in
MySQL Performance Blog: Profile, Details
0
Webinar “How to Turbocharge Your MySQL Performance Using Flash Storage”
Next Wednesday, March-21, 11:00am Pacific Time, Baron and me will be co-presenting with Virident webinar: “How to Turbocharge Your MySQL Performance Using Flash Storage” (From Virident side: Shridar Subramanian and Shirish Jamthe).
Running My...
0   Published 72 days ago in
MySQL Performance Blog: Profile, Details
0
The Benefits of the MySQL Memcached Plugin
The Benefits of the MySQL Memcached Plugin: Mario Beck:
But the memcached plugin to MySQL is a replacement or addition to the SQL interface to MySQL. So instead of using SQL queries in your application to persist or retrieve data from MySQL you can use th...
0   Published 72 days ago in
myNoSQL • NoSQL Databases and...: Profile, Details

All posts

Page 1 out of 20:

1 2 3 4 5 ... 19 20 Next »

Blogs with invalid RSS feeds, or feeds that contain more than 50 posts are not included in TopBlogLog. Blogs that spam can be removed from the main page or deleted from TopBlogLog.

Categories


Your blog is missing? Add it here. Requires registration. The system is updated every hour. If you wish your site to be updated in real time, please use TopBlogLog ping service and add voting button.