All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.

learn more… | top users | synonyms

0
votes
0answers
44 views

Partial restore of InnoDB from snapshot

We currently run a mix of MyISAM and InnoDB tables on an older version of MySQL. ZFS is used as the filesystem which allows us to take instant snapshots of mysql data. One useful case for this has ...
0
votes
0answers
17 views

Can MySQL walk through the files of a directory?

Like the title says: can MySQL (alone, i.e. without C or Python) walk through the files of a directory? Or can you only do this through an API? Sorry for the dumb question. Total noob here and I ...
0
votes
0answers
26 views

Mysql replication to empty db

I had a db master/slave setup that had hardware break on the slave. Now the server is backup I reinstalled mysql and setup replication the issue being backups are off. Is there a way to start mysql ...
0
votes
0answers
71 views

nbsp character might not be passing as nbsp to the MySQL backend

I am following a tutorial where a web application written in PHP, blacklists spaces from the input(The 'id' parameter). The task is to add other characters, which essentially bypasses this blacklist, ...
0
votes
0answers
123 views

MySQL log tables design

I have to make 25 modification historic tables from 26 tables. I need a design for each table that could grow more than 75,000,000 of rows. I use InnoDB for 25 tables and 1 with MyISAM. I have one ...
0
votes
0answers
89 views

Syntax error when creating SCHEMABINDING view

I am trying to implement full text search in laravel 4, with mysql database. To implement full text search I need to create indexed view. When I am trying to create view with schemabinding i am ...
0
votes
0answers
42 views

Database migration stops halfway through

I've had issues trying to use PostgreSQL so changed my application to use MYSQL. But, when I run rake db:migrate I get the following message before the migration stops: -- PostgreSQL database ...
0
votes
0answers
179 views

MySQL queries waiting for table lock

Today I had some weird behaviour on my MySQL server that I couldn't explain. Hopefully someone can give me some debugging hints. The initial problem was that some parts of our webshop didn't seem to ...
0
votes
0answers
32 views

Toad for Mysql gives error on Compare

I've posted this message on Toad World looking for help but no one has answered. So I'm trying here. I repeatedly get the same error while using any of the Compare options when connecting to a ...
0
votes
0answers
30 views

Amazon RDS Read Replica

I would like to know, is the Read Replica is nothing but the slave server, where only reads are there. I created two mysql instances in amazon RDS, one is Read Master, and another is Read Replica. ...
0
votes
0answers
28 views

mysql 5.5 statement based to rds mysql mixed replication

I am moving to rds mysql 5.6 that has by default mixed replication. I am moving from 5.5 where I have statement based replication. I was wondering if i enable replication between them i.e make rds ...
0
votes
0answers
75 views

Is there an equivalent in postgresql to MySQL's “safe update mode” or “safe delete mode”?

Is there a configuration or flag in PostgreSQL I can turn on to disable bulk updates and bulk deletes, similar to MySQL's "safe update mode" or "safe delete mode"?
0
votes
0answers
113 views

MySql stored procedures are not atomic (JDBC)?

I have a stored procedure with one UPDATE and one INSERT in its body. I call the SP with a single executeQuery(...) wrapped within a try-with-resources. The DB connection is set (by default) to ...
0
votes
0answers
46 views

How to retrive deletes Mysql table data back?

I accidently delete data from mysql but i want it back. I am fedora operating system is use for installing Mysql. Please help ASAP because data is very critical
0
votes
0answers
100 views

MySQL - high CPU usage (MyISAm tables) in LAMP

I have a LMAP stack running on Centos 6.6. Here is the detail which may help. # cat /etc/redhat-release CentOS release 6.6 (Final) MySql version # rpm -qa | grep -i mysql ...
0
votes
0answers
157 views

How can i add index in MYSQL stored procedure?

I can not use alter table () on my stored procedure i don't have a permission to do that in the big database data_pro. How can i use index in my stored procedure for my 2 fields in where condition? ...
0
votes
0answers
154 views

Design database schema for membership application with fees and purchases

My membership application needs to record payment of membership fee, card fee and misc. fee for each member. I also need to record purchases of each members and payments for the purchases.
0
votes
0answers
61 views

Mysql Full Text Search with word delimiter

