New answers tagged

0 votes

Cloud SQL MySQL 8.0.26 Intermittent "Got timeout reading communication packets" error in App engine flex + Node.js app

Rate Per Second = RPS Rate Per Hour = RPHr With information posted as of today, Suggestions to consider for your Google Cloud Database flags, to be applied in each server involved. connect_timeout=...
user avatar
0 votes

How to do mysql_secure_installation via ansible playbook?

You can do this with Ansible's Expect Module. Here is an example: - name: secure mariadb become: yes expect: command: mysql_secure_installation responses: 'Enter current password for ...
user avatar
  • 101
0 votes

Where does MySQL store its database files on OS X?

As others have suggested I found this helped the most to remove all traces (at least all that I needed) NOTE: This will make you lose all your data if you didn't back it up brew remove mysql &&...
user avatar
2 votes
Accepted

How to debug unexpected mysqld restart?

Observation in the posted error log, auto update from 8.0.29 to 8.0.30 Confirmed by MySQLTuner report of 2h-45m. Reasonable conclusion?
user avatar
0 votes

MySQL Query working on MySQL Workbench but not in Python

This is the weirdest WHERE clause I see. The normal way will be something like: WHERE tb2.StartDateTime < \"2022-07-19\" AND tb2.FinishDateTime > \"2022-07-19\" The ...
user avatar
  • 2,795
0 votes

Mysql is not starting in UBUNTU 20.4

$ locate libprotobuf-lite.so /usr/lib/mysql/private/libprotobuf-lite.so.3.19.4 $ dpkg -S /usr/lib/mysql/private/libprotobuf-lite.so.3.19.4 mysql-server-core-8.0: /usr/lib/mysql/private/libprotobuf-...
user avatar
0 votes

Converting a Medium Sized Database from one charset to another with minimal downtime

If you are using a new enough version of MySQL and do not need utf8mb4 in any PRIMARY KEY, the following might work. (Please thoroughly test on large tables first) For each table: Add VARCHAR/TEXT ...
user avatar
  • 2,008
2 votes

MySQL: myisamchk recover error after "mysqlhotcopy --noindices" on table whose index file was larger than 2048 bytes

Delete the .MYI file, then REPAIR the table. AND seriously consider changing to InnoDB (from MyISAM).
user avatar
  • 2,008
3 votes

ib_logfile0 size 44895232 is not a multiple of innodb_page_size after Ubuntu upgrade

innodb_page_size is by default 16K which is 16384 and your innodb_log_file_size seems to be corrupted in half way during upgrade. When you say you lost ssh, does that mean server was rebooted? you ...
user avatar
0 votes

port 3306 is closed on my website how can i open it?

/etc/mysql/mysql.conf.d/mysqld.cnf must have localhost bind-address commented out so: #bind-address = 127.0.0.1 Create and grant permissions for user root connecting from machine 192.168.0....
user avatar
0 votes

apache DBD not connecting to MySQL

This is an old question, but I'd like to say that setting DBDPersist Off Resolved the issue to me.
user avatar
0 votes

Detecting database breach

The general term, not specifically for database protection, is "intrusion detection system" (IDS) and the often closely related "intrusion prevention system" (IPS). The Wikipedia ...
user avatar
  • 1,137
0 votes

Copy large-size JSON content and paste it into MySQL column

The quote you presented about a 64KB limit for a row is bogus. MyISAM allows bigger rows; InnoDB puts big columns "off-record". phpmyadmin is built on PHP and it runs under Apache (or other ...
user avatar
  • 2,008
1 vote

Performance improvement for Innodb - High CPU

Analysis of GLOBAL STATUS and VARIABLES: Observations: Version: 10.3.27-MariaDB-0+deb10u1 16 GB of RAM Uptime = 04:05:27; some GLOBAL STATUS values may not be meaningful yet. 1.58e+4 Queries/sec : ...
user avatar
  • 2,008
0 votes

How to refer environment varibales in MySQL configuration file

See mysql_config_editor as a convenient way to both establish your credentials and make them reasonably secure. Since it is a one-time setup, you don't even need the $variables after that.
user avatar
  • 2,008
0 votes

Where is my mysql log on OS X?

The approved answer from Bruno didn't work for me on MacOS Monterey, and in any case, it won't help you if your problem is that there is no mysqld process because it failed during startup. However, ...
user avatar
  • 101
0 votes

How to refer environment varibales in MySQL configuration file

This is not possible. MySQL does not support variables in the configuration file. If you want to ease deployment you should look into configuration management.
user avatar
1 vote
Accepted

Performance improvement for Innodb - High CPU

Rate Per Second = RPS Suggestions to consider for your OS and my.cnf [mysqld] section For your OS, ulimit -n 32768 # to increase Open Files limit for your load + other apps needs For this to persist ...
user avatar
1 vote

ERROR 1034 (HY000): Incorrect key file for table 'mytable'; try to repair it

PRIMARY KEY (title(255)) Ouch! Technically that says that the first 255 characters of title are unique. This is probably not what you wanted. I think that prefixing UNIQUE and PRIMARY KEY should ...
user avatar
  • 2,008
1 vote

Check remote certificate - MySQL

Recent versions of the OpenSSL s_client command support the -starttls mysql flag. If you add that flag, you can also check certificates of MySQL services.
user avatar
0 votes

Mysql - Data_free value in a table cannot be decreased

Are you using ENGINE=InnoDB? Is the table in question Partitioned? MySQL's InnoDB preallocates "extents" in anticipation of new rows being inserted. This usually (not always) shows up as ...
user avatar
  • 2,008
0 votes

Unable to get subdomain to connect to MariaDB

Finally figured it was a permissions issue. Permission for my functions files were all set to 640 meaning that the owner has read and write permissions, the group has read permissions, and all other ...
user avatar
  • 1
0 votes

mysql crashes when accessing database after upgrade from 5.5 to 5.7

Did you run mysql_upgrade after you updated the software?
user avatar
0 votes
Accepted

optimize Mysql 8.0 performance for millions of small tables

Immediate question For tiny tables, file_per_table is probably the wrong way to go. It would be better to have them in the main tablespace (ibdata). The OK does not like having millions of tables, ...
user avatar
  • 2,008

Top 50 recent answers are included