Showing entries 13721 to 13730 of 44105
« 10 Newer Entries | 10 Older Entries »
Article in php[architect] about MySQL forks

I have an article in this month’s php[architect] about the various flavors of MySQL.  I discuss the current state of Oracle MySQL, Percona Server, and MariaDB, and why you should use each of them.  I hope you all enjoy it!  Once the exclusive period is over for the article, I’ll be able to publish it [...]

Eliminating duplicate users in MySQL

This is hypothetical.

What would happen if I did the following?

alter table mysql.user add unique key(User);

I’m tossing this out there for people to think about because I’ve always thought that MySQL’s authentication model is a nuisance:

MySQL considers both your host name and user name in identifying you because there is no reason to assume that a given user name belongs to the same person on all hosts. For example, the user joe who connects from office.example.com need not be the same person as the user joe who connects from home.example.com. MySQL handles this by enabling you to distinguish users on different hosts that happen to have the same name: You can grant one set of privileges for connections by joe from office.example.com, and a different set of privileges for connections by joe from home.example.com. ( …

[Read more]
MySQL Subquery Optimization

Join 7000 others and follow Sean Hull on twitter @hullsean. MySQL’s optimizer can do a lot of things, but subqueries are not always handled well. Take a look at the IN subquery below. If you see the DEPENDENT SUBQUERY in your explain plan, you may want to take a second look. This will run slow [...]

MySQL Monitoring With Cacti Using Percona Monitoring Plugins (1-minute resolution)

Today, just like many times before, I needed to configure a monitoring server for MySQL using Cacti and awesome Percona Monitoring Templates. The only difference was that this time I wanted to get it to run with 1 min resolution (using ganglia and graphite, both with 10 sec resolution, for all the rest of our monitoring in Swiftype really spoiled me!). And that’s where the usual pain in the ass Cacti configuration gets really amplified by the million things you need to change to make it work. So, this is a short checklist post for those who need to configure a Cacti server with 1 minute resolution and setup Percona Monitoring Plugins on it.

Configuring Cacti for 60-seconds polling

First of all, we need to take a Cacti server, which by default is configured to do polling …

[Read more]
MySQL Cluster and Node.JS

Here are some things to know about our new Node.JS connector:

  • It provides an easy-to-use JavaScript API for data management. Developers write JavaScript, not SQL.

  • If the data is stored in MySQL Cluster, that JavaScript is turned into fast NDB API calls sent directly to the NDB data nodes.

  • You can also use the connector with data stored in InnoDB or some other engine. In this case, our implementation will generate SQL statements from your API calls and send them to MySQL using node-mysql, the all-JavaScript MySQL client built and maintained by Felix Geisendörfer. But we don’t just generate arbitarary SQL and trust the optimizer to make it work. We know where the indexes are, and we require you to use them.

  • Because node.js is still a rapidly moving target, we don’t …

[Read more]
From MySQL Fulltext Search to Sphinx

MySQL fulltext search (FTS) is old and well known. It has a simple setup and requires only small changes for querying. For many people it’s more than enough to provide fulltext search. So, here’s the question: why add a new variable – Sphinx – into the system when the database already has the basic functionality? [...]

Limited disk space? Compact backups with Percona Xtrabackup 2.1

One very interesting feature, “Compact Backup,” is introduced in Percona XtraBackup 2.1. You can run “compact backups” with the  –compact option, which is very useful for those who have limited disk space to keep the database backup. Now let’s first understand how it works. When we are using –compact option with Innobackupex, it will omit the secondary index pages. This will make the backups more compact and this way they will take less space on disk but the downside of this is, the backup prepare process will take longer time because those secondary index pages will be recreated while preparing the backup. Here, we need to consider couple of things before implement …

[Read more]
June 2013 - MariaDB and Galera Synchronous Replication

Hi Visitor, and welcome to the June 2013 issue of the Open Query Newsletter.

In this issue:

  • short news
  • MariaDB replacing MySQL
  • Galera Synchronous Replication
  • Training days
  • upcoming events
  • tip: FULLTEXT indexing or SPHINX

read more

New XAMPP 1.8.2 for Windows, Linux and OS X

Hi,

We are excited to announce that we just released a new stable version of XAMPP that includes PHP 5.4

http://www.apachefriends.org/xampp.html

This version of XAMPP includes the following improvements:

  • Updated main components PHP to 5.4.16, MySQL to 5.5.32, Apache to 2.4.4, phpMyAdmin 4.0.4
  • Updated Linux and Mac OS X versions of XAMPP, which had not been updated for a while. Moving forward, we aim to keep them up to date and perform releases at the same time as the Windows version.
  • Updated the XAMPP Control Panel to 3.2.1 for Windows
  • New manager tools for Linux and OS X that allows starting / stopping servers using a GUI interface.
  • New GUI installers for Linux and OS X that match the Windows GUI installer.
  • Support for 64bit versions of Linux and OS X.
  • Expanded …
[Read more]
Eliminating duplicate users in MySQL

This is hypothetical. What would happen if I did the following? alter table mysql.user add unique key(User); I’m tossing this out there for people to think about because I’ve always thought that MySQL’s authentication model is a nuisance: MySQL considers both your host name and user name in identifying you because there is no reason to assume that a given user name belongs to the same person on all hosts.

Showing entries 13721 to 13730 of 44105
« 10 Newer Entries | 10 Older Entries »