MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
117 views

mysql my.cnf is empty with webmin [closed]

mysqltune said that I need to make some changes in the my.cnf file Variables to adjust: query_cache_size (>= 8M) tmp_table_size (> 16M) max_heap_table_size (> 16M) thread_cache_size (start ...
0
votes
0answers
76 views

Can't connect to MySQL server on '127.0.0.1' (110)

I'm randomly getting a 110 error when connecting to a local mysql instance ( -h 127.0.0.1 ). Checking perror I see that it's a timeout: # perror 110 OS error code 110: Connection timed out The ...
1
vote
1answer
51 views

Any way to import MySQL tables with indexes intact?

Currently our live database server does daily downloads of large data dumps (on the order of 10GB), imports them into MySQL, normalizes the data, and builds a number of indexes (full-text indexes ...
0
votes
0answers
61 views

PHP & MySQL config for IIS server under heavy load

I am running a PHP/MYSQL website on Windows Server 2012 using IIS 8. I had performance issues on my old server with the CPU spiking above 100% during peak times. So I've just upgraded my server to a ...
1
vote
1answer
83 views

Identifying MySQL injection exploit [closed]

I know someone whose server with cPanel/WHM and phpBB 3.0.x was victimized by a MySQL injection attack against phpBB (or a plugin thereof). Certain information was leaked, but we do not know the ...
2
votes
1answer
55 views

Galera: Run slow ALTER without locking entire server

I have a 3-node galera cluster with a few hundred databases servicing various clients. I'm only using galera as an easy way to handle replication and fallover. I'm not actually using multiple masters ...
0
votes
0answers
91 views

Gitlab update from 7.2.0 centos(mysql) to 7.7.2 ubuntu(postgres), can't create ssh key, or new project

I had a CentOS server running gitlab 7.2.0, which uses mysql server. I updated to the omnibus version of 7.7.2 successfully porting the database from mysql to postgres using instructions found here ...
-2
votes
1answer
29 views

Set rules on exchange and save it to database [closed]

I wanna set exchange rules for my incomming backup mails. After receiving one message with "Backup Exec Alert: Job Success (Server: "SERVERNAME") (Job: "JOBNAME") " in the subject a script should be ...
0
votes
0answers
42 views

Application logs an INSERT into database but data is not there. Where to look for debug info?

I have a PHP shell application which essentially moves data from a MySQL table to a REMOTE MS SQL Server (2008 R2) server based on a number of business rules. This routine has been working flawlessly ...
1
vote
0answers
135 views

200 OK blank page setting up Wordpress on restore test VM

I'm testing a partial backup of a frankly rather outdated (legacy, what can you do?) CentOS/Apache/MySQL/PHP/Wordpress server by restoring to a VM with a fresh copy of the relevant packages. After ...
-3
votes
1answer
76 views

bash script mysql reset pass

It seems that this code is not working I tried using it on my debian 7 machine and the password it gives me is wrong. # Please confirm that you want to reset the MySQL passwords CONFIRM="n" echo -n ...
0
votes
0answers
51 views

CentOS MySQL Problems

Im having trouble with MySQL on my centos5 server. When I try to connect to the server I receive the following message ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
0answers
124 views

MySQL suddenly 'crashed' but not stopped, mysqld_safe 100% cpu on CentOS 6

Suddenly, today i see the website down. Checking the cpu with "top" in command, i found the mysqld_Safe at the top using all of the cpu. After some google i found some different solutions, i made a ...
0
votes
1answer
96 views

Can't connect to local MySQL via TCP (Error 1045)

root@127.0.0.1 exists, but still can't connect to local MySQL. It looks like MySQL verifies hostname instead of lo ip(127.0.0.1). root@castle /v/l/mysql# mysql -u root Welcome to the MySQL monitor. ...
1
vote
1answer
180 views

Low load average, but high %user and %system cpu usage

Summed up question: Why do we see one set of servers perform significantly worse with the same database and workload as others? Symptoms other than longer execution time is low (near zero) load ...
0
votes
0answers
188 views

How to reduce Tomcat response time (OR increase throughput)?

I have Tomcat 8 and MySQL 5.6 running in 2 Azure virtual machines (8 cores and 28 GB RAM). My web application provides a REST API to insert several data fields into DB. The application uses a common ...
0
votes
0answers
82 views

Install latest mysql 5.6 update (update 19 to update 22) on Ubuntu 14.04

A while ago I installed Mysql 5.6.19 via "apt-get install mysql-server-5.6" on a Ubuntu 14.04 amd64 server, now I want to upgrade this Mysql 5.6.19 to the latest stable update (5.6.22). I can't do it ...
1
vote
0answers
23 views

Performance: Generating up to 2000 rows and email deliveries [closed]

I guess this belongs here better than in StackOverflow. I have the following scenario: Small database with users ( around 2000 only ) information, they participated in an event last year. This year ...
0
votes
1answer
24 views

'> instead of -> in mysql command line client?

Im using mac os terminal to insert data into the table of mysql database. I accidentally pressed something and instead of -> now i see '>. I have no idea what it means, what is it and how can i get ...
0
votes
1answer
153 views

MySQL replication or MySQL cluster?

Currently i'm running Rails 3 web application with MySQL on one first server and Rails API application on second server that connects to the MySQL database from first server. I'm not happy that API ...
0
votes
1answer
41 views

How to overwrite the database name set in the .sql file when importing

Well I have .sql files which create their own new database when importing because they CREATE DATABASE /*!32312 IF NOT EXISTS*/ `something` /*!40100 DEFAULT CHARACTER SET$ USE `something`; i'm ...
0
votes
2answers
1k views

Yum: No package mysql-server available in Cent OS 7

I just installed Apache on my new Digital Ocean Cent OS 7 x64 server. When following Digital Ocean's tutorial, yum cannot install mysql-server. # yum install mysql mysql-server mysql-libs ...
2
votes
1answer
30 views

Splitting MySQL General Query Log by Clients

I would like to know a solution to splitting very large MySQL general query logs by specific clients that have accessed the server. Ideally a separate log will be created for each client. Thanks
0
votes
0answers
46 views

Can I get a running list of executed queries from mysql to trace problems?

This question was formerly: "Mysql replication logs are filling disk and halting server". However, I'm asking the community if there is a command line trace or live log that I could tail -f and see ...
1
vote
2answers
94 views

Getting no query results in email

This is the powershell script below. I am trying to export the query's results into email body. However, the email contains nothing except the table headers. Could anyone help out what could be wrong ...
0
votes
1answer
64 views

CRUD with MySQL Master-Slave Architecture

I have setup mysql master-slave replication with 1 master and 3 slaves. Now that I have finished setting up the architecture I am curious as to the best way to make my reads. I realize all writes, ...
1
vote
1answer
21 views

Size of MYI index smaller on slave server

I've recently altered a huge MyISAM table (80 million entries) by adding a new value in an enum field. After I did this I've checked the health of the table on 2 slave servers which are used to ...
0
votes
1answer
168 views

What is safe way to stop mysql docker container?

I run mysql container using Docker. I start it with like sudo docker -d --name mysql -p 3306:3306 -v /var/lib/mysql:/var/lib/mysql mysql_image I suspect that stopping mysql by stopping docker is ...
-1
votes
2answers
159 views

Data lost in MySQL DB when roll back happened after system restart [closed]

Few days back due to electricity outage, client's system got restarted, resulted in DB rollback. But due to this roll back, we lost around 2k existing records from various tables.( which were already ...
-1
votes
1answer
361 views

mysqltuner: Thread cache is disabled

Mysqltuner says " Thread cache is disabled" but according to my.cnf, it is not. Why is that? Here is the my.cnf content. [mysqld] log=/var/log/mysql.log datadir=/var/lib/mysql ...
1
vote
2answers
116 views

MySQL with bind-address - possible to create an ip exception?

If you set the bind-address to 127.0.0.1 in my.cnf is there any way to manually allow connections from a specific ip address? Mostly my database is accessed by the server it is hosted on, but I also ...
0
votes
0answers
45 views

Linked Server Mysql to SQL Server 2008 32-Bit

I have an SQL Server 2008 64 Bit and a Mysql-Server, and would like to use a Linked Server. However I need the 32-BIT Mysql ODBC Connector for an extern Application. When I would like to connect to ...
1
vote
0answers
138 views

Apache 2.4 prefork, MySQL 5.6 and 2GB RAM

I think I'm having problem setting up Apache24 correctly. Apache seems to taking up to much RAM, and I'm not sure how to configure it. The FreeBSD server is using 50% of it's swap space. We are ...
1
vote
0answers
82 views

MariaDB 5.5 on Slackware 14 need to change to new password format

Strangely, this worked fine for a while, but my computer rebooted recently and now my php apps won't work: mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an ...
0
votes
0answers
191 views

Google Cloud SQL - Lost connection and Timeout errors

I keep getting the following errors when attempting a simple connection to a Google Cloud SQL database instance from a PHP script. Lost connection to MySQL server at 'reading initial communication ...
1
vote
1answer
137 views

why is my mysql-proxy always doing selects on master?

My selects are always going to master and if i stop master I got some 'Cannot connect, all backends are down.' [read_query] 89.216.31.228:64166 current backend = 0 client default db = nivo client ...
3
votes
1answer
116 views

Is it possible to install MySQL extensions on Amazon RDS?

We are about to migrate our existing system from local MySQL instances on the same EC2 to a proper remote Amazon-RDS. Unfortunately there is a functionality called Median that MySQL is missing. Our ...
0
votes
1answer
33 views

How do I find out when a MySQL root password was last changed?

I have looked for solutions to this. I am able to change it, but I need to find out when it was last done and preferably also seeing who was logged in when it was done. Need proof for a security ...
0
votes
0answers
26 views

Why has MariaDB created database directories with @ in?

A backup script on a Debian server looked at /var/lib/mysql/*/ to find local database names. Having recently installed Seafile, this no longer works because although the databases are called normal ...
1
vote
1answer
149 views

How to remove MySQL from Ubuntu 14.04?

I tried to move my datadir on a working MySql install, which apparently I messed up. I have tried to uninstall / reinstall numerous times, only to get the same errors on reinstall. The ...
0
votes
1answer
105 views

ISPconfig / Dovecot - Mysql went down = Mails gone? [closed]

So im running ISPconfig with Dovecot as mail-server (storing mails via mysql). Yesterday i made some changes to the mysql-config. I wanted the server to answer also External Requests. The Problem ...
1
vote
0answers
68 views

Destination Host Unreachable and Communications link failure when I connect to MySQL database using D2RQ library

I have a question: I have a web service which runs on a virtual machine located on a remote server with Ubuntu 12.04 operating system. Now, I want to test this Web Service and I'm using this code ...
0
votes
0answers
37 views

Local MySQL connection using eth0 rather than lo loopback

We've installed MySQL 5.6.22 on RHEL6.6 and noticed terrible performance compared to a previous install on RHEL6.5 and MySQL 5.6.20 The main thing that we've noticed is that all the traffic appears ...
-2
votes
2answers
163 views

How to start mysql automatically if that stop for any reason? [closed]

I have a digitalocean ubuntu vps for development use only, But sometimes the mysql server stop working. As per my investigation I don't have enough memory to handle few laravel installation. As I use ...
0
votes
1answer
172 views

how to permanently increase innodb_buffer_pool_size on ubuntu

I have read lot of posts & manuals to try to find out how to increase memory in mysql 5.6 on Ubuntu, which say there are 3 methods: by editing innodb_buffer_pool_size in the my.cnf by command ...
0
votes
1answer
76 views

Two browser windows hitting same MySQL app, both can't run at the same time

I have a LAMP web application that has some pages that do quite a bit of processing and take a while to complete. Sometimes as the developer I like to do two things at once as I'm working on a ...
5
votes
1answer
919 views

Can I copy the entire /var/lib/mysql folder to a different server? (mysql vs mariadb, different versions)

I used to have a Linux system (LMDE) with MySQL. The system used innodb_file_per_table for most of the databases. (not sure about the version, whatever is the "latest" in LMDE) I am now on a new ...
-1
votes
2answers
190 views

Configure MySQL so it doesn't automatically change values in NOT NULL columns

Surprisingly (at least to me), the following queries will insert records. CREATE TABLE null_1 ( id INT NOT NULL, text1 VARCHAR(32) NOT NULL, text2 VARCHAR(32) NOT NULL DEFAULT 'foo' ); INSERT ...
0
votes
0answers
46 views

Database Organizational Structure, DB Groups

I'm setting up a web server where users can create their own databases. In order to prevent name clashing, I've typically seen hosting companies handle this by prefixing any DB name the user creates ...
3
votes
2answers
95 views

How can I drop a MySQL user whose username contains unprintable characters?

I have a user in MySQL 5.6 that was somehow created with a non-printable character in the username. How can I drop this user? mysql> select user,host from mysql.user where user like 'wiki%'; ...