Tuesday, September 25, 2012

MySQL and PHP are two key components in the open-source LAMP stack, and are widely used by web developers. One day you launched a website, and it gradually gained traction and now serves hundreds times more traffic than day one. As a PHP developer, have you ever looked back and adjusted the MySQL configurations accordingly to meet the most current website load? Have you ever wondered if there are secret tips you might have missed or common mistakes that you could have avoided but never thought of? If you answered yes to either question, this presentation is for you!

In this live webinar, PHP & MySQL experts Ulf Wendel and Johannes Schlüter will share the top 10 tips and mistakes for PHP developers. After a quick overview of lesser known but cool client and server features and plugins, and a recap of the benefits of the relational database model, we quickly jump to the hot irons, including:
• …

One of the MySQL bugs having birthday today is Bug #30994 which i filed five years ago.

So i decided to give it a little birthday present by finally writing a patch for it myself:

https://code.launchpad.net/~hartmut-php/maria/5.5-bug30994

On Percona Live New York I’ll be giving two talks

• “Percona XtraDB Cluster: HA solution for MySQL”. I will give introduction in MySQL clustering and show how Percona XtraDB Cluster solves HA and scalability problems.
• MySQL and SSD: usage and tuning. If you follow this blog, you know that I do quite a bit experiments with SSD / Flash. In this talk I will share my experience, results and some tuning advises.

Right now it is the best time to get tickets to Percona Live New York as our Advanced Rate prices end this Saturday.

If you are working with MySQL and you are in …

The MySQL developer tools team announces the availability of version 5.2.44 of the MySQL Workbench GUI tool. This version contains various fixes and minor enhancements and includes 8 resolved bugs.

This version improves the Migration Tool to support additional RDBMSes
- PostgreSQL 8.x and 9.x
- Sybase Adaptive Server Enterprise 15.x
- Any RDBMS that implements the INFORMATION_SCHEMA views from the SQL-92 standard

Additionally, MySQL Utilities 1.1.0 have been included on the distribution.

For a full list of issues fixed in this release, see http://dev.mysql.com/doc/workbench/en/changes-5.2.x.html

Please get your copy from our Downloads site. In Windows, you can also use the MySQL Windows Installer to update Workbench.

Sources and binary packages are available for several platforms, …

The MySQL developer tools team announces the availability of version 5.2.43
of the MySQL Workbench GUI tool. This version contains various fixes
and minor enhancements and includes 53 resolved bugs.

With this version, Fedora 15 packages are replaced with Fedora 17.
Also, Gatekeeper in Mac OS X Mountain Lion is now properly handled.

For a full list of issues fixed in this release, see http://dev.mysql.com/doc/workbench/en/changes-5.2.x.html

Please get your copy from our Downloads site. In Windows, you can also
use the MySQL Windows Installer to update Workbench.

Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

http://dev.mysql.com/downloads/workbench/

…

In my three previous blogs I wrote about our implementation of Fractal Tree Indexes on MongoDB, showing a 10x insertion performance increase, a 268x query performance increase, and a comparison of covered indexes and clustered indexes. The benchmarks show the difference that rich and efficient indexing can make to your MongoDB workload.

It’s one thing for us to benchmark MongoDB + TokuDB and another to measure real world performance. If you are looking for a way to improve the performance or scalability of your MongoDB deployment, we can help …

Ryan Betts and Ning Shi of VoltDB give a talk and demo of VoltDB at the Boston MySQL User Group on March 12, 2012. They presented a use-case based overview of what VoltDB is and the types of problems it helps to solve. They discussed some newer VoltDB features, including the WAN replication beta functionality and command logging (a durable write-ahead log).

Richard Laskey did an amazing job with the video and audio. I am absolutely awestruck that you can actually *see* the demo – usually small text is unreadable! My hats off to Richard, who does all this as a volunteer.

The

Thanks….
Nice posting……it works for me….

This mysql stored function will return you all the dates between given dates having specified day. In short if you say: give me all Sundays in this month. I have…

The post MySQL function returns dates of specified day & between date range first appeared on Change Is Inevitable.

Getting the MySQL Workbench’s Database Migration has been interesting, and at present incomplete. While I can now successfully connect to the SQL Server 2012 source database and capture a schemata list, migrating the data from SQL Server doesn’t work. Actually, the connection doesn’t work without modifying a Python library in the current MySQL Workbench release.

I blogged about the SQL Server 2012 installation and Windows SQL Server DSN setup last night because the development manager requested them to create a repeatable test case to help resolve Bug 66516. The existing blog post on the MySQL Workbench blog provides …