MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

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
51 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, ...
7
votes
5answers
886 views

MySQL 5.5 degraded performance in linux kernel 3.2 compared to 2.6

Our database servers (mainly based on the Debian stable packages (=currently Wheezy) seem to have about 4 times more load for the same workload in kernel 3.2.0-4-amd64 then in it's previous ...
0
votes
0answers
76 views

MySQL Cluster client says ndbclient not loaded

I'm trying to create a JPA Client for a MySQL Cluster 7.3. (MySQL 5.6). I'm building the jpa client on OS-X and have copied the libndbclient.so.6.0.0 and libndbclient_static.a from the Cluster SQL ...
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
vote
1answer
310 views

DB encryption for Django web app without storing key on server

We are setting up a virtual private server (not hosted by us), on which we will be user testing our Django-based web application. The user-generated content produced in these tests will be very ...
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
0answers
47 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 ...
2
votes
1answer
3k views

ProFTPd, MySQL, virtual users and permissions

I want to control my ProFTPd authentication by a MySQL database. Users will be able to change the username and password of their FTP account(s) in a PHP web application. This provokes a following ...
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
2answers
270 views

Cannot select from new view in MySQL (can select from everything else)

I am a newbie to MySQL, being more accustomed to MSSQL. However, we have recently purchased the LabTech management software, which uses a MySQL back end. While writing a custom report to keep track ...
0
votes
2answers
781 views

MySQL Cluster transaction isolation level - READ_COMMITTED

I'm learning by mostly reading the documentation. Unfortunately, http://dev.mysql.com/doc/refman/5.1/en/set-transaction.html#isolevel_read-committed doesn't say anything, while it says everything. ...
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 ...
0
votes
1answer
119 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
3answers
166 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 ...
1
vote
3answers
4k views

Plesk: libmysqlclient_16 not defined in file libmysqlclient_r.so.16

I've found this error in my logs: relocation error: /usr/lib64/libmyodbc5.so: symbol strmov, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference ...
0
votes
1answer
76 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
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
1answer
58 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
2answers
121 views

Queries going to mysql server even when no one is connected to it

I have a MySql server which has 2 active databases which are used for a web application and 3 inactive ones (left for archival purpose but not currently used). The problem is that the server seems to ...
-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
267 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
0answers
44 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 ...
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
0answers
64 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
5answers
759 views

What is the best option to set up a quick and easy-to-manage database for my small office?

First, please be aware I am definitely a beginner when it comes to server maintenance or network administration. That being said, if I am asking this question in the wrong forum, please feel free to ...
1
vote
2answers
257 views

Query cache for MariaDB Galera cluster

I've read from multiple sources now that you can't have query caches with Galera, but my current application could really benefit from a query cache. I'm load-balancing this cluster with HAProxy and ...
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
59 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
votes
2answers
94 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 ...
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
vote
1answer
260 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
1answer
334 views

Interspire Email Marketer taking long time to send bulk emails

I am using Mailjet SMTP Server along with Interspire Email Marketer to send emails to a large group of users (around 54,000). I once used Mailjet's inbuilt Email Marketer to perform a similar ...
6
votes
3answers
9k views

Why are outdated packages installed by yum on CentOS? (specifically PHP 5.1) How to fix?

I'm working on a fresh CentOS server and am extremely annoyed to find out that yum does not work as smoothly and brilliantly as "apt-get install" does on Ubuntu. Installing a LAMP stack, I ran the ...
0
votes
1answer
21 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
2answers
7k views

how to fix corrupt, not cleanly closed and upgrade needing tables in mysql

When I restart mysql server in Debian, I always have the below messages. How to make the messages disappear or fix the problem/corrupted tables? debian:~# /etc/init.d/mysql restart Stopping MySQL ...
7
votes
2answers
2k views

Connecting to MySQL securely - MySQL's SSL vs Stunnel vs SSH Tunneling

We have a PHP application which connects to a MySQL server, and we wish to secure connections between the web & application servers and the database. At peak times, the web servers make many ...
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
366 views

Mysql tmp file cause site exception error crash

Running Magento and every 3-15 days or so (fairly random) I get this error: exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[HY000]: General error: 1 Can't create/write to file ...
0
votes
0answers
69 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 ...
2
votes
2answers
545 views

MySql raw binary data files copy 5.0 > 5.1

We are in the process of preparing a data migration of some fairly big DB (200GB), InnoDB tables from our old server to the new servers. The data is very index heavy and trying to migrate the data via ...
115
votes
5answers
160k views

MySQL: Bind to more than one IP address?

Is there a secret way to bind MySQL to more than one IP address? As far as I can see the bind-address parameter in the my.cnf does not support more than one IP and you can't have it more than once.
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) ...
9
votes
2answers
30k views

How do i find out what my IP Address of my MySQL host is?

I have a free domain running at x10hosting (x10.bz), and I want to find out the IP Address of my MySQL host for it, so I can contact the MySQL database from another host. I've already added that host ...
1
vote
4answers
155 views

How to determine which SSL library MySQL is using?

My Debian squeeze server is running mysqld version 5.1. How do I determine if the SSL libraries it is using are OpenSSL or yaSSL? (I am pretty sure this MySQL supports SSL as the User table has the ...
2
votes
1answer
2k views

Changing the MySQL datadir location to a mapped drive under WAMP [closed]

I have a WAMP server running on Windows 7 and I want to move the mysql data files to a network share (A NAS device). I stopped the WAMP server, created a drive letter mapping to a share on the NAS, ...
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 ...