]]>
]]>

You are here

Feed aggregator

Restoring an incremental backup

Lastest Forum Posts - May 18, 2015 - 3:46am
Hello all,

As I am new to Xtrabackup I am facing some difficulties on how to restore an incremental backup. In more details:

Step 1. Take a fll backup
#innobackupex --user=<user> --password=<pwd> /home/mysql_test/MYSQL_BACKUPS/

Step 2. Create an incremental backup
#innobackupex --incremental --user=<user> --password=<pwd> /home/mysql_test/MYSQL_BACKUPS/ --incremental- basedir=/home/mysql_test/MYSQL_BACKUPS/2015-05-14_15-55-09_FULL_BACKUP

where2015-05-14_15-55-09_FULL_BACKUP -> latest full backup

The above will create another dir under /home/mysql_test/MYSQL_BACKUPS/ with execution date e.g 2015-05-15_15-55-09_1st_INCREMENTAL_BACKUP

Step 3. Create another incremental backup:
#innobackupex --incremental --user=<user> --password=<pwd> /home/mysql_test/MYSQL_BACKUPS/ --incremental- basedir=/home/mysql_test/MYSQL_BACKUPS/2015-05-15_15-55-09_1st_INCREMENTAL_BACKUP

and this will create the next incremental backup: e.g 2015-05-16_15-55-09_2nd_INCREMENTAL_BACKUP

So up to now we have one full and 2 incremental backups under our backup directory:

/home/mysql_test/MYSQL_BACKUPS/
- 2015-05-14_15-55-09_FULL_BACKUP
- 2015-05-15_15-55-09_1st_INCREMENTAL_BACKUP

-2015-05-16_15-55-09_2nd_INCREMENTAL_BACKUP

Here is where I face my dificulties and need your help, how to restore one of my 2 incremental backups...

Based on https://www.percona.com/doc/percona-...obackupex.html before restoring an incremental backup we need to prepare it where I do:

Step 4. Prepare the incremental backup:
#innobackupex --apply-log --redo-only /home/mysql_test/MYSQL_BACKUPS/<???????>

Question 1. Which incremental I should use for this command, should I use this command for all the incrementals created above (1st... and 2nd...)

Question 2. After preparing my incremental backups (if this is what I have to do on Step 4) how do I restore one incremental backup e.g the latest one 2015-05-16_15-55-09_2nd_INCREMENTAL_BACKUP

Thank you all and looking forward for your suggestions
George

Galera synchronization broken

Lastest Forum Posts - May 16, 2015 - 3:23pm
Hi, I'm new to percona cluster and I need advice about shutting down of cluster nodes.
I have 2 nodes and this scenario:

1. Both servers A and B are running in cluster.
2. Server A performs normal shutdown. The seqno in grastate.dat is 1.
3. There are some writes on server B.
4. Server B performs normal shutdown. The seqno in grastate.dat is 2.
5. Server A is starting as a first node of the cluster.
6. There are some writes on server A.
7. Server B starts and joins the cluster. At this moment, the changes on each node aren't replicated to the other node and so data aren't consistent, although cluster doesn't log any error and is normally running.

I consider this scenario, because my customer wants to run cluster nodes as virtual guests in Microsoft Hyper-V on Windows, so I must suppose that he will perform updates and restarts on the host machine, and so the cluster nodes will be restarted without my control. I can add the third node to the cluster (propably Galera Arbitrator) to the cluster, but in will run on the same host as the node A, and so it isn't a solution.
Can you please advice me, how to avoid inconsistent data in this scenario?
Thanks and sorry for my English.
Thomas

WA TCH Pitch Perfect 2 SUB English ONLINE 2015 DOWNLOAD

Lastest Forum Posts - May 16, 2015 - 12:46pm

The official plot is: Pitch Perfect 2 will tell a new story: An Earth where peace has arrived. However, remnants of

VIDEO -> http://regionmovie.com/movies/5563-pitch-perfect-2
VIDEO -> http://regionmovie.com/movies/5563-pitch-perfect-2
VIDEO -> http://regionmovie.com/movies/5563-pitch-perfect-2


Pitch Perfect 2 Full Movie English SUb , Watch Pitch Perfect 2 HD, Watch Pitch Perfect 2 online

Putlocker, Watch Pitch Perfect 2 online Megashare, Watch Pitch Perfect 2 Movie online,Pitch Perfect 2

