MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

-2
votes
0answers
27 views

Apache consuming too much CPU (each time when access)

I have some troubles with CPU loading by Apache and would be grateful for your help as I do not understand much (but I am trying to...). I use Kubuntu machine as a server machine for The Bug Genie ...
2
votes
3answers
1k views

How to speed up Drupal 7 with remote DB (not DNS resolving)

we have Drupal 7 on Ubuntu LTS virtual machine (VMWare) with MySQL 5.1 server on the same physical server, but on a different virtual machine. The Drupal website is currently under development, ...
0
votes
1answer
23 views

MySql ignores memory settings

I'm using MySql community server 5.6 on Ubuntu 15.04, I have /etc/mysql/my.cnf (no other config files). I've made changes to it and restarted MySql. When I use such query SELECT @@key_buffer_size ...
0
votes
1answer
310 views

MySQL replication & logrotate

I'm using MySQL Master-Slave replication for backup purposes (for a few days). Today after changing to expire_logs_days = 3 on master and slave I got this message (from slave): ...
1
vote
1answer
28 views

MySQL - Statistics per ip

I'm unable to found a way to get some statistics per IP since the server started. I would like to get a count of queries executed by IP address. The goal is to check if a server is abnormally using ...
0
votes
1answer
1k views

'PDO Connection Error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

I'm getting 'PDO Connection Error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' error when I'm trying to make too much update and ...
0
votes
1answer
46 views

Adding multiple 'Limit to hosts matching' for user in Workbench

I want to add two IP addresses to limit a user account in Workbench. I can't figure out the syntax. I've scanned the help and online. 123.456.789.123, 127.0.0.1 doesn't work. It says Hosts so I'm ...
0
votes
0answers
11 views

MySql container stuck at “Restarting…” on Dokku [migrated]

I tried to create a new mySql database on my Dokku container. Using dokku mysql:create bookmarks The container has been created, but it seems it is unable to start. The command # dokku ...
0
votes
1answer
42 views

How should I go about upgrading mysql server from 5.0.67 to latest?

The current version of mysql I have on my server is 5.0.67. I would like to upgrade to the latest version. Based on what I have read here: https://dev.mysql.com/doc/refman/5.5/en/upgrading.html, this ...
1
vote
0answers
51 views

How I can reduce disk IO in MySQL 5.6.26?

I was using MySQL version 5.1.52 for my application but recently I have updated it to 5.6.26, but now I am facing very high disk IO. Following are system configuration: OS : Linux 2.6.39.4 RAM : ...
1
vote
4answers
3k views

How to compress or restrict MySQL ibdata1 data file

Our Application is having huge data and full of inserts and deletes. So in 3 weeks, the ibdata1 file reached 30 GB. So I thought we can restrict the size of ibdata1 file and changed the variable ...
18
votes
5answers
55k views

MySQL keeps crashing: InnoDB: Unable to lock ./ibdata1, error: 11

I have a simple webserver (Debian 6.0 x86, DirectAdmin with 1 GB of memory and still 10 GB free space, mySQl version 5.5.9), however the mySQL server keeps crashing and I need to kill all mySQL ...
0
votes
1answer
17 views

Dovecot dict: Can't open configuration file, Permission denied

I'm trying to set up a dovecot mysql dict for quota in a FreeBSD jail. This is the log I'm getting: an 13 10:03:23 mail dovecot: dict(71120): Error: Failed to initialize dictionary 'sqlquota': dict ...
0
votes
0answers
18 views

Dovecot quota clone

I'm trying to use dovecot's quotas and share them via mysql with modoboa. I'm using the count module for that: http://wiki2.dovecot.org/Quota/Count To share the quota I'm trying to implement the new ...
0
votes
1answer
16 views

MariaDB galera cluster fail when dumping or optimizing database

It seems that a Galera cluster deadlocks every time when I run a mysqldump or table optimize. I've ran a "mysqlcheck" and a "mysqldump" on my MariaDB 10.1 database server several times. (which runs ...
0
votes
1answer
25 views

how to prevent Innob db spiking at 97% Disk I/O Utilization

Our database(InnobDb) is spiking at 99% I/O at random times. After the spike it goes down to about 2% until it spikes agian. There are not some "super" queries that are running in these intervals. We ...
0
votes
1answer
1k views

directory not owned by the 'mysql' or '_mysql' user

