All Questions
51 questions
0
votes
2
answers
8k
views
How to upgrade MySQL from 8.0 to 8.4?
I'm on Windows. I installed MySQL 8.4, stopped all services and copied the Data folder and my.ini files into the 8.4 folder but now the 8.4 services does not start and does not produce any logs. I can'...
John John
1
vote
3
answers
1k
views
WordPress MYSQL DB BINARY LOG - Droplet/SERVER Volume Increasing rapidly
My WordPress website uses Nginx. Recently I have noticed that server volume has increased from 8GB to 40GB. I have found that the WordPress MYSQL Binary Log is taking more space. Each second, database ...
0
votes
0
answers
70
views
Detail about communication packets error log
On MySQL error log /var/log/mysql/error.log I'm getting this error couple of times during the day:
2021-08-23T07:30:17.660730Z 455148 [Note] Got an error reading
communication packets
My question is ...
- 139
0
votes
1
answer
1k
views
Mysql on Ubuntu crashing periodically [duplicate]
I have a problem with Mysql on my ubuntu server. it is restarting periodically about 4-5 times a day .
Here is the logs that I found in /var/log/mysql/error.log:
2021-02-23T08:35:08.249856Z 18 [Note] ...
1
vote
1
answer
843
views
Does logging affect query performance
I want to benchmark the performance of MySQL, I want to know if logging affect performance.
MySQL has logs: general-log, binlog, errlog, redo log. Do these logging behaviors affect performance? For ...
- 223
0
votes
1
answer
1k
views
mysql (mariadb) won't start after power outage (MacOS)
/var/log/system.log says (over and over)
Oct 13 19:34:01 Data-Server com.apple.xpc.launchd[1] (com.mariadb.server[2128]): Service exited with abnormal code: 1
Oct 13 19:34:01 Data-Server com.apple.xpc....
- 191
1
vote
1
answer
244
views
Is there a way to hide mysql innodb cluster queries from general_log?
When I start my innodb cluster I get many lines of cluster related logs in the mysql general_log file like below, how can I hide these from the log?
2020-06-26T14:40:43.719029Z 31774 Connect ...
- 21
0
votes
1
answer
3k
views
Know when MySQL server was slow shutdown? [closed]
I use MySQL 8.0.
How I can know when MySQL server was slow shutdown?
I start mysql server
/usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/my.cnf --user=mysql
I shutdown mysql server
/...
- 101
0
votes
1
answer
2k
views
Rotate MySQL log files
I want to daily rotate MySQL log files on Windows. I want to keep the files, I don't want to use tables instead.
There are 3 log files: general.log slow-queries.log and error.log
I can do it easily ...
- 886
10
votes
2
answers
21k
views
My disk is full of binlog files
I just realized that my server is growing by 2 GB per day, which is not normal.
I looked at my folder and the folder / var / lib / mysql reached 26 GB
Normally it should be about 4 GB
A month ago I ...
- 113
15
votes
6
answers
22k
views
Disable Binary Logs in MySQL 8.0
How can I disable binary logging on MySQL 8.0?
I am needing to import a large MySQLDump file, and don't want to fill the Binary logs with many GB of data. In the past I would have set log_bin=0 in ...
- 2,276
3
votes
2
answers
1k
views
When mysql innodb undo log write and fsync to disk?
Before transaction commit , every dml operation will modify innodb page which will flush to disk and generate undo log , so when the undo log write and fsync to disk to ensure rollback ?
- 477
1
vote
3
answers
14k
views
Rotation of bin.log file
I am trying to change the binary log rotation from days to hours. By default there is an option only for days in the MySQL config file: expire_logs_days.
Is there any way to change the binary log ...
- 11
0
votes
2
answers
651
views
Mysql 5.6 general log file output not showing unix timestamp
Mysql 5.6 general log file output not showing unix timestamp, so i wonder if there an option that i can execute to enable unix timestamp while logging general queries ?
UPDATE : Here is example for ...
- 163
0
votes
0
answers
52
views
How to restore a mysql database
I have to re-build a mysql database (some tables were truncated), Is it possible? What logs do I need?
My mysql is 5.7 running on ubuntu 18.4
- 252