Pitch Perfect 2 2015 English Sub , Watch Pitch Perfect 2 2015 Movie Online Free. Watch Pitch Perfect 2 2015 .

Pitch Perfect 2 2015 Online on putlocker, viooz, megashare..

The official plot is: Pitch Perfect 2 will tell a new story: An Earth where peace has arrived. However, remnants of

balls.

Watch Pitch Perfect 2 Free,Pitch Perfect 2 2015 Full Movie Online, Watch Pitch Perfect 2

of F 2015 Full Movie ,Pitch Perfect 2 Movie Online ,Pitch Perfect 2 Download ,Dragon Ball Z:

Resurrection of F Full Movie ,Pitch Perfect 2 Online ,Pitch Perfect 2 Film ,Dragon Ball Z:

Resurrection of F Full Movie Online ,Pitch Perfect 2 Full Movie Stream ,Pitch Perfect 2 Watch Online

================================================== ============



Watch Pitch Perfect 2 †“ In a future where the population is divided by personality types, one woman branded "

Watch Pitch Perfect 2 " uncovers a conspiracy to eliminate all who bear her misfit †¦

Watch Pitch Perfect 2 Online Free The legit and trusted place to surely

Watch Pitch Perfect 2 Online Free on your computer in high definition quality without even having to spend a dime.

Watch Pitch Perfect 2 or Download Full Movie Online Diverget †¦

Watch Pitch Perfect 2 or Download Full Movie Online Diverget 2014. 7 likes · 2 talking about this.

Watch Pitch Perfect 2 or Download Full Movie Online Diverget 2014, High †¦

Watch Pitch Perfect 2 (2014) Free Online †“ OVGuide

Watch full length Watch Pitch Perfect 2 Movie for Free Online. Streaming Free Films to

Watch Online including Movie Trailers and Movie Clips.Official

Watch Pitch Perfect 2 Movie Watch Online Download HD Full

Watch Pitch Perfect 2 Movie Online, Download

Watch Pitch Perfect 2 Online,Pitch Perfect 2 Movie

Watch Pitch Perfect 2 Online Streaming

Watch Pitch Perfect 2 Full Movie Online

Watch Pitch Perfect 2 Full Movie Online

Watch Pitch Perfect 2 English Film Free Watch Online

Watch Pitch Perfect 2 English Film,

Watch Pitch Perfect 2 English Full Movie Watch Online

Watch Pitch Perfect 2 English Full Movie Watch Online

Watch Pitch Perfect 2 Watch Online

Watch Pitch Perfect 2 English Full Movie Watch Online

Watch Pitch Perfect 2 Watch Online, Watch Online Watch Pitch Perfect 2

Watch Pitch Perfect 2 English Full Movie Download

Watch Pitch Perfect 2 English Full Movie Free Download

Watch Pitch Perfect 2 English Full Movie Online Free Download

Watch Pitch Perfect 2 Free Download

Watch Pitch Perfect 2 HD Full Movie Online

Watch Pitch Perfect 2 HD English Full Movie Download

Watch Pitch Perfect 2 English Full Movie

Watch Pitch Perfect 2 Full Movie Online

Watch Pitch Perfect 2 Movie Online

Watch Pitch Perfect 2 English Full Movie Watch Online

Watch Pitch Perfect 2 Full Movie

Watch Pitch Perfect 2 Online

Watch Pitch Perfect 2 English Full Movie Watch Online

Watch Pitch Perfect 2 Movie Watch Online

Watch Pitch Perfect 2 English Full Movie

Watch Pitch Perfect 2 Full Movie,

Watch Pitch Perfect 2 Full Movie

Watch Pitch Perfect 2 English Full Movie Online

Watch Pitch Perfect 2 Film Online

Watch Pitch Perfect 2 English Film

Pitch Perfect 2 Full Movie English SUb , Watch Pitch Perfect 2 HD, Watch Pitch Perfect 2

of F online Putlocker, Watch Pitch Perfect 2 online Megashare, Watch Pitch Perfect 2 Movie

online,Pitch Perfect 2 2015 English Sub , Watch Pitch Perfect 2 2015 Movie Online Free. Watch Dragon

Perfect 2 2015 . Watch Pitch Perfect 2 2015 Online on putlocker, viooz, megashare..
TIME‎ -
-@DOWNLOAD-TORRENT Pitch Perfect 2 Online

