MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

-1
votes
1answer
249 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
67 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
42 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
52 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
47 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
26 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
50 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
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
71 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
78 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
38 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
124 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
59 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
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
21 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
45 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
40 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
65 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
41 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
44 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
169 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
60 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
60 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
24 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 ...
-1
votes
2answers
95 views

issue mysqladmin: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory

[root@mysys mysql]# locate libmysqlclient.so.16 /home/local/CORPORATE/hardik/libmysqlclient.so.16 /usr/lib/mysql/libmysqlclient.so.16 [root@dktp-lab-23 mysql]# netstat -nptl | grep 3306 tcp ...
0
votes
0answers
278 views

apt-get fails with unmet dependencies

I have a server running Ubuntu 12.04 on AWS and I can no longer install anything on apt-get because I get this error: The following packages have unmet dependencies: mysql-server-5.5 : Depends: ...
0
votes
1answer
22 views

mysqld : multiple tmpdir & balancing

Our 1Tb tempdir can sometimes be completely used by mysqld, resulting in disk-full and query errors. This can be due to lots of mid-size queries, or couple of very big queries. We have a 5Tb raid ...
1
vote
1answer
266 views

MySQL high CPU/query time usage during concurrent inserts

I just setup a new server for a large MySQL database of about 70GB. This database is regularly written by automatic processes that must write as quickly as they can their data. Before we had a server ...
0
votes
0answers
26 views

Data usage increase although remove data in table MySQL Cluster

I try to test my MySQL cluster system. I add data to a table and use command ndb_mgm all report memoryusage. The data usage in data node increases. When I remove all data in the table and use command ...
0
votes
0answers
73 views

php-mysqli extension fails as compilation

When I am trying to build the latest php5-mysqli port I get the following errors back: cd /usr/ports/databases/php5-mysqli && make MAKE_JOBS_UNSAFE=yes install clean ...
-1
votes
2answers
70 views

repeated mysql queries change execution time

I noticed that when I execute a query more than one time consecutively on my mysql machine, the execution time drops and changes significantly (40/50%) after the first execution, and that WITHOUT ...
0
votes
1answer
151 views

PHPMyAdmin forces to use ut8mb4 as default collation

After to updated PHPMyAdmin the default collation has been set to utf8mb4_general_ci instead the old default collation utf8_general_ci. As I do not have any need to use utf8mb4_general_ci I would like ...
0
votes
1answer
24 views

MySQL: Grant permissions for `start transaction` and “surroundings”

I have created a sample user with the following request: grant select, insert, update, delete on db.* to user@localhost identified by 'pass'; but that user does also need permission to use start ...
0
votes
1answer
32 views

Logging connections in MySQL doesn't work

I am trying to log all the connection attempts in my MySQL server (don't worry, it's a low traffic one). Here is my my.cnf file: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock ...
0
votes
2answers
360 views

MySQL PID file missing [closed]

Some time ago MySQL stopped working on my server and I've only just got round to looking into it. When I try and start it with service mysqld start I get Starting MySQL.The server quit without ...
0
votes
1answer
33 views

MySQL replication slave got 2147483647 (INT32_MAX) in a column for time stamp

I have set up two replication slaves, one on CentOS(x86_64 5.1.37), the other on Ubuntu LTS(x86_64 mysql 5.5.38). Both of them seem to replicate most of the Master db (CentOS i686, mysql 5.5.37) ...
0
votes
1answer
37 views

Send e-mail upon user login for MySQL

I know that I can use ONESEC to e-mail myself if someone logs into my server but I was wondering if I could do the same thing if someone logs into a specific user for MySQL. My GoogleFu seems to be ...
-1
votes
2answers
38 views

linux MTA email forwarding with DB Lookup

I need to setup a service that will receive an email such a $uniqueID@domain.com lookup that uniqueID in a MySQL database for an email address then forward the incoming email to the email address ...
0
votes
2answers
25 views

Disallowing interactive login for specific mysql users

I want to create some mysql users for different web sites but disallow interactive connections for them. If a evil-user get the mysql login credentials of a website, creating a conexion from ...
0
votes
0answers
60 views

MariaDB mysqldump fails on tables with underscores

mysqldump -u root -pvagrant --skip-lock-tables --no-data databasename is giving me this: mysqldump: Couldn't execute 'show table status like 'view\_admin\_mu\_list\_view'': SELECT command denied to ...
1
vote
1answer
31 views

Managing multiple servers with database and apache [closed]

We are building a relatively simple setup, with multiple apache servers potentially behind a loadbalancer, with a single database server to serve a particular website that will in effect need to be ...
0
votes
1answer
122 views

MySQL CREATE command denied to user

I have a script system that refuse to be installed because of error that breaks installation. I tryied to import the data by import the data via .sql file at phpmyadmin and it still cant import. ...
1
vote
1answer
132 views

Postfix/Dovecot configuration with virtual users

I followed this tutorial for configuring Postfix + Dovecot with virtual users (in a mysql database) : ...
0
votes
1answer
59 views

Most reliable MariaDB to Postgres dump method

I am in the process of migrating an app to another server, and will need to migrate the database contents from MariaDB to Postgresql. Most documentation indicates that the following format should ...
1
vote
1answer
130 views

Keepalived load balancing MySQL. Backup server time-out

Dear beloved people at ServerFault. I'm trying (and failing) to setup a load balanced MySQL server array. Please enlighten me, show me the error in my ways. Current setup: two MySQL servers with ...
0
votes
1answer
56 views

postfix/dovecot/mysql not sending/getting emails [duplicate]

I understand that I posted this before, however I left out some very important details which apparently made a lot of people less likely to answer, here's a more detailed version. My ...
0
votes
0answers
52 views

Amazon EC2 not responding on port 80 and mysqld will not start

An EC2 instance running Apache 2.2.5 on CentOS 6.4 appeared to be fine up until September 29. That day at 7:49 the Value in CloudWatch was 42, at 7:59 it was in the low 100,000's, the last Value ...
0
votes
1answer
61 views

Mysql - best setup for 4 replication databases and another standalone

we would like to merge on one server 2 mysql instances coming from 2 different server : 4 databases on the first instance, which is a replication slave, which are replicated from a master 1 database ...
1
vote
1answer
193 views

Upgrade mysql 5.5.40 to 5.6 on centos 6.4

I can't find a repo to add to my repolist that has an update for mysql 5.6. Does anyone know how to do this? I tried this [link] but it broke everything. I was getting a mysql_connect() undefined ...
0
votes
0answers
47 views

How to link my local MySQL DB to remote MySQL on the internet

Please I need some suggestions or advice on how to how to link my local MySQL DB to remote MySQL on the internet. I developed a Conference Management System for my client and they want us to setup 2 ...