Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 71 to 80 of 33096 10 Older Entries
Using sysbench 0.5 for performing MySQL benchmarks
+0 Vote Up -0Vote Down

Given the recent excitement & interest around OpenStack I wanted to make sure I was ready to conduct appropriate evaluations of system performance.  I generally turn to sysbench since it comes with a variety of different tests (accessed via –test= option interface), including:

  • fileio – File I/O test
  • cpu – CPU performance test
  • memory – Memory functions speed test
  • threads – Threads subsystem performance test
  • mutex – Mutex performance test

As you can see, sysbench lets you stress many of the fundamental components of your hardware and infrastructure, such as your disk subsystem, along with your CPUs and memory. An additional option exists that is designed to perform synthetic stress testing of MySQL, and I was surprised when I didn’t see it in the

  [Read more...]
Set up a blasting fast hosting solution with nginx and MariaDB
+0 Vote Up -0Vote Down
Tue, 2014-09-02 12:00svetoslavsavov

When you need a fast and reliable hosting solution, you should consider which web server and database system to use. Many sites find the combination of nginx (pronounced "engine x") and MariaDB to be an optimal solution. Let's see how to install and configure the applications to work together.

Nginx is a stable, lightweight, and fast open source web server. Nowadays it is the second most popular web server overall, after Apache. More and more system architects are installing it on their servers to support heavy resource demands and efficiently handle the traffic volume at popular web sites. Nginx can also serve as a reverse proxy service in front of Apache, and handle load-balancing.

  [Read more...]
Upscene releases Database Workbench 5
+0 Vote Up -0Vote Down

Upscene Productions is proud to announce the availability of the next major
version of the popular Windows based multi-DBMS development tool:

" Database Workbench 5 "

There have been numerous improvements to existing tools and the new, more consistent user interface is better than ever and works fine under Wine on Linux.

Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you!

"There is so much new in Database Workbench 5, I don't know where to start", says Martijn Tonies, founder of Upscene Productions. "This release adds code editor features, has diagramming improvements, comes in multiple editions, is fully HiDPI aware and offers tunnelling for MySQL and MariaDB connections. It all was a lot of work, but it was worth it!"

"We worked closely with out customer and implemented

  [Read more...]
#DBHangOps 09/04/14 -- R-Tree Indexes, DBAs and Networking, and more!
+0 Vote Up -0Vote Down
#DBHangOps 09/04/14 -- R-Tree Indexes, DBAs and Networking, and more!

All set for this week. Check out the recording below:

Hello everybody!

Join in #DBHangOps this Thursday, September, 04, 2014 at 11:00am pacific (18:00 GMT), to participate in the discussion about:

  • R-Tree index overview from Matt Lord
  • Index Fragmentation (requested by Shlomi)
  • What should a DBA know about networking?

Be sure to check out the #DBHangOps twitter search, the @DBHangOps twitter feed, or this blog post to get a link for the google hangout on Thursday!

See all of you on Thursday!

Show notes

Index Fragmentation

  • How do you handle index
  [Read more...]
Making MySQL Better at GitHub (the GitHub blog)
+0 Vote Up -0Vote Down
Suggestions for transitioning into Strict SQL-Mode
Employee +1 Vote Up -0Vote Down

As MySQL 5.6 now enables the SQL Mode STRICT_TRANS_TABLES for new installations, I have been running into users who have been upgrading from previous versions, and not quite sure how to test their application for compatibility with this new default.

For some applications converting warnings to errors presents an unknown-unknown, in that the operators of the system can not easily detect what may break. Certainly many deployments will have QA environments, but there is always some fear production queries are just a little bit different.

Since sql_mode is configurable on a per-session basis, there are some strategies that I have been recommending to ease transition:

  • Whitelist: Have all new application components enable strict mode by default. For example, if
  [Read more...]
Percona XtraDB Cluster 5.6.20-25.7 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on September 1st 2014. Binaries are available from downloads area or from our software repositories.

Based on Percona Server 5.6.20-68.0 including all the bug fixes in it, Galera Replicator 3.7,

  [Read more...]
Hunting for “Locked” queries with pt-stalk utility
+0 Vote Up -0Vote Down

Recently we faced an issue when Nagios reported significant amount of “Locked” queries.
To investigate and debug the issue we needed to get more insight about the state of MySQL and the OS at the time the locks occurred.
This is how we got the much needed information:

wget -O pt-stalk
chmod +x pt-stalk
mkdir -p /tmp/pt-stalk
sudo pt-stalk --daemonize --notify-by-email <EMAIL> --log /tmp/pt-stalk/pt-stalk.log --user root --dest /tmp/pt-stalk --function processlist --variable State --match Locked --threshold 20 --cycles=10 --sleep=15 --run-time=15

In this case we are running pt-stalk utility in background and trying to catch the case when there are 20+ Locked queries in processlist. When a match occurs, pt-stalk will collect a lot of OS and MySQL info and notify us by email.

pt-stalk: MySQL diagnostic data capturing
+0 Vote Up -0Vote Down

pt-stalk tool collects MySQL diagnostic data for further analysis to resolve intermittent issues.

Sometimes problems with MySQL can happen seemingly randomly and last for only a few seconds. Many times server issues arise and by the time we login to check, it seems to have disappeared, leaving us frustrated. So, we need to find a way to know what the server is up to when a problem occurs in order to fix it. We need a tool that automatically collects data, when a condition is met. Thanks to Percona Toolkit pt-stalk is available for just this task. It helps to diagnose the problem by capturing a ton of diagnostic data that can help us to pinpoint the cause of the issue.

pt-stalk watches a trigger condition to beome true, then collects data to help diagnose problems. The

  [Read more...]
Is automation killing old-school operations?
+0 Vote Up -0Vote Down
Join 27,000 others and follow Sean Hull on twitter @hullsean. I was shocked to find this article on ReadWrite: The Truth About DevOps: IT Isn’t Dead; It’s not even Dying. Wait a second, do people really think this? Truth is I have heard whispers of this before. I was at a meetup recently where the […]
10 Newer Entries Showing entries 71 to 80 of 33096 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.