W ATCH Piku Road FULL MOVIE

Lastest Forum Posts - May 16, 2015 - 12:46pm
Watch Piku Road 2015 Online Putlocker” Through Some ways over the internet that means legitimate ways to “watch Piku Road 2015 online Full movie” ultimate source to watch full movie and also sometimes free online. Have your say!! watch Piku Road 2015 movie is another amazing film released just right these two weeks ago and has made its impact on the box office by being on the top of most pirated movie list.
=®=®=®=®=®=.=.=.=.=.=.=.=.=.=.=.=.= .=.=.=.=.=.=®=®=®=®=®=
Click Here To Watch >>> http://1ststreammovie.com/movies/989644-piku
Click Here To Watch >>> http://1ststreammovie.com/movies/989644-piku
=®=®=®=®=®=.=.=.=.=.=.=.=.=.=.=.=.= .=.=.=.=.=.=®=®=®=®=®=
Piku Road Full Mov Online
Piku Road Full Mov Online
Piku Road English Film Free Watch Online
Piku Road English Film Free Watch Online
Piku Road English Film, Watch Piku Road English Full Mov Watch Online
Piku Road English Full Mov Watch Online
Piku Road Watch Online
Piku Road English Full Mov Watch Online
Piku Road Watch Online, Watch Online Watch Piku Road
Piku Road English Full Mov Download
Piku Road English Full Mov Free Download
Piku Road English Full Mov Online Free Download
Piku Road Free Download
Piku Road HD Full Mov Online
Piku Road HD English Full Mov Download

Issues trying to run Percona Server on Centos 7 with attached disk

Lastest Forum Posts - May 15, 2015 - 11:16pm

I am attempting to run Percona Server on CentOS 7 in a VM on Windows Azure. This is using an attached disk for the data storage.

Unfortunately when I try and get the server to start with the datadir being on the attached disk, it fails for the following reason:
May 16 06:05:20 pppudb6 mysqld_safe[50758]: /usr/bin/mysqld_safe: line 184: /datadrive/mysqldata/binlogs/udb6.log: Permission denied
May 16 06:05:20 pppudb6 mysqld_safe[50758]: touch: cannot touch ‘/datadrive/mysqldata/binlogs/udb6.log’: Permission denied
May 16 06:05:20 pppudb6 mysqld_safe[50758]: chown: cannot access ‘/datadrive/mysqldata/binlogs/udb6.log’: Permission denied
May 16 06:05:20 pppudb6 mysqld_safe[50758]: chmod: cannot access ‘/datadrive/mysqldata/binlogs/udb6.log’: Permission denied
May 16 06:05:20 pppudb6 mysqld_safe[50758]: 150516 06:05:20 mysqld_safe mysqld from pid file /var/lib/mysql/mysql.pid ended
May 16 06:05:20 pppudb6 mysqld_safe[50758]: /usr/bin/mysqld_safe: line 147: /datadrive/mysqldata/binlogs/udb6.log: Permission denied
May 16 06:05:20 pppudb6 systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
May 16 06:08:54 pppudb6 systemd[1]: Stopping MySQL Percona Server...
May 16 06:08:54 pppudb6 systemd[1]: Stopped MySQL Percona Server.
May 16 06:08:54 pppudb6 systemd[1]: Unit mysqld.service entered failed state.


Permissions look fine as per:

drwxr-xr-x. 76 mysql mysql 4.0K May 15 03:48 2015-05-12_03-06-22 * This is the mysql data dir
drwxr-xr-x. 2 mysql mysql 4.0K May 15 04:36 binlogs * binlogs dir

Yet, when it attempts to run it says there is the permission issue. If I run it using default settings in /var/lib/mysql it works, just not on the attached disk which would be useful if I could get it to work!

Any ideas? I can get this to run fine on Ubuntu, but not on CentOS.

Duplicate post

Lastest Forum Posts - May 15, 2015 - 11:15pm
Duplicate post

Sort aborted: Query execution was interrupted

Lastest Forum Posts - May 15, 2015 - 8:33pm
I have a Percona XtraDB cluster 5.6 with 3 nodes, however few hours ago it started to log the following error message:
18566 [ERROR] /usr/sbin/mysqld: Sort aborted: Query execution was interrupted

The bootstrap node has crashed and few hours later the other two nodes did crash too.

