MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
8 views

MySQL 5.6 upgrade - reducing code changes / developer burden [migrated]

Does anyone know the key things that should be done when moving to MySQL 5.6 to reduce the amount of code changes required? I found that new installations of it have STRICT_TRANS_TABLES set for ...
1
vote
0answers
33 views

Installing php-mysql on centos 6.5 fails due to conflicts when percona client 5.5 also installed

Some background: I'm writing a Chef cookbook to set up a LNMP stack for local development. It requires the php-mysql library for PHP 5.4 (using the php package). We're using the yum-remi repository ...
0
votes
0answers
15 views

Linode resource splitting [duplicate]

We would like to move our sites to Linode and I have a theoretical question. Which is the best in speed and why? If MySQL runs on a different machine, is it give better result or worse? 1 option ...
0
votes
0answers
22 views

MySql JDBC - java.net.ConnectException: Connection refused, can't see why [duplicate]

I have a test environment with MySQL 5.6 server running on a Windows machine and a Linux machine running a webserver. When I start the webserver it tries to connect to MySQL via: ...
0
votes
1answer
4 views

multiple database syncing in different locations in MYSQL at periodic timings

i have a system at head office with MySQL installed. i have client machines at different locations. i need to sync all the database for example once a customer detail is entered in one client it has ...
0
votes
1answer
43 views

Website takes a long time to first byte [duplicate]

Recently, I migrated a joomla 2.5 site with K2 from a shared host to a dedicated web server with 1 GB of RAM and 8 CPU cores. My problem is now that the website loading is very slow, much slower than ...
0
votes
2answers
14 views

CentOS 7 won't connect to external MySQL database. Database works from other servers

I have a new CentOS server set up, with Apache and php-fpm. The php application fails to connect to an external MySQL server. This server is reachable from other servers, the firewall on the database ...
-1
votes
1answer
14 views

Tracking the slow - how to list all processes related to web-server?

I wanted to ask people in this community about administration of the Debian based web server - its a dedicated server, hosting a single website. From time to time the web site is slowing down, on ...
0
votes
1answer
21 views

How to upgrade MySQL 5.6 to MariaDB

We are using MySQL 5.6 on a productive Server which we want to migrate to MariaDB. Many reasons - but the main reason is the way the Master <-> Master Replication on MariaDB is working. There are ...
1
vote
1answer
22 views

MySQL PID Errors

While attempting to change the MySQL server timezone to CDT to match the Centos sytem time, something has messed up. I edited the my.conf in /etc/ in vim logged in to SSH as root, and saved it. On ...
0
votes
1answer
29 views

