Questions tagged [mysql]
MySQL is an open-source database owned by Oracle.
8,247
questions
0
votes
0answers
8 views
Remote MySQL backup from Windows with Worker file
I need a solid remote backup/restore solution for my linux webserver.
The backup/restore software must run on Windows
It must connect to a remote worker file (script) that does the actual backup/...
0
votes
2answers
24 views
Improve MariaDB Execution Time
I have a database with one table and three fields (id, hash, creation time).
This table got around 30 million records, the execution time for a query like
SELECT * from `table` WHERE hash='...
0
votes
2answers
34 views
Why cannot use buff/cache?
It seems mysqld allocates too much memory as buff/cache:
free -m
total used free shared buff/cache available
Mem: 990 448 96 36 ...
0
votes
0answers
20 views
How can I automate the importing of txt files to a MySql database?
I'm running a database on AWS Lightsail and I have a bunch of .txt files I want to import into the database. I can't merge the files because I want to create one table per text file (table name = txt ...
0
votes
1answer
8 views
How to connect to remote mysql through two ssh tunnels?
I can ssh into a mysql server via an intermediate host from home:
[email protected]ome -> Ubuntu a.b.com -> MySQL on Ubuntu: x.y.org
by:
ssh -t [email protected] ssh [email protected]
as x.y.org only ...
0
votes
1answer
28 views
How does mysql count in used connections?
As per my question, I would like to ask how does mysql count used connections. Is it by browser trying to connect to the server? Computer? IP Address?
Yesterday, our client's server got an error ...
0
votes
0answers
7 views
how to find which sql caused the status locked. in history
1.in every day 05:19:21 am, our pro mysql will meet this warning "MySQL 3306 active threads more than 70 on 10.198.227.211" ,this is our monitor software zabbix 's warining .
2.we check ...
-3
votes
0answers
15 views
How to set up MySQL group replication in Ubuntu 18.04 LTS?
MySQL group replication plugin missing in ubuntu 18.04. I am unable to load this plugin in my MySQL version in Ubuntu 18.04. Please help me to resolve this issue. Thanks
0
votes
0answers
11 views
Mysql backup- restore on multiple host in live replication
MySQL database has 1 primary host which is replicating to 2 Read replicas
RR1
RR2
RR1 is master of RR11 RR12 RR13
RR2 is master of RR21 RR22 RR23
I have to make a schema change so I started schema ...
0
votes
1answer
14 views
mytop & mysql: queries per second
On a MySQL 5.5.62 server, with InnoDB tables, I run mytop, and in the "qps now" field it reports something like 40-70. The historical qps is about 60.
I then hit "m" to see the ...
0
votes
0answers
82 views
Debug problems of ssh tunnel to remote mysql connection
I am running on my VPS Ubuntu 20.04.1 LTS and locally Ubuntu 18.04.3 LTS and I want to create a ssh-tunnel to connect to my database to run SELECT's for reporting in my laravel 6 application.
My ...
0
votes
1answer
14 views
Connect to production database on vps from local dev environment
I am using a Ubuntu 20.04.1 LTS VPS with a deployed Laravel Framework 6.20.16 application.
I am currently connecting to my mysql database via ssh using dbeaver, using simply [email protected]_Address and my ...
-2
votes
0answers
28 views
i have uploading database using phpmyadmin and pc hang after restart mysql not start
I am uploading database using phpmyadmin. and pc hang and restart pc and mysql server not working
I have to give below error
systemctl status mysql.service log
mysql.service - MySQL Community Server
...
0
votes
0answers
20 views
Chaning bind-address in mariadb 10.0 on Ubuntu (16.04) does not change the bind address
I changed the bind-address from 127.0.0.1 to 0.0.0.0 in /ect/mysql/mariadb.conf.d/50-server.cnf
and then restarted the MySQL service using
sudo service mysql restart
but
netstat -ntl | grep 3306
...
0
votes
0answers
56 views
MySQL 8 InnoDB taking a long time to start
I upgrade some month ago from Ubuntu 18.04 to 20.04.
So MySQL upgrade from 5.7.33 to 8.0.23.
I notice after the upgrade that MySQL is slow to start.
2021-02-24T09:20:16.972632Z 0 [System] [MY-013172] [...