MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
0answers
4 views

General error: 1615 Prepared statement needs to be re-prepared

I have been running into this issue every time I try and sync a medium size JSON object to my database so we can perform some reporting on it. From looking into what can cause it I have come across ...
0
votes
1answer
16 views

MySQL InnoDB log files on different location

I am using MySQL version: 5.5.38 There are following parameters that can control InnoDB log files: innodb_log_files_in_group - amount of log files in the group, by default 2. Will create 2 files ...
0
votes
1answer
22 views

Changed a user name in MySQL, but user is still able to login using previous user name

I created a user with user name user_dev. Then created a database sampledb and granted some privileges to this user on this database. Then I decided to edit username and changed it to user_local, and ...
1
vote
1answer
15 views

MATCH AGAINST one character words returns empty rows with ft_min_word_len = 1

I've set ft_min_word_len = 1 to my.cnf file, also SHOW VARIABLES LIKE 'ft_min_word%' displays ft_min_word_len as 1. Then I've reloaded all database tables and it still doesn't search for one character ...
1
vote
0answers
13 views

MySql Audit Changes from Db Admin, Security

I know that you can use triggers (before insert, update, delete) to track the changes in history tables. But this only works if the changes are made by the applications. But in some circumstance, ...
0
votes
0answers
8 views

Change MAMP to use a lower Mysql 5.1 version

I need to have the same development environment for my PHP program. My clients test server is running on Mysql 5.1 while my local is using MAMP running Mysql 5.5. How do downgrade my mysql database ...
0
votes
0answers
9 views

mysql connection requires socket flag

I'm running mysql 5.6.19 on centos 6.4. I have my /etc/my.cnf file set as the following: [client] port = 3306 socket = /data/mysql_data/mysql.sock [mysqld] bind-address = 0.0.0.0 report-host = ...
0
votes
1answer
11 views

Slow server with many access

I have a problem of slowness in a server with few tables and many changes and many data I changed the MySQL by MariaDB My server is in the digital ocean with 8 processors and 16GB of RAM, but are the ...
0
votes
1answer
6 views

Create t2 instance and connect via Wokrbench

I've created an t2 RDS instance inside a VPC. The instance is set to Publicly avaiable: No. I wasn't able to connect to the instance using MySQL Workbench. Is there an option to connect to the ...
0
votes
0answers
17 views

Never ending count(*) on a table after upgrading to Percona 5.6.16

I had a 5.5 instance I was upgrading to 5.6.16. That went seemingly with out issue, take a mysqldump from the 5.5 version and source into the 5.6.16. It starts up with out error in the error log. ...
0
votes
1answer
28 views

Adding two rows in a database together based on columns [on hold]

Let's say I have rows in my database like so: A|B|Num1|Num 2 21|21857|51|1 21|21857|15|1 16173|21312|48|1 How would I write a query that would aggregate the rows that have the same A and B, and ...
0
votes
0answers
34 views

Querying MySQL, duration increases 10x fold after adding one more Join

I have a somewhat complicated query consisting of many joins on an issue tracker/project management database in MySQL. My issue is that my query was doing OK while I was in the process of building it ...
0
votes
0answers
19 views

Too much IO to MySQL InnoDB log files

I am using MySQL version: 5.5.38 I have dedicated HDD to InnoDB log files using innodb-log-group-home-dir option. atopsar -d 30 shows big load (>50%) to this HDD What can be done to increase ...
0
votes
1answer
22 views

mysql - Recovering databases from ibdata1 , .frm and .idb

I have a server running a mysql instance which crashed today. Now there are a massive amounts of tables in multiple database exceeding over 200GB stored on disk. After the server crash mysql is ...
2
votes
1answer
12 views

Percona's xtrabackup --apply-log fails with “all log files must be created at the same time”

I'm trying to figure out why applying logs on my xtrabackup files isn't working. I created a VM running MySQL 5.5.24. Then I created the sakila test database and backed it up with the following ...
0
votes
0answers
15 views

MySQL - Foreign Key Problem [duplicate]

I'm trying to get to grips with Foreign Keys in MySQL (5.6), and can't figure out why the below doesn't work: CREATE TABLE `test`.`parenttable` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, ...
0
votes
1answer
37 views