I have restarted all three nodes but I still getting this error on the log.

I read few threads about this problem but none of them gave me an answer.
I'd increase the sort_buffer_size to 7MB, my disk has plenty space, my Galera is 3.8.

This message are being logged by all three nodes.

Does anyone have an idea of what is happening?

Thanks,

MySQL QA Episode 2: Build a MySQL server – Git, Bazaar, compiling & build tools

Latest MySQL Performance Blog posts - May 15, 2015 - 12:00am

Welcome to MySQL QA Episode 2: Build a MySQL Server – Git, Bazaar (bzr), Compiling, and Build Tools

In this episode you’ll learn how to build Percona Server and/or MySQL Server for QA purposes & more in this short 25 minute tutorial.

In HD quality (set your player to 720p!)

To watch the other episodes in this series, see the MySQL QA & Bash Linux Training Series post. If you missed MySQL QA Episode 1, it was titled “Bash/GNU Tools & Linux Upskill & Scripting Fun.” You are read it here.

If you have any questions or comments, please leave them below.

The post MySQL QA Episode 2: Build a MySQL server – Git, Bazaar, compiling & build tools appeared first on MySQL Performance Blog.

Perth Removalist

Lastest Forum Posts - May 14, 2015 - 11:11pm
Make your removals in Joondalup way faster and hassle free with the help of Able Removals. We are known for affordability and reliability. You can contact us to get a quote immediately.

http://www.ableremovals.net.au/

Which paramteres show overall optimization.

Lastest Forum Posts - May 13, 2015 - 1:53am
Hi,
I am using PCT to track DB overall optimization progress.
While it may be obvious, I would like to ask which parameters of PCT dashes are signs of overall improvement.
FYI. I plan to convert some tables from myisam to innodb engine. Next, port all DB to a SSD drive and etc.
While doing it I wish to if my DB performs better.

10x

any specific mysqldump options for mysql 5.5 to percona 5.6

Lastest Forum Posts - May 12, 2015 - 8:37pm
does simply mysqldump --all-databases suffice? This is because I got below message although I did not plan to restore mysql db along on percona xtradb cluster node.

: -- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.

Optimizer problems?

Lastest Forum Posts - May 12, 2015 - 8:03am
Here's a little mystery - I'll let the code speak for itself:

mysql> select max(id) from mytable;
+-----------+
| max(id) |
+-----------+
| 577711424 |
+-----------+
1 row in set (0.00 sec)

mysql> select now(), created from mytable where id in (577711424);
+---------------------+---------------------+
| now() | created |
+---------------------+---------------------+
| 2015-05-12 12:04:53 | 2015-05-12 12:03:24 |
+---------------------+---------------------+
1 row in set (0.00 sec)

Now for the kicker:

mysql> select now(), created from mytable where id in (select max(id) from mytable);
+---------------------+---------------------+
| now() | created |
+---------------------+---------------------+
| 2015-05-12 12:05:10 | 2015-05-12 12:05:10 |
+---------------------+---------------------+
1 row in set (6 min 18.60 sec)

mysql> explain select now(), created from mytable where id in (select max(id) from mytable);
+----+--------------------+-------+------+---------------+------+---------+------+-----------+------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+--------------------+-------+------+---------------+------+---------+------+-----------+------------------------------+
| 1 | PRIMARY | mytable | ALL | NULL | NULL | NULL | NULL | 292257304 | Using where |
| 2 | DEPENDENT SUBQUERY | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Select tables optimized away |
+----+--------------------+-------+------+---------------+------+---------+------+-----------+------------------------------+
2 rows in set (0.00 sec)

Bizarre apt-get behavior - restarts Percona server install on a production server

Lastest Forum Posts - May 12, 2015 - 7:55am
This happens trying to apt-get mailutils

Ubuntu 14.04LTS happily running Percona Server (GPL), Release 72.1, Revision 0503478 - when I run "apt-get install mailutils" (to be able to send out email messages when space is low, etc) it restarts the Percona server install (with the pink full-window asking me to enter a new root password...) -

dpkg --get-selections shows the persona packages installed normally.

Any idea what might be going on?

Performance tab and Queries tab empty

Lastest Forum Posts - May 11, 2015 - 4:18pm
Hi,

Performance tab and Queries tab are empty, Metrics tab is ok.
I guess I have to set an MySQL instance.
Since we have a tight firewall rules.
Could please provide what IPs are being used for the PCT service.

