Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

Questions tagged [mysql]

MySQL is an open-source database owned by Oracle.

-1
votes
0answers
13 views

hosts file domains is not responding [on hold]

am using debian , and am working on a php laravel project so first thing to do is sudo service apache2 start sudo service mysql start every thing working fine , the project is working great ...
0
votes
0answers
23 views

Disk of VirtualBox Size keeps increasing when doing MySQL restores

I am using a classic LAMP (Ubuntu 18.04) in a VirtualBox (5.2.18). The disk has a Dynamically allocated storage. Each time I restore the tables using this command, the disk size of the virtual ...
0
votes
1answer
26 views

Unifi AP-PRO with pfSense running FreeRADIUS, with MySQL database externally

I'm in the process of moving from a set of Aerohive AP's to Unifi AP-PRO to increase the range of our wifi. Adding more Aerohives could be a solution, but they're way more expensive and I already have ...
0
votes
1answer
18 views

Is it necessary to export and import stored procedures, triggers and indexes while dumping sql database?

I use WordPress and I have always exported my database using the following command: mysqldump -u user_name -p database_name > backup.sql I never used --routines Just wondering if I am doing ...
-2
votes
0answers
26 views

Is it possible to a 4GB ram server handle 500+ (keeps growing) concurrent users? [duplicate]

Im new to the server config world.. i dont have too much knowledge about performance. My client has majority traffic source from youtube, meaning that whenever he uploads a new video, the amount of ...
0
votes
0answers
4 views

Is it okay to stop my repair on my mysql database if it's not showing in processlist? [migrated]

I started a repair on a table in my database that seems to still be running. mysql> repair table dicore_search_index; [empty line] It's just been sitting there like that since i started it about ...
-1
votes
1answer
18 views

How do I reconnect my Amazon RDS database to my EC2 instance after restarting? [closed]

I'm running a staging site through an EC2 instance which I stopped earlier tonight, without being aware that Amazon would give me a new IP address. I've already edited all my database info in my site ...
0
votes
1answer
24 views

MySQL 8 - Error log into Syslog

i'am trying to switch /var/log/mysql/error.log into syslog in MySQL 8. Reason is compatibility with our monitoring for parse, maybe not that clean, but it does the job. I had no problem with this on ...
3
votes
2answers
54 views

Upgrading a MySQL database using numbered scripts compared to a version field [closed]

I have been given a task to upgrade a MySQL 5.7 DB using a directory of sequenced scripts and comparing them to a version field in a DB. You should query the DB, then compare the returned table ...
0
votes
0answers
19 views

mysql (Perconadb) Galera/Xtrabackup cluster join fails with “Invalid Argument”

I have a MySQL Galera cluster, using Perconadb and Xtrabackup. The nodes can start stand-alone, or can join the cluster if only an IST is required. However, if an SST is required, then this runs to ...
0
votes
0answers
13 views

Gogs not restarting after server reboot

I had quiet an abnormal thing happen with my development gogs server today. I should say that I am working with a huge repo (+60GB) and this may be a factor in the problem. I checked out a previous ...
1
vote
1answer
79 views

my.cnf MariaDB configuration - hitting the CPU ceiling even with the optimizations in place

I'm trying to get around this issue of mySQL hitting the ceiling in terms of CPU/Server load, as the server specs are as follows: List item 2 x 2.4GHz Octa-Core E5-2630 v3 Haswell Xeon 128GB RAM SSD ...
1
vote
1answer
46 views

Audit logs for RDS MySQL not appearing in CloudWatch

I've been trying to get a MySQL instance on Amazon's RDS to send logs to CloudWatch: in particular, both error logs and audit logs. Error logs work fine, they're appearing in CloudWatch, no issues at ...
0
votes
0answers
4 views

MySQL: Replication and local variables [migrated]

Can I use local variables in a trigger if I expect it to replicate on a slave ? I have a trigger that uses a local variable @userId that is set prior to the triggering query. So every time a certain ...
0
votes
0answers
29 views

MySQL's innodb_buffer_pool_size doesn't seem to have any effect on RAM usage

(I have checked similar questions, none of them cover my situation) I'm trying to increase MySQL 5.7 memory usage on my Ubuntu 16.04. Before my changes mysqld was using about 8% of RAM out of 8GB ...
0
votes
1answer
19 views

Centos 7 / MariaDB, 1gig DigitalOcean Droplet high traffic kills MySQL [duplicate]

I have a Centos 7 / MariaDB, 1gig DigitalOcean Droplet with 2 low traffic Wordpress sites on. When the server gets approx 15 concurrent users MySQL runs out of memory and drops. Log below: 180806 14:...
0
votes
0answers
30 views

