Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 121 to 130 of 33184 10 Older Entries
Webinar Replay & Slides: Performance Tuning of HAProxy for Database Load Balancing
+0 Vote Up -0Vote Down
September 11, 2014 By Severalnines

 

Thanks to everyone who attended and participated in this week’s webinar on ‘Performance Tuning of HAProxy for Database Load Balancing’. And special thanks to our guest speaker, Baptiste Assmann of HAProxy Technologies. 

 

If you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.

 

Watch the replay of this webinar to learn about what HAProxy can tell you about your application and database instances. And understand the difference between short-lived connections and

  [Read more...]
MySQL Central @ OpenWorld: What’s New in MySQL 5.7?
Employee_Team +2 Vote Up -0Vote Down

MySQL Central @ OpenWorld is coming up soon. I look forward to present What’s New in MySQL 5.7? on Tuesday, Sep 30, 12:00 PM – 12:45 PM – Moscone South – 252.  Join product manager Mike Frank and myself to discuss the big picture! We will cover:

  • InnoDB Performance & Scalability: Over 600 thousand QPS for SQL queries, over 1.1 million QPS for  Memcached API, over 60 thousand connects/ disconnects per second, parallel flushing, bulk data load and more.
  • Optimizer: New optimizations,  new architecture for the parser, new architecture for the optimizer, new additions leading to a new cost model designed to handle latest OS and hardware innovations.
  [Read more...]
Get help from an MBA - MySQL Benchmark Advisors
+1 Vote Up -0Vote Down
I am not an academic but I attend academic database conferences and read many papers from them. My focus is transaction processing (OLTP, small data). Some of the work published there is awesome, try reading the papers describing the R&D effort for Hekaton and you might agree (see papers from Larson, Levandoski and others). Better performance is the key contribution for many of the papers and in most cases that is measured via benchmarks because the ideas change the constant factor rather than reduce complexity from N*N to NlogN. I also wonder if there is too much emphasis on peak performance and not enough on reliability and  [Read more...]
Puppet Module for ClusterControl - Adding Management and Monitoring to your Existing Database Clusters
+0 Vote Up -0Vote Down
September 10, 2014 By Severalnines

If you are automating your infrastructure using Puppet, then this blog is for you. We are glad to announce the availability of a Puppet module for ClusterControl. For those using Chef, we already published Chef cookbooks for Galera Cluster and ClusterControl some time back.  

 

 

ClusterControl on Puppet Forge

 

The ClusterControl module initial release is available on Puppet Forge, installing the

  [Read more...]
Generating test data from the mysql> prompt
+0 Vote Up -0Vote Down

There are a lot of tools that generate test data.  Many of them have complex XML scripts or GUI interfaces that let you identify characteristics about the data. For testing query performance and many other applications, however, a simple quick and dirty data generator which can be constructed at the MySQL command line is useful.

First, let’s talk about what kind of data you can easily create with MySQL function calls:

You can generate a decimal number between zero and another number using the MySQL RAND() function like the following query (here between 0 and 10000):

SELECT RAND() * 10000;

Similarly, you can generate a random integer by adding the FLOOR() function:

SELECT FLOOR(RAND() * 10000)

You can generate a random string of 32 characters using MD5():

SELECT MD5(RAND() * 10000)

You can

  [Read more...]
Hopper - Stored Routine debugger - v1.5.2 released
+1 Vote Up -0Vote Down

Upscene Productions is proud to announce version 1.5.2 of our product called "Hopper".

Hopper is a Windows-based Stored Routine and Trigger Debugger, available for InterBase, Firebird and MySQL.


This release brings a code parser bug fix.



For more information on Hopper, see our website.

Click here for the news item at our website.
Multi-Valued INSERTs, AUTO_INCREMENT & Percona XtraDB Cluster
+0 Vote Up -0Vote Down

A common migration path from standalone MySQL/Percona Server to a Percona XtraDB Cluster (PXC) environment involves some measure of time where one node in the new cluster has been configured as a slave of the production master that the cluster is slated to replace. In this way, the new cluster acts as a slave of the production environment – traditional replication takes care of getting the data into the cluster, and then Galera replication handles the intra-cluster traffic. This often works without issue, although there is one case that I’ve encountered recently where special care must be taken to properly configure the stream to ensure that replication does not break. If you use multi-valued inserts with auto-increment columns, then this post is for

  [Read more...]
Discover the MySQL Central @ OpenWorld Tutorials
Employee_Team +4 Vote Up -0Vote Down

MySQL Central @ OpenWorld is only 20 days away! It is therefore time to start planning your conference, and Schedule Builder is a useful tool we recommend to use.

On Monday, September 29, you have the opportunity to attend MySQL tutorials. Each tutorial will last 2 hours and help you acquire in-depth knowledge on a number of MySQL topics. You will be able to choose from:

10:15 am - 12:15 pm

How to Analyze and Tune MySQL Queries for Better Performance
Øystein Grøvlen, Senior Principal Software Engineer, Oracle

Moscone South - 250


  [Read more...]
MySQL Community Reception at Oracle OpenWorld
Employee_Team +4 Vote Up -0Vote Down


Are you using or interested in learning more about MySQL? Are you attending Oracle OpenWorld and looking for an opportunity to meet and exchange ideas or experiences with MySQL users?

Join us on Tuesday, September 30, 2014 to celebrate the dynamics and growth of the MySQL community. Whether you are attending MySQL Central @ OpenWorld, a member of local MySQL user groups, a MySQL user in the Bay Area, or simply interested in MySQL technology, you're all invited to Oracle's MySQL Community Reception.

  • Mingle with your peers and learn from real-world experiences.
  • Talk to MySQL engineers face-to-face and get the first-hand

  [Read more...]
OurSQL Episode 199: Make It Fast
+0 Vote Up -0Vote Down
PodcastsPerformanceQuery OptimizationServer Tuning

This week, we discuss common MySQL performance tips.

10 Newer Entries Showing entries 121 to 130 of 33184 10 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.