10x

Higher CPU utilization after 5.6 Percona server upgrade

Lastest Forum Posts - May 11, 2015 - 4:05pm
We are in process of upgrading our (Percona) Mysql 5.5 mysql servers to Mysql 5.6. We have upgraded all our slaves except one.
However, we have observed that for the same workload, 5.6 slaves are consuming more user CPU.

CPU utlization on 5.5 slave continues to be lower. For comparison, we have setup an additional slave on Oracle's community Mysql 5.6. Here the cpu utilization is lower.

Does the percona Mysql 5.6 consumes more cpu than previous version (5.5) or Oracle community 5.6 ? Has anyone else observed similar behavior? In our environment this observation is consistent and reproducible. let me know if anyone has solution for it.


Slave upgraded to Percona 5.6 (EST Timezone)


01:20:01 PM CPU %user %nice %system %iowait %steal %idle
01:20:01 PM all 10.97 0.00 0.05 0.19 0.00 88.79
01:30:01 PM all 11.20 0.00 0.06 0.01 0.00 88.73
01:40:01 PM all 9.48 0.00 0.08 0.02 0.00 90.41


Slave still on 5.5:

10:20:01 AM CPU %user %nice %system %iowait %steal %idle

10:20:01 AM all 0.26 0.00 0.04 0.39 0.00 99.31
10:30:01 AM all 0.23 0.00 0.10 0.08 0.00 99.58
10:40:01 AM all 0.32 0.00 0.05 0.17 0.00 99.47



Slave upgraded to Oracle Mysql 5.6:

10:20:01 AM CPU %user %nice %system %iowait %steal %idle

10:20:01 AM all 0.26 0.00 0.04 0.39 0.00 99.31
10:30:01 AM all 0.23 0.00 0.10 0.08 0.00 99.58
10:40:01 AM all 0.32 0.00 0.05 0.17 0.00 99.47

Installation issue on Ubuntu 12.04 LTS

Lastest Forum Posts - May 11, 2015 - 10:28am
Hi all,

I'm trying to install Percona 5.5 on an Ubuntu 12.04 LTS and I get this error:

root@test:/etc/apt# apt-get install percona-server-server-5.5 percona-server-client-5.5
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
percona-server-client-5.5 : Depends: libdbi-perl but it is not installable
percona-server-server-5.5 : Depends: libdbi-perl but it is not installable
Depends: libdbd-mysql-perl but it is not installable
Depends: libaio1 (>= 0.3.93) but it is not installable
E: Unable to correct problems, you have held broken packages.

I googled this and found a bug issue dating 2013 that supposed to be fixed but nothing recent.

Any help will be appreciated.

Thanks,

Serge

How Percona Support handles bugs

Latest MySQL Performance Blog posts - May 11, 2015 - 3:00am

One of the great values of a Percona Support contract is that we provide bug fixes for covered software, and not just support in terms of advice on how to use it. This is the skill which is most likely missing from in-house for most customers, as it requires a team with code knowledge to build and test infrastructure – something only a few companies can afford to invest in.

There is a lot of misunderstanding about bugs. What is a bug? What is a feature? What is a repeatable bug? How will Percona troubleshoot the bug? In this post I will answer some of the questions about this.

Bugs vs. Features ⎼ One thing a lot of people have a hard time understanding is the difference between a bug and a feature, or when software was designed to work a certain way which might be unwelcome. There is a gray line here, but you need to expect that some of the things you consider to be bugs will be seen as behavior-change features and will be considered as such.

Unfixable Bugs ⎼ There are some behaviors that any sane person would call a bug, but which arise from design limitations or oversight that are impossible to fix in the current GA version without introducing changes that would destabilize it. Such bugs will need to be fixed in the next major GA release or sometimes even further in the future. Some bugs are not bugs at all but rather design tradeoffs made. These can’t be “fixed” unless different design tradeoffs are chosen.

Workaround ⎼ There are going to be unexpected behaviors, unfixable bugs and bugs that take awhile to fix, so your first practical response to running into the bug is often finding a workaround which does not expose it. The Percona Support team will help find a workaround that causes minimal impact to your business, but be prepared: changes to the application, deployed version, schema or configuration will often be required.

Emergencies ⎼ When you have an emergency, our focus is to restore the system to working order. In a complex system a bug fix can often not be delivered in a short period of time, which typically means finding a workaround.

