MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

1
vote
0answers
33 views

PHP requests to insert to database are missing [closed]

i have this code in PHP that insert the data to DB 1 table, for example: The DB Table CREATE TABLE IF NOT EXISTS `thistable` ( `id` bigint(20) NOT NULL, `code` varchar(7) NOT NULL, `sku` ...
0
votes
3answers
564 views

How to optimize mysql insert using perl?

ive got log parser on perl and it uses mysql insert or update command on every line. Like: Log line 1: 2012-12-01 12:12 [perld] Hello world #1 .... Log line N: 2012-12-01 12:NN [perld] Hello world #N ...
0
votes
2answers
102 views

How to troubleshoot high CPU usage on a server?

On my cloud server, the MySQL CPU usage jumps to over 100% on Sundays at 1PM GMT. How can I troubleshoot the cause of this? I have been told to run the cmd 'top' on the server but this only tells me ...
0
votes
2answers
56 views

Is it OK to have database name the same as user name in MySQL?

Many web services require a database and quite often that is MySQL. Typically, the installation instruction of the software tells you to create a database and a user with permission for that database. ...
0
votes
3answers
70 views

MySQL “Duplicate entry” Errors on the Slave break replication all the time

I followed this tutorial: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql Unfortunately the replication stops on the slave all the time with: ...
0
votes
2answers
959 views

How do I sync a subset of tables between two databases on the differnet mysql database server?

I have the main MySQL database which has the following columns in one of the car table: +---------------+-----------------+------+ |carId |name |model | ...
0
votes
1answer
213 views

Configuring ASR and Oracle Clusterware

I have a four server cluster with Oracle Clusterware managing 4 MySQL instances on them. On failure Clusterware will move the MySQL instance to another server. I am on Proliant servers and also have ...
0
votes
1answer
26 views

syscp cron_traffic.php needs 10 minutes to execute

I use syscp on debian and i noticed that this script is taking more than 10 minutes to execute: date ; /usr/bin/php5 -q /var/www/syscp/scripts/cron_traffic.php; date Do 5. Dez 12:09:09 CET 2013 Do ...
4
votes
3answers
7k views

How does mysql determine the hostname of its clients?

I'm trying to create a MySQL user which will only be allowed to connect to the MySQL database from a specific hostname. grant all on db_name.* to 'user_name'@'appserver-lan.mydomain.com' ...
0
votes
1answer
46 views

mysql innodb crash assertion

I've got some very big trouble with my innodb database since friday. The mysql server crashes whenever I do some operations on a specific table which is about 22GB. inserting data works, all other ...
-3
votes
1answer
55 views

Building a future-proof webapp [closed]

My app uses php, node.js, mysql and all the front-end trends. I am hosted on the Linode 4GB plan, 8 CPU (4x priority) and 8TB Transfer for the entire static website, api's etc, a cdn for static files ...
1
vote
3answers
1k views

Connection Reset on MySQL query

OK, I'm flummoxed.(i've asked this question over on Stack too - but I need to get it fixed so I'm asking here too - any help is GREATLY appreciated) I'm trying to execute a query on a database ...
0
votes
1answer
306 views

Securing MySQL debian-sys-maint

With a fresh (but old) install of Ubuntu and MySQL, I found I could access the MySQL via command line client without being asked for any user or password. This bothered me as the default situation, ...
32
votes
7answers
37k views

What is the debian-sys-maint MySQL user (and more)?

I have been bitten several times by the 'debian-sys-maint' user that is installed by default on the mysql-server packages installed from the Ubuntu repositories. Generally what happens is I pull a ...
3
votes
1answer
898 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 ...
1
vote
1answer
25 views

Mysql Undocumented Default Setting for sort_buffer_size in Options File

From a recent install of MySQL Workbench V. 6.2 (MySQL 5.6), while inspecting the options file (Edit > Preferences > General) I see that sort_buffer_size is set to 256k\n256k. What does the \n256k ...
0
votes
5answers
5k views

Can't connect to mysql server (13) using php function

I opened every links google results had thrown to me in regards to this MySQL error. I have been spending hours to get this to work.. I have a web server (apache in centos installed in host B, and ...
-1
votes
1answer
270 views

Keeping database synced in all of my computers [closed]

I have 1 PC (windows 8.1) and 1 Macbook pro. I am working on a PHP project with mysql database backend but is switching between these 2 computers. The PC has WAMP installed and the macbook pro has ...
2
votes
1answer
2k views

Install iRedMail on server with existing MySQL

Is it possible to install iRedMail on server with existing MySQL database? What will happen when I will install iRedMail, will it delete my all my databases or just skip MySQL installation and use ...
0
votes
2answers
825 views

Connections to host are sporadically successful with mysql_connect() and telnet, but I can always ping the host successfully?

When I try to connect to a host on my LAN with mysql_connect();, the connections succeed some of the time and fail at other times. I can always ping the MySQL server successfully, but when I try to ...
0
votes
4answers
2k views

MySQL Query Browser mysteriously can't connect

I have a problem with an end-user who can't connect to their MySQL Server. The facts: Client is Windows XP on a corporate Domain. Group policy has disabled Windows Firewall and there is no other ...
0
votes
3answers
2k views

MySQL Query Browser to run 400+ Insert Statements?

I'm manually duplicating a few records and would like to paste the INSERT statements directly into Query Browser, but I have only ever performed one INSERT at a time with QB. Is it possible to insert, ...
2
votes
1answer
5k views

MySQL - The server quit without updating PID file

I have installed MySQL 5.6.16 on Debain 7.4. But i encountered problems with starting mysql, where every time i start mysql i get this error: The server quit without updating PID file ...
0
votes
0answers
31 views

Trying to replicate a MySQL 5.6 master, the replication server crashes

We run a MySQL 5.6 server that acts as a replication master. Recently, due to some other bug in upgrading from 5.5 the replication seems out of sync so we're trying to create a new replication on a ...
2
votes
2answers
580 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 ...
0
votes
2answers
850 views

Cannot drop index from MySQL INNODB table with foreign keys/references

I'm about to drop an index from a mySQL INNODB table. There are references defined already. When I try to alter it, it says: 1025 - Error on rename of 'X/#sql-2a5f_219828' to 'X' (errno: 150) ...
1
vote
1answer
30 views

MySQL Server fail to restart after trying to import database from command line

My server is CentOS 6.5 64bit, running MySQL 5.5.42 community server by Remi. I tried to import a database from command line by running mysql -u root -p website_database < website_database.sql ...
7
votes
2answers
4k views

Highest value of max_connections in AWS RDS micro instance

Currently, the value for the max_connections parameter in a MySQL RDS t1.micro server model is {DBInstanceClassMemory/12582880} is 32. Since my server does not allowing any more connections after 32, ...
0
votes
0answers
4 views

How to create insert procedure with input parameters in xampp ? and where it is located in PHPADMIN [migrated]

how to create insert procedure in mysql using XAMPP and where it will be located ? how to see my procedure in phpmyadmin ? here is the query delimiter // CREATE PROCEDURE reg_db ( uname ...
0
votes
1answer
45 views

localhost != localhost for MySQL/PHP

System: Mac OS X Server 10.6.latest I just switched from the ancient MySQL (<5?) that came with Mac OS X Server to MariaDB 10.1, installed via MacPorts. (That was a whole 'nuther barrel of fun...) ...
1
vote
2answers
1k views

Heavy write to Galera cluster - table locked, cluster practically unusable

I set up Galera Cluster on 3 nodes. It works perfectly for reading data. I have done simple application to make some test on the cluster. Unfortunately I have to say that the Cluster fails totally ...
0
votes
1answer
21 views

mysqldump without SQL_BIG_SELECTS

Trying to dump all databases for replication creation using mysqldump --all-databases --master-data --single-transaction > all_databases.sql Results in the following error mysqldump: ...
0
votes
1answer
63 views

Ubuntu apache process consuming 100% cpu PHP/MySQL app

I have a server at Rackspace connecting to a Cloud DB instance running MySQL. I'm not a server admin so I apologize for not having enough data. I'm having a hard time determining what is causing my ...
0
votes
1answer
67 views

why won't mysql accept connections from local programs?

I am getting a "Host 'mydomain.com' is not allowed to connect to this MariaDB server" error whenever a program on my CentOS 7 server tries to access the MySQL/MariaDB database located on the same ...
-1
votes
1answer
13 views

Is there any way to backup all mysqldatabses in single file

Usually i have cron job to dump separate databases in separate sql file and then i can restore it. Is there any way , any command so that i run as cron job everynight and i have single file which i ...
2
votes
1answer
4k views

MySQL high CPU usage on small website

I have a small website hosted on a dedicated server (FreeBSD 9.2, MySQL 5.6.1 and php 5.5.5). The problem is that MySQL eats a lot of cpu resources even if the website have a few visitors. The ...
0
votes
0answers
93 views

Google Cloud SQL - Lost connection and Timeout errors

I keep getting the following errors when attempting a simple connection to a Google Cloud SQL database instance from a PHP script. Lost connection to MySQL server at 'reading initial communication ...
-1
votes
0answers
9 views

MYSQL : unable to add privileges to newly created user [migrated]

I am just trying out Google Cloud SQL. Created a SQL server and white-listed one of my IPs to connect to it. I am able to connect as root@'%' there and do everything I wish, other than granting ...
0
votes
0answers
43 views

Wordpress on Apache - Pageload Increased up to 30 Sec. - How to Debug?

I running a Wordpress Theme on a Google Compute Engine with Cloud SQL and Apache2 (W3 Total Cache which is off at the Moment). Actually no Visitors than me because it´s in development. The Problem ...
-1
votes
0answers
15 views

mysql return true when int = 1 [migrated]

this seems a simple question, but i cannot find the awnser. I want to save a true/false in my mySQL database. So i'm saving 1/0 in a INT column. When i select this i get the 1/0, but i want it to ...
0
votes
1answer
43 views

MariaDB Galera SST Fails

I am running a 3 node MariaDB 10 Galera Cluster on CentOS 6. I have use this set-up before without issue else where but now when adding a 3rd node the SST fails with this error in the logs: 150212 ...
0
votes
0answers
25 views

MySql server keep crashing inside docker

I am running mysql inside docker with its /var/lib/mysql mounted on HOST. Eveything was working fine . Then i upgraded the docker from 1.4 to 1.5 . I rebuild the mysql image and but /var/lib/mysql ...
0
votes
1answer
55 views

Mysql replication lags

I am 2 slaves and 1 master on aws, 1 slave is already in sync with master but 2nd slave create huge slave lg behind, after investigation i found , this slave create numerous relay log in Kb's but ...
0
votes
1answer
87 views

CentOS 7 : cannot create mysql.sock

I've installed MySQL on CentOS 7. It looks fine, start mysqld service and change root password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) ...
0
votes
1answer
2k views

installing mysql5.6.12 in ubuntu 12.10 error:/etc/mysql/conf.d is missing

I am trying to install mysql in ubuntu 12.10. Downloaded 'MySQL-5.6.12-1.linux_glibc2.5.i386.rpm-bundle' from http://dev.mysql.com/downloads/mysql/. Extracted it and tried to install using rpm -i ...
2
votes
1answer
46 views

Sending Data extremely slow or RDS

I have the following two profiles for a basic SELECT STATEMENT: select count(*) from mturk_completion; Here are the two profiles: # My Local machine, using a local db Status ...
0
votes
0answers
36 views

Yet another “Can't connect to local MySQL server through socket” after a security update

SOLVED As yoonix pointed out, it was only an issue with the root partition being full... Thanks for your help! - So yes, this question has been asked several times, here and elsewhere. I apologize ...
2
votes
1answer
1k views

mysql becomes unresponsive at same time every day

My server goes down every day at same time. I found that the issue was due to mysql. I tried show processlist; and found that data base was entering in to sleep mode. I saw there was so many inserts ...
0
votes
2answers
193 views

Getting \r\n newlines to display properly in Mantis database

I've exported a Mantis project from one server to another and despite the MySQL SQL file (from which it was populated) showing: (15375,'\r\n1. Log out\r\n\r\n2. When logging in, start ... The final ...
1
vote
1answer
431 views

mysql won't run from command line

When trying to run the /etc/bin/mysql command from the command line, I'm returned to the prompt without any action. Restarting mysql via /etc/init.d/mysql restart shows the following error during the ...