Tag Info

New answers tagged

1

I finally had time to revisit this project and for completeness sake wanted to post what I ended up doing. The original problem with the DELETE FROM taking so long, I believe, is related to how I was specifying rows to be deleted. I was using a statement similar to DELETE FROM table WHERE starttime < 20150101 limit 200000; The starttime field is ...


-1

I know this is a very old answer, but just in case someone else will be looking for an answer here. In my case - the problem was in permissions that wasn't correct on the destination folder.


0

Probably you have project moved from apache-2.2 to apache-2.4. Since v2.2 some changes have been introduced to the config files syntax, especially with access definitions. While apache before 2.4 have had the next syntax Order allow,deny Allow from all the 2.4+ versions have the next syntax Require all granted Please read carefully notices about ...


0

The usual reason I've seen for this problem is that you create the files so they are owned by you (the user that you are logged in as). You can access the files locally because you own them. When you try to access them remotely, they are accessed by user "apache" or whatever user your web server runs as. Change the permissions so that the web server can ...


0

You can use mysql proxy ( https://dev.mysql.com/downloads/mysql-proxy/ ) is a simple program that sits between your client and MySQL server(s) that can monitor, analyze or transform their communication.


0

Opps! My bad. hackmysql.com According to the hompepage the download link ended last January. Since mysqlreport is no longer supported I will the author's recommended percona-toolkit instead. https://www.percona.com/doc/percona-toolkit/2.2/index.html


2

It looks like an infinite loop as line 159 of wp-admin/includes/file.php is a recursive call to the function wp_tmpnam(). It breaks the update process, so may be it could be worth checking this small correction, which describes your problem : wordpress bug fix


2

The memory leak (or just high memory usage) is almost always because of Wordpress. Wordpress is a well known memory and CPU hog, especially if you are using bad plugins and templates. You may try to disable all the plugins and templates one by one until you find which one is causing the high memory usage and replace it with another similar one or report ...


2

Since you do not have any addition plugins, I still suggest you to follow below steps: Disable both plugins Switched to default WordPress themes Scan all contents using virus scanner Then try to update contents. If it is still consuming lots of memory, it may be server configuration issue.


0

You might give this a try, should provide the best readability: select db 'DATABASE', host HOST, user USER from mysql.db where db = '<databasename>'; Something more memorizeable for the cli: select db,host,user from mysql.db;


2

You seem to have hit the bug "Any statement of the form CREATE USER x IDENTIFIED BY 'x'crashes mysqld". The reason described is missing "password_expired" column in the mysql database restored or reused from older MySQL version. The solution described is run mysql_upgrade.


1

You should not set innodb force recovery. First you have to identify the root cause of MySQL crash. You should review your MySQL error log. Generally it should be present is the Mysql data directory but it may be at different location depending on your installation. Also, make sure that there is no invalid or incompatible entry in your my.cnf.


2

Do you have the option to rebuild PHP without mysqlnd? If your current build is using it then it'll flat out refuse to have anything to do with the old authentication method and you'll be getting an error along the lines of "mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication" in your logs. A build without it might just get you thru, ...


-2

http://www.heidisql.com/forum.php?t=10835 Note to self: When setting up SSH, you MUST set the following option in /etc/ssh/sshd_config: AllowTcpForwarding yes If you don't, then your packets will be silently dropped at the server. This results in the above error message.


0

For folks that are using automysqlbackup you will need to do the following: Modify or Create your ~/.my.cnf and create a mysqldump section by adding the following [mysqldump] events ignore-table = mysql.events Using this solution guarantees that if you upgrade automysqlbackup that your changes won't be erased.


1

Have you tried 127.0.0.1 as the hostname on the "General" Tab of your application? It's hard to tell exactly what this application is trying to do (remote/local/dynamic tunnel) I have to do something similar to get to a remote Oracle Database we use... I have the luxury of having access to either a linux workstation or cygwin. I am not familiar with the ...


0

I recommend signing up for a free account on SenderScore.org. They have some very useful tools for diagnosing why your mails might be being rejected.


0

MySQL is already running. Kill the existing MySQL server processes manually before trying to start it again.


0

Try killing the MySQL server manually if the stop command fails/hangs. Find the MySQL process and kill it. List all processes and search for mysql: ps aux | grep mysql mysql 5471 1.0 3.5 615688 142900 May21 528:18 /usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid Then kill the mysql process: kill -9 5471 The will at least prevent you from ...


-2

Edit the my.cnf file and specify the amount of RAM MySQL is allowed to use Change the ib_data file to ensure that all databases create their own file. That way reading the database does not take as much RAM All these edits should be done in /etc/mysql/my.cnf.


1

mysqli and PDO both operate in buffered mode by default. This means that your queries are effectively subject to the PHP process memory limit. From http://php.net/manual/en/mysqlinfo.concepts.buffering.php: [In buffered mode], query results are immediately transferred from the MySQL Server to PHP and are then kept in the memory of the PHP process. ...


0

Solution 1: If you have lines like this : skip-networking bind-address = 127.0.0.1 In your my.cnf configuration file, you should comment them (add a # at the beginning of the lines), and restart MySQL. Of course, to do this, you must be the administrator of the server. Solution 2: If you could login as root to mysql then you create a new user: CREATE ...


1

Those options are to manage what IP will the server use to listen for the incoming connections. I would recommend that you use Ubuntu firewall to controll who has access to the ES port, or you can use a plugin from Elastic, Shield, that provides that feature (as described in Shield documentation.


1

You can specify many mysql maps in virtual_mailbox_maps parameter. For your example case, here the configuration virtual_mailbox_maps = mysql:/etc/postfix/example1,mysql:/etc/postfix/example2 Then in both maps specify the different parameters #/etc/postfix/example1 user = someone password = some_password hosts = foo.example1.org dbname = foodb query = ...


1

A common cause of this can be php's install directory not being included in the PATH environment variable ( See: PHP: Installation of Extensions in Windows ), which causes the php module to fail to find mysql. Any error in the logs about failure to load the extension?


2

Your HAProxy is not testing for MySQL health as on your MySQL section you are telling to do tests for http (with the line option httpchk), you should use option mysql-check so it should read as listen mysql-cluster 192.168.7.149:3306 mode tcp balance roundrobin option mysql-check user a_test_user server xtra1 192.168.7.151:3306 check ...


0

An easy way to check the memory usage on your server is to install a tool called htop. htop will give you the vitals of your server on a per-process basis. In your case where you want to check memory, you could load htop and hit M to sort by Memory (or > to pick a category). Once you find out which of your applications is using the most memory(I'm ...


0

For some reason you are running into the maxclients parameter. Do you have any more information as of amount of requests per second when the server goes down? It looks like your swap is being filled completely, causing the server to crash. Do you have any info on which components are using how much memory?


0

I do not think with apt-get you could give parameters so it would know which php.ini to use. I think you could either try to compile the module, or download the .deb file from the repo, and extract the contents with 'ar' first followed by extracting the data tar gzip. Then you could move the file over manually.


0

That was a big failure to do so. There is a tool for macos to restore permissions for the filesystem, but as long as you don't have a backup of your server you are lost.


0

Connect to mysqld using mysqladmin MySQL Documentation says about mysqladmin ping Check whether the server is available. The return status from mysqladmin is 0 if the server is running, 1 if it is not. This is 0 even in case of an error such as Access denied, because this means that the server is running but refused the connection, which is different ...


0

M is Megabytes, K is Kilobytes, key_buffer_size is MySQL setting related to MyISAM engine If you use InnoDB engine for all your tables, you need only small (but non-zero key_buffer_size), you need large innodb_buffer_pool_size. I would highly recommend this web page as it gives simple answers to otherwise very complex thing, which MySQL optimization is. ...


0

As @khaled said in the comment thread of your question, it'd be much more reliable to implement keepalived. It's not nearly as scary as you may think it is. keepalived will manage the floating IP, and you tell it to run a script in the event of a failover. Here's an article specifically on how to configure keepalived with mysql: ...


0

Assuming you will have sshkey auth for password less login for root user to the remote machine, you can run the following command - ssh remotemysql "if [ 'ps -efww | grep mysql| grep -v grep' ]; then echo "server is up" ; else echo "server is down"; fi" replace echo "server is down" with the a mysql start up script. say /etc/init.d/mysqld start


0

Checking is easy as this: mysql -e "select 1" || echo down You could replace the echo with an ssh command into root to start the service, but that seems a bit risky. It may have security implications. It may not be reliable. I would suggest that you should probably have some kind of proper cluster/failover software to do this. There is MySQL MMM, which we ...


0

You can install mysql in an alternative directory, using puppetlabs mysql module in this way, if you want to install percona first you need to add the percona repository for your distro. file mysql.pp class { '::mysql::server': service_name => 'mysql', package_name => 'Percona-Server-server-56', root_password => ...


0

this is what you have to use to understand whats going on with your database: https://www.percona.com/software/percona-toolkit Percona Toolkit for MySQL is a collection of advanced command-line tools (which our own Percona MySQL Support staff uses) to perform a variety of MySQL server and system tasks that are too difficult or complex to perform ...


0

Oddly enough turning on the firewall (and a getenforce check) and things work. In the nas table of mysql I had to set the nasname to the ip address even though it seemed to be resolving via dns?


2

It's the idea of mysqltuner to recommend actions for better performance. The optimize table will care about fragmentation. Optimize on big tables takes some time though, while the table you are optimizing is locked. Generally the warning notes prefixed with [!!] are commented in the General recommendations section. Before you tune the default parameters of ...


0

Answer to Question 1 pt-table-sync (togerther with pt-table-checksum) can be used to correct replication errors like data corruption, someone directly modifying data on the slave, server crashes, schema changes in wrong order, etc. However pt-table-sync can be also used without replication for keeping tables synced in near-realtime if the data don't change ...


0

It would seem that the Erlang VM is unable to either find or access one of mysql.beam, mysql_auth.beam, mysql_conn.beam or mysql_recv.beam. Make sure those are all in the appropriate ebin directory and readable as the user ejabberd runs as.


2

It sounds like you are over thinking this too much. If you are just starting this web service, there is no way you'll need that much hardware. You would be best off renting something cheaper (a VPS or an instance in one of the popular Cloud providers) and replicating inside their private network. Also, with such a small web service, replication seems ...


1

Try accesing the server with 'root'@'127.0.0.1' which is diferent from 'root'@'localhost'. Then issue a command to create the user 'root'@'localhost' and grant all privileges to it


0

A purge action on an already removed package by definition will try to remove the configuration files provided by that package. You have installed a package from two different providers that most probably define the same conffiles. Find out which are these by issuing: # dpkg-query --showformat='${Conffiles}\n' --show mysql-server for installed packages, ...


0

As mentioned by Shlomi Noach, performance_schema is not supposed to be backed up. The easy way to fix this is to set the following in your config file: CONFIG_db_exclude=( 'performance_schema' 'information_schema' )


0

You have to establish standard ssh-session with putty, log in, launch screen and then start mysql CLI-client: /usr/local/etc > mysql -u imdba -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 108316807 Server version: 5.5.41-MariaDB FreeBSD Ports Copyright (c) 2000, 2014, Oracle, MariaDB ...


0

Ensure the Common Name of your CA certificate and Server certificates are different If your certificates were generated using openssl with a version greater than 1.0 and are RSA, reformat your keys using the following: openssl rsa -in key-from-openssl-1.pem -out pkcs1-yassl-compatible-key.pem (replace filenames as appropriate). The reason for this is that ...


0

When you use mysql installed via Homebrew, you should find your database folders and files in /usr/local/var/mysql


2

As the author of Percona data recovery toolkit I recommend you to use TwinDB data recovery toolkit. There is no development in Percona's toolkit last two years and all new features go to TwinDB's toolkit. You case is described in a post Recover Corrupt MySQL Database To recover table structure you can use mysqlfrm tool or recover the structure from InnoDB ...


0

You have to decrease max_connections as far as you have only 9 simultaneous connections within 138K for 12 hours (and 600 is defined). Default 151 connections if enough. You have to increase your key_buffer_size to at least twice big as MYISAM indices (64MB, and 256MB prevents troubles in the future) to fit all the indices into the memory. You can reduce ...



Top 50 recent answers are included