MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
7 views

MySQL behaviour and disk space handling after deletions and insertions with MyISAM

I have a question about the way MySQL with MyISAM engine handles the free/empty space after deletions and how it behaves when new records are inserted. For example, think about a new and empty DB (...
-1
votes
0answers
6 views

android using jdbc driver connecting to mysql server takes time sometimes works fine [on hold]

I have used JDBC driver for mysql connectivity in android . Sometimes it works fine but sometimes it takes too much time to connect. Is it because of jar file - (mysql-connector-java-5.1.35-bin) that ...
-1
votes
0answers
6 views

Reliable backup system with Ubuntu and ISP Config [on hold]

I'm new mounting servers and I have finally a functionally Ubuntu Web Server on EC2 Amazon AWS with: - ISPConfig - MySQL - Postfix - Bind - Amavisd-New - OpenDKIM Some domains are in Route 53 DNS ...
0
votes
1answer
14 views

How can I export a database from phpMyAdmin when the “Export” tab is missing?

My Webhost has disappeared, possibly because the company has gone out of business. I no longer have access to cloud-based backups which my host created on a daily basis, however I still have access to ...
0
votes
0answers
10 views

Mysqld terminates, system low on memory

I've been getting this error repeatedly: "The process “mysqld” was terminated because the system is low on memory". I have a blog running on WordPress and a forum running on XenForo In the log, I ...
0
votes
0answers
37 views

Laravel 5.2 deployment issue on EC2 Linux AMI

Environment health is OK (green check). I have setup my environment variables according to advice given here and here. I created a separete .env file for production environment, so it's all good on ...
0
votes
0answers
6 views

grafana / collectd Write Graphite plugin change timestamp

I am using collectd with write_graphite plugin to monitor mysql. I am using EDT on my server and when creating dashboards on grafana I can only use UTC/browser time. I want to know if there is an ...
0
votes
0answers
6 views

Dovecot passdb fetch “unknown user”

I am using passdb backend for passdb { driver = sql args = /etc/dovecot/dovecot-sql.conf } userdb { driver = prefetch } Content of /etc/dovecot/dovecot-sql.conf password_query = \ SELECT ...
0
votes
0answers
11 views

MYSQL error: IP address could not be resolved

My website is hosted with Linode, I installed webmin on Ubuntu 14.04 to manage it. Recently my database server keeps shutting down, when I look at /var/log/mysql, there are several log files in there ...
0
votes
0answers
17 views

Having trouble connecting to mysql on Redhat

I'm having issues connecting to mysql on Redhat. The server is running Red Hat Enterprise Linux Server release 7.2, and the mysql server is rh-mysql56-mysqld systemctl start rh-mysql56-mysqld....
0
votes
1answer
16 views

MySQL won't allow login from normal user account

When connecting to MySQL as root from the linux user user user@computer:~/$ mysql -u root -p Enter password: ERROR 1698 (28000): Access denied for user 'root'@'localhost' When doing the same exact ...
-2
votes
0answers
21 views

Mysql script using lot of memory, connected with open port

I am facing problem by the php - mysql script that is connected to the server open port via xinetd. Php mysql script is a simple script that connects to server inserts the data and at the end it ...
0
votes
0answers
3 views

Setting sql_slave_skip_counter is not working on Percona 5.6.24 [migrated]

I am currently running a master - slave replication where on my slave there is an sql error due to which my replication was stopped. when I tried to run the following good old solution SHOW SLAVE ...
-1
votes
0answers
9 views

Switch to Redis or use Redis as cache for mySQL [closed]

I have been using mySQL to make an multi-platform application. I am looking upscale the app and so I am looking into noSQL alternatives. I have been getting the hang of Redis and I really like it. I ...
0
votes
1answer
43 views

yum install error nothing to do (MYSQL, CentOS 7)

I'm trying to install MYSQL instead of MariaDB on my CentOS 7. I used this command: wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm yum install http://dev.mysql.com/get/mysql-...
2
votes
1answer
32 views

MySQL SSL Connection

I'm trying set ssl connection with MySQL Server. I've read this and many more articles https://dev.mysql.com/doc/refman/5.7/en/using-secure-connections.html There is one thing i still don't know, ...
0
votes
1answer
10 views

serverspec if statement for mysql version on server

Is there a way to check which package installed on server by command output? describe command('mysql -e "select version();"') do if its(:stdout) { should =~ /5.6.27-76.0-log/ } describe ...
0
votes
1answer
12 views

Setting group_concat_max_len in Sphinx config is not being applied

I ran into a problem whereby our Sphinx SQL queries are getting truncated. This was due to the default limit for the Group Concat function in MySQL being 1024 bytes. I used the following in my ...
1
vote
0answers
19 views

How to troubleshoot a MySQL / MariaDB error

I've imported two Wordpress databases to a system (CentOS7), and I did not have any problems. When I try to import an .sql file (obtained with mysqldump command) for a vBulleting forum (the newest ...
0
votes
0answers
5 views

mysql 5.5 controlled by corosync/pacemaker on Centos 5.11

As an intermediary step before upgrading to a newer OS (in a few months) I have to upgrade the MySQL version from 5.0 to 5.5 on a CentOS 5 system. The installation itself, and the upgrade via MySQL 5....
0
votes
0answers
2 views

Command wbcopytables --table-range not working [migrated]

I am migrating sql server tables in MySQL using wbcopytables command. I want to copy a specific range(id 1-10000) of data from MSSQL to MySQL, so I am using below syntax. wbcopytables --odbc-source="...
-1
votes
0answers
5 views

MySQL CPU overload and cant Use max Connection Mor Then 50

I have 8 Cores Server And 8 GB Ram And MySql 5.6 My.con File [mysqld] default-storage-engine=MyISAM interactive_timeout=300 key_cache_block_size=4096 max_heap_table_size=32M max_join_size=...
0
votes
0answers
5 views

MySQL slave becoming a replication master for additional slaves

I have MySQL servers A, B, C, and D. Server A is the MySQL master who receives the write traffic, and my applications look at B + C for reads (current slaves). I have replication forwarding ALL ...
0
votes
0answers
7 views

group_concat paragraphs from different records

I have a mysql table where paragraphs are splitted over various records. Paragraphs span randomly across records, something like this example: n | m | text --------------------------...
0
votes
0answers
13 views

Failed to allocate nodeid for API at <ip-address>. Returned error: 'No free node id found for mysqld(API)

i have configured mysql-cluster in centos 7 Management Node db1 = 192.168.5.130 Data Nodes db2 = 192.168.5.131 db3 = 192.168.5.132 SQL Nodes db4 = 192.168.5.133 db5 = 192.168.5.134 output ...
0
votes
0answers
19 views

freeradius+ external users database

I need authenticate users with freeradius, these users are located in an existing external database. I think that the rest_module can help me to do that, in that case, which values the rest api ...
0
votes
0answers
59 views

Out of memory: The process “mysqld” was terminated because the system is low on memory

I got this email alert today, with the following information: Process Name mysqld Event Time Tuesday, June 14, 2016 at 11:09:42 PM UTC PID 1820 Process UID 498 Process Username mysql ...
0
votes
1answer
61 views

Server crash (504 gateway timeout) with 100 concurrent users, using nginx and php5-fpm

We have a VPS server which is dedicated to a single website. Day to day it seems to work fine (say 20-50 concurrent users) but as soon as we get up to around 90+ concurrent users, the server starts to ...
0
votes
1answer
23 views

Upgradeing mysql on centos 7 with virtualmin

I have a running centos 7.2 with virtualmin, mysql 5.5.47 I would like to upgrade the database to a newer version. How should I do it without breaking anything ?
0
votes
1answer
56 views

Enabling SSL in MySQL when using Windows as a server and client

I wanted to enable SSL on the connections to my MySQL server that I installed in a Windows machine, so I googled "use ssl mysql windows". The first result is this simple and straightforward guide. ...
-1
votes
0answers
28 views

Replication of MYSQL to MongoDB

I have one doubt. Is it possible to suggest some steps? I have my database in MongoDB at digital ocean. Planning to incorporate Opencart solution. OpenCart solution doesn't support NOSQL. Option ...
0
votes
0answers
24 views

Chef and MySql: Error setting data_dir

I am trying to setup Mysql server 5.6 on Ubuntu 14.04 using Chef 12, testing using Vagrant It all goes fine till i try to set the data_dir to a custom value (It was working fine with the default ...
1
vote
1answer
59 views

Non-interactive (silent) install of MySQL 5.7 on Ubuntu 16.04 LTS

MySQL 5.7 (5.6+ actually) changed how mysql_secure_installation works. This made it hard to find a working, silent, scripted install for Ubuntu 16.04 LTS. How would you install MySQL securely in a ...
0
votes
0answers
5 views

Saving regular SQL result array as an entry in another table do reduce queries number, good idea or not? [migrated]

I had an idea and I wonder if its completely stupid or a good idea. I'm working on a web app which analyze GPX tracks and give stats. Actually I'm storing the coordinates of each points of each ...
0
votes
0answers
12 views

mariadb best performance [duplicate]

I have a web server running Centos with 126G RAM and 24 treads hosting only one website on joomla 3.5. The website because very slow after i reach 100 concurrent users. Result of htop: 1 [|||| ...
0
votes
2answers
49 views

Learning to deal with a large MySQL database

Total newb in terms of databases/server management but currently running a large database: LAMP Stack Ubuntu WordPress platform (can't change) Over 100,000 database entries Site adds new entries via ...
1
vote
1answer
32 views

Squid3 URLrewrite - Unable to configure

I have Squid3-3.4.8 on Debian Wheezy. It is performing caching duty. I just want to replace one jpg url to another URL in my local server or outside. I have tried solutions like Volta, squidred, ...
2
votes
1answer
61 views

MySQL performance problems after hardware upgrade and move to VM

Recently we've ran some (security) updates on our servers and rebooted the machines. Our development server did not came online anymore due to a problem with the GPU (integrated in CPU). We've ...
1
vote
2answers
112 views
+50

Postfix(admin), Dovecot, MySQL: Aliases not working

I'm able to send mail to the mailboxes i've setup with postfixadmin. This is working correctly and i can send and deliver mail on them. But now i'm in need of Aliases to work properly as well. I've ...
0
votes
1answer
16 views

cannot login to mysql root from vagrant, but can from sudo

I just reinstall mysql, which is now running 5.7.9. I'm using vagrant. I try to login to mysql with mysql -u root -proot and I get: ERROR 1698 (28000): Access denied for user 'root'@'localhost' I ...
0
votes
1answer
10 views

HY000 General Error on RDS

I have just set up my Laravel (PHP) project on Amazon with EC2 and RDS. Using MySQL 5.7. However, I've stumbled upon an error after I log in. I can register a user just fine, but when I log in, I get ...
2
votes
1answer
25 views

mdadm, raid1: write to multiple devs but read (mostly) from one?

Is it possible to prioritize which devices are for writes/reads in mdadm RAID1 setup? I'd like to write to both devices for fault tolerance (AWS EBS and local storage SSD), but read mostly from local ...
3
votes
2answers
68 views

How to avoid VMWare stunning a client during imaging with Veeam

Recently our MySQL server has been "going away" (ie. the client connection drops out). After weeks of trying different things (like adjusting packet size), we've discovered that it's our Veeam imaging ...
0
votes
1answer
9 views

Enabled / disabled repos in .repo file overwritten / superceded when new versions of software released?

I'm working on installing MySQL from the yum repositories: http://dev.mysql.com/downloads/repo/yum/ However our requirements are to run only MySQL 5.6, not the latest version 5.7. So we don't want a ...
0
votes
1answer
59 views

Can't start mysql service [closed]

I can't restart my mysql service from my ubuntu server. Here is the error : ● mysql.service - LSB: Start and stop the mysql database server daemon Loaded: loaded (/etc/init.d/mysql; bad; vendor ...
0
votes
0answers
50 views

MySQL has filled hard drive - can I get some back?

I have an ancient web application that a few people still rely on. A year or so ago I discovered that the database that backs it had filled almost all of the disk space available. I deleted a lot of ...
-1
votes
0answers
26 views

Site returning Database connection error after second visit - Must restart httpd

I am running CentOS release 6.6 and have been running a wordpress site for over 2 years. From 1 week ago my site displays the following message(bear in mind I didnt login or change anything for it to ...
0
votes
0answers
4 views

How to export views and import it in other DB? [migrated]

I am trying to export the database and everything is fine but I am not able to export the VIEWS. Is it possible to export the views from sql queries and import it?
2
votes
1answer
106 views

MySQL 5.7 bind-address doesn't work

I have always successfully set up a remote connection for mysql 5.5. Today I installed a new server with Ubuntu 16.04 and MySQL 5.7. But for some reasons, I can't make this mysql installation listen ...