This Week in Website Performance is a weekly feature of the Monitis.com blog. It summarizes recent articles about website performance. How to make yourweb site better, how to improve your users experience when they come to your website and how to optimize the overall experience. Why? Because your friends at Monitis.com care.

Improving website performance – 10 tips

Author: palepurple.

Discussed in this short article are 10 useful tips for a LAMP (Linux/apache/mySQL/PHP) based website. This is a nice round up of various tips seen in many similar articles. It’s a great way to get started if you are getting into performance optimization on this platform, or maybe it’s time to take another look to be sure things are …

[…] For more info, check http://insidemysql.com/announcing-new-yum-repositories-for-mysql/ […]

Recently I wrote about one advantage of MySQL statement-based replication. In the comments of that post Andrew Moore pointed out that I can set slave_exec_mode=IDEMPOTENT on my replicas in order to get similar behavior in row-based replication. Thanks Andrew!

Now I'm going to highlight an advantage of row-based replication in MySQL. Again this is not one of the advantages documented in the manual, but it's one that I think is important.

Here it is:

• Row-based replication does not write to the binary log if you execute a statement that doesn't change any data.
• Statement-based replication writes all successful inserts, updates, and deletes to the binary log …

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.6. This is a Beta release. See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 10.0? page in the AskMonty Knowledgebase for general information about the MariaDB 10.0 series.

Download MariaDB 10.0.6

Release Notes Changelog …

Reading Ernie’s post today inspired me to write about something I’ve been wanting to write about for a while: how much of a performance impact you should expect from network latency.

Hypothetical Numbers

I’m going to throw out some web-application ‘back of the envelope’ numbers which I will then use for examples:

• The goal is to generate a page within 200-500ms.
• Network latency between the application server and DB server is 0.5-1ms.

There will be use-cases which have goals far more agressive than this, for example advertising server goals are closer to 50ms. I have also seen network latency well below 1ms. I encourage commenters to correct me where they disagree ;)

Analysis

So if we say that a typical web page …

Every MySQL DBA has at least peeked at a mysql.user table. But with the latest versions come some changes that many may have not noticed. The last three of the forty three columns — plugin, authentication_string, and password_expired — fields deserve a closer look.

First off, lets look at the entire table that is the output of DESC mysq.user run in MySQL Workbench and only the last few lines are shown for the sake of clarity.

The password_expired field is simply set to ‘N’ if the password is expired.
ALTER USER 'joeuser'@'localhost' PASSWORD EXPIRE;
The use will receive a message that their password has expired and they need to set a new one IF their client supports resetting password. The account is is “sandbox” mode where the use has …

[2017 update: MySQL 8.0.1 now features SQL-standard CTE syntax; more information is here ; the entry below, from 2013, shows how to work around the absence of CTEs in older MySQL versions.]

If you have been using certain DBMSs, or reading recent versions of the SQL standard, you are probably aware of the so-called "WITH clause" of SQL.
Some call it Subquery Factoring. Others call it Common Table Expression (CTE). In its simplest form, this feature is a kind of "boosted derived table".

Assume that a table T1 has three columns:

CREATE TABLE T1(
YEAR …

This is part two on a two-part series on the performance implications of in-flight data encryption with MySQL. In the first part, I focused specifically on the impact of using MySQL’s built-in SSL support with some rather surprising results. Certainly it was expected that query throughput would be lower with SSL than without, but I was rather surprised by the magnitude of the performance hit incurred at connection setup time. These results naturally lended themselves to some further investigation; in particular, I wanted to compare performance differences between MySQL’s built-in SSL encryption facilities and external encryption technologies, such as SSH tunneling. I’ll also be using this post to address a couple of questions posed in the comments on my original article. So, without further ado….

Test Environment

The …

We are announcing the new MySQL for Developers course. This training:

• Takes advantage of both SQL and NoSQL
• Shows you how to plan, design and implement applications
• Brings you realistic examples, interactive instruction and hands-on exercises using Java and PHP
• Covers MySQL 5.6 features including optimizer improvements
• Helps you prepare for the MySQL 5.6 Developer certification.

You can take this course as a:

• Live-virtual event: Take this course from your own office; no travel required. You can choose from a selection of events on the …

Great… Finding the right repo sometimes was a very big problem