Starting MySQL database server: mysqldinstall: invalid user `mysql' [on hold]

i have a problem with mysql on my Raspberry Pi running Linux raspberrypi 3.18.7+ #755 PREEMPT Thu Feb 12 17:14:31 GMT 2015 armv6l GNU/Linux. This is error I have when I run sudo service mysql start ...
-1
votes
0answers
17 views

Am i making too many queries to the server? [on hold]

I am building a web soft for a company with large data requests and searches. I've managed to limit all the queries to the database to 50/second when used by up to 10 people. However i do have an ...
-1
votes
0answers
15 views

Mysql Servers with crossover cable in windows [on hold]

I has two server Master with windows 2008 R2, Slave with windows 2003. I connect the servers with a crossover cable. So far only the slave can ping the master. but the slave replication don't work, ...
-1
votes
3answers
26 views

how to recover all mysql tables of all databases in centos6 with mysql 5?

mysql is corrupt in centos 6 it is showing #1033 - Incorrect information in file: /xxxx/xxx.frm for all database and showing all tables empty. how to recover all databases?
0
votes
2answers
65 views

Strange “/var/lib/mysql too full!” message, with almost empty partitions

I've just encountered a strange problem on my server : it's a basic LAMP server I've just setup and when I try to restart MySQL, I get the following error. /etc/init.d/mysql: ERROR: The partition ...
-1
votes
1answer
19 views

Connect RDS from MySQL Workbench through proxy server(squid) [on hold]

We have many people work from home, they connect RDS dbs from MySQL workbench via "Standard TCP/IP OVER SSH", where a transparent proxy server (squid3) was used. The initial connection was made ...
0
votes
0answers
12 views

Can't enable binary logging (“index not found”) [migrated]

I have a MySQL 5.5.41 server running on Ubuntu 14.04 that already contains several databases of data, and I would like to enable binary logging. I want the binary logs to be placed in their own ...
0
votes
0answers
22 views

How to fix hung requests creating dead lock(/root/syn)?

We are running a search service using written in Java using solr We are noticing dead locks on the service. 14:00:30,465 WARN ThreadPoolAsynchronousRunner:416 - Task ...
-1
votes
0answers
14 views

What type of server is right for my requirements? [IOS Application API] [duplicate]

I am preparing for the startup of my iOS application. What type of server would be the best for my requirements. REQUIREMENTS MySQL DB PHP GET/POST Requests Sufficient Storage for Images Good ...
0
votes
1answer
20 views

cant turn on mysqld. I moved mysql to an XFS directory and pointed it there

hey guys hopefully someone has the answers for this but these are my errors ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) and in my ...
0
votes
2answers
35 views

Protecting mysql instance on Linux Azure VM

I have mysql running in a Linux Azure VM. It's currently bound to the "Internal IP Address" of the VM as looked up in ifconfig and the Azure Dashboard. I've turned on logging to see who and what is ...
-1
votes
0answers
21 views

High memory usage (compared to wamp) and unresponsive site at times

Lately my site (with 260000 posts, 12000 images, 2,360,987 mysql rows and 450.7 MiB size) is running slow and at times not loading for many mins I installed this Debug bar plugin ...
0
votes
0answers
21 views

Import outdated MySQL dump using console

I have a mysql dump file created by outdated MySQL version. I have no access to that server (console). If i use this command on my current server: mysql -u user -p dbname < dump.sql I get this ...
0
votes
0answers
24 views

Port 3306 for MySQL closed

It seems that the port 3306 for remote MySQL access is closed on my server. In /etc/mysql/my.cnf I changed the bind-address setting to my remote IP already and restarted the server. A nmap scan of ...
0
votes
1answer
15 views

MySQL Bad Handshake to MySQL Cluster behind Proxy

I have just set up a MySQL cluster using five hyperV linux boxes (2x management nodes, 2 data nodes and 1 proxy) having followed (with a bit of tweaking) the instructions here. Everything works fine ...
0
votes
1answer
43 views

Is it better to drop a MySQL database before doing a restore?

I have been doing a ton of database restores lately and have been thinking about better ways to do things. One thing I am not sure of is what is the best order of operations in terms of backup and ...
0
votes
0answers
71 views

MariaDB crashing with “Assertion failure in thread xxx in file rem0rec.cc line 580”

I have three MariaDB servers set up in a Galera cluster. I use one server at a time as a "primary" master (i.e., Galera is just for failover, the app doesn't actively use multiple masters). About ...
-3
votes
0answers
16 views

Reducing query cache for mostly INSERT-heavy database? [migrated]

What sort of MySQL query cache should I choose considering the following... Large, rapidly growing database (I got 500,000 rows). UPDATEs practically never happen. SELECTs are rare, but when they do ...
-1
votes
1answer
19 views

Need help importing data to new SQL server from MySQL folder

My hard drive crashed, and can no longer write, but it can still read. Because of this, I was unable to export my SQL database to an .sql file for later importing. I can still access the drive, and ...
-2
votes
0answers
30 views

MySQL table doesn't exist [migrated]

What I did before the disaster was: vi /etc/my.cfg I added innodb_buffer_pool_size=4G innodb_buffer_pool_instance=2 innodb_read_io_threads=12 innodb_write_io_threads=12 innodb_io_capacity=300 ...
0
votes
1answer
18 views

mysql command in command line return unknown variable

When I try to use: mysql -u [user] -p command (or any other "mysql") at my Debian server command line I get this error: mysql: unknown variable 'log=/var/log/mysql.log' mysql-client is ...
-1
votes
0answers
21 views

Connect EC2 with RDS

I am trying to move my CMS from 1&1 to AWS. The CMS was built using PHP + MYSQL. I have completed the following steps in AWS - I created an EC2 instace I uploaded a php script to test if ec2 ...
0
votes
1answer
22 views

Clustring haproxy + Apache + MySQL

Im new to clustering, So I started my LAB using linux centos, My schema is : 2 Load balancers, 2 Web servers (apache), 2 MySQL DBs (separated). I configured the 2 LBs and 2 Webs, the load balancing ...
-3
votes
1answer
40 views

MySQL backups of information_schema? [closed]

When performing routine MySQL backups (using mysqldump), should I be including information_schema? Isn't it just meta information? I've seen multiple suggestions to ignore the mysql and ...
0
votes
1answer
31 views

Current setup maxing CPU. Need help designing AWS architecture and MySQL Clustering via AWS RDS instances

My company runs a mid-sized eCommerce (30,000-50,000 unique views monthly) shopping cart using X-Cart as a back-end. We are in the processing of redesigning and upgrading our back-end software. We are ...
0
votes
0answers
10 views

MySQL ODBC DSN ignoring IP address of server - Windows 7

I'm trying to create an ODBC connection to a MySQL server on my network. I can create the DSN but when I click test I get an error (HY000) Access denied for user user@localhost despite the fact that I ...
0
votes
1answer
15 views

MySQL Cluster ndb_restore fails without error

I have been working to migrate our current single instance database to a new clustered database running MySQL cluster. It is a large database (several billion records) and, while it seems to be ...
0
votes
0answers
29 views

Connect to a Server from my AWS EC2 instance

I have a app running on AWS EC2 which connects to a database in another server. The database connection Uri is as following, jdbc:XXX:172.18.2.107:3306/database This is what I got form my ...
1
vote
2answers
49 views

Where are MySQL users and passwords stored?

When I delete 'mysql'.'user' table I'm still able to log in as any user I've created before. How is this possible?
1
vote
1answer
27 views

mysql / mariadb - remove ipv6 user

Can I remove the 'user'@'::1' <- ipv6 user from mariadb? I have ipv6 disabled on my CentOs install. Or is it not related to ipv6?
1
vote
0answers
38 views

Made changes to my.cnf and mysqld wont restart - no backup [migrated]

I thought I'd be clever and update my.cnf file to add ft_min_word_len=2 and didn't back it up first. I will never make that mistake again. Luckily, our project is still in production and no harm done. ...
1
vote
0answers
22 views

Cannot install mysql server - Error in PREIN scriptlet in rpm package mysql55-mysql-server-5.5.32-3.el5.x86_64

I am trying to install mysql server 5.5 (or any 5.x versions) on Redhat 5.5 and am having some trouble. I can install the other mysql components but when I try to install mysql-server (or ...
-5
votes
1answer
30 views

Automysqlbackup how long does it keep the backups

I wonder that if you setup automysqlbackup with default config, how long does it keep the old backups? total 12 drwxr-xr-x 4 root root 4096 2010-01-27 17:20 daily drwxr-xr-x 2 root root 4096 ...
1
vote
2answers
43 views

Need to improve apache and mysql configuration. Current config is crashing server due to RAM maxing out?

Ok, we run a growing auto parts shopping cart. Our server runs slow and is always crashing so we asked our web host to assist us. They sent us these report but I need some advice in how to process it. ...
6
votes
2answers
56 views

Postfix deny relay for some virtual users

I'm using Postfix as MTA and relay. Users that wish to send e-mail from a remote system authenticates and Postfix hands that to Dovecot, and this works well. But how can I limit which users can use ...
0
votes
4answers
236 views

telnet cannot connect to port without firewall

If I try to connect to MySQL with telnet myhost.com 3306 I get a network not reachable error, even when I flush all iptables rules. I can reach other ports like ssh (with the same iptables rules ...
0
votes
0answers
26 views

Elastic search custom mysql server

I want to use ElasticSearch nodes with Amazon RDS servers. How I can do this? The idea is to have the ElasticSearch feature only with a remote DB.
0
votes
3answers
78 views

Offline mysql dump

I'm hosting a 60GB InnoDB file-per-table MySQL database with a VPS provider. I want to generate a dump of the file. Running mysqldump makes the website connected to this database extremely slow, ...
1
vote
2answers
40 views

AWS RDS mysqldump hanging

I am attempting to migrate data between RDS MySQL instances. I cannot use snapshots because, with this migration, I want to encrypt the underlying disk and upgrade versions (5.1.73a to 5.5.41). The ...
-1
votes
2answers
51 views

How to Dump all databases from MySql server with mysqldump without passwords

Is it possible to dump all databases without supplying the username and password for each databe ? The server has 10 databases with different usernames and passwords. I will be logged in as root ...