MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

0
votes
0answers
16 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
12 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
9 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
30 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
13 views

MySQL-Python on Centos with multiple python versions

I've been trying hard to get this work. What I'm trying to accomplish is - Get the Mysql-Python driver installed for both Python2.6 (default) and Python2.7. Do this preferably in a virtualenv. I ...
0
votes
0answers
15 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
27 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
25 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 ...
-5
votes
0answers
23 views

accidently i deleted var/tmp file in centos server [on hold]

accidently i deleted var/tmp in root directory ,, and i reboot my server,, i cant login to ssh and my site in 500 internal server error, i try to restart service in whm but i cant, got error with ...
-1
votes
0answers
19 views

How not to automatically start MySql service on Easyphp startup? [on hold]

I'm using EasyPhp 14.1 on Windows XP. I would like to know how to configure EasyPhp to start Apache webserver, but not MySql server when the app starts? Is there any configuration to do?
0
votes
2answers
47 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
31 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
44 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 ...
-3
votes
0answers
22 views

Recommend local server for 50 user [closed]

I am new to the server side. I am asked to setup a local server for 50/60 users max. The server will be running linux, mysql and a java application server (for a CRUD application, using spring, ...
1
vote
0answers
18 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
15 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
50 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
18 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
62 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 ...
-4
votes
0answers
27 views

i can't add the MySQL 5.5 cartridge? [closed]

I scale down and remove mysql 5.1 to create mysql 5.5, and now i can't add the MySQL 5.5 cartridge. my url : http://dd-tapchiict.rhcloud.com Unable to add cartridge: nguyenac@gmail.com is ...
0
votes
0answers
26 views

MySQL server access denied [duplicate]

I have a server with Digital Ocean. They claimed my server had been compromised and is part of a DDoS attack so they disabled networking and require me to access it from from online console. I have ...
-3
votes
0answers
30 views

How to SSL + MySQL on Windows? [closed]

Has anyone successfully setup MySQL with openssl certs on Windows with clients authenticating? I've followed ChriSQL's tutorial to a tee but haven't been successful. ...
0
votes
0answers
16 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
21 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 ...
-2
votes
0answers
32 views

Why I'm having this High IO?

I've got a Web Server VPS (on Amazon EC2) where everything run well till 4 days ago, when I moved from the EBS Standard (HDD) to a SDD General Purpose. Since then, I'm having trouble related to the ...
-1
votes
2answers
34 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
0answers
4 views

Convert Duplicate Finder Query to Drop All But the Newest Record [migrated]

I have a duplicate finder query... SELECT Author, Name, TrackNum, title_id, COUNT(*) FROM db.table GROUP BY Author, Name, TrackNum, title_id HAVING COUNT(*) > 1 It returns those ...
0
votes
0answers
15 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
17 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
0answers
18 views

Best Query/Method to Import A Database Via Workbench and Push Edits Back Out to Prod [migrated]

I have a local instance of Workbench. It connects to a local dev database, and also a remote prod database via SSH. I want to be able to work on my dev database and push the changes out to the prod ...
0
votes
1answer
23 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
47 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
20 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
30 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
32 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
21 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
26 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
24 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
34 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
46 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
31 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
43 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
49 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
36 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
21 views

Mysql - best setup for 4 replication databases and another standalone

we would like to merge on one server 2 mysql databases coming from 2 different server : 4 databases which are replicated from a master 1 database which will be standalone What do you think is a ...
1
vote
1answer
89 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
1answer
39 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 ...
0
votes
1answer
31 views

Amazon RDS load balancing and performance

My question is simple. Is it possible to load balance rds (master and read-replicas) using the same haproxy instance used for application load balancing? This would mean that the IP of the ...
-5
votes
1answer
68 views

MySql wont start [closed]

'Hi I have a pretty recent install of MySql on DigitalOcean. And for some reason I cannot get MySql to start. 141003 07:25:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 141003 ...
0
votes
0answers
19 views

MYD files renamed after restart - how to recover?

The disk space went full on our server. It remained like this for too long, and now mysql is completely crased. I'm getting errors like this : mysql> use mysql; Reading table information for ...