New answers tagged mysql
1
In preparing a backup strategy you should start by evaluating recovery point objective (RPO) and recovery time objective (RTO). The RPO indicates how much data the business is willing to lose in the event of an incident, while the RTO indicates how quickly it will take to recover. Your requirements for RTO and RPO will drive the economic and performance cost ...
0
If the research server only contains data based on the production DB, why not run SQL Server on your linux servers instead of MySQL? If your production database is less than 4GB (which it sounds like it is), you could run SQL Server Express edition for free.
You would not need a separate export step. IT guys should already be making full and transaction ...
1
Use the 5.5 version of mysqldump to create the dump. It might work. Or it might get into other troubles.
5.5 had a very limited set of defaults for TIMESTAMP columns. Even if you could turn off the incompatible syntax, would you get a CREATE TABLE that will work.
This may be only the tip of the iceberg. What do you intend to do on the version 5.5 ...
0
You already found the compatibility flag for the dump, and it does not have that specific of a version.
Upgrade the destination database to 5.7 or later. If this is not feasible, write a program to do any needed transforms and import it. Extract from the running database, or transform the 5.7 dumps.
(In general, forward compatibility with any significant ...
0
I've resolved this and the underlying problem was the password for the backend mariadb/mysql.
Wasn't at all clear from the logs which reported...
PHP message: PHP Fatal error: Uncaught Error: Call to undefined function mysqli_init() in /usr/share/webapps/wordpress/wp-includes/wp-db.php:1591
However, I started stripping things back and after checking ...
0
Thanks for your answer :)
It is behind a NAT but the 3306 is forwarded to it. It is accessible by the WAN, I'm connected from the EC2 instance
You may be right, it gives me the idea to try to connect to the RDS DB from the VM and... i can't (connection timed out)
I don't understand why tho,
The RDS is public
The RDS is in a security group accepting my ...
1
MySQL considers 127.0.0.0/8 addresses to be different from localhost so when creating users if you specify one you need to connect using that one reference.
Additionally, some MySQL connectors will use a socket when connecting to localhost but use TCP/IP when connecting to 127.0.0.1
Finally, one of the more recent differences is if localhost is used ...
0
Is your master DB VM behind a NAT? And if so have you got the MySQL port forwarded from outside to the VM?
Is your RDS in a subnet from which it has access outside? I.e. either in a public subnet with IGW attached and a Public IP, or in a private subnet with NAT Gateway?
Both these conditions must be true if you want to connect from RDS to your VM.
Hope ...
0
Hi check whether your disk is full in the installation partition. And if the storage exists manage the logs in the Mariadb server adding following lines to my.conf
expire_logs_days = 10 #this is for managing the log days
max_binlog_size = 100M #this is for managing the log size
Move the logs to a directory and restart the mariadb server.
0
For anyone else who views this, you can also use the mysqladmin command to list all running queries and selectively kill them if need be. This would preserve any other queries that were executing on that instance.
https://dev.mysql.com/doc/refman/5.5/en/mysqladmin.html
Note that SHOW VARIABLES will return the location of MySQL's logs, if that is also ...
1
You are right, meddling like this should not be necessary. A quick grep shows that $use_mysqli is set in line 621 in wp-db.php:
// Use ext/mysqli if it exists unless WP_USE_EXT_MYSQL is defined as true
if ( function_exists( 'mysqli_connect' ) ) {
$this->use_mysqli = true;
if ( defined( '...
2
No
As far as I know the current working directory is not something you can use as a security / authentication attribute in MySQL.
0
Solution:
My.cnf has been changed to the settings below:
[client-server]
[mysqld]
datadir = /opt/timwe/data/mysql
innodb_log_group_home_dir = /opt/timwe/data/mysql/innodblog
log-bin = /opt/timwe/data/mysql/binlog
log_error = /opt/timwe/log/mysql_error.log
slow_query_log_file = /opt/timwe/log/slow_query.log
tmpdir=/opt/timwe/data/mysql/tmpfs
...
0
Check which process is already using this port (mysqld is using socket 3306 by default):
netstat -lntp | grep 3306
Stop or reconfigure that process and try to start mysql again.
0
Run ls -la in your mysql data directory:
-rw-r----- 1 999 999 56 апр 27 00:08 auto.cnf
-rw-r----- 1 999 999 0 мая 20 21:51 binlog.index
-rw------- 1 999 999 1679 апр 27 00:08 ca-key.pem
-rw-r--r-- 1 999 999 1107 апр 27 00:08 ca.pem
-rw-r--r-- 1 999 999 1107 апр 27 00:08 client-cert.pem
-...
0
I solved myself
for this error do this
In the wp-config.php file, include (or change) this line from
define(‘DB_HOST’, ‘localhost’);
to
define(‘DB_HOST’, ‘127.0.0.1’);
0
From my (still limited) understanding the IOPS numbers reflect disk I/O and not operations in general.
With this is mind I think the following applies:
Every write operation to the DB (i.e. any INSERT, UPDATE etc. statement) updates the data in memory and also triggers a write operation to disk (to persist the data)
Read operations (i.e. SELECT statements) ...
0
Building on the answer of Vladimir: the BurstBalance metric is now also available in Cloudwatch, so you can set up and alarm based on it there.
0
Okey guys after i deleted application that uses query (WHERE member_group_id != member_group_id ...)
I didint have my websites shutdown for around 1 day and 8 hours, so there is improvment.
I want to thank very much to Rick and bjoster for help, i really appreciate it and you really saved a lot of my time.
Now because i modify my configuration file many ...
0
As Rick said, this is obviously problem with the query and/or the code genreating that queries, not with the server itself.
0
MySQL 5.7 onwards you can use max_execution_time variable to get this done automatically for all "SELECT" read queries .
1
ALTER TABLE `core_sys_lang_words` ADD INDEX(lang_id, word_key);
ALTER TABLE `bimchatbox_chat` ADD INDEX(user, `time`);
This will be mis-parsed:
WHERE 'member_group_id' != `member_group_id` NOT IN(94,96)
What do you want it to mean?
1
You can do it using several ways:
Create general log and store there the info like in this answer:
You would probably want to use the general query log.
The general query log is a general record of what mysqld is doing. The server writes information to this log when clients connect or
disconnect, and it logs each SQL statement received from clients....
0
I discovered this problem and a fix just the other day... so you're in luck! This is NOT a firewall issue, but an authentication plugin issue.
The default configuration does not allow "root" to log into the local mysql instance unless it is using file sockets. Check the authentication plugin by logging into the local machine and doing mysql -u root -p (...
0
What Engine are you using for your tables? It should be InnoDB. In this case, you should configure
innodb_buffer_pool_size = 20G
(Or perhaps more; how much data do you have?)
Use the slowlog to find the slow queries, then let's see SHOW CREATE TABLE and EXPLAIN SELECT ....
1
256MB of RAM is almost too small to handle MySQL. And it would be crowded to have anything else running on the same machine. (I don't know the memory footprint of Grafana.)
128MB allocated for the buffer_pool adds to the disaster. MySQL needs RAM for things other than that, so MySQL is actually using most of RAM.
You could try these:
...
5
To allow connection via loopback adapter only on port 3306 you can run the following:
sudo ufw allow from 127.0.0.1 to 127.0.0.1 port 3306 proto tcp
0
On my setup, I wasnt running xinetd, but found that the mysql-check option was causing issues. So I was at least able to get haproxy up and running by commenting it out. I suspect that mysql-check has something to do with either wrong mysql user being used or missing grants.
0
I saved by accident my configuration "my.ini" using "UTF8 with BOM". After changed the charset to "UTF-8" (or ASCII) it's working again.
1
What are the measures and steps I can take to prevent this from happening again?
It is difficult to tell you what to do as you didn't tell us what you did. In general
Run mysql_secure_installation which will do some basic securing of a newly installed MySQL/mariadb server.
Only allow the database root user to access the system locally and always ensure ...
0
It is hard to analyze the memory requirements for such a tiny (1GB) system. Especially since you have the entire stack in the single VM.
The obvious culprit is so many PHP threads. They are probably sitting idle. Does nginx have a way to tune the number of threads it will run? If so, set it much lower, say 6. This may be the best quick-fix.
The ...
1
I had the same issue and finally I found what was wrong. According to documentation: https://mathias-kettner.de/cms_check_check_sql.html the result from first column is parsed and final status depends on what script finds in that first column.
In other words, you have always WARNING status, because you INSERTED '1' instead of '0' in first column. Try to do ...
Top 50 recent answers are included
