Questions tagged [mysql]
MySQL is an open-source database owned by Oracle. ServerFault topics include how to run the server. For more MySQL specific questions like backup/restore/recovery/configuration, dba.stackexchange.com is probably a better home.
8,731
questions
0
votes
1
answer
489
views
Apache2 Serverload / CPU increase from 1% up to 90% - How to debug?
I´m using:
Google Cloud Compute Engine
Linux Debian + Apache2
Google Cloud SQL
Wordpress
Yesterday my CPU started increasing from 1-5% to 80-90%.
I was developing on a wordpress site as it ...
0
votes
1
answer
40
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
1
answer
681
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 is,...
0
votes
1
answer
389
views
Salvaging inaccessible MySQL db without InnoDB log files
In the past few weeks, I have been playing with the configuration of our test MySQL server, without first making a mysqldump of applications running on it. Aim was to increase performance and enable ...
0
votes
2
answers
12k
views
ERROR 1130 (HY000): Host 'host' is not allowed to connect to this MySQL server, only on slave
So I have a master and a slave in a mysql cluster, the syntonization works as it should however I am not able to connect to the slave from any host except from the server it self.
I have no problems ...
0
votes
1
answer
3k
views
install mysql 5.6 on centos6.4 conflicts error
When i try to install mysql 5.6 and i remove mysql 5.1 from centos
now not installing any mysql in my VPS.
yum install mysql-server
Loaded plugins: fastestmirror, refresh-packagekit
Setting up ...
0
votes
1
answer
2k
views
mysql grant select to ONE table on ALL database
I have many tables with the same table structure. I want to create a user which can access one table in all of those databases. We are adding new databases frequently, so a wildcard would be preferred....
0
votes
1
answer
606
views
Set MySQL innodb buffer pool size on IIS7
I am using VPS, Windows 2008 r2, IIS7, MYSQL 5.1.73,
Hardward Config: Ram 2GB , Hardisk 40GB
On this VPS only 1 .NET application is running. Application is currently using by only 5 users.
I found ...
0
votes
1
answer
979
views
Percona Server & MySQL server on the same server on different ports
I have MySQL installed from ports, running and listening on port 3306.
On the same server I have Percona Server compiled from sources, running and listening on port 3307.
Here are the process list ...
0
votes
1
answer
179
views
Courier can not access mysql server while mysql-client can
I've setup a mail server on an Ubuntu 14.04 server. I've installed Courier as the IMAP server and I've configured it so it can connect to MySQL and use its data as the user list and stuff.
I've ...
0
votes
1
answer
492
views
FreeBSD: mariadb55 conflicts mysql55
I'm trying to install percona-toolkit as package/port on my system:
[root@alexus ~]# uname -a
FreeBSD alexus.org 9.2-RELEASE-p5 FreeBSD 9.2-RELEASE-p5 #0 r265974: Wed May 14 07:57:04 PDT 2014 ...
0
votes
1
answer
971
views
Elasticsearch River JDBC - Avoiding 'SELECT *'
I'd like to syncronize some MySQL tables to an ElasticSearch index, you know, for search.
But almost every examples I can find show a big bad fat "SELECT * FROM", it's OK for an example, but I'm in ...
0
votes
1
answer
2k
views
Website slowing down when many users access simultaneously [closed]
I'm new to web development. I have hosted my website through a free web hosting service providing free subdomain. The free hosting service says that they provide 100 GB bandwidth. I just upload files ...
0
votes
2
answers
72
views
Allow mysql user to be used just by specified user
Currently any system user can run:
systemuser$ mysql -u mysqluser -p
(assuming he knows the password).
Is there a way to deny mysql (cli) to use particular mysql user?
eg.
systemuser$ mysql -u ...
0
votes
2
answers
113
views
MySQLD is using 175% of the cpu
On one of the servers, I have mysqld running as slave DB.
The CPU usage is 175% at the moment used by mysqld.
Here are the results of SHOW PROCESSLIST;
+----------+-------------+-----------+--------...
0
votes
1
answer
2k
views
Wordpress and Apache crashing MySql (CLOSE_WAIT)
Last days mysql server on my vps start crashing, sometimes right after restart.
I found that problem in wordpress website. After service mysql start many apache2 processes overload memory and cpu. ...
0
votes
1
answer
218
views
My local MySQL server was temporary down for unknown reasons
My local MySQL server 5.5.38 (on CentOS 6.5) has been temporary down and the mysql log file was filled with this kind of details:
This could be because you hit a bug. It is also possible that this ...
0
votes
1
answer
227
views
New nagios/cacti monitoring setup, should I use a dedicated VM?
Currently we have 4 bare metal servers and one small VM server (all running centos6) and I'm looking at setting up monitoring for the Percona MySQL db server and replication slave (bare metal), as ...
0
votes
2
answers
616
views
Centos 6.5 DB MySQL server, default install, resize or move DB location - disk-usage issue
I did a standard install of Centos 6.5 in a 1TB SSD (MLC) not realizing that only 50G is allocated to / and approximately 816G to /home:
[gskidmor@mrserver ~]$ df -h
Filesystem ...
0
votes
1
answer
152
views
how to use mysql database replication to backup a single database
Suppose I want to replicate a single database in mysql on my slave, the master might be creating and writing to multiple databases. is this possoible?
or does the replication slave have to replicate ...
0
votes
1
answer
941
views
MySQL installation with Ansible on Debian Wheezy
As the title suggests, I am trying to install MySQL Server 5.5 on Debian with Ansible.
Since this needs to be a silent installation, I provide the root password before the installation with debconf ...
0
votes
2
answers
3k
views
PHP stopped working after upgrading from 5.3 to 5.5 using PPA
I had PHP 5.3 working on an old server that my company uses. I have PHP 5.5 working on my AWS server. Both of the servers are Ubuntu. My application is working fine on my AWS server. But when I ...
0
votes
1
answer
97
views
What are good systems for managing Drupal infrastructure? [closed]
I work in a company which is about to migrate most applications from in-house custom built Java/Tomcat applications to Drupal. Due to company policies, applications and websites need to run on in-...
0
votes
1
answer
254
views
"Can't create table" when having to many partitions
I am currently having a problem I dont understand. Wherever I look it says mySQL (5.5) / InnoDB doesnt have a table limit.
I wanted to test the InnoDB compression and was about to create an empty ...
0
votes
1
answer
5k
views
update time and create time of tables is showing null in mysql
The columns update_time and create_time is having the value NULL in the information_schema Tables of MYSQL. How can the value be NULL?. Can anyone please explain?
0
votes
1
answer
704
views
How many incremental backups to keep with Percona xtrabackup?
I'm looking to replace an aging and decidedly suboptimal mysqldump-based database backup strategy with Percona's Xtrabackup. This all looks pretty straightforward, except that I'm wondering: how many ...
0
votes
1
answer
99
views
New MySQL 5.7 installation: Account "Any@%" with USAGE-only, no-GRANT? [duplicate]
I've a MySQL 5.7 brand-new installation (via Oracle official RPM) on CentOS 6.5.
Via phpmyadmin, I see this strange "Any@%" account I didn't create, with only USAGE as GLOBAL PRIVILEGES and Grant: No
...
0
votes
1
answer
1k
views
mysql dump file corrupted
I've been using the following command to dump my databases:
$ mysqldump -uuser -ppass --all-databases | gzip > all-db.sql.gz
A full dump of the database is around 130 Gb, and takes about 10 hours ...
0
votes
1
answer
1k
views
mysql crash on 512MB Debian server (memory problems?) How to fix?
I'm on a 512MB Debian 7.5 server. I woke up to find mysqld not running, and the syslog reveals lines like:
Aug 9 09:00:58 web kernel: [1086155.903755] Out of memory: Kill process 2669 (m
ysqld) ...
0
votes
1
answer
568
views
MySQL: Error establishing a database connection
I'm running a DigitalOcean.com Virtual Server with the typical Ubuntu LAMP Stack for a few WordPress sites. Of course, every week or two the MySQL service seems to crash. If I restart MySQL or the ...
0
votes
2
answers
273
views
Mysql/Apache stops working once in a while
My problem: My webserver stops working once in a while. Apache still responds to requests, but it can't connect to mysql server. According to how I read the syslog it's because of insufficient RAM. ...
0
votes
1
answer
2k
views
Ubuntu 12.04 LTS: Changing Mysql root Password [duplicate]
I did an upgrade from 10.04 to 12.04 today. I wanted to access MySQL afterwards, but I've forgot the root password... So I tried some guides from the net but none is working for me. Im not even sure ...
0
votes
2
answers
1k
views
Postfix and MySQL configuration
I have the problem with configuration of Postfix on my server. I have been used this link like tutorial for creating and configuration Postfix.
https://www.digitalocean.com/community/tutorials/how-...
0
votes
1
answer
2k
views
Error changing mysql 5.6 default port
I've changed my.ini with port=3308 but after restart the service mysql 5.6 is working in the same default port 3306.
I've tried in mysql 5.5 and it worked fine.
C:\Archivos de programa\MySQL\MySQL ...
0
votes
1
answer
1k
views
Mysqld shutting down by itself
I'm running a Wordpress Blog that gets medium-high traffic. It is hosted in an
Ubuntu Server 2GB Memory 2 Core Processor 40GB SSD Disk, 3TB Transfer.
The problem is that MySQL shuts down by itself ...
0
votes
1
answer
100
views
Taking database from possibly cracked server
I have a server which is behaving erratically. While I investigate if it's been hacked, I'm also thinking about my backup options:
As many posts have said the only way to truly know you're clean is ...
0
votes
1
answer
3k
views
How can i use my local mysqldump through ssh tunnel
I would like to dump a mysql-database with mysqldump. But: This command isn't installed on the remote server.
It is possible to use my local mysqldump command, to connect via an ssh tunnel to achieve ...
0
votes
1
answer
1k
views
MySQL won't start after reboot. Exiting with signal 11
last night I was doing a server maintenance that required DB reboot.
No changes in a config were made.
Current setup is as follows:
master (server1) - master (server2) and slave (server0)
MySQL ...
0
votes
1
answer
597
views
RHEL 6.5 / Updating MySQL [closed]
Currently running RHEL 6.5 and need to update to MySQL 5.5.36. Currently it has MySQL 5.1.73 installed. The Software Collections repo has been added. I performed a yum update and it does not show me ...
0
votes
1
answer
340
views
yum update MemoryError 1G memory free
I am trying to do yum update and getting "MemoryError". The server (OpenVZ box) has 2G RAM and Percona MySQL server running with 1G InnoDB buffer configured. The OS is CentOS 6.5, kernel 2.6.32-openvz-...
0
votes
1
answer
2k
views
Plesk error when adding a subscription: ODBC error #08S01 can't connect to local MySQL [closed]
I'm getting this error after updating MySQL to 5.6 (Plesk 11.5, fresh installation) using the official MySQL repository right after adding a new subscription.
Internal error: ODBC error #08S01: [...
0
votes
1
answer
170
views
How does creating multiple virtual machines affect performance of a Dell Server? [closed]
Say, a dozen applications have to hosted on a single Dell Server using open source technologies like XenServer. Some of the applications are resource intensive while others are not.
What should be ...
0
votes
1
answer
80
views
MySQL Replication across two mounts on AWS Amazon Linux
Recently we took advantage of the SSD instance stores available on AWS. While these are great, they obviously get deleted when the instance dies. Obviously the performance of non Provision IOPS is ...
0
votes
1
answer
216
views
Mysql service refuse to be started
Mysql service just stop working. once I typed: service mysql startThe linux system displayed the following:
tail: invalid option -- n
Try `tail --help' for more information.
tail: invalid option -- n
...
0
votes
2
answers
189
views
How do I prevent a website on my server causing the whole server to crash [closed]
I have a server with 6GB of RAM and a 6-Core CPU. Number of websites hosted by the server is about 10, but sometimes 2 of them take 100% CPU and almost entire RAM which cause the whole server to crash ...
0
votes
1
answer
530
views
Single ec2 instance with multiple mySQL databases on separate EBS volumes
I have a single ec2 instance on which I am running multiple separate wordpress sites. I want to store the database for each separate site on it's own mounted ebs volume, so that I can handle the db ...
0
votes
2
answers
14k
views
Zabbix not connecting to MySql database
I'm trying to get Zabbix running under Amazon Linux
I've installed the following packages:
zabbix20-server-2.0.11-1.el6.x86_64
zabbix20-server-pgsql-2.0.11-1.el6.x86_64
zabbix20-web-mysql-2.0.11-1....
0
votes
1
answer
6k
views
Postfix mysql Temporary lookup failure
I'm trying to configure a postfix/courier/mysql/SquirrelMail setup, using this guide, but i get the following error when trying to send an email:
451 4.3.0 <[email protected]>: Temporary lookup ...
0
votes
1
answer
54
views
Ubuntu upgrade 11.10 to 12.04 - MySQL migration
Some time ago, I tried upgrading my Ubuntu 11.10 to 12.04, but it failed on several points, so I rolled back the LVM snapshot.
One of the problems was MySQL. During the upgrade process, it started ...
0
votes
1
answer
228
views
Finding out when an MySQL user was added?
I was just looking through my MySQL user databases (for all the MySQL users in PhpMyadmin) and noticed something exceedingly alarming, a user named darkangel with all permissions. I havent looked in a ...