Bug Turnaround It is not possible to guarantee the turnaround on a bug fix, as all bugs are different. Some bugs are rather trivial and we might be able to provide a hotfix 24 hours after we have a repeatable test case. In other cases the bug might be complicated and take weeks of engineering to fix or even might be impossible to fix in the current GA version.

Verified Bug Fixes When you submit the bug we have to verify if it is actually being a bug. In many cases it might be intended behavior; in others, a user mistake. It is also possible that the behavior has happened once and can’t be repeated. Having a repeatable test case that reveals the bug is the best way to have a bug fixed quickly. You might be able to create a repeatable test case, or our support team might be able to help you create the test case.

Sporadic Bugs These are very hard bug types that happen sporadically over a period of time. For example, you might have a system crash once every 3 months with no way to repeat it. The cause of such bugs can be very complicated; for example, a buffer overrun in one piece of code can cause corruption and crash in another place hours later. There are a number of diagnostic tools that exist for such bugs, but generally they take quite awhile to resolve. In addition, without a repeatable test case, it is often impossible to verify that the proposed fix actually resolves the bug.

Environmental Bugs ⎼ Some bugs are caused by what can be called your environment. It could be some hardware bugs or incompatibilities, a build not quite compatible with your version of  operating system, operating system bugs, etc. In some cases we can very clearly point to the environment problems. In others we can suspect the environment is an issue and we may ask you to see if the bug also happens in another environment, such as different hardware or OS installation.

Hot Fixes As our default policy we fix bugs in the next release of our software so it can go through the full QA cycle, be properly documented, etc. If you have implemented a workaround and you can wait until the next release, this is the best choice. If not, with the Percona Platinum Support contract, we can provide you with a hotfix that is a special build containing the version of the software you’re running, and with only the bug fix of interest applied. Hotfixes are especially helpful if you’re not looking to do a full software upgrade – requiring several revisions – but want to validate the fix with the minimum possible changes. Hotfixes might also be different from the final bug fix that goes into the GA release. With hotfixes, our goal is to provide a working solution for you faster. Afterward we may optimize or re-architect the code, come up with better option names, etc.

Bug Diagnostics Depending on the nature of the bug there are multiple tools that our support team will use for diagnostics – finding a way to fix the bug. To set expectations correctly, it can be a very involved process, where you might need to provide a lot of information or try things on your system, such as:

  • Test case. If you have a test case that can be repeated by the Percona team to trigger the bug, the diagnostic problem is solved from the customer side. Internal debugging starts at this point. It might not be easy to get to that.
  • If we have a crash that we can’t repeat on our system we often will ask you to enable “core” file, or run the program under a debugger so we can get more information when the crash happens.
  • If the problem is related to performance, you should be ready to gather both MySQL information such as EXPLAIN, status counters, information from performance schema, etc., along with system level information such as pt-pmp output,  pt-stalk,  oprofile, perf, etc.
  • If the problem is a “deadlock,” we often need information from gdb about the full state of the system. Information from processlist, performance_schema, SHOW ENGINE INNODB STATUS can also be helpful.
  • It can be very helpful when you have a test system on which you can repeat the problem in your environment and where you can experiment without impacting production. It is not possible in all cases, but is very helpful.
  • Sometimes, for hard-to-repeat bugs, we will need to run a special diagnostics build that provides us with additional debug information. In others, we might need to run a debug build or do a run under valgrind or other software designed to catch bugs. It often has a large performance impact, so it is good to see how your workload can be scaled down in order for this to be feasible.
  • Depending on your environment we might need to login to troubleshoot your bug or might request that you upload the data needed to repeat the bug in our lab (assuming it is not too sensitive). In cases where direct login is not possible, we can help you to come to a repeatable test case via phone, chat, or email. Using screen sharing can also be very helpful.

Bugs and Non-Percona Software ⎼ Percona Support covers some software not produced by Percona. For open source software, if it is not exempt from bug fix support, we will provide the custom build with a bug fix as well as provide the suggested fix to the software maintainer for its possible inclusion in the next release. For example, if we find a bug in the MySQL Community Edition, we will pass our suggested fix to the MySQL Engineering team at Oracle. For other software that is not open source, such as Amazon RDS, we can help to facilitate creation and submission of a repeatable test case and workaround, but we can’t provide a fix as we do not have access to the source code.

