You searched for install script on mysql

Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

April 24, 2013 By Ignacio Nin Leave a Comment

In our last 5.5 series release of Percona Server, we included a regression in the RPM packaging that prevented the server from restarting following an upgrade — instead, the server would remain stopped after the upgrade was completed regardless of its state before updating. This caused some problems for some users, especially if automatic upgrading was configured [...]

Filed Under: MySQL, Percona Software

Percona Monitoring Plugins 1.0.3 for MySQL now available

April 23, 2013 By Roman Vynar 4 Comments

Percona is glad to announce the release of Percona Monitoring Plugins 1.0.3 for MySQL — high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your existing in-house, on-premises monitoring solutions. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of [...]

Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available

April 17, 2013 By Hrvoje Matijakovic 2 Comments

Percona is glad to announce the release of Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL on April 17, 2013. Binaries are available from the downloads area or from our software repositories. New Features: Percona XtraDB Cluster has implemented initial implementation of weighted quorum. Weight for node can be assigned via pc.weight option in the wsrep_provider_options variable. [...]

Filed Under: MySQL, XtraDB Cluster Tagged With: libjemalloc library, pc.weight, Percona XtraDB Cluster

Percona Toolkit for MySQL Webinar Followup Questions

April 5, 2013 By Stephane Combaudon 1 Comment

I didn’t have time to answer all of the questions during Wednesday’s MySQL webinar, “5 Percona Toolkit Tools That Could Save Your Day,” but as promised, here are all of the questions and my answers. (A recording is available here.) Q: One of the links to download the Percona Toolkit for MySQL (percona.com/get/percona-toolkit.tgz) doesn’t work! A: [...]

Filed Under: MySQL, MySQL Webinars, Percona Toolkit Tagged With: MySQL Webinars, Percona Toolkit, Stephane Combaudon

MySQL 5.6 – InnoDB Memcached Plugin as a caching layer

March 29, 2013 By Mike Benshoof 10 Comments

A common practice to offload traffic from MySQL 5.6 is to use a caching layer to store expensive result sets or objects. Some typical use cases include: Complicated query result set (search results, recent users, recent posts, etc) Full page output (relatively static pages) Full objects (user or cart object built from several queries) Infrequently [...]

Filed Under: MySQL Tagged With: caching layer, InnoDB, Memcached, Mike Benshoof, MySQL 5.6

InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By Ernie Souhrada 1 Comment

I’ve never been a very big fan of MyISAM; I would argue that in most situations, any possible advantages to using MyISAM are far outweighed by the potential disadvantages and the strengths of InnoDB. However, up until MySQL 5.6, MyISAM was the only storage engine with support for full-text search (FTS). And I’ve encountered many [...]

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: Ernie Souhrada, FTS, FullText Search, InnoDB, MyISAM, MySQL 5.6

Announcing Percona Server for MySQL version 5.5.29-30.0

February 26, 2013 By Hrvoje Matijakovic Leave a Comment

Percona is glad to announce the release of Percona Server for MySQL version 5.5.29-30.0 on February 26th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.29, including all the bug fixes in it, Percona Server 5.5.29-30.0 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details [...]

Filed Under: Events and Announcements, MySQL, Percona Software Tagged With: MariaDB, MySQL 5.5.29, Percona Server 5.5.29-30.0, Percona Server for MySQL

Using MySQL Sandbox with Percona Server

February 16, 2013 By Peter Zaitsev 3 Comments

One of the most useful tools if you’re working with multiple versions of MySQL Servers is MySQL Sandbox which allows you to maintain many different versions of MySQL, Percona Server, MariaDB. If you’re just working with single sandbox you can just use MySQL Sandbox in its most basic way and it will work:

root@smt2:~/sandboxes# make_sandbox /tmp/Percona-Server-5.5.29-rel29.4-401.Linux.x86_64.tar.gz
unpacking /tmp/Percona-Server-5.5.29-rel29.4-401.Linux.x86_64.tar.gz
Executing low_level_make_sandbox --basedir=/tmp/5.5.29 \
        --sandbox_directory=msb_5_5_29 \
        --install_version=5.5 \
        --sandbox_port=5529 \
        --no_ver_after_name \
        --my_clause=log-error=msandbox.err
...
no_run                         =
no_show                        =
do you agree? ([Y],n) Y
loading grants
... sandbox server started
Your sandbox server was installed in $HOME/sandboxes/msb_5_5_29

root@smt2:~/sandboxes# make_sandbox /tmp/Percona-Server-5.5.29-rel29.4-401.Linux.x86_64.tar.gz

unpacking /tmp/Percona-Server-5.5.29-rel29.4-401.Linux.x86_64.tar.gz

Executing low_level_make_sandbox --basedir=/tmp/5.5.29 \

--sandbox_directory=msb_5_5_29 \

--install_version=5.5 \

--sandbox_port=5529 \

--no_ver_after_name \

--my_clause=log-error=msandbox.err

...

no_run =

no_show =

do you agree? ([Y],n) Y

loading grants

... sandbox server started

Your sandbox server was installed in $HOME/sandboxes/msb_5_5_29

However [...]

Filed Under: MySQL Tagged With: MariaDB, MySQL Sandbox, Percona Server

Percona Monitoring Plugins 1.0.2 release: enterprise-grade MySQL monitoring and graphing capabilities

February 15, 2013 By Roman Vynar Leave a Comment

Percona is glad to announce the release of Percona Monitoring Plugins 1.0.2 — high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your existing in-house, on-premises monitoring solutions. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates, plugins, [...]

Filed Under: Events and Announcements, Percona Software Tagged With: percona monitoring plugins

Can’t Create Thread: Errno 11 (A Tale of Two Ulimits)

February 4, 2013 By Ernie Souhrada 10 Comments

Recently some of my fellow Perconians and I have noticed a bit of an uptick in customer cases featuring the following error message:

SQLSTATE[HY000] [1135] Can't create a new thread (errno 11); if you are not
out of available memory, you can consult the manual for a possible OS-dependent bug.

1 2	SQLSTATE[HY000] [1135] Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug.

The canonical solution to this issue, if you do a bit of Googling, is to increase the number of processes / threads available to the MySQL user, typically by adding a [...]

Filed Under: Insight for DBAs, MySQL Tagged With: 90-nproc.conf, Errno 11, Ulimits

Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

Percona Monitoring Plugins 1.0.3 for MySQL now available

Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available

Percona Toolkit for MySQL Webinar Followup Questions

MySQL 5.6 – InnoDB Memcached Plugin as a caching layer

InnoDB Full-text Search in MySQL 5.6 (part 1)

Announcing Percona Server for MySQL version 5.5.29-30.0

Using MySQL Sandbox with Percona Server

Percona Monitoring Plugins 1.0.2 release: enterprise-grade MySQL monitoring and graphing capabilities

Can’t Create Thread: Errno 11 (A Tale of Two Ulimits)

Search

Top Searches

Percona Webinars

ABOUT PERCONA

Percona MySQL Training

Percona Careers

SOFTWARE FROM PERCONA

SERVICES FOR MYSQL USERS

ABOUT THIS BLOG AND PERCONA