Why MySQL taking 150% CPU?

select * from information_schema.GLOBAL_STATUS; (All other values was zero) ABORTED_CLIENTS 97 ABORTED_CONNECTS 929 BINLOG_CACHE_DISK_USE 388 BINLOG_CACHE_USE 1533317 BINLOG_STMT_CACHE_USE ...
0
votes
2answers
31 views

How to resolve: Specified key was too long; max key length is 767 bytes [duplicate]

Our server is creating a lot of tables and one of them is the Lock_ table. We are using MySQL 5.5 on Percona. Also we are using utf8_general_ci and utf8. It throws the following error when creating ...
2
votes
1answer
13 views

MySqlDump's DISABLE KEYS have no effect on import

I have a follow up to my previous question regarding import speed with Inno-Tables (suprise!). Scenario I try to import some big* database dump on my local dev machine in reasonable time. We have a ...
0
votes
0answers
13 views

How to redirect a SQL command Output in shell script?

I want to run a shell script for some group of mysql commands and the result of those commands should be saved in separate o/p file. The o/p file should contains both the query and its result. ...
-1
votes
1answer
38 views

Very Slow MySql Stored Procedure

I'm working with a web app running on MySQL. It uses stored procedures for all database-related tasks. The original web app and the database were designed by another developer; I'm only maintaining it ...
1
vote
0answers
16 views

How to calculate geographic distances using MySQL

Given a MySQL table with a series of latitude and longitude points, stored as strings, how can I find the distances between each point in the table and a given point, call it "originlat, originlon" ? ...
0
votes
1answer
14 views

how to Use old mysql database after reinstall mysql in RHEL 6?

I was getting problem in starting and login mysql server so I backuped /var/lib/mysql folder and reinstalled mysql server. Now I want to use old database files like: ibdata1 and database folder ...
0
votes
1answer
32 views

Unable to delete a record in Mysql

Let's say I have table name Company with two columns cname, location. In the table I am having two records with cname |location Asmetric |Dallas Sophore |Washington on this table when I ...
1
vote
1answer
42 views

Fastest engine for Mass Updates (only updates done on table)