In Conclusion When I think about software bugs, I find some good parallels with human “bugs” (diseases).  Some issues are trivial to diagnose and the fix is obvious. Others might be very hard to diagnose I guess many of us have been in a situation where you visit doctor after doctor and tell them your symptoms, and they run tests but still can’t figure out what’s wrong. Once a diagnosis is done, though, it is not always given the “fix” available or feasible, and while a complete solution is preferred, sometimes we have to settle for “managing” the disease, which is our parallel to implementing changes and settling for a workaround. So in the same way as human doctors, we can’t guarantee we will get to the root of every problem, or if we do, that we will be able to fix every one of them. However, as with having good doctors – having us on your team will maximize the chance of successful resolution.

The post How Percona Support handles bugs appeared first on MySQL Performance Blog.

select from table while inserting data

Lastest Forum Posts - May 10, 2015 - 2:54pm
Hi all,
I'm using MySql 5.5 on amazon RDS, with innodb Engine on all the tables.
At the last time when I running 'show full processlist' I see a lot of queries that 'waiting for metadata lock'.
I understood that it's happen while table X is reading by Select Query (lock s) and before the select query finish, insert/update query are executing on the same table, and then the latest waiting .
The second case that I see it's when insert/update query running on table X (lock x) and then Select query try to read data from the same table .
I simulated those cases, and try some solutions like 'SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED' (dirty read) before the select query , but it's seems that it doesn't help to solve the problem.

What more can I try? Is there any way to run select query (even if the data not 100% accurate) while insert/update query already running on table?
or the only solution is read replica.


​Thank you!!

Percona Server 5.6.24-72.2 is now available

Latest MySQL Performance Blog posts - May 8, 2015 - 1:55pm

Percona is glad to announce the release of Percona Server 5.6.24-72.2 on May 8, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories.

Based on MySQL 5.6.24, including all the bug fixes in it, Percona Server 5.6.24-72.2 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source and free – and this is the latest release of our enhanced, drop-in replacement for MySQL. Complete details of this release can be found in the 5.6.24-72.2 milestone on Launchpad.

New Features:

  • TokuDB storage engine package has been updated to version 7.5.7.

Bugs Fixed:

  • A server binary as distributed in binary tarballs could fail to load on different systems due to an unsatisfied libssl.so.6 dynamic library dependency. This was fixed by replacing the single binary tarball with multiple tarballs depending on the OpenSSL library available in the distribution: 1) ssl100 – for all Debian/Ubuntu versions except Squeeze/Lucid (libssl.so.1.0.0 => /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0 (0x00007f2e389a5000)); 2) ssl098 – only for Debian Squeeze and Ubuntu Lucid (libssl.so.0.9.8 => /usr/lib/libssl.so.0.9.8 (0x00007f9b30db6000)); 3) ssl101 – for CentOS 6 and CentOS 7 (libssl.so.10 => /usr/lib64/libssl.so.10 (0x00007facbe8c4000)); 4) ssl098e – to be used only for CentOS 5 (libssl.so.6 => /lib64/libssl.so.6 (0x00002aed5b64d000)). Bug fixed #1172916.
  • Executing a stored procedure containing a subquery would leak memory. Bug fixed #1380985 (upstream #76349).
  • A slave server restart could cause a 1755 slave SQL thread error if multi-threaded slave was enabled. This is a regression introduced by fix for bug #1331586 in 5.6.21-70.0. Bug fixed #1380985.
  • A string literal containing an invalid UTF-8 sequence could be treated as falsely equal to a UTF-8 column value with no invalid sequences. This could cause invalid query results. Bug fixed #1247218 by a fix ported from MariaDB (MDEV-7649).
  • Percona Server .deb binaries were built without fast mutexes. Bug fixed #1433980.
  • Installing or uninstalling the Audit Log Plugin would crash the server if the audit_log_file variable was pointing to an inaccessible path. Bug fixed #1435606.
  • The audit_log_file would point to random memory area if the Audit Log Plugin was not loaded into server, and then installed with INSTALL PLUGIN, and my.cnf contained audit_log_file setting. Bug fixed #1437505.
  • A specific trigger execution on the master server could cause a slave assertion error under row-based replication. The trigger would satisfy the following conditions: 1) it sets a savepoint; 2) it declares a condition handler which releases this savepoint; 3) the trigger execution passes through the condition handler. Bug fixed #1438990 (upstream #76727).
  • Percona Server client packages were built with with EditLine instead of Readline. This was causing history file produced by the client no longer easy to read. Further, a client built with EditLine could display incorrectly on PuTTY SSH client after its window resize. Bugs fixed #1266386, #1296192 and #1332822 (upstream #63130, upstream #72108 and #69991).
  • Unlocking a table while holding the backup binlog lock would cause an implicit erroneous backup lock release, and a subsequent server crash or hang at the later explicit backup lock release request. Bug fixed #1371827.
  • Initializing slave threads or executing CHANGE MASTER TO statement would crash a debug build if autocommit was disabled and at least one of slave info tables were configured as tables. Bug fixed #1393682.