I have the following paragraph, Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. <h1>Methodology</h1> Lorem ...
0
votes
0answers
37 views

migrating MYSQL 5.5 to percona xtradb cluster 5.6

if we have to migrate MYSQL 5.5 using statement based replication to percona xtradb 5.6 would that be possible. What we want to do is to make percona xtradb cluster a slave of our current MYSQL and ...
0
votes
0answers
137 views

How to make search faster using LIKE in mysql with over 3m row?

I looking for a solution to solve this. Any idea help me plz? My table over 3m record Data in search column like '0123456789' => cannot use Full Text Search. I try put innodb_buffer_pool higher ...
0
votes
0answers
128 views

Should innodb_buffer_pool_size be much larger than the innodb_buffer_pool_bytes_data?

Our old server had 32GB total RAM, 18GB allocated to innodb_buffer_pool_size. It also had 10GB for the php_memory_limit. The new one had 16GB RAM, 9GB for innodb, 5GB for php. The same application ...
0
votes
0answers
98 views

Query EXPLAINed differently on MySQL 5.6 (or Amazon RDS) and is very slow

I have the following query: SELECT ld.idDataAttribute AS idDataAttribute, ld.instance AS instance FROM logs l INNER JOIN logData ld ON l.idLog = ld.idLog INNER JOIN dataAttributes da ON ...
0
votes
0answers
44 views

Does galera cluster works in thecloud (Azure IAAS)

We are moving our infrastructure into the cloud (Microsoft) Our current MySQL master-Slave environments will be moved as Infrastructure as a service. At the same time I have been asked to look to ...
0
votes
0answers
83 views

Replicating from MySQL 5.1 master to 5.6 slave failing because 'INSERT … VALUES (NOW())' results in 'Error_code: 1062'

I am migrating away from some old MySQL 5.1 servers to some new MySQL 5.6 servers. During this process, I'm creating a new MySQL 5.6 slave from an existing MySQL 5.1 slave, using the procedure in the ...
0
votes
0answers
13 views

Pat_ID Incrementing by 2 only after close

I am working on an internal project connecting my database to my application. I am using C# to write the program. I am still learning and this is more of a training tool than anything else. When the ...
0
votes
0answers
597 views

How to make search faster in mysql DB with > 2m records, only numbers

I have a table with sim card data with over 2m-3m records. The design is a column sim_number = varchar(11) with data like number (0123456891) When the table is under 1m records it's still fast but ...
0
votes
0answers
23 views

is it possible to get the lost data deleted from rails console?

The command I ran in rails console is Product.delete_all("id > 44 AND id < 51") Is there any way to get the records back? Thanks
0
votes
0answers
61 views

Innobackupex restore steps from 1 incremental and multiple incremental steps

My current backup plan is: Full -> Incremental1 based on full -> incremental2 based on incremental1 -> incremental3 based on incremental2... Please validate if this steps is correct during emergency ...
0
votes
0answers
79 views

pt-online-schema-change with statement based replication in MYSQL

Is it possible/safe to use pt-online-schema-change in a Master slave environment where as the way replication is setup is statement based(SBR). What is the better way of doing it as currently I have ...
0
votes
0answers
26 views

MySQL 5.6 or 5.7 sharding geospatial data

I have ran into a problem where I need to start to scale horizontally. With my database I am performing only nearest point searches with my data. So from a lat/long inoput I find all the nearest ...
0
votes
0answers
38 views

Get last updated date and group by in mysql

trans_id | item_id | price | last_updated 01 |001 | 100 | 2015-01-01 02 |002 | 200 | 2015-01-02 03 |001 | 150 | 2015-01-03 03 |003 | 200 | ...
0
votes
0answers
21 views

Mysql database name

My Mysql version is Server version: 5.6.19-0ubuntu0.14.04.1 (Ubuntu) I have two databases, with a test table in each database. I can run the following select statement in one db, but not the other. ...
0
votes
0answers
32 views

subquery in set clause retrieving different values

I want to update the column "kstplcode" using different values coming from column warehouse except the value "main" with their corresponding delivery numbers. I've tried this code but the set clause ...
0
votes
0answers
58 views

Column based replication in mysql 5.6

