Tag Info

New answers tagged

0

It is a brave soul indeed that still uses an all-MyISAM database. Why are writes being quietly discarded instead of being queued, as they would be for a regular table lock? Look at the error message again [20-Nov-2014 01:41:56 UTC] Wordpress database error The MySQL server is running with the --read-only option so it cannot execute this statement ...


0

Believe it or not, I once wrote a post about why you should not do that (How can I disable utf8mb4 entirely on MySQL 5.5?). However, in the spirit of my old post and the commentary in it from @ChristopherSchultz, I will go out on a limb and tell you how you can do it, then tell you why you should not. I once wrote a post about the home position of any empty ...


0

I have successfully done 5.1 to 5.5 and 5.5 to 5.6 for short periods of time, as it looks like you plan to do. Could you do a stepped upgrade? That is, 5.1 to 5.5 to 5.6? Some of the issues you could run into can be caused by things particular to your workload. I've used the pt-upgrade tool (http://www.percona.com/doc/percona-toolkit/2.2/pt-upgrade.html) to ...


0

The general rule is you do not replicate from a newer version into an older versions. Replicating into a newer version is the exact upgrade path you should do. If you only have one slave then you would just promote that to master. You'll want to be sure to retain the output of show master status before promotion so you can reconnect the old master as a ...


0

Your per-connection buffers are too high. Look at the mysqltuner.pl output. It says 736.1M per thread. This has the greatest impact on the 220GB Estimate. How ? join_buffer_size is 32M sort_buffer_size is 256M read_buffer_size is 64M read_rnd_buffer_size is 384M The sum of these is 736M Multiplying this by max_connections (which you have set at 300) is ...


0

A few ideas: Turn query cache off (reduces that usage to 0). Doesn't appear to be a big win for you, so it's an unnecessary performance hit (in addition to the memory usage). Unless I’m reading the report wrong, you don’t appear to have a lot of MyISAM tables. I’d reduce read_buffer_size to the default (128K) and read_rnd_buffer_size to the default (256K). ...


0

There is no command to execute for this. What you need are the following: Oracle MySQL Executive Summary (under Supported Versions Affected) MySQL 5.1 Release Notes I would be concerned because MySQL 5.1 was last updated Dec 03, 2013 and the Last Critical Patch to MySQL 5.1 was Jan 2014 (See Patch Availability Table under column Patch Availability and ...


1

Following is the logical order of execution of the SQL clauses: FROM clause WHERE clause GROUP BY clause HAVING clause SELECT clause ORDER BY clause


0

due to: MySQL :: MySQL 5.1 Reference Manual :: 16.1.3.3 Replication Slave Options and Variables Warning To specify multiple databases you must use multiple instances of this option. Because database names can contain commas, if you supply a comma separated list then the list will be treated as the name of a single database. my.cnf's incorrect syntax: ...



Top 50 recent answers are included