mysql-server-5.7 package post-installation script subprocess returned error exit status 127

I have a website server on Ubuntu server 18.04 with apache and mysql. The database stopped for no apparent reason. I just did a restart of mysql server to solve the issue but after a simple update I ...
1
vote
0answers
51 views

How to use screen with mysql cli?

Here is what is happening. I'm using debian with KDE. I open Konsole. I use ssh to log into my amazon server. All of the following commands are done in the Konsole whiled logged into the amazon server....
0
votes
0answers
24 views

Ubuntu apache2 mysql 5.6.35 not able to start mysql

I installed mysql on my ubuntu apache2 aws ec2 server I ran the following command to install sudo apt-get install mysql-server-5.6 Now when i type in mysql -V i get the below output mysql Ver 14....
0
votes
0answers
19 views

mariadb 10.3.7 gcache page files not deleted

env: 3 node ubuntu cluster : galera cluster but it is not deleting any of those files. 2018-07-31 22:52:28 16 [Note] The slave is applying a ROW event on behalf of an UPDATE statement on table ...
0
votes
1answer
29 views

Promoting MYSQL Slave to MYSQL Master

I have a MySQL setup with one master (M1) and one slave(S1). Due to some unforeseen issue I need to promote my slave server to master and demote master to slave. My MySQL version is 5.6 in Linux. ...
0
votes
1answer
52 views

MariaDB doesn't start after upgrade from MySQL 5.7

I installed MariaDB server, my MySQL got removed automatically and I tried to get it running using sudo service mysql start, which caused the following error message: Job for mariadb.service ...
0
votes
2answers
38 views

unable to remotely connect to mysql on ubuntu server

I have an Apache2 ubuntu AWS EC2 server which I just installed mysql on. However I do not seem to be able to connect remotely to the database via mysql workbench. I am wondering what step did I ...
-2
votes
0answers
35 views

Server waiting time is increasing if the 300concurrent users are trying to call 2APIs simultaneously in Android [duplicate]

Our server configuration is 4GB RAM and 20GB HDD with 2 core processor. Now the issue I'm facing is when more than 300 concurrent users try to call 2 APIs simultaneously, the waiting/response time is ...
0
votes
1answer
29 views

How do I configure postfix for Mysql 5.7

I made the appropriate changes to postfix to get mysql 5.7 working as the database instead fo Maria DB. I can run tests and all seems to work on the server. However, I cannot log into my account from ...
0
votes
0answers
5 views

MySQL: Why does the Metadatalock continue to be held when a long query is killed?

Sorry for not having specifics, I will try my best. Note: this is on 5.7 AWS Aurora/MySQL When performing the steps below, I run in to a bogus METADATA lock being held. To fix it I just need to make ...
2
votes
2answers
236 views

PHP 7.2.8 PDO Fails to Connect to MySQL 8.0.12 (GA) in AWS EC2 LEMP Stack

I'm testing a new LEMP webserver built with Ubuntu Server 18.04 LTS, NGINX 1.14, PHP 7.2.8, and MySQL 8.0.12. It is an AWS EC2 instance using the official Canonical AMI. Web and PHP work as intended ...
0
votes
0answers
38 views

Cannot connect: invalid settings. phpmyadmin

I got Cannot connect: invalid settings. from phpMyAdmin with the following docker files. docker-compose.yml version: '3' services: expressionbrowser: build: . restart: always ...
0
votes
1answer
62 views

Need help expanding space on a debian virtual server

I'm running a vm on vmware and it only had 17gig of space allocated to it, I changed the size of the hard drive in vmware from 17gig to 100gig. Here is the info for the vm, how can expand the ...
0
votes
1answer
23 views

Adding ip to connect to RDS 'not Publicly accessible'

I would like to allow access to an RDS for a group of ip's outside the VPC (devs using workbench). However, I would like to leave 'Publicly Accessible' disabled. Is there a way to do this? Config: ...
0
votes
2answers
55 views

MariaDB won't start after server crash. No error logs

My CentOS 7 server recently crashed by having a hard drive unplugged while it was running and now MariaDB won't start and I'm not getting any error logs. Everything else on the server seems to be ...
0
votes
0answers
26 views

Email “catch all” function for postfix with mysql

I spent a day searching for an answer and I decided to write about it. Here's my question. My mail server configuration is based on this tutorial: https://thomas-leister.de/en/mailserver-debian-...
0
votes
1answer
33 views

MySQL not finding database/tables through symlink

