Tagged Questions

MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

-1
votes
0answers
20 views

Connection failed to MySQL server?

My website runs on a cPanel server that I have root access to. About once every 2-3 hours I get an error message saying that the website can't connect to my MySQL database. The website and database ...
0
votes
1answer
15 views

WebServer - moving MySQL to another server on LAN for gaining more processing power?

I have website with high traffic hosted on dedicated machine. This machine running out of resources. Will moving MySQL database to another dedicated machine on LAN give more resources to website ...
-1
votes
1answer
15 views

Frontend executing PHP page stopes other PHP pages from working? [on hold]

I have VMware workstation with Turnkey Linux LAMP, but i had this problem in the past many times so don't think its related to server architecture. I have site setup example1.com where i have 2 PHP ...
-1
votes
1answer
16 views

Correct packages to install LAMP on ubuntu

I have read some tutorials about install LAMP and I have seen that they install differents packages for MySQL and PHP. For example to install MySQL: 1. mysql-server 2. mysql-server ...
0
votes
1answer
33 views

mySQL issue at installation

I have great trouble with mySQL installation. The error message in log (/var/log/debug) is: Nov 20 11:17:41 gotfarm1 /etc/init.d/mysql[11880]: 0 processes alive and '/usr/bin/mysqladmin ...
-1
votes
0answers
13 views

unzip file and import it on the same line [duplicate]

I upload a gzziped file that contains an sql file, I would like to extract it and use it in the same line so I don't need to delete it later. steps: - I upload a file the web interface - in my code I ...
-4
votes
1answer
13 views

Guidance for mysql 5.6 install on Ubuntu 14.04 [on hold]

I have followed the instructions at http://dev.mysql.com/doc/refman/5.6/en/linux-installation-debian.html to a T twice now and twice it appears it hasn't worked. There is no my.cnf under /etc, there ...
-2
votes
0answers
62 views

MySQL any way to import a huge (32 GB) sql dump faster? [migrated]

I have this huge 32 GB sql dump that I need to import into MySQL. I haven't had to import such a huge sql dump before. I did the usual: mysql -uroot dbname < dbname.sql It is taking too long. ...
0
votes
1answer
6 views

Minimizing Downtime With Upgrades For 3rd Party Products

