MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

-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
35 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
29 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
66 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
29 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
25 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
16 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
19 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
18 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
55 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. ...
-1
votes
0answers
16 views

Mysql cluster - the mysqld node is not accepted by the mgmd node

I have been trying to set up a MYSQL cluster in Ubuntu. I have ndbd, ndb_mgmd and mysqld each running on their own independent machine and assigned a static ip. The ndbd node connects to ndb_mgmd ...
2
votes
1answer
57 views

postfix-mysql package on CentOS 7

I'm following this tutorial on how to install a secure mail server. The guide is for Ubuntu 14.04LTS but I'm doing it with a few modifications for my CentOS 7 system. I am however stuck on ...
1
vote
1answer
47 views

Reset MySQL password doesn't work (can't connect without granted tables) on OSX [closed]

Let me start by saying that I've looked through tons of posts (both here and elsewere on the internet and the article on mysql.com about resetting the admin password) about resetting the mysql ...
1
vote
1answer
124 views

MySQL 5.6.21 on Debian 7.7 — nice is automatically set to 19 several seconds after starting it up; can't figure out why

I'm running MySQL 5.6.21 on an OpenVZ VPS with Debian 7.7. MySQL is installed from the DotDeb repository (full version number is 5.6.21-1~dotdeb.1). Whenever the MySQL server is started or restarted, ...
0
votes
0answers
51 views

MySQL exits without any output

Having a strange issue. Some time ago MySQL exited suddenly when I was creating a table (I think), and I shelved the issue until now. It seems to start, but nothing happens and it exits: 141031 ...
0
votes
0answers
89 views

MySQL stops unexpectedly on CentOS 6.5 with WHM/Cpanel after migrating server with transfer tool

I recently moved my entire websites from a dedicated CentOS5 server to a CentOS 6.5 on Amazon EC2 with the same cPanel/WHM version. WHM 11.44.1 (build 19) However after angry calls from clients I ...
0
votes
1answer
79 views

MySQL crashed and was not able to restart until clearing a table

I have MySQL running on my Ubuntu server and suddenly the MySQL Daemon was down. When trying to restart it, the restart failed due to xxx table is marked as crashed and last (automatic ) repair ...
0
votes
2answers
48 views

Can I restore the “mysql” system database along with another from a mysqldump backup?

Basically, what I did is: mysqldump -uroot -pxxx <some_options> --result-file Backup.sql --databases mysql customappdb Is it sane to later do mysql -uroot -pxxx < Backup.sql Or do I ...
-1
votes
1answer
65 views

/bin/sh: fork: Cannot allocate memory

In my web server running with following architecture Centos 6.5 Plesk 12 Nginx 1.6 (As a reverse proxy) Apache 2.2 MySQL 5.5 PHP 5.5 Openfire 1.9.4 Pagespeed web server can have max 500 ...
0
votes
2answers
66 views

MySQL: I omitted a space--what did I do?

I'm curious and learning...this is non-urgent On a production server running 19 databases I entered this typo mysql -uroot-p[passwd] ^ omitted space I soon enjoyed a solid 12 seconds ...
0
votes
1answer
35 views

Choose hardware for MySQL server with 1-2k rps [duplicate]

I am looking for new DB server. I'd like to know your opinions and recommendations. Current server spec: We use DB server for website with 100-200 req per sec(i plan growth up to 200-250) Today we ...
-2
votes
3answers
47 views

How to remote access my mysql database? [closed]

can you please help people, i made an application which will be used by few friends of mine, but the application is written with connection method: Standard (TCP/IP), i was thinking it will be easy, ...
1
vote
2answers
40 views

SSL Support for PHP 5.3.3 and Apache

After a solid day investigating why I can't get my application to connect to a remote server over SSL using PHP PDO, I found PDO::MYSQL_ATTR_SSL..., but it seems that they exists only for 5.3.7 or ...
0
votes
1answer
24 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
0answers
38 views

PHP use socket connection when use “localhost”, but when use 127.0.0.1 use tcp

I have a cPanel server where i move the mysql service into another server, all databases has ben moved by mysqldump and it work very well. On cPanel server, where there are all php sites, i just ...
0
votes
0answers
27 views

#1130 - Host 'localhost' is not allowed to connect to this MySQL server after acunetix scan [migrated]