In my installation of MySQL the database files are located in ./var/lib/mysql. I wanted to move one of those databases to another drive, so I followed instructions to move one database to a different ...
1
vote
1answer
65 views

All administrator page login are not working and showing “Service Unavailable”

Let assume I have websites aaa.com, bbb.com and ccc.com aaa.com - working. aaa.com/about - working. aaa.com/services - working. aaa.com/administrator - Showing the below error message. "Service ...
0
votes
1answer
36 views

Write permission error in /tmp in python call to MySQL on Centos 7

I have a python (3.6 anaconda distribution) scrip on Centos 7 which at some point executes a simple query of the following structure import MySQLdb cursor = cnn.cursor() # cnn is the open ...
0
votes
1answer
27 views

MYSQL log_bin_trust_function_creators

I am trying to create triggers on a mysql database. In doing this I encountered the following error: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the ...
0
votes
1answer
23 views

MariaDB (MySQL) 'table marked as crashed' recurring

I have a production environment where about once a week I'm finding the database needs to be repaired and restarted. The MariaDB database contains some InnoDB and some MyISAM tables (the mixture being ...
0
votes
2answers
44 views

Cannot enable MySQL bin log

I have a MySQL 5.7.22 server that I'm having a problem enabling the bin log for. As far as I can tell from my reading, I have the proper configuration to enable bin logs, but they're never created ...
0
votes
0answers
39 views

Master Master replication between RDS and database instance on EC2 Errno: 1032

I face this error many times with my replication Last_SQL_Error: Could not execute Delete_rows event on table db_name.event; Can't find record in 'event', Error_code: 1032; handler error ...
-1
votes
1answer
74 views

How to backup and restore mysql without mysqldump

I couldn't chroot to the broken ubuntu server, may i know how can i backup and restore the mysql server without mysqldump? Could it be copy the directory and replace to the new server?
1
vote
1answer
27 views

Different cardinality after each ALTER TABLE;

There is no new entries in this table. Same error on 10.3.8-MariaDB and 10.2.6 What could cause that? Also this is strange too.
0
votes
0answers
34 views

Website down with 3,000 concurrent user 4Gb Memory Dedicated Server (myIsam - MySQL) [duplicate]

Our site has 3,000+ concurrent users when we open our registration on our website. The site was too slow and get the server down sometime, even sub accounts websites are down. Free memory was 400MB. ...
0
votes
1answer
44 views

execute check and repair mysql(wampserver) from a batch file

I'm trying to run check mysql and repair mysql functions in a sql file from another batch file. I get the error as: C:\wamp64\bin\mysql\mysql5.7.19\bin\mysql.exe" "mysql -u root -p < batch.sql" ...
0
votes
0answers
28 views

mysql ndb cluster and table partitioning

I have mysql ndb cluster with 3 datanodes. I want to break one of my tables into partitions based on one column (maybe date), the question is that what happens after I run partitioning script : I ...
0
votes
0answers
44 views

mysql no user login

I have the problem that someone / someone is trying to connect to my database without a user / password. Port forwording on 3306 is not active. My SQL protocol: @localhost when using TCP / IP Access ...
1
vote
0answers
20 views

Mysql Enterprise Encryption / Backup & Restore

To use the Encryption in MySql I would require the Enterprise version (TDE). (Unless I am mistaken?!?). The cost for this is quite high, and the information about it is not really helpful. I have a ...
0
votes
1answer
14 views

OpenDKIM Exited status and mysql plaintext passwords

On my VPS Debian Jessie, email server Postfix + Dovecot with user and password on MySQL, I've installed OpenDKIM, that use MySQL for keys too. If for some reason the server reboot, I can find every ...
0
votes
1answer
14 views

mysql error on moved tikiwiki installation

while move my tikiwiki installation from one to another server i ran into this issue: i moved my tikiwiki(12.2) installation from one server(Apache 2.2.26, PHP 5.3.16, MySQL 5.5.25a, Mac Server App 1....
0
votes
1answer
26 views

Mysql Workbench Connects with IP not with Hostname on Local Network

Connecting to an Ubuntu machine from Win 7 over LAN using MYSQL Workbench. Using hostname 'chili-xeon' fails to connect. I can ssh and ping using that hostname. I can also connect with Workbench ...
0
votes
0answers
25 views

Connect my DB (separate server) with mysql-ssl

I want connect prestashop 1.6 to a DB separate server with mysql-ssl. Settings.inc.php don’t have any path options to SSL (ca.pem, client-cert.pem and client-key.pem). Anyone have any ideas how do ...