Questions tagged [mysql]

MySQL is an open-source database owned by Oracle.

Filter by
Sorted by
Tagged with
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] [...

15 30 50 per page
1
2 3 4 5
550