I am using the xampp . As stated in the question i am getting the #1130 - Host 'localhost' is not allowed to connect to this MySQL server after i ran acunetix vulnerability scan on my localhost . I ...
-1
votes
0answers
13 views

Determining max concurrents on a LAMP stack, and related questions [duplicate]

Consider a basic LAMP stack with clients continuously long-polling it for anywhere from, say, five to 15 minutes at a time. (Note that the period of long-polls is around 30 seconds max; the five to 15 ...
0
votes
0answers
18 views

Duplicate DB and files

I'm creating a group of websites using the CMS Concrete5 has models to be presented to my clients. My idea is that they can choose each one they want and deploy a new subdomain with a model ready to ...
0
votes
1answer
67 views

Can I do zero downtime MySQL replication if I have archive tables present?

I've read the question and answers at How to setup MySQL replication with minimal downtime. It looks like I can get a slave DB into sync without down time if I am using only Innodb tables. My ...
0
votes
1answer
51 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
0answers
33 views

Why does freshly created MySQL slave keep throwing foreign key errors?

We are running Ubuntu-14.04 LTS with its stock mysql-5.5.40 and mysql-utilities-1.3.5 and we are setting up some master/slaves couples. Some of them get up without any issues just like usual, but some ...
0
votes
1answer
78 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 ...
1
vote
1answer
46 views

MySQL on LAN not working when IPTables enabled

I have two Centos VM. The IP Addresses are as follows : VM_1 => 10.99.0.10 VM_2 => 10.99.0.12 Apache and PHP are in VM_1 and MySQL is in VM_2. Both are having iptables rules. VM_2 is working ...
0
votes
0answers
8 views

create federated copy of a table? [migrated]

From the MySQL documentation : The basic structure of this table should match that of the remote table, except that the ENGINE table option should be FEDERATED and the CONNECTION table option ...
0
votes
1answer
25 views

MySQL connections not closing

I have a web application running on Tomcat7 that connects to MySQL 5.5. I have two servers running the identical code: Ubuntu Red Hat The Ubuntu one runs fine maintaining a steady 8-16 ...
-1
votes
1answer
18 views

MySQL upgrade issues - script to analyze general query log

When moving from MySQL 5.0.x to a newer version (such as 5.1.x or 5.5.x) what's the best way to proactively find backwards compatibility issues? There is lots of documentation out there such as ...
0
votes
0answers
35 views

(OpenShift) Permission denied when installing my own cartridge from my github repository

I froked MySQL cartridge from official github repo and I added some modifications to support utf8mb4 encoding. this is my cartiridge on github : ...
-1
votes
1answer
37 views

Memory on dedicated server is filled out [duplicate]

We are managing a dedicated server (WHM/cPanel) with 4-5(Magento & Woocommerce mostly) accounts in it, along with custom code that will connect those platforms with ERPs. This custom code works a ...
0
votes
0answers
46 views

No version specified, and no candidate version available for mysql

I'm trying to install MySQL using Chef on CentOS 6.5. I've got the repositories in place. -rw-r--r--. 1 root root 256 Oct 15 16:59 centos-base.repo -rw-r--r--. 1 root root 267 Oct 15 16:59 ...
1
vote
1answer
34 views

Courier-IMAP pop3d auth over mysql

I've got a task of migrating one mail server from one box to another and so far I have configured Postfix and it's working. But, Courier pop3d server fails without exception. So, I have Courier pop3d ...
0
votes
1answer
42 views

MySQL user:pass in roundcube php config

Is it considered bad practice to have a MySQL query with user:pass as plaintext? I'm doing this right now (in nginx/roundcube to modify my dovecot passwords) but it seems strange because if I had ...
1
vote
3answers
137 views

Server problems, running out of RAM, really high load average

I desperately need help in figuring out how to troubleshoot this problem I'm having. I run a fairly mission critical web server (Debian 7.5, 512MB RAM, 512MB swap, Apache, MySQL). It runs a couple ...
0
votes
2answers
54 views

Previous Version of mySQL on apt-get

I'm trying to download a previous version of mysql-server (5.5.28-0ubuntu0.12.04.2) using apt-get, but I can't seem to find the source list with the version that I want. I've done apt-get update to ...
0
votes
1answer
55 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 ...
1
vote
0answers
21 views

Mysql with low memory on development environment

How to set mysql to run on very low memory? (preferably under 100MB and max 250MB) Currently it's running for about 400mb. I can't turn off the innodb because production using innodb. Is there any ...