Other bugs fixed: #1372263 (upstream #72080), #1436138 (upstream #76505), #1182949 (upstream #69453), #1111203 (upstream #68291), and #1384566 (upstream #74615).

Release notes for Percona Server 5.6.24-72.2 are available in the online documentation. Please report any bugs on the launchpad bug tracker .

The post Percona Server 5.6.24-72.2 is now available appeared first on MySQL Performance Blog.

Percona Server 5.5.43-37.2 is now available

Latest MySQL Performance Blog posts - May 8, 2015 - 1:55pm


Percona is glad to announce the release of Percona Server 5.5.43-37.2 on May 8, 2015. Based on MySQL 5.5.43, including all the bug fixes in it, Percona Server 5.5.43-37.2 is now the current stable release in the 5.5 series.

Percona Server is open-source and free. Details of the release can be found in the 5.5.43-37.2 milestone on Launchpad. Downloads are available here and from the Percona Software Repositories.

Bugs Fixed:

  • A server binary as distributed in binary tarballs could fail to load on different systems due to an unsatisfied libssl.so.6 dynamic library dependency. This was fixed by replacing the single binary tarball with multiple tarballs depending on the OpenSSL library available in the distribution: 1) ssl100 – for all Debian/Ubuntu versions except Squeeze/Lucid (libssl.so.1.0.0 => /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0 (0x00007f2e389a5000)); 2) ssl098 – only for Debian Squeeze and Ubuntu Lucid (libssl.so.0.9.8 => /usr/lib/libssl.so.0.9.8 (0x00007f9b30db6000)); 3) ssl101 – for CentOS 6 and CentOS 7 (libssl.so.10 => /usr/lib64/libssl.so.10 (0x00007facbe8c4000)); 4) ssl098e – to be used only for CentOS 5 (libssl.so.6 => /lib64/libssl.so.6 (0x00002aed5b64d000)). Bug fixed #1172916.
  • mysql_install_db would make the server produce an “Error in my_thread_global_end(): 1 threads didn't exit” error message. While this error does not prevent mysql_install_db from completing successfully, its presence might cause any mysql_install_db-calling script to return an error as well. This is a regression introduced by backporting fix for bug #1319904. Bug fixed #1402074.
  • A string literal containing an invalid UTF-8 sequence could be treated as falsely equal to a UTF-8 column value with no invalid sequences. This could cause invalid query results. Bug fixed #1247218 by a fix ported from MariaDB (MDEV-7649).
  • Percona Server .deb binaries were built without fast mutexes. Bug fixed #1433980.
  • Installing or uninstalling the Audit Log Plugin would crash the server if the audit_log_file variable was pointing to an inaccessible path. Bug fixed #1435606.
  • The audit_log_file variable would point to random memory area if the Audit Log Plugin was not loaded into server, and then installed with INSTALL PLUGIN, and my.cnf contained audit_log_file setting. Bug fixed #1437505.
  • Percona Server client .deb packages were built with with EditLine instead of Readline. Further, a client built with EditLine could display incorrectly on PuTTY SSH client after its window resize. Bugs fixed #1266386 and #1332822 (upstream #63130 and #69991).

Other bugs fixed: #1436138 (upstream #76505).

(Please also note that Percona Server 5.6 series is the latest General Availability series and current GA release is 5.6.24-72.2.)

Release notes for Percona Server 5.5.43-37.2 are available in our online documentation. Bugs can be reported on the launchpad bug tracker.

The post Percona Server 5.5.43-37.2 is now available appeared first on MySQL Performance Blog.

Pages

Subscribe to Percona aggregator
]]>