I have a table of 2 columns and 60 million rows. I want to update the table by incrementing one field by 1 on various different rows (This is the only type of operation that will ever be done on the ...
0
votes
2answers
28 views

How are derived table implemented in MySQL

When MySQL makes a derived table as a result of SELECT (SELECT ...) etc or SELECT * FROM a JOIN (SELECT * from B) etc or SELECT * FROM (SELECT ...) Are these derived temporary tables created ...
0
votes
1answer
17 views

Mysql enable remote connection in centos,my.cnf does not have bind-address to comment out

I am trying to make my mysql server running on centos to allow remote database connections.I am reading this article http://xmodulo.com/2012/06/how-to-allow-remote-access-to-mysql.html that says i ...
0
votes
2answers
19 views

mysql stored procedure create date plus one day but time set to 00:00:00

In a mysql stored procedure, how can i put into a date variable:- curdate()+interval 1 day but at midnight - e.g. today is 2014-09-14 13:15:23 so the variable will hold:- 2014-09-15 00:00:00 thanks
0
votes
1answer
38 views

Mysql Select vs Select SUM performance

I need to check whether the surfer has alrady voted this can be done using Method 1 Select record_num FROM table where etc etc. i.e. SELECT record_num FROM content_votes_tmp WHERE up = 1 AND ip ...
1
vote
0answers
11 views

Conversion to Barracuda/Compressed Rows Doesn't Free Disk Space

I'm currently converting large tables to the Barracuda file format. We are using file_per_table. I had one table that decreased from 4.3gb in size down to 1.8gb and we're very happy about this. ...
0
votes
1answer
28 views

Database structure for bonus system in MySQL

I have a problem with creating the structure for my database in MySQL as I'm new in creating databases. The problem is in this: there are three tables sellers, clients and bonus. Table sellers stores ...
0
votes
0answers
19 views

MySQL database autoscaling process

Is there a tool or a method for MySQL autoscaling? If the load increases then more slaves are added and if the load decreases then the number of slaves is reduced.
1
vote
1answer
42 views

How to improve this product rental schema?

I have a rental system where each product's stock item can be rented from a location and returned to a different location (think Alamo, Hertz etc.). When saving an order, first an inventory event is ...
2
votes
0answers
26 views

longitude lattitude performance

I have to store frequently (at least every min) the position (longitude, latitude) of animals in a DB, and perform for each update a search in order to determinate if ananother animal is near to it. ...
0
votes
0answers
20 views

Best practice for storing image order number in a database

I am designing a social networking website(mysql with InnoDB engine + php) where I need to store image sequence in a database. The table structure is as follows:- PicId (BIGINT, AUTO INCREMENT, PK) ...
0
votes
0answers
11 views

Control Query Time

I have a table for comments and I want users to wait 5 minutes before sending other comments. I have five columns: id, id_user_to, id_user_from, message and ,date (this is a table for comments). I ...
1
vote
1answer
44 views

MySQL - varchar length and performance

Is declaring VARCHAR size make sense for performance? Is there any difference (in speed) between VARCHAR(50) and VARCHAR(255)? Or defining length is logic/design constraint?
-2
votes
0answers
17 views

Performance suggestion tool for MySQL in windows? [on hold]

Is there any free tools for Windows which make suggestions on how to improve the MySQL database?
1
vote
1answer
77 views

Peer Review of Database Design

I'm working on a movie inventory database. This is a personal side project for me. I can use what I have, but I would like to make it the best design that I can while learning more about databases and ...
-1
votes
0answers
14 views

Slow Performance with Multi-threaded app - MySQL InnoDB

My application is a java 1.7, multi-threaded application with MySQL 5.6 as the backend. Application reads data from files and writes it to corresponding tables in multithreaded fashion. The ...
1
vote
1answer
17 views

MySQL Junction Table as Foreign Key?

I have several tables: company, customer, company_has_customer, and transaction. company_has_customer is a many-to-many junction table using the PKs of company and customer as its PK. In almost all ...
2
votes
1answer
47 views

Running a query on an improperly indexed, 600gb table

This is my first post on here and I'm really baffled by this. I have joined a team and somewhere in the past a horrific table was created which has been bloated to a point of 600+gb of data. ...
0
votes
1answer
30 views

MySQL Entity Relationship Problem - 3-way join table?

This is a db relationship question. I have a scenario which I believe I have come up with a solution - however, I can't be sure it's a manageable one, or even correct. The scenario is as follows: ...
0
votes
1answer
30 views

Efficient way to DELETE whole partition's data in table partitioned by HASH(DAY(datetime))?

I have a MySQL InnoDB table PARTITIONed by HASH(DAY(dateTime)). I'd like to remove partitions holding data older than 10 days. CREATE TABLE `partitioned` ( `id` bigint(20) unsigned NOT NULL ...
1
vote
1answer
18 views

pt-query-digest results are empty

I have a slow log generated by MySQL 5.1.71-log, that I've copied onto another machine. It appears I'm not getting any results from pt-query-digest. $> pt-query-digest slow.log # 2.1s user time, ...
0
votes
2answers
22 views

How do I fix #1062 error received while importing EE database to localhost from remote server

I am trying to import a MySQL database into the localhost database that was exported from the remote database and I am receiving a #1062 error (which is weirdly in French!): #1062 - Duplicata du ...
0
votes
1answer
27 views

column value is not increment after 10

I tried below 2 codes.... showing same error 1.SELECT columnname FROM tablename ORDER BY columnname DESC LIMIT 1 SELECT MAX(columnname ) AS max FROM tablename I am trying to increment value of ...
0
votes
1answer
20 views

Fetch data from database from multiple tables matching condition

I want to fetch data from the database. I have three tables in my database like listing_master_residential and listing_master_condo and listing_master_commercial. There are three tables and there is ...
0
votes
0answers
9 views

Have you ever used MySQLBackupFTP? [on hold]

I have found this backup program for MySQL, called MySQLBackupFTP. Have you ever used it? My main question is; does it have any problems?
0
votes
0answers
27 views

Communications link error with MySQL

I have a process which runs via Pentaho on a Unix server against MySQL 5.6.19. and using 5.1.32 of the MySQL jdbc driver. We actually found this driver helped with this error in some cases compared ...