Please mark your calendars now for two upcoming Percona Live events. Percona Live London 2013 will be November 11-12 at the Millenium Gloucester Conference Center. The Percona Live MySQL Conference and Expo 2014 will begin on March 31, 2014 at the Santa Clara Convention Center and Hyatt Santa Clara. Watch for the call for papers for Percona Live London.
The post Percona Live MySQL Conference 2013 wrap-up appeared first on MySQL Performance …
- Engine Yard Developer Blog: MySQL 5.5 and 5.1 Support in Alpha
- Opscode Blog: Packt Publishing releases "Instant Chef Starter" book
- Brightbox Ruby Blog: New Relic Agent vulnerability
- Brightbox Ruby Blog: MySQL authentication vulnerability
- Plataformatec Blog: Security announcement: Devise v2.2.3, v2.1.3, v2.0.5 and v1.5.3 released
- Binary Code: Raw SQL queries and Rails
…empty transaction list when creating read views. However, the more general descriptors optimization in Percona Server showed fairly close results in our tests. In Dimitri's tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6.
In order to understand more about differences between results we have rerun tests on several our boxes. You can find setup/config details at the very end of this post.
Hardware:
HP ProLiant DL380 G6 (8cores/16 cpu threads) …
Percona Server with TokuDB
I was excited to see that TokuDB for MySQL from Tokutek is now open source. I believe this is a great technology and it was a significant restriction on the adoption when it was distributed only in a binary format with a proprietary license.
So I went and built Percona Server 5.5.30 with TokuDB's storage engine. This is an experimental build and I am just going to play with it. The build procedure is somewhat complicated and confusing and this …
- MySQL Performance Blog: Benchmarking Percona Server TokuDB vs InnoDB
- igvita.com: HandlerSocket: The NoSQL MySQL & Ruby
- More info on Percona Server 5.5.30-30.2 -
New Features:
Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool . ( Alexey Kopytov )
Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost . ( Ignacio Nin )
This release of Percona Server for MySQL has fixed a number of performance …
…Percona XtraBackup has implemented basic support for MySQL 5.6, Percona Server 5.6 and MariaDB 10.0. Basic support means that these versions are are recognized by XtraBackup , and that backup/restore works as long as no 5.6-specific features are used (such as GTID, remote/transportable tablespaces, separate undo tablespace, 5.6-style buffer pool dump files).
Percona XtraBackup can use XtraDB changed page tracking feature to perform the Incremental Backups now. …
- New Relic: How do you move more than 6000 customers in 2 hours? (Hint: plan ahead)
- Engine Yard Developer Blog: MySQL 5.5 and 5.1 Support in Alpha
Percona Server for MySQL version 5.1.68-14.6
Percona is glad to announce the release of Percona Server 5.1.68 -14.6 on April 19, 2013 (downloads are available here and from the Percona Software Repositories ) . Based on MySQL 5.1.68 , including all the bug fixes in it, Percona Server 5.1.68-14.6, a MySQL alternative, is now the current stable release in the 5.1 series. All of Percona ‘s software is open source and free, all the details …
- New Relic: More on Managing Real World Rails Apps at Massive Scale: An Interview with Joshua Warchol, Vice President of Technology at Fanzt
- On the Path: Tuning MySQL
- Signal vs. Noise: Nuts & Bolts: Database Servers
Breakout Sessions on Percona Server and Related Projects
Stewart Smith, Director of Server Development, Percona
Topic: "Percona Server 5.6"
Jay Janssen, Consulting Lead, Percona
Topic: "Migrating to Percona XtraDB Cluster"
Mark Atwood, Vipul Sabhaya, and Jim Cooley, HP
Topic: "Using Percona Server as Database-as-a-Service on OpenStack"
Breakout Sessions on MariaDB
Monty Widenius…
- MySQL Performance Blog: Is your MySQL buffer pool warm? Make it sweat!
- New Relic: More on Managing Real World Rails Apps at Massive Scale: An Interview with Joshua Warchol, Vice President of Technology at Fanzt
- Engine Yard Developer Blog: MySQL 5.5 and 5.1 Support in Alpha
- till's blog: Hosted MySQL: Amazon RDS (and backups)
- On the Path: CodeSherpas is looking for new talent
- Freelancing Gods: Searching with Sphinx on Heroku
Now in Percona Server, for each connection we use a preallocated read view structure, reuse that memory during the entire connection lifetime and free it at disconnect. If some transactions require a larger amount of memory - we just reallocate memory to fulfill it needs.
To demonstrate the difference we have run sysbench POINT SELECT test for glibc and jemalloc allocators.
Observations:
= MySQL 5.5.30
- throughput of MySQL 5.5.30 with glibc is limited first of all by inefficiency …
- Engine Yard Developer Blog: MySQL Minutiae: Table Engines
- James on Software: InnoDB kernel_mutex Contention and Memory Allocators
- New Relic: Better Metric Data Handling Improves New Relic's Performance
- Global Nerdy: Further Into FizzBuzz!
- Dalibor Nasevic: Development Setup
- Justin Leitgeb: Common Rails Testing Mistakes
So both the general "trx descriptors" optimization introduced in Percona Server 5.5.30-30.2 and the special-case "read-only transactions" optimization in MySQL 5.6 are nice ways to improve scalability in highly concurrent workloads. We also have plans to combine them in the future releases of Percona Server for MySQL 5.6, which is currently in the alpha stage.
We are going to blog about other MySQL performance improvements introduced in our latest Percona Server…
- MySQL Performance Blog: Memory allocators: MySQL performance improvements in Pecona Server 5.5.30-30.2
- MySQL Performance Blog: More on transactions descriptors optimization
- Engine Yard Developer Blog: MySQL 5.5 and 5.1 Support in Alpha
- New Relic: WordPress Performance Optimization
- Journal: Faye integration into a rails app (+ testing!)
- Biodegradable Geek: This vs That — Be Tech Agnostic
…technologies, as it is relevant to MySQL users. MySQL, MariaDB, Percona Server, Drizzle are all well represented at the conference. No talks from Oracle. Marten Mickos is back with a keynote, " Making LAMP a Cloud ." He's now CEO of Eucalyptus. Percona announces Percona XtraDB Cluster as GA - the new approach to MySQL High Availability in and out of the Cloud. MySQL 5.5.23 is GA and 5.6.5 is nonGA at the time of the conference.
The event's …
- Videos related to 'Ruby on Rails vs Java - Commercial #1 of 9': PHP Tutorial: Introduction | Web Design & Development | Beginners
- Videos matching: rubyonrails: How to Install Ruby on Rails 1.9.3 on Windows 7 with RadRail and MySQL Server
- Signal vs. Noise: Taking the Pain Out of MySQL Schema Changes
- High Scalability: Building a Database remote availability site
- Phusion Corporate Blog: Bundler and public applications
- Paul Gross's Blog: Migrating from MySQL to PostgreSQL Slides