New answers tagged mysql
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=...
- 381
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 ...
- 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 &&...
- 101
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?
- 381
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 ...
- 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-...
- 19.1k
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 ...
- 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).
- 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 ...
- 31
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....
- 21
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.
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 ...
- 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 ...
- 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 : ...
- 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.
- 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, ...
- 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.
- 19.1k
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 ...
- 381
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 ...
- 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.
- 295
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 ...
- 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 ...
- 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?
- 1,991
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, ...
- 2,008
Top 50 recent answers are included