MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
1answer
370 views

innodb completely crashed after interruption

I am having a major crash on mysql affecting a lot of websites. We had a crash on our SAN storage. Since that time, mysql refuse to start. I tried to reinstall mysql, but still no luck. I think ...
0
votes
0answers
13 views

mysql - innodb - crashed - mysql cannot start - please help asap! :) [duplicate]

I am having a major crash on mysql affecting a lot of websites. We had a crash on our SAN storage. Since that time, mysql refuse to start. I tried to reinstall mysql, but still no luck. I think ...
1
vote
1answer
202 views

How to force MySQL Workbench to use constraints in my file?

I'm currently working on a project that requires I write my own constraints for my database (to show I know how they work). I'm attempting to test them in MySQL Workbench however the programs settings ...
2
votes
2answers
221 views

MySQL nested queries

I'm working on a project using a MySQL database and we'd like to combine a query which was previously made in several steps into one step. The queries are created in a Java-App using Hibernate. Goal ...
1
vote
0answers
903 views

Error when syncing MySQL database (XAMPP) on Dropbox

I'm working on a MySQL database for local development using XAMPP, and I would like to work on two different computers. Looking online, I saw this link that gives a tutorial on syncing your database ...
3
votes
1answer
406 views

When interrupting a query on a Master, does it replicate to the Slave?

In MySQL, when does the master send a query to the slaves? Here's a specific scenario that I'm trying to understand. Admin entered an update on master that took a long time to execute. Admin hits ...
0
votes
1answer
30 views

MySQL still seems to be establishing a connection even when access is denied, causing aborted connects and instability

