New answers tagged mysql
2
If the server's performance is bounded by disk read time or load, adding an SSD will certainly help. If it is bound by RAM, disk writes, network, or CPU load, an SSD will not help.
You should consider using top, iotop, and bwmon to see the data on this. top will show you memory usage and CPU usage, and is especially good for seeing what is going on in ...
1
Mysqltuner is the perl script which will read your Mysql settings and tell you what setting you need to tune in order to optimize your Mysql
https://raw.github.com/rackerhacker/MySQLTuner-perl/master/mysqltuner.pl
0
This is probably, as David explained, a normal behavior of the Linux Kernel, but it can also be an occurrence of the MySQL “swap insanity” problem. In your case (8 CPU, 16 GB RAM total, 5 GB used), for that to happen, your computer should be a NUMA system with 4 nodes (sockets) and 4 GB of RAM per node and a MySQL InnoDB buffer pool of 4 GB.
In short (you ...
0
On a handy CentOS server I have to hand,
yum provides */mysqldbcopy
mysql-utilities-1.3.0-1.el6.noarch : MySQL Utilities
Repo : epel
Matched from:
Filename : /usr/bin/mysqldbcopy
So (if it's not already installed) you should be able to install it with
yum install mysql-utilities
You may not have EPEL installed/enabled but there are plenty ...
0
check apache access logs to get more information, you might want to check if there is a redirect in the virtual host config file or where ever you have specified server settings ( I dont know what all in running on the web server)
I would start here given the information you have given in the question.
1
You cannot mysqldump the mysql schema and simply import to the higher version. Why ? In the DBA StackExchange, I answered this question a little over a year ago: Cannot GRANT privileges as root. In short, the table mysql.user has a different number of columns for each major release of MySQL:
43 columns in MySQL 5.6
42 columns in MySQL 5.5
39 columns in ...
1
The auditd(8) daemon provides the functionality you request in your question. It is configured in the /etc/audit/auditd.conf file, and its syntax is described in the auditd.conf(5) manual page.
You need to install and enable the daemon, and configure the /etc/audit/audit.rules to audit those events you consider relevant. And example from the audit.rules(7) ...
1
It appears as if there were innoDB-related files (ibdata1, ib_logfile, etc) in my /var/lib/mysql/ directory. Per the suggestions in this mailing list post, I ran rm ib* and re-ran apt-get dist-upgrade. Everything appears to work.
1
You can migrate your instalations to Percona Server and use one of this two ways to connect MySQL to LDAP by PAM:
Full PAM plugin called auth_pam. This plugin uses dialog.so. It fully supports the PAM protocol with arbitrary communication between client and server.
Oracle-compatible PAM called auth_pam_compat. This plugin uses mysql_clear_password ...
0
Your phrase "access that I have." is interesting. Are you bandwidth limited? Space limited? Shell limited? Explaining that would help clarify a better suited solution to your particular parameters.
In order to get the DB from one machine to the other your have to transfer the files. you could do this several different ways:
1.) Copy the whole mysql ...
2
I agree with @faker's answer's and comments (+1 for his answer), but there is still one major thing to do:
Before you shutdown mysql, you need to run SET GLOBAL innodb_fast_shutdown = 0;. Why?
This will completely purge all transactional information left over in ib_logfile0 and ib_logfile1. The shutdown time is longer, but nothing in terms of transactional ...
0
This does not use phpMyAdmin, so may not apply to your case.
If using MySQL and you have shell access, consider using mysqldump with pipes.
http://www.cyberciti.biz/faq/mysqldump-pipe-mysql-output-and-input/
Note this can lock tables on both servers. Also if you do not use SSH the data is sent as plain text. I have often used this method over fast, ...
2
You are on the right track but in some newer OS's (e.g. CentOS 6), there is a:
/etc/security/limits.d/
That will override items put in limits.conf.
I recommend putting a higher number file (e.g. 99-mysql.conf) in here with your limits.
For more See:
http://www.mysqlperformanceblog.com/2013/02/04/cant_create_thread_errno_11/
0
Stop the server, make the changes in my.cnf and then start the server. It will reflect the changes properly.If the variable is global then you can change it inside MySQL, but it will retain the new value until next server restart only. And if it's a session variable it will retain the new value for that particular session only. For example: mysql> set ...
0
Add the following parameters and check if the problem is resolved:
innodb_buffer_pool_instances=3
innodb_change_buffering=inserts
innodb_flush_method=O_DIRECT
1
http://dev.mysql.com/doc/refman/5.0/en/innodb-multiple-tablespaces.html:
The --innodb_file_per_table option affects only table creation, not access to
existing tables. If you start the server with this option, new tables are
created using .ibd files, but you can still access tables that exist in the
shared tablespace. If you start the server without ...
0
There were a few things I had to do.
First log into mysql using root from local machine (the server, but I used ssh) and add a new remote user.
mysql -u root -p
It will prompt for a password. Then create a new user that has access from anywhere.
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%';
FLUSH ...
0
The process is only using 100megs of memory. If you have any caching enabled in your config it will put the query+results in memory to make the next ones fast.
As for the sleeping connections. They are connections from your app that aren't closed yet. It would be a horrible assumption by mysql to close the connection after each query. It would mean your ...
2
You would want the SQL server to be as close as possible to your current VPS; preferably in the same datacenter for best results. It doesn't matter where it is for end-users because it should be your website accessing the database and not the users.
0
The problem was that I had ''@'master.myapp.com (anonymous user).
This answer solved my issue: http://stackoverflow.com/a/11216911/1630391
0
Did not really find a solution to this, thought I'd do a recap for anyone who could be having the same problem:
To rule out ISP problems use another program to test the connection (in my case windows remote desktop)
Try adding skip-name-resolve to your MySQL configuration (add "skip-name-resolve" in the my.ini file just below [mysqld] and restart mysql)
...
0
###### WARNING ######
Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
mysqldump: Couldn't execute 'show events': Access denied for user 'root'@'localhost'
to database 'performance_schema' (1044)
System info:
# mysqldump --version
mysqldump Ver 10.13 Distrib 5.5.31, for debian-linux-gnu (i686)
# uname -a
Linux ...
0
Although I cannot completely explain why, moving /usr to the same partition as / solves this problem. To me, it looks as if during startup, some daemon or process tries to look up some user or group, and fails because the MySQL client or libs under /usr are not (yet) there.
In theory, this should not cause trouble, since all system users/groups can be ...
0
I plan do upgrading with following plan.
Backup and practice on virtualbox before do any change
I use no plugins in my old redmine.
Read install guild and upgrade guild.
* [Redmine Instal Guild](http://www.redmine.org/projects/redmine/wiki/RedmineInstall)
* [Redmine Upgrade Guild](http://www.redmine.org/projects/redmine/wiki/RedmineUpgrade)
Using taps ...
0
In your my.cnf, locate innodb_force_recovery and change
innodb_force_recovery = 4
to
innodb_force_recovery = 3
Also ensure you have enough disk space for the database.
0
You don't need to edit the perl script to fix this. Perl is just asking for an environment variable that it can't find. All you have to do is define that variable... and maybe a few others. You cand find the list of environment variables you need to define and what they should contain here:
...
4
Sounds like you're looking for fail2ban.
1
Plan C sounds safest to me. With that plan, you can leave the original instance untouched while sorting out issues on the new server.
Be mindful of plugins, too. It's likely that you'll find incompatible ones with that big of a version jump.
I've been pondering the same migration myself, but have been putting it off for a while. I know for a fact that some ...
1
$ perror 1067
MySQL error code 1067 (ER_INVALID_DEFAULT): Invalid default value for '%-.192s'
Check your mysql log file and find out which parameter in your config is causing problems.
1
If you don't want the process running, then just kill it.
0
It looks like there's no "installation" per say and you're just supposed to run start_navicat from the command line, but it doesn't seem to work for me. You might want to contact their support if you also have issues.
1
First off: mysql 4.1 is ancient. Instead of investing time in rebuilding it, invest time in upgrading to 5.0, 5.1 and then 5.5.
Now for the rebuild, this is how I generally do this, as non-root user:
$ sudo yum install yum-utils
$ echo '%_topdir %(echo $HOME)/rpmbuild' > ~/.rpmmacros
$ sudo yum-builddep mysql
$ rpm -i MySQL-4.1.22-0.src.rpm
$ rpmbuild ...
1
Heroku itself only provides direct support for PostgreSQL. Many applications (especially those in Rails) can be migrated from MySQL to PostgreSQL with little issue.
For situations in which you can't easily migrate, you can use a third party Heroku add-on.
2
Not sure why this wasn't provided as an answer so here it is:
The recommended approach is to upgrade to the next major version first. You should go from 5.0 -> 5.1 -> 5.5.
As a general rule, to upgrade from one release series to another, go to the next series rather than skipping a series. To upgrade from a release series previous to MySQL 5.1, upgrade ...
-3
I upgraded my PHP just now. There is no clear answer. So I just tested it on my server:
Commands removed by moderator as this is a terrible idea in general.
The process described by the other answer is "correct".
It works, and this update didn't affect my MySQL databases. You need adjust some options in my.cnf ot restart the MySQL server.
3
I will advice you to hire a team of experienced database consultants. This is not a simple question which can be answered on serverfault.
First of all what type of NoSQL? Do you need integrity for your data? What will the database store, how much will it store, how intensive are the queries? If you have to ask such questions here you are already out of your ...
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.
0
show open tables where In_Use > 0 ;
0
in /etc/default/zabbix-server
set START=yes
1
There's no way for MySQL to know what PHP script was running. All it knows is it got a connection from username, password, host, and was asked for some query. So it logs what it has available.
If you're the developer, you should hopefully be familiar enough with your application to locate the code making the query within a few seconds. If you aren't the ...
0
I don't use cpanel for my sites (I am on a virtual box, so I get full root access) anyway, I am not sure exactly what you are trying to do. Why don't you have a bind address?
In my own /etc/mysql/my.cnf I have my static IP in the bind-address portion.
I can access the mysql databases from localhost when using PHP on the web, and I can access it when making ...
0
You started MySQL with the skip-name-resolve option, either on the command line or in /etc/my.cnf, but you have MySQL users whose names include a hostname, rather than IP address. Since MySQL isn't resolving IP addresses to hostnames, it can't authenticate those users.
To resolve the issue, do one or both of:
Remove the skip-name-resolve option.
Create ...
0
Connect to the host 127.0.0.1 rather than localhost. localhost has special meaning for MySQL on a Unix based OS.
2
not possible using standard mysql. you could look at nbd clustering, but it's a completely separate product made by mysql and not completely compatible.
what type of clustering are you using? replication? that's not clustering.
if the only problem you were running in to is disk space then you don't need more mysql servers, just more storage. a ...
1
Row based replication format actually uses more disk space than statement based. That is simple because into the binlog you would have all data that was inserted/updated not just the statement. So if a statement says to insert 100 rows if binlog_format=STATEMENT will insert just one statement but if is ROW will actually contain all entries.
So in order to ...
1
Certainly switching to innodb will solve the contention problem - you won't have as many table waits - but it won't help your system to go any faster. Currently it looks like your query cache is disabled - is there a reason you don't use it? It doesn't always help with performance but it can do.
You should have plenty of spare memory on this system - ...
2
Waiting for table lock means that you have write contention on one or more tables. MyISAM only has per-table locks and thus runs into this locking issues much mre frequently than e.g. InnoDB. You may be able to optimize your reading queries to leave more time for writing, but it's better to enable InnoDB and convert your tables to InnoDB format.
1
Try experimenting with the Provision IOPS that RDS offers. Regardless of instance size, the IO is limited, and you can use the Provision IOPS settings, at an additional cost, to improve IO performance.
You can provision up to 3TB storage and 30,000 IOPS per database instance. For a workload with 50% writes and 50% reads running on an m2.4xlarge ...
0
I had a similar issue on a Rackspace server instance. Queries took ages to execute, even with Innodb configured to the best of my efforts. I ended up moving to the dedicated database product offered by Rackspace. My guess is that disk intensive services such as databases does not thrive that well on virtualised servers where disks are shared between multiple ...
1
You don't do that
$url=parse_url(getenv("mysql://adffdadf2341:adf4234@us-cdbr-east.cleardb.com/heroku_db?reconnect=true"))
getenv = get an environnment on your unix.
so
$url=parse_url(getenv(CLEARDB_DATABASE_URL))
is good.
Top 50 recent answers are included
