Henrik has already posted it over on the Drizzle Blog, but I thought I’d give a shout out here too.
We’re holding a Drizzle Day right after the Percona Live MySQL Conference and Expo in April. So, since you’re all like me and don’t book your travel this far in advance, it’ll be easy to stay for the extra day and come and learn awesome things about Drizzle.
I’m also pretty glad that my employer, Percona is sponsoring the event.
I’m scheduled to deliver several free MySQL webinars via Percona and ODTUG in the upcoming weeks. I hope you can join me:
Further Reading:
[Read more]It might surprise you to hear this, but I had no idea whether my talks would be accepted. The committee decided on that, and neither I nor anyone else at Percona is on the committee. In any case, I’ll be giving some tutorials again this year, and two of my talks have been accepted: Measuring Scalability and Performance With TCP and Diagnosing intermittent performance problems. This seems like an appropriate place to mention a few words about the conference organization.
There are several traps when using Typo3 4.5 and the direct_mail newsletter extension with an external SMTP server. Here’s how to set it up:
First of all, prepare the SMTP server (for instance, by allowing the IP of the Web server as relay host or setting up user authentication).
In the Typo3 Install tool, set the [MAIL] settings correctly (transport=smtp, transport_smtp_server, defaultMailFromAddress and defaultMailFromName). To see if it works, send a mail from within the Install tool and check its headers (the SMTP server should be mentioned in a Received line).
As a dependency for direct_mail SMTP usage, you need PEAR::Mail with Net::SMTP support. Mail.php must be in the include path. Install it on your server, or if you only have a Webspace, put the necessary files into a /pear directory and add this directory to the include_path. Check whether it works using a modified …
[Read more]
A big thanks to Xiaobin Lin for taking the time to submit and the
related patch for bug
#64248. The patch is based on 5.5.20
This should help users to restore their database faster thanks to
fast index creation. More information is available via the
bugs page. I have heard that this is just one of
several patches he has contributed.
Contributions such as this, help MySQL to continue to deliver an
always improving product.
So a big “Thank You” from the MySQL team.
Hi Everyone,
Just a quick note to let you know that I've just finished up
adding some new features to XtraBackup Manager.
You can now get better visibility into what is going on inside
XtraBackup Manager with the "xbm status"
command.
It will allow you to see which backup jobs are running and also
those which may be waiting to start, due to the maximum number of
concurrent backup tasks already running.
It looks/works as follows:
[xbm@localhost ~]$ xbm status[Read more]
XtraBackup Manager v0.8 - Copyright 2011-2012 Marin Software
Currently Running Backups:
+--------+-----------+-------------+---------------------+-------------------+------+
| Job ID | Host | Backup Name | Start Time | …
its very informative.
i enjoyed reading this.
SkySQL and MariaDB are delighted to announce that we’ll be co-hosting our first Solutions Day for the MySQL® Database on 13 April, 2012, at the Hyatt Regency Santa Clara.
During this one day event, attendees will receive free, hands-on training on MySQL database solutions from the experts at SkySQL, MariaDB, Continuent, ScaleDB, Severalnines, Sphinx, and Webyog, among others.
As well, SkySQL and MariaDB will bring together industry visionaries, including Michael (Monty) Widenius and David Axmark, the original authors of the MySQL database, to share their insights on current and future …
[Read more]
In relation to this MPB post, there is a command to output
data into a file and then to load it back into MySQL to resolve
locks. (An example of a really big reporting query that
could be quite heavy, can be found here.)
There is an issue with outputting data into a
file through MySQL if the file already exists. For
example:
mysql> use mysql
Reading table information for completion of table and column
names
You can turn off this feature to get a quicker startup with
-A
Database changed mysql> select * from user into outfile
'/tmp/user.sql';
Query OK, 10 rows affected (0.00 sec) mysql> select *
from user …
The latest episode of our “Meet The MySQL Experts” podcast focuses on MySQL & PHP! Andrey Hristov and Johannes Schlüter from the MySQL Connectors Team talk about various ways PHP developers can use MySQL, and also how they can leverage the MySQL Query Analyzer to optimize queries.
Enjoy the podcast!
For additional information about MySQL & PHP, check out our last special edition newsletter.