Lately the server's been going a bit haywire and we've spent several weeks chasing down leads to no avail. All we can tell is that when the websites go down (and come back up, and go down, and come ...
0
votes
1answer
55 views

How to optimise very simple query with subquery that only needs to execute once

SELECT products_id, products_model, products_iban_no, products_allocation_number FROM products WHERE products_model IN (SELECT products_model FROM products GROUP BY products_model HAVING ...
0
votes
1answer
624 views

Split MySql table into two tables with One to many Relationship

I have an old database table in MySql. It is used to store the orders from online ecommerce. Simplified diagram looks like this: +----+------+-----------------------+-------+--------------+ | id | ...
0
votes
1answer
146 views

Mysql: How can i make a host show up by hostname in 'show processlist' rather than by IP address

THought this might be something controlled via rdns but updated that and still getting connections for a couple machines showing in 'show processlist' as the ip address (and port) rather than hostname ...
0
votes
1answer
1k views

How to configure my.cnf for Mysql 5.1, which is using too much CPU?

I am new Database engineer. I am having trouble in my server which is using too much CPU on database query(simple count statement). I have googled about it, so i found out it depends on system ...
1
vote
0answers
35 views

How to update all primary keys in the existing database

I'm moving mysql multi-master replication to production using tungsten. I had setup the auto increment and offset values in my.cnf file. To achieve this i'll have to update my all primary keys of all ...
1
vote
2answers
2k views

Only “grant usage”, but can still select, drop, create?

I have a mysql user (I'll call) "user5" who only has "grant usage" (i.e. no privileges) in the output of "show grants", but can still do a select on database "app_db" (which is what I want, but I do ...
1
vote
1answer
199 views

percona xtrabackup to backup mysql database

I'm trying to use percona xtrabackup to backup a mysql database. in the restoring the database according to the documentation: rsync -avrP /data/backup/ /var/lib/mysql/ this will copy the ibdata1 ...
0
votes
0answers
40 views

Normalization of irregular relations?

I have two tables in MySQL: The orders table CREATE TABLE `orders` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `transaction_id` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `task_id` ...
20
votes
6answers
2k views

Count where two or more columns in a row are over a certain value [basketball, double double, triple double]

I play a basketball game which allows to output its statistics as a database file, so one can calculate statistics from it that are not implemented in the game. So far I've had no problem caluclating ...
1
vote
1answer
329 views

Cannot execute statement: impossible to write to binary log?

When I try to create a user story/issue in my my percona xtradb cluster I am getting below error. How to fix it? Error creating issue: Could not create workflow instance: root cause: while ...
1
vote
2answers
383 views

MySQL Database replication for high availability

configuration: 1 balancer 2 Azure machines(4 gb ram, 2 cores), with MySQL master-master replication enabled. X users connecting to the balancer to sync data. test: i've tested the MySQL ...
5
votes
3answers
154 views

Find the user with closest taste of mine

I trying to write in SQL the following requirement: Each user can rate as much films as they like. (1= I don't like, 5=I love it) And the system should provide to the current user a list of films ...
1
vote
1answer
460 views

Is there a product to auto-build indexes based on slow queries?

I'm looking to either find, purchase, or write a script to identify slow queries, identify potential missing indexes, and when needed create the appropriate index within a reasonable amount of time of ...
0
votes
1answer
49 views

How To Prevent Replication Failure

If I become a MySQL DBA, will I had to deal all day with those kind of issues or do you have tips to prevent from breaking the whole replication? I received this message because I removed manually ...
1
vote
1answer
22 views

CREATE TABLE not issued on other masters

Database is created on all multi masters. Why CREATE TABLE doesn't being replicated to other masters. some explanations?
1
vote
1answer
79 views

MySQL from table to table data transfer

I've got some problem with my MySQL. I have the database with many many data. Well, there is only one table actually with huge ammount of data, over 1 billion rows. For some reasons I need to create ...
0
votes
1answer
454 views

phpmyadmin not working after mysql update

i followed this guide to update my mysql form 5.1 to 5.5. After lots and lots of command and headache, i was able to upgrade mysql. i checked the version via terminal. But now there is another ...
0
votes
1answer
64 views

Save dataset within another table best practice

I want to save one dataset within another table, this dataset should be persistent. For example Table1: FIELDS (A,B,C) Table2: FIELDS (D, DuplicateTable1) I can think of 2 possiblities: Have ...
0
votes
1answer
3k views

Innodb: Operating System Error number 5 in MySQL

I am trying to retrieve the data from MySQL ibd file but facing following error. 140601 17:00:45 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated ...
0
votes
1answer
1k views

#1044 - Access denied for user '#username'@'10.%' to database '#database'

I'm trying to connect my webpage to mySQL with ipage hosting. When I copy the snippet: <?php $link = mysql_connect('username.ipagemysql.com', 'username for mySQL', 'password for mySQL'); if ...
1
vote
1answer
821 views

MySQL Master-Master Replication not syncing

SETUP: I have a WAMP MySQL Master-Master replication setup on 2 machines with sync_binlog=1 for safety. Machine config: Windows Azure Standard 2: 2 core, 4GB RAM, Windows Server 2008, MySQL 5.6.12, ...
1
vote
2answers
105 views

how to use an index on a mysql query with a where clause and a order by

I have a table CREATE TABLE activity ( id INT(10) UNSIGNED AUTO_INCREMENT, subscriberid INT(10) UNSIGNED NOT NULL DEFAULT '0', action VARCHAR(250) NOT NULL DEFAULT '', ip INT(10) UNSIGNED NOT ...
0
votes
0answers
117 views

CREATE VIEW joining two tables, only displaying rows from the first table with the most recent date in the second table

I have multiple tables. My main table has a composite key consisting of a phone number and an order number. I want to create a VIEW where only the subscriptions with the most recent order date are ...
2
votes
1answer
261 views

Mysql database in a symlink-ed directory gives ERROR 1005 (errorno: 13)

I've the need to put my database outside the default datadir of mysql. To achieve that I followed the symlink guidance in the mysql documentation. However when I use the db if I try to create a ...
0
votes
0answers
196 views

Upgrading MySql 5.1 to MySql 5.5

I followed a tutorial to update My MySql 5.1 to 5.5 (actually i wanted to upgrade to 5.6, but the tutorial mentioned that i should upgrade to 5.5 first and then to 5.6). However, after removing ...
0
votes
0answers
53 views

Upgrading MySql 5.1 to MySql 5.5

I followed a tutorial to update My MySql 5.1 to 5.5 (actually i wanted to upgrade to 5.6, but the tutorial mentioned that i should upgrade to 5.5 first and then to 5.6). However, after removing ...
0
votes
1answer
37 views

MySQL - Bin folder [closed]

I'm trying to learn all the binary files inside the mysql bin folder,but unfortunately I couldn't able to find the detailed explanation of these.So please tell me the procedure to have good knowledge ...
0
votes
0answers
27 views

MySql cannot get started after increasing buffer_pool_size and log_file_size in my.ini

I try to change buffer_pool_size to 256 MB and log_file_size to 64 MB in my configuration file. After the changes made, I was unable to start MySQL service. System RAM size is (1.99 GB usable)4 GB. ...
1
vote
0answers
40 views

Need help in optimizing a Slow Query

I am using userpoints module to provide points for different actions that they do on my site. mysql> desc userpoints; +-------------+---------+------+-----+---------+----------------+ | Field ...
2
votes
1answer
128 views

Why am I getting different results from a query vs. a view

The base problem I'm facing is that I need the latest record for each item. A little setup... MySQL 5.6.14. I need to create two views (because MySQL won't let me have a subquery in a view). My ...
-5
votes
2answers
89 views

MySQL stores 0.00 as 0? [closed]

How can we store 0.00. The column is of float datatype. It automatically converts 0.00 to 0
0
votes
0answers
21 views

MySQL crashes frequently [duplicate]

I am facing frequent MySQL crash problem. Not sure how to fix the problem. Attaching the mysql error log. How can I improve the performance? Suggest me a solution. Server Config Digitalocean SSD ...
2
votes
1answer
2k views

MySQL crashes frequently

I am facing frequent MySQL crash problem. Not sure how to fix the problem. Attaching the mysql error log. Suggest me a solution. Server Config Digitalocean SSD server 1GB RAM CentOS 6.5 64-bit ...
1
vote
1answer
562 views

MySQL slave database wont start

I have a MySQL master slave configuration and the slave is not working anymore. When trying to stop and start again the slave db, I am getting this error: 140530 14:21:23 [Warning] Slave I/O: ...
0
votes
0answers
161 views

Mysql DB recovery

Mistakenly I have deleted "ibdata1" file in mysql server. Now my database is not working. All the tables are corrupted. But still I have "ib_logfile0" and "ib_logfile1" files.Also I have a recent ...
0
votes
1answer
4k views

Moving mysql datadir cause info: checking for tables which need an upgrade

So after moving the data directory to another partition, I get this error: [info] checking for tables which need an upgrade, are corrupt or were not closed cleanly. This is on Debian 7.5. The ...
1
vote
1answer
136 views

Mysql 5.6.17 drop large table locks the server for minutes

We run Mysql 5.6.17. Dropping a large InnoDB table 10GB caused the whole server to lock for about 40 seconds. We have 55GB innodb buffer pool size. I read bunch of old bugs that could be the source ...
0
votes
2answers
69 views

Which database for survey app [closed]

I need to build a very simple mobile survey app. The app will ask for different questions where people can give one of 3 possible answers, which will be always "yes", "no" or "maybe". To save ...
0
votes
0answers
1k views

mysql takes too long on “checking permissions”

We have about 20 databases with about 8000 tables each. Modifying the software is not an option (it is bought), and it seems most of the cpu is consumed by "checking permissions". While the s/w ...
0
votes
0answers
186 views

MySQL: after query optimization the CPU is still over 100%

my first time here! First of all I want to say that I'm not a DBA and I have a very little experience with MySQL but I like to study and understand what I'm doing. I have a virtual machine (2gb RAM, ...
0
votes
1answer
546 views

Insert into a view derived from a table with a discriminator field

I am in a situation in which I have a base table with some fields and a discriminator field which could have one out of a specific set of values. From that base table, I have derived many views, one ...
0
votes
0answers
61 views

Mysql database recovery in linux

Is there anyway to get back database if I deleted database. Is mysql creates temp file which contain temporary data from database and whether I can recover from that Edited: cp my.cnf my.cnf41 mv ...
0
votes
1answer
91 views

Can queries containing deterministic user defined functions be cached in mysql query cache?

According to the mysql 5.6 docs: A query also is not cached under these conditions: ... It refers to user-defined functions (UDFs) or stored functions. However, I have seen claims that if ...