New answers tagged

0

It sounds to me like you need a -replication-do-DB statement on your slave so that it will only attempt to run queries from the database that you are trying to replicate. Otherwise as noted in the comments it will attempt to run statements on all databases (even the ones that don't exist) and create the error identified.


0

Just wanted to note for posterity that if you want to use a load balancer (such as an F5 or HAProxy) in between MySQL and the client, you will want to import your SSL certificate from the load balancer into the MySQL server. This is due to the STARTTLS-like connection startup.


3

errno 28 means ENOSPC, that is, "No space left on device". There's several lookup commands available for such standardized errors, one is called simply errno: % errno 28 ENOSPC 28 No space left on device Another is called perror: % perror 28 OS error code 28: No space left on device


2

DO NOT use mysqldump with any of the mysql schema tables. This can have terrible consequences. I actually just used the accepted answer to try and solve this problem myself and I ran into all sorts of errors. I effectively ended up locking myself out of the database because my admin account wasn't recognizing my password and I couldn't create new users. ...


1

So I figured out the answer. The problem was due to the bad query design. (This query was coming from a Wordpress Plugin, so it's not surprising). The third join was not only worthless, it was attaching "creating" 1 record in the result set for every record in the Post Meta table that had wpcr3_enable set to 1 * every record in the WP Post table, resulting ...


0

For the repeat part I can think of two ways: puppetDB hiera PuppetDB Whenever you want the fact of a node to do something on a second node, use puppetDB. This is called exported resources. This is also explained in the puppet-mysql documentation. Example1: Add the SSH Hostkeys of all machines to the known_keys of all other machines. Example2: Add all ...


0

Maybe this will help some folks: It appears that if bind-address is declared in 2 places, the service fails to restart. Perhaps you quickly scanned your /etc/conf/my.cnf file and did see a 2nd appearance of bind-address. However, note that the file may contain a !includedir directive, and some of those included files can contain a 2nd bind-address.


0

Uninstall sudo apt-get purge mysql-server mysql-client mysql-common mysql-server-core-5.5 mysql-client-core-5.5 Remove directory sudo rm -rf /etc/mysql /var/lib/mysql Clean-up sudo apt-get autoremove sudo apt-get autoclean


0

It worked for me using sudo apt-get purge mysql* sudo apt-get autoremove Also try to take a look at http://askubuntu.com/questions/776845


0

I had the same "AH01909: RSA certificate.." error. In my case I had the correct serverName value. The cause was an incorrect IP address in the <VirtualHost 10.11.12.13:443> definition for the secure site. I had missed typed it!


0

I know this is old, but I stumbled across it when I was having this problem. Here is what was going on with mine. I have a script that runs mysqldump nightly. I just brought a new db online and added the script. The user the script uses had the right permissions, but it was still failing. I temporarily granted dba access to the backup user and it still ...


0

config.status has a --config flag to print out the last configuration. I found it by running ./config.status --help --config print configuration, then exit So just run ./config.status --config, and it will print out all the configure parameters.


0

You need to quote what you echo or else echo will interpret wildcard with what it finds in the directory matching a pattern. It is called globbing and can be disabled. box:[~/tmp/test]$ touch file.txt other.txt box:[~/tmp/test]$ foo='*.txt' box:[~/tmp/test]$ echo $foo file.txt other.txt nox:[~/tmp/test]$ echo '$foo' $foo box:[~/tmp/test]$ echo "$foo" *.txt ...


0

Okay, I did it with a python script which I wrote. import os for filename in os.listdir('<path_to_folder_contains_sqls>'): print 'importing db: ' + filename dbname = 'db_' + str(os.path.splitext(filename)[0]) os.system('mysql -e "create database ' + dbname + '; use ' + dbname + '; source ' + filename + ';"')


1

mysqli constructor accepts 5th optional argumen specifying port. You should use $mysqli = new mysqli("127.0.0.1", "root", "root", "database_name", "3307"); instead. Did you verify you can connect to the port from the other host? Mysql is usually using unix domain socket instead of port (which you can forward too). ssh -fNg -L ...


0

Problem was resolved. The issue was the temp directory was filling up and stopping uploads. Once the temp files were cleared up everything worked as planned. So essentially over time after letting it idle for 2-3 days the directory filled up... and there was no way a restart would resolve this issue. Pretty surprised we didn't get any write errors or ...


0

When connecting to Mysql remotely, I got an error. I had this warning in /var/log/mysqld.log: [Warning] IP address 'X.X.X.X' could not be resolved: Temporary failure in name resolution I just added this line to /etc/hosts file: X.X.X.X some_name Problem solved! without using skip-name-resolve, it caused some errors in my local app, when connecting to ...


1

Use mohit's answer, but refer to https://dev.mysql.com/downloads/repo/apt/ for the current mysql-apt-config. Click "Download" at the bottom. Then copy the link from "No thanks, just start my download." at the bottom


1

Looks like the problem was that for dedicated tenancy, the RDS instance class has to correspond to the EC2 instance class, e.g. m3.medium EC2 corresponds to db.m3.medium. I was using m3.medium with db.t2.large. Makes sense, but it's kinda buried in the docs.


1

Whenever I find a site is going slow I run it through http://tools.pingdom.com/fpt/ it generally gives you some insight into whats slowing it down and where its coming from.


2

As Iain described above the kernel module is killing apache I recently had similar issues, my first solution was to lighten the load on apache... particularly the wp-cron.php file. Disabling the file running in wordpress on every click of every page and making a manual cron removed lots of load from the server: ...


2

When your system invoked the OOM killer, you appear to be running 161 httpd processes, that seems to be a little excessive for a system that gets <50 users/week. The first thing I would do is reduce the number of httpd processes your system will spawn and keep alive To do this adjust values of StartServers, MinSpareServers, MaxSpareServers, ServerLimit, ...


0

Since you are long bead like me you deserve one another answer: Also from another point of view I noticed something. If you don't use Memcache you don't need Varnish. Varnish is "pasato", since not planning to support spdy for a long time as Varnish author said once. Also I see that your caching layer is actually on application layer. The W3TC plugin you ...


1

Check your mysql error log. tail -100 /var/log/mysql/error.log If your log says (like mine did): InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 [ERROR] InnoDB: Cannot allocate memory for the buffer pool You don't have enough memory to use the default buffer size of 128M Edit the config file ...


0

Solved. The issue was related to database Mysql 5.7 when update from Msyql 5.1. The error mod_fcgid: stderr: PHP Warning: Invalid argument supplied for foreach() in... was right. The query executed by prestashop returned anything. Need to change SQL mode in my.cnf to sql-mode=TRADITIONAL


1

Yes, it is possible. But is it really what do you want? Question sounds to me like you found some new and cool called NDB cluster and want to use it without any deeper knowledge. NDB is storage engine, do you know you can do all necessary modification to your DB structure?


1

Log shows you didn't create yet a MySQL root user: 2016-05-16T03:54:28.704660Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 2016-05-16T03:54:28.705527Z 0 [ERROR] Aborting Not all installation scripts create them automatically. To create a root user, run mysqld --initialize --user=mysql [with random root ...


1

Caching on the web server is usually far more effective than caching using a Wordpress plugin. I have a Wordpress/Nginx caching tutorial for Nginx, but it's possible using Apache as well. This article goes into microcaching, which is helpful if your content changes rapidly. Most Wordpress blogs are fine cached, you just exclude logged in users from the ...


0

These values are pretty normal for a site with 200+ concurrent visits. With such traffic, a dedicated server would be recommended. In the meantime, You can install the free Wordpress plugin named WP Super Cache. Choosing the best configuration may require analyzing your business logic, but you can setup the plugin following these hints: Cache mode = ...


-1

The log shows that InnoDB data is corrupted. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! This may happens for many reasons (we may discuss them in comments), but in many cases you can repair them running mysqlcheck --repair --all-databases as root. If this fails, you can try dump all ...


0

I researched alot, I guess there is no way to allow your laptop dhcp address at googlecloud firewall. I was able to fix this hurdle by ceating ssh tunnel Windows Source: http://quintagroup.com/services/support/tutorials/mysql-windows Linux Source: http://quintagroup.com/services/support/tutorials/mysql-linux


0

First I got another error about the database and I solved it. Then appears this message "Cannot load DB manager *Required field" then .... I only went back once through the arrows then I clicked next and I could go to next screen, "Confirm Settings". The error doesn't appeared anymore.


0

To explain the difference, you would need to compare the current MySQL configuration with the previous one. Look at /etc/mysql/my.cnf for the different allocated buffer sizes. On most configurations, the biggest would be the innodb_buffer_pool_size.


-1

According to the MariaDB doc, innodb_file_per_table is disabled by default. And yes, it can impact performance (like when doing bulk queries to search and replace values in a newly cloned WordPress instance). But on balance enabling it seems to increase the odds of surviving in a situation where individual database files have been corrupted (or accidentally ...


0

What I had to do in the end is the following: Upgrade MySQL-libs using yum update mysql-libs, which installed mysql-community-libs Downgrade them using yum downgrade mysql-libs so that they were on 5.6.29 Install mysql-community-server


0

With Mysql Community server (common version), it is possible to setup replication of databases. It could be set as master-slave or master-master. The best guide I've seen for those are Master-Slave replication howto and Master-Master replication howto. The option chosen mainly depends on whether you need your second server to be able to do updates to ...


0

systemd was only adopted in RHEL 7, so RHEL6 doesn't have it. https://en.wikipedia.org/wiki/Systemd If I were you I would try something like this: http://sharadchhetri.com/2013/12/26/install-mysql-server-5-6-in-centos-6-x-and-red-hat-6-x-linux/


0

If you start an EBS instance, then follow this guide How to Recover an Unreachable Linux Instance An EBS EC2 instance is a blessing. What you need to do is : Go to EC2 web console, under EBS - volumes, look for the EBS volume attach to the instance. Make sure you shutdown instance before doing this. Detach it from the instance-id. Now Attach this volume ...


2

I've to dump the data from the mysql database present in that volume. Is that possible? If so, how can I do that with the mounted volume? Yes, that's possible: Install mysql on the host. Stop mysqld. Either point the datadir directive inside the mysql config to /<mountpoint-of-your-old-host/path/to/the/datadir or remove /path/to/the/datadir and ...


0

You can use the --one-database option Ignore statements except those that occur while the default database is the one named on the command line. This option is rudimentary and should be used with care. Statement filtering is based only on USE statements. so mysql -u someone -p somedatabase <all.sql Should work as you want and be reasonably safe ...


0

log_queries_not_using_indexes=1 logs all queries that do not use indexes, regardless of how fast they are, because they are performance killers in waiting. With Rows_sent: 1 Rows_examined: 6075 it's an entirely safe bet that this query was logged for that reason.


0

Well, in the end the issue was related to the hardware firewall as there was an inactivity timeout set at 900 seconds. Kinda embarrassing if I think why I haven't thought about it earlier, but yea thats the reason for this issue. Just thought I should update it here instead of deleting the question so that others can refer.


0

If you've installed MySQL by running MAMP on the Mac, then the files are stored at /Applications/MAMP/db/mysql For MAMP Pro, the files should be in /Library/Application Support/appsolute/MAMP PRO/db/mysql Stack Overflow answer that addresses MAMP / Sequel Pro installations here: ...


0

As it turns out, when I copied over /var/lib/mysql from my old system, the permissions weren't corrected, resulting in nginx not having read access to the directory containing the socket file for MariaDB. The solution was to update the permissions on /var/lib/mysql so nginx had access.


0

CentOS and Red Hat now have a repository called "Software Collections". You can install MySQL 5.6 by following the instructions here and substituting rh-mysql56 in the second command.


1

It sounds as the underlying disks are busy. The problem in restoring a large database is that each (group of) INSERT requires a flush/sync operation, which is very slow on mechanical disks (a 7200 RPM disk is in the order of ~100 IOPS). To hasten the restore, you had to temporarily instruct MySQL/MariaDB to not issue flushes/syncs. To do that, interrupt the ...


1

If your underlying storage is plain old disks, for a 25GB-on-disk MySQL database, that's quite normal to experience hours-long restore - especially for some badly structured dbs (lots of tuples, indexes, etc.). For a start compress your dump, that saves tons of I/Os and puts less stress on cache memory : mysqldump foo |gzip >foo.sql.gz zcat foo.sql.gz ...


0

From the process-list it seems that it is not a local database, i.e., not on the localhost and you are not accessing it using localhost or 127.0.0.1. Therefore it could be network or DNS related issue. Check DNS resolution issues and network latency problems. If the DB Server is on the same host and you are using localhost in the connection string, then ...


1

localhost will be the server on which the server is executing and will generally be a local loop back address such as 127.0.0.1 and set up in the /etc/hosts file.


1

When the /etc/init.d/mysqld script and mysql_install_db found that the datadir does not exist or empty they will try to create it if they has the right permissions. If you started your mysql server before your separate disk been mounted, the datadir may be empty, and the /etc/init.d/mysqld script assuming that is a brand new environment, so it will run ...



Top 50 recent answers are included