I want to do column based replication which means: In my server, I have table T1 in which columns are A, B, C, D, E I want to replicate this table on different server in mysql 5.6 only, but with ...
0
votes
0answers
46 views

Index pages in innodb file when innodb_file_per_table = ON

I have MySQL 5.5, and innodb_file_per_table was always in config file. After some time of using MySQL DB was produced big ibdata1 file, but i don't know how explain why this file is so big, i try to ...
0
votes
0answers
226 views

PostgreSQL -> MySQL Migration with MySQLWorkbench

I'm trying to migrate data from a PostgreSQL DB to a MySQL DB (it's for permissions in the VPC, so please nobody link me the 'choose-something-else'). I'm getting this error from MySQL Workbench when ...
0
votes
0answers
24 views

mysql Function not picking up parameter

I have written the following function: DECLARE thetotal INTEGER; select count(stock_current.EntryNo) INTO thetotal FROM stock_current WHERE (stock_current.PartNo = thepart) AND ...
0
votes
0answers
65 views

Benefits of compressed MySQL tables on INSERT-only workload?

We have a MySQL table that is 18gb of email record blobs (the text of every email sent stored in a blob). There are several million records and each one is about 5kb. The only operation on the table ...
0
votes
0answers
124 views

MySQL: Replication is paused with both threads running, System Lock in ProcessList

I have just set up Master Slave replication from a MariaDB EC2 instance to a MySQL RDS instance. What can I do? The Seconds_Behind_Master are increasing, never decreasing. Slave_IO_State Waiting ...
0
votes
0answers
42 views

making everything varchar on purpose, though some fields should be int

I'm writing a PHP website for some clients which parses excel, stores the value in a database and then retrieves them. Some fields are only integers, but the clients can't make up their minds, they ...
0
votes
0answers
145 views

MySQL Workbench error: Attribute error 'nonetype' object has no attribute 'parameterValues'

I am trying to export a database but i don't have access to "server administrator" at all... everytime i try to do something from Server administration i get the message mentioned in the title. What ...
0
votes
0answers
405 views

MySQL Transaction with rollback upon @@error

I have done several transactions with MySQL but mainly using php's libraries as the handle. Using php you would have something as: $pdo->beginTransaction(); $pdo->execute(' query1; ...
0
votes
0answers
47 views

Update a field in table when a combination of three fields with a second table is matched

I have a database form an old archaeological project which I imported into a mysql DB. I have a table "graves" with 400+ entries: "graves" id necr burials single multi 1 1 1 ...
0
votes
0answers
72 views

Role based access control protocol for resources in mysql database

I have a mysql database for an application which contains users and resources, like for example books, movies, tv-shows and music. Users should be able to view and edit specific entries of this ...
0
votes
0answers
62 views

DB Design for Mobile App Clients

Hello I am new to designing DB for Mobile App where speed is the Key. My Mobile App will request to WebAPI and WebAPI will get data from MySQL. I have designed my tables in MySQL as per relational ...
0
votes
0answers
216 views

Ideas for Database schema for Automotive web app

For the last couple of days I have been searching all over Google for database schema for my automotive web application [like a marketplace of sort] (in Laravel 5 PHP). I have tried many models some ...
0
votes
0answers
55 views

Outer left join with WHERE loses row

The line below MUST be in query or the null rows when joining are dropped. Why is this? //If I don't add this line; I lose rows where items.name IS NULL $this->db->or_where('items.name ...
0
votes
0answers
132 views

MySql Innodb Database Slow INSERT Query to Remote Server

I have searched thoroughly on how to improve general performance of my database which is hosted on Hostgator. I have mostly come across performance tuning strategies which are catered to only local or ...
0
votes
0answers
67 views

how to do a backup and restore for a single database with mysql enterprise backup

I am Chinese, the documentation of mysql enterprise backup is hard to understand for me, and now I need to finish my job quickly, I wonder is that possible to backup a single database and restore it ...
0
votes
0answers
31 views

hashed password retrieval in mysql

here I am again with the next question! I hash a password as follows: mysalt=os.urandom(12).encode('hex') passhash =mysalt + pw hash =str( pbkdf2_sha256.encrypt(passhash)) How can I verify this ...