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.

Filter by
Sorted by
Tagged with
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 ...
MCG's user avatar
  • 101
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 ...
user avatar
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,...
Daniel's user avatar
  • 51
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 ...
usr-local-ΕΨΗΕΛΩΝ's user avatar
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 ...
gonace's user avatar
  • 1
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 ...
Mahmoud.Eskandari's user avatar
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....
Jared Green's user avatar
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 ...
Kartik Goyal's user avatar
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 ...
Kirzilla's user avatar
  • 573
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 ...
Mehran's user avatar
  • 519
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 ...
alexus's user avatar
  • 13.4k
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 ...
Mandark's user avatar
  • 251
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 ...
Engineer's user avatar
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 ...
Sfisioza's user avatar
  • 592
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; +----------+-------------+-----------+--------...
Milos Cuculovic's user avatar
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. ...
Sonique's user avatar
  • 241
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 ...
ibedelovski's user avatar
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 ...
xref's user avatar
  • 273
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 ...
Jerry Skidmore's user avatar
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 ...
user12145's user avatar
  • 1,125
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 ...
Deniz Acay's user avatar
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 ...
Angelo's user avatar
  • 1
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-...
sbrattla's user avatar
  • 1,600
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 ...
Chris's user avatar
  • 104
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?
arvind babu's user avatar
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 ...
Nate's user avatar
  • 229
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 ...
Dr. Gianluigi Zane Zanettini's user avatar
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 ...
jpaugh's user avatar
  • 231
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) ...
CaptSaltyJack's user avatar
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 ...
jjwdesign's user avatar
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. ...
Philip G's user avatar
  • 111
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 ...
Barthel Zieba's user avatar
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-...
Ivan Milosavljevic's user avatar
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 ...
Joe's user avatar
  • 121
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 ...
AJ Naidas's user avatar
  • 199
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 ...
split_account's user avatar
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 ...
Matthias Kleine's user avatar
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 ...
ptrh's user avatar
  • 389
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 ...
user218668's user avatar
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-...
Greendrake's user avatar
  • 1,421
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: [...
gremo's user avatar
  • 349
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 ...
Abhishek Kandoi's user avatar
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 ...
David Eisen's user avatar
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 ...
amani's user avatar
  • 9
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 ...
user16948's user avatar
  • 101
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 ...
gregtzar's user avatar
  • 903
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....
Greg Pagendam-Turner's user avatar
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 ...
Ratzor's user avatar
  • 103
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 ...
Halfgaar's user avatar
  • 8,194
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 ...
James Heald's user avatar

1
119 120
121
122 123
175