Hot answers tagged mysql5.5
30
Contact Rackspace support.. That's what they're there for.
Do everything they suggest.
If that doesn't work, try Dan's suggestion of data recovery software.
Use this as an opportunity for growth and learning.
Always ensure that all your servers are backed up, and test the backups regularly. There's no point in having a backup service if you never ...
8
There are times when MySQL 5.1 may outperform MySQL 5.5 under certain circumstances.
Percona performed a bake-off among multiple releases of MySQL
MySQL 4.1
MySQL 5.0
MySQL 5.1 (with built-in InnoDB)
MySQL 5.1 with InnoDB-plugin
MySQL 5.5
MySQL 5.6
All tests were performed with MySQL unconfigured (In other words, no my.cnf was made). The results?
...
7
It's a safe move.
Shutdown the mysql dameon and copy the database dir to another disk (it doesn't matter storage topology), then you should modify mysql config, restart mysql daemon and go live. This is a raw backup / migration and it's the safest way to get a snapshot of your database.
For your security you can make a data dump for your databases using ...
6
Innodb is the default storage engine, and it is loaded by default. I would consider this a flaw in MySQL Workbench. You can read more about the --innodb (and --skip-innodb) option here:
http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#option_mysqld_innodb
Notice that if you disable innodb, MySQL won't even start unless you specify a different ...
6
It seems to me that your .sql file actually contains the text <br /> <b>Fatal error</b>: Maximum execution time of 300 seconds exceeded in <b, which is obviously not valid sql. You have possibly exported your database with some tool like phpMyAdmin, which took longer than 300s to create the export which was cut short at that point in ...
5
I'd suggest you use mysql 5.5 from IUS instead of webtatic. With it, you can also get yum-plugin-replace, which will let you do yum replace mysql --replace-with=mysql55 and it will figure out the dependencies and install the new package. This would avoid removing php53-mysql (which you need if you have any PHP code that interacts with MySQL).
5
Yes, you are correct that if you don't specify --ssl-ca then the client does not check the server certificate at all. Since it works without that option the most likely reason for the failure is that the client doesn't trust the server certificate.
If you are using self-signed client and server certificates then the ca.cert file should include both these ...
4
If you're using SELinux (Fedora, SUSE, some Ubuntu), it is probably the problem. You need to change your security context for mySQL with something like:
chcon -Rv --type=mysqld_db_t /my/new/data/dir
or if you're using AppArmor (Ubuntu), you'll need to update your
/etc/apparmor.d/usr.sbin.mysql
3
This question is a bit old now, but in case other people come across this page (like I did), here is what got me working:
In my case the answer was apparmor.
The solution:
edit the file /etc/apparmor.d/usr.sbin.mysqld
Add the following lines:
/path/to/new/data/ r,
/path/to/new/data/** rwk,
/path/to/new/logs/ r,
/path/to/new/logs/ rw,
Then restart ...
3
Use whichever version is latest on your distribution of choice. I'd suggest you use Ubuntu 10.04 LTS, and the current version of that is.. MySQL 5.1.41-3ubuntu12.7
That means that you'll get easy to install binaries sudo apt-get install mysql-server , and support for them from the ubuntu community, because things will happen as expected.
Mixing and ...
3
I opted to try this out on my MySQL server to see what the problem was. It appears that you need to create the table in MySQL (with engine=csv specified) so that the table will appropriately be added to MySQL and it will keep track of the table field metadata. In my testing, I was unable to make MySQL learn of the csv file without first using "create ...
3
The configuration file use the dash (-)
The variable name use the underscore (_)
http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_open-files-limit
Another question I have, in my config file I have open_files_limit =
500, but whenever I do a show variables the open_files_limit is 7048.
Why would this be?
It sounds like ...
3
Is the web server the same physical server than the database server? bind-address should be an address that is assigned to your server -- if ifconfig lists the address, then you can use it for MySQL. You can't just blindly pick some IP and put that as bind-address, no sir.
EDIT: It seems you understand bind-address completely wrong.
1) Put your database ...
3
When you connect to MySQL, just run
SELECT SUBSTR(variable_value,1,
LOCATE(' ',variable_value) - 1) DBVersion
FROM information_schema.global_variables
WHERE variable_name='version_comment';
You should get this when you connect to MySQL
mysql> SELECT SUBSTR(variable_value,1,
-> LOCATE(' ',variable_value) - 1) DBVersion
-> FROM ...
2
ERROR 1231 (42000): Variable 'general_log_file' can't be set to the
value of '/var/lib/msyql/ubuntu.log'
What's going on?
The simple answer is this file doesn't exist.
You type too fast. There is a typo in the file name, it should be /var/lib/mysql/ubuntu.log.
2
Do you have SELinux enabled? It's possible that the MySQL packages are not built to play nice with SELinux (not uncommon for 3rd party packages) and that it is blocking access to creating the PID file. A quick and dirty test would be to set your SELinux context to Permissive (or Disabled)
# setenforce permissive
If that is not the case then have a ...
2
In ordet to simplify the promotion of the Slave to a Master, I have a suggestion to keep the Slave closer sync'd to the Master.
You should use the tool mk-slave-prefetch.
Here is the beauty of this tool: On a slave, it will read the relay logs, look for all queries that have a WHERE clause, convert it to a SELECT and execute it. That way, the caches for ...
2
There is no way to run multiple MySQL installations using yum on a single instance. But, it's very easy to install and uninstall current and future versions via yum or rpm.
It seems you are going about this in a very wrong way. First do this on a staging machine. Document the steps and time taken in detail. Do this multiple times if you have to improving ...
2
cPanel should be fine with MySQL 5.6 but you would need to confirm on your dev/test/staging environment where you're going to trial the upgrade process first =)
cPanel support suggests doing the MySQL upgrade their way: http://forums.cpanel.net/f5/mysql-upgradation-211421.html#post871392
You would need to be using a yum installed version of MySQL under ...
2
This is a syntax error in the .sql file. There should be a line there with "<b>Fatal error: Maximum execution time of 300 seconds exceeded in
This error looks alot like a PHP error to me. During database export/dump, php stopped after 300 seconds, and wrote out the error to its output -> your file.
You should fix php.ini, to allow longer execution ...
2
Sounds like an issue with MySQL Workbench.
MySQL 5.5 has a default storage engine of InnoDB.
In fact, the option default_storage_engine is predefined as follows:
MySQL 5.5.4 and prior, MyISAM
MySQL 5.5.8 and after, InnoDB
There is another option called storage-engine, which was deprecated as for MySQL 5.5.3. Keep in mind that MySQL 5.5.8 was the very ...
2
MySQL.com does have .dmg files. What do you mean by "requires lots of manual linking"?
If the .dmg file on MySQL.com doesn't work for you, then your best bet is probably to compile it yourself. Compiling stuff from source might sound daunting, but it's really not that hard. Here's a pretty thorough tutorial that should help you out.
2
ISSUE #1) Semisynchronous Replication
A master with multiple slaves isn't all that great because only the first slave would replicate quickly and all subsequent slaves would sometimes switch into asynch mode depending on how long a query takes to run. In terms of the first slave, that is by design. I guess there are no guarantees for subsequent slaves ...
2
Re: issues with innodb_buffer_pool_size and innodb_buffer_pool_instances:
I think there is a disconnect with how these variables are related. innodb_buffer_pool_size is the total buffer pool available. That is then divided amongst the # of threads referenced in innodb_buffer_pool_instances.
In the poorly-performing example above, 2.5GB was divided ...
2
Yes, 51k entries were added, only 986 are in there now. so there were roughly 50k entries which were added to the cache, but are no longer there, 9k of them because it ran out of memory in the cache and the rest because inserts/updates invalidated cache entries. Com_select is a parameter which is useful to know when trying to decide if you are getting ...
1
The files that are missing (that are specified in the spec file as Source[123]) are either RedHat specific or is the basic my.cnf file. These won't be typically included in the basic mysql-5.5.18 source tarball and are generally added by Red Hat in their RPMs.
What I would do is get the SRPM for this version of MySQL. Go to ...
1
If you want to ensure versioning, honestly your best bet is to install manually.
Additionally, you should consider Percona; it's a largely drop-in replacement for MySQL. (We replaced MySQL on Ubuntu 10.04 LTS earlier this year, and have been very happy with it.) there are some caveats to Percona pertaining to your existing tables, but that is your due ...
1
The problems you're seeing could be caused by dozens of different root causes. You definitely should not guess; you certainly need to measure and diagnose carefully. If you gather enough information, the true cause will be evident, and the solution will be obvious (provided that you also understand enough about the server's internals to know what you're ...
1
There are multilpe variables at work here.
You have a custom installation of mysql in /usr/local/mysql. This means that your mysql socket may not be in the default location that PHP expects it to be. To fix this problem, make sure that mysql and PHP agree on the location of the socket. you could also use the network socket. The Mysql config might be in ...
1
Privileges in MySQL are tied to both a 'username' and a 'host'. The host can be a domain name, an IP address or 'localhost'. Any of these can include the wildcard %. If you connect from the wrong place, even with the right username and password, you will still get a permission denied error.
Each of these different users can have different access to ...
Only top voted, non community-wiki answers of a minimum length are eligible