I am currently maintaining a Review Board server (https://www.reviewboard.org/) and one of the big pain points is scheduling upgrades. Currently the process is: Take the server down and send all ...
0
votes
1answer
30 views

MySQL - Why are there three root users with different hosts? [duplicate]

I'd love to know why when you first install MySQL on a server there are three root users entered into the users table each with different host addresses. One with localhost one with 127.0.0.1 and one ...
-1
votes
1answer
31 views

access MySQL connection from outside LAN [on hold]

Currently I have a scenario like this: I develop desktop application that connect to mysql using public IP. There are 2 servers, Mysql DB server with only LAN IP (ex: 192.168.0.3) and Application ...
1
vote
0answers
18 views

Error missing systemd on AWS server

I cant seem to figure out how to install systemd. I am attempting to upgrade mysql server on AWS from 5.5 to 5.6. I am getting the following error when trying to install- "Requires: systemd" Any ...
-7
votes
0answers
31 views

Synchronisation between AD & MySQL server [duplicate]

I would like to know if there is a way to synchronise a MySQL's database to a AD. By exemple the user created in MySQL's database is sychronized to the active directory and vice versa. And if it's ...
0
votes
1answer
58 views

Centos/directadmin Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Error connecting to MySQL: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I get the following error on my CentOS VM with DirectAdmin. What I already tried: ...
-2
votes
0answers
33 views

MySQL tuning for dummies [closed]

my.cnf needs to tune. Server RAM 64G. Below is the mysqltuner output. Please help me on this regard -------- Performance Metrics ------------------------------------------------- [--] Up for: 34s (2K ...
-1
votes
0answers
7 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
0answers
12 views

Installing mysqludf library on CentOS x64

I've been googling a lot about the problem that I have trying to install MySQL library. I've downloaded library files from https://github.com/mysqludf/lib_mysqludf_sys and placed it on digitalocean ...
0
votes
1answer
20 views

Lost connection to MySQL during backup [closed]

When I mysqldump a table I am receiving mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `activities` at row: 124546 Portions of the table is not in RAM, which ...
-1
votes
0answers
12 views

Table not converted in Owncloud migrating from SQLite to MySQL/MariaDB

In Owncloud database migratiion from SQLite to MySQL/MariaDB I have been prompted for the following question... # php occ db:convert-type --all-apps mysql owncloud_user 127.0.0.1 owncloud Creating ...
-2
votes
2answers
18 views

How to work on 2 MySQL databases at the same time using PHPMyAdmin through Plesk?

I am trying to open 2 instances of PHPMyAdmin by clicking on the "manage database" link in Plesk. But the challenge is I seem to be only allowed to work on 1 database at a time as when I try and open ...
0
votes
1answer
18 views

Connecting to mysql with SUPER user when reached Too many connections

The documentation says that: mysqld actually permits max_connections+1 clients to connect. The extra connection is reserved for use by accounts that have the SUPER privilege ...
0
votes
0answers
42 views

Bottle neck of nginx?

I'm using nginx as a load balancer on amazon ec2 m3.large instance. This load balancer will receive loads from a load generator and distributed them to the 3 instance with mysql database serves as ...
0
votes
0answers
19 views

auto-provisioning mySQL via WHMCS

I'm trying to use the WHMCS API / provisioning module to auto-create a mysql database for a new WHM / cPanel client after their order for hosting goes through. It seems like it should be simple ...
-1
votes
0answers
20 views

mySql backup/restore via a cpanel alternative in ubuntu [closed]

Ubuntu 12.04 x86_64. As I found CPanel cannot be installed. I found an alternative Ajenti but I can't find functionality I need: 1. backup/restore of selected mySQL DB. 2. Backup/restore of a vhost ...
3
votes
3answers
135 views

server's memory taken up almost to 8GB

Lately, our server face problem with the memory. Started from few weeks ago, our server was loading very slow. Accessing emails and websites were really take too long. Then we asked the server ...
0
votes
1answer
22 views

Remote Connections Mysql Ubuntu - bind address failed

I am trying to configure my server to allow remote connections. From what I understand I need to uncomment bind-address 127.0.0.1 in the my.cnf file, then restart mysql. That hasn't worked. I have ...
3
votes
1answer
50 views

High CPU on MySql Fusion-io server

I've just finished reading this old Q&A which had some really good detailed information on a similar setup to ours, though unfortunately our problem (now) is not with replication. MySQL ...
1
vote
0answers
40 views

mysqld shuts down every 10 minutes

I have a very odd problem: mysqld shuts down every 10 minutes, without any errors, just like some process actually calls "shutdown" on it. I already checked cron, but couldn't find anything there. ...
0
votes
0answers
4 views

Does the order of a mysql multi-column MySQL index matter - if you're always using all columns in the query? [migrated]

I'm aware that when you define a MySQL index that the order of the fields matters if the query is only using part of the index, as described here. But if your query is always going to use all columns ...
0
votes
1answer
21 views

How can I log information specific to the “Too many connections error” in mysql

When the Too many connections error is thrown does mysql log that somewhere so later I can see what caused the error? I know I can use commands like "SHOW ENGINE INNODB STATUS" and "SHOW PROCESSLIST" ...
0
votes
1answer
41 views

High Load Website. how to load balancing? [closed]

i have the following problem: i have two servers (intel xeon 3,4 GHZ with 32GB RAM and RAID 10 (4x1TB Enterprise Harddiscs). all servers are installed with vmware esxi 5.5 (free). webserver, ...
0
votes
2answers
108 views

Database password error in Owncloud migrating from SQLite to MySQL/MariaDB

In a Fedora system, I need to convert the Owncloud's SQLite database into a MySQL/MariaDB database I started installing MySQL: # systemctl enable mysqld # systemctl start mysqld $ ...
-1
votes
0answers
24 views

Do i need reindex mysql table after bulk delete? [migrated]

I have a table in mysql with a lot of INSERT and SELECT at every second. And there is a bulk delete of some older data once in a day. Do I need to reindex the table after delete? I want to increase ...
0
votes
0answers
15 views

MariaDB, ARIA, “File size bigger than expected”

On (only) my production server, whenever I wait a while and restart MariaDB, it completely crashes and burns, e.g.: 141110 16:18:26 [Note] /usr/sbin/mysqld: Shutdown complete 141110 16:18:26 [ERROR] ...
0
votes
1answer
35 views

Nginx Load Balancer Optimum Specs

I have 3 Nginx servers and each of them should handle about 2k users (concurrent connections). In front of them I have Nginx load balancer. That's 4 Virtual machines, sharing same subnet and same ...
-1
votes
0answers
36 views

Mediawiki database recovery

I had a small wiki I was hosting for free, but it seems it got spammed and the host took it down. They passed me a .sql file which was 2Gb large. I am looking to set up another wiki, load the .sql ...
1
vote
1answer
32 views

Mysql optimize one table in all databases

I see in the mysqlcheck manual that there's an option for --tables that overrides that databases option, but it isn't well explained. I'm trying to run mysqlcheck -o and I want it to optimize a ...
0
votes
1answer
28 views

Diagnosing where all the queries are coming from

We have an issue where a site on a shared hosting account is going over the allowed query limit per user; that is set at 100k queries/hr. The site shouldn't be generating that amount of queries TBH ...
1
vote
1answer
59 views

MySQL and SSL with -sha256

I'm trying to create some certificate to use with MySQL and everything works fine if I use the sha1 algorithm. If I add the -sha256 switch or -sha384 I can NOT connect to MySQL!. I get this error: ...
-1
votes
2answers
28 views

How to allow all clients access to remote MySQL server? [closed]

So I followed this guide to gain remote access to a MySQL server for my laptop. However, my IP changes and I want to be able to access the server outside my network. How can I allow any client IP ...
0
votes
0answers
22 views

AWS: RDS instance(s) and connecting from remote machine

I'm moving a site over to AWS. It's on the Amazon-flavored Linux distro, using MySQL. I vaguely remember setting it up a couple of months ago (been busy), and allowed access from my elastic IP. I ...
0
votes
1answer
14 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 ...
-1
votes
0answers
25 views

MySQL 5.6: creating users kills mysql, and mysql_upgrade fails [migrated]

I have a fresh (not upgrade) installation of mysql 5.6.19 community edition win64 running on windows 8. I have had no problems with it until today I tried to create a new user. When I do this, mysql ...
0
votes
0answers
18 views

MySQL replication shuts down after rotate of binlog

I have following issue. I had successfull setup of master-replica(row-based). It has been running for 2-3 hours. After bin-log was rotated -> mysql-bin.index file got corrupted on master. Here is ...
0
votes
0answers
16 views

can't run mysql server (Can't create/write to file '/run/mysqld/ibmW5ibS')

I am trying to run mysql and getting the following: 141107 8:48:08 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future ...
0
votes
1answer
28 views

How long should a MySQL connection take to create?

I've got some code connecting to a MySQL database and running a simple query. I have instrumented everything and my timer is showing that the first query returns after 12 milliseconds. The code does ...
0
votes
0answers
39 views

What can CPU and disk usage be at maximum, to handle visitors without causing slowness? [duplicate]

What should these rates be at maximum, to handle visitors without causing slowness? Such as 5mb/s and %20 CPU usage? I might get a lot of visitors soon and I want to be ready beforehand. My current ...
4
votes
1answer
56 views

Multiple websites on multiple servers - seperate mysql or not

I currently have 2 Debain boxes (VPS - 4Gb memory) and am hosting a variety of websites of different importance, some ore production sites, others are demo/staging/test sites. Approximately 15-20 ...
-1
votes
1answer
47 views

Can't login to remote mysqld server with phpMyAdmin, but works in shell

I've read all similar topics already, and didn't find any solution. I have server1 where is phpMyAdmin, and server2 where is mysqld. This setup was working. After updating phpMyAdmin (CentOS), I just ...
0
votes
1answer
22 views

Two servers, one clone of another - Port 80 problems

I have currently two servers, which goal is to have redundancy of data. My primary server has Windows Server 2008, which IP is 10.0.0.55 and it's hosting my websites..and everything is working fine. ...