Tagged Questions

MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

-2
votes
0answers
14 views

Save MySQL InnoDB data to multiple DIR [on hold]

I want to save MySQL data to two different DIRs. datadir=C:/PROGRA~1/Bitnami/DJANGO~1.7-0/mysql\data And i want to also use D:\MySQL_BACKUP\DATA simultaneously to store data Can someone please help ...
0
votes
1answer
16 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 ...
0
votes
0answers
14 views

Unable to start MySQL on Mac OS X 10.10 [on hold]

I am trying to start MySQL on a Mac OS X 10.10 but for some reason when I try to connect with PHP it sends me this error: Connection failed: SQLSTATE[HY000] [2002] No such file or directory ...
0
votes
0answers
7 views

How to connect to mysql database on a remote server behind a vpn requiring an ssh tunnel from another remote server using php?

I need to connect to a mysql database with php from a remote server. The mysql database is on another server owned by me. On the mysql server, the only permissions I have is to read and do database ...
-1
votes
0answers
19 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
1answer
33 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
26 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
34 views

How to remote access my mysql database?

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
22 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
16 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
15 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 ...
0
votes
0answers
20 views

Optimizing LAMP/zend framework based application

We have an application based on zend framework that is currently quite slow, I have spent some time using siege to benchmark the application in comparison to wordpress (to have a basis for comparison) ...
0
votes
0answers
8 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
15 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
0answers
17 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 slavedb into sync without down time if I am using only innodb tables. My primary ...
0
votes
1answer
25 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
17 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
26 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
31 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 ...
-1
votes
0answers
20 views

How delete files of this packet? [closed]

I done: root@omyvps:~# cd /usr/share/mysql root@omyvps:/usr/share/mysql# apt-get build-dep mysql-5.6 but all packages now are installed in "/usr/share" instead of "/usr/share/mysql" How can I ...
0
votes
1answer
23 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
14 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
21 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
33 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
votes
0answers
25 views

MySQL-Python on Centos with multiple python versions [migrated]

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
22 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
29 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
37 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
103 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
40 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
48 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
19 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
29 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
87 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
19 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
78 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 ...
-1
votes
0answers
27 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 ...
0
votes
0answers
18 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
27 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
36 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
38 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
26 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
18 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
56 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
22 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) ...