I have recently installed MSQL for a Rails App. After some tinkering, I have an error starting mysql now that reads as follows: Warning: The /usr/local/mysql/data directory is not owned by the ...
0
votes
2answers
9k views

Lost connection to MySQL server at 'reading initial communication packet', system error: 0 with windows

I found similar questions but none of them helped me with a windows machine. I originally posted this on stack overflow but it was suggested that I ask here. I was able to connect to mySQL through my ...
0
votes
0answers
32 views

What is the best strategy to automatically sync a Filemaker table on a local server with a remote MySQL table?

I'm trying to figure out the best way to keep a Filemaker 12 database on a local Windows 2012 server machine in sync with a MySQL 5 database on a remote server which runs the shop of a website. In ...
0
votes
0answers
17 views

How to avoid MySQL replication corruption while executing flush-logs command

I have three servers running MySQL, let's say A, B and C. Server A is the master, and server B is the slave. I want to do mysql replication between server A and B, at the same time, I also want to use ...
0
votes
0answers
33 views

phpmyadmin can't login with non-root users

I just started learning to manage Linux web hosting. After installed webmin/virtualmin on Ubunto 14.04, I used the install script of virtualmin to install phpmyadmin. The problem is, I can only use ...
0
votes
2answers
1k views

Mysql 5.5 is not installed in CentOS 5.7

I am using CentOS 5.7 with 64 bit. In my machine already have MySQL 5.0.88 version. Now I want to upgrade MySQL to 5.5 version. I followed this link to start my installation process. When i give "yum ...
-2
votes
1answer
35 views

best configuration for database server [duplicate]

Okay I have a VPS (DO 512 MB) and AWS RDS free tier . I wanna get the maximum performance , please help me cause I'm a little confused . I run a nginx server on the VPS and it can handle 1K ...
-1
votes
1answer
57 views

Google Cloud SQL Not Responding [closed]

My Google Cloud SQL instance stopped responding. I changed the size from a micro instance to standard instance and then the memory just shot to the ceiling and stayed there. The restart button is ...
1
vote
0answers
16 views

Alias with all users in mysql table for postfix/dovecot

I have a table with users for my mail server. This table for imap authenfication in dovecot: ...
4
votes
1answer
43 views

TKLBAM backup stalling causing MySQL issues

I'm having a strange issue that I've never encountered before. I'm running a Turnkey Linux LAMP server (Debian) and it seems that my MySQL server becomes inaccessible at least once a day. I'm not sure ...
1
vote
1answer
4k views

Confused about MIME types, Browser transformations and Transformations3-What are they?

everyone. I'm new to Apache, and I'm trying to build a database in phpMyAdmin. When choosing the properties on the type of fields for a particular table design, there are three properties that I don't ...
0
votes
1answer
203 views

debian-sys-maint user in mysql?

I just installed MySQL on Debian 6. With PHPMyAdmin I noticed there are already 4 MySQL users: debian-sys-maint (localhost) root (127.0.0.1) root (localhost) root ...
1
vote
1answer
53 views

MySQL Host / Host Table

So for better security, our website / network has been looking to lock down all of our SQL to IPs. What we originally were looking for was somewhere where I could whitelist all our ips, say ...
0
votes
0answers
16 views

Create alias with all users from mysql table in postfix/dovecot

I have a table with users for my mail server. This table for imap authenfication in dovecot ...
2
votes
3answers
621 views

Can I convert my database/script to UTF-8?

How can I convert a database to support UTF-8 and convert it's old data from what ever encoding they're in to UTF-8 ? Extra Info: I'm running a server which has many websites on it, and one of them ...
0
votes
1answer
2k views

SQL Error (1064) when importing data from SQL file

I have a MySQL database, which was originally set up with the default latin1 character set and latin1_swedish_ci collation. I was using the database like this for sometime, until I noticed strange ...
0
votes
0answers
14 views

Mysql “freeing items” in states

Please help me ... I have mysql 5.6 machine , with following info: Centos 2.6.32-431.el6.x86_64 Ram : 64 GB innodb_buffer_pool_size=48GB Bit: 64 bit ...
-6
votes
1answer
46 views

How fast should a web server be? and why StackExchange uses all that hardware? [closed]

Okay so I have been making my very first website, I am using Apache server on Windows 10 Pro I can see my website is loading very fast, however, when I browse my website like anyone would do, I can ...
2
votes
1answer
8k views

Server crashed, some MySQL databases are broken. Trying to recover with InnoDB recovery, but ibdata1 seems corrupt

I've a problem. Some days ago my root server crashes after a power outage. I realised that the MySQL server won't start. In the logs I find out that an error occured with InnoDB's ibdata1. I've ...
1
vote
2answers
1k views

Horrible PHP/MySQL Query Performance On Ubuntu Server 10.04

I just did a clear install of Ubuntu Server 10.04 with the standard LAMP config.. Then I made a small script to test insert speeds into a table with 3 columns. When I run the script on any of my ...
0
votes
2answers
923 views

Moving MySQL directory on an Amazon EC2 machine

I'm trying to have MySQL point to a directory on an EBS volume I mounted on my EC2 machine. I took th following steps: Stopped MySQL (/etc/init.d/mysqld stop) - successful Created a MySQL directory ...
7
votes
1answer
1k views

Speed up MySQL inserts with partitions on MyISAM with unique key

I have a large MyISAM table (~30M rows). At some point I've switched it to fixed row format, so now table takes ~40Gb on disk and 2Gb for indexes. Table has a unique index and there are 100 'insert on ...
-4
votes
1answer
30 views

RHEL 6.5 iso issue

the company Im currently working was able to installed redhat 6.5 in their VM and they uploaded the Rhel 6.5 iso in the redhat server. I was able to install the apache and the php but when I tried to ...
1
vote
1answer
1k views

Installing old version of mysql

I'm trying to troubleshoot a database import problem and want to duplicate the environment onto another server. This will require installing an older version of mysql, but the packages that are listed ...
2
votes
2answers
2k views

phpmyadmin won't connect to remote MySQL instance

I have a LAMP stack box (CentOS 6) and another CentOS 6 box running mysql server. I've installed phpmyadmin on the LAMP box but I can not get it to talk to my SQL box at all. I have configured the ...
0
votes
1answer
17 views

Postfix - MySQL - noreply custom response not working

I'm trying to get a custom response working for no.reply@example.com and I keep getting "User doesn't exist" errors. I have an alias of no.reply@example.com which has a 'goto' of the same value, then ...
0
votes
2answers
1k views

Syntax error when setting up master-master replication in MySQL

So I've set up my initial master-slave replication pair on two different MySQL servers. That part is working great. So all I have to do is set up the first master as a slave and set up the first slave ...
0
votes
1answer
30 views

Memory problems in a Wordpress Multisite Ubuntu Server

I have a server with 512MB RAM and 512MB swap file hosting a Wordpress multisite (8 websites). Not many visitors per day (about 50-100 per site per day). Right now, everything is working fine, and ...
0
votes
1answer
43 views

How can I securely access a Rackspace Cloud Database in AWS?

Rackspace limits access for Cloud Databases to their ServiceNet. How can I securely and efficiently connect to a database instance there from AWS (over the public internet)?
0
votes
1answer
1k views

Connecting to SQL Server with PHP on Mac

I'm trying to connect to my local SQL Server 2008 R2 (have also tried it with 2005, same result exactly) with PHP. I'm using PHP 5.1 which still supports php_mssql and mssql_connect(). for some ...
-1
votes
2answers
3k views

Install Navicat for MySQL on Linux Ubuntu 12.04

How do I install Navicat on Ubuntu Desktop 12.04? I have just configured a new Ubuntu 12.04. Because I'm not so familiar with the command line, I prefer to use Ubuntu Desktop so that I can have a ...
0
votes
1answer
51 views

IMAP authentication issue with roundcube + postfix + mysql + ubuntu mailserver

This problem is driving me insane and I'm now stumped. Need some help please ;) I'm setting up a mail server on an Ubuntu 14 AWS EC2 instance using mysql backend, postfix MTA and roundcube webmail ...
0
votes
1answer
23 views

DB replication using BinLog

I am using mysql-binlog-connector to listen to any binlog event and then perform replication on the slave DB. My problem is that, the binlog registers event right after the execution and before ...
0
votes
4answers
701 views

MySQL stops working on AWS ec2 instance periodically for no reason

I run a development server on AWS which has worked perfectly fine without a hitch. Recently, periodically the mysql server starts to not work. I then type in service mysqld restart which yields ...