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

4
votes
1answer
19 views

Checking for fields not on SET clause on before update trigger on MySQL

I want to set a before update trigger that sets a column to a given value if an update query is done and that column has no new value on the set clause. The table I'm using. (Sort of) DROP TABLE IF ...
0
votes
0answers
30 views

MySQL Errror “Cannot Connect Invalid Settings”

I was working with mysql using phpmyadmin on a local server and when I clicked on a table it took a very long time to do anything so I let it do its thing, I walked away and when I came back I had the ...
0
votes
0answers
8 views

mysqlworkbench nasty result grid with text columns

On MySQL Workbench 6.3, when you query a table with text columns that have carrier return \n in it, the Result Grid expands record's height accordingly. In the image, I've reduced the height of the ...
1
vote
2answers
27 views

Interested in counting number of threshold crossings

I would like to determine the number of times that a value has crossed a threshold in either direction in a specified time frame. As an example, lets say that I am interested in the number of times ...
0
votes
2answers
33 views

Spanish characters saved incorrect in Mysql

I have googled this already, but I couldn't find what's wrong in my situation. I have a wordpress site that has a lot of non-english users which type in words such as "español" it is printed ...
1
vote
0answers
46 views

Is there a way to throttle MySQL requests to mitigate DoS traffic?

I've a server with ~200 wordpress websites hosted. When Google Favicon bot pays us a visit it searches all the sites indexed on our IP, that means it's requesting ~200 favicons. Most of the sites ...
1
vote
1answer
40 views

Mixed based replication between two databases on the same server

I have two apps with a current configuration as follows: App1 DB on server A/MySQL Instance A App2 DB on server B/MySQL Instance B Students can apply for internship using App1 and those ...
1
vote
0answers
55 views

MySQL 5.6 Performance Tuning Issue

I have read and try lots of things about MySQL optimization and tuning. I tried most of them one by one according to our needs but nearly I got nothing. I am doing my test using some simulation ...
1
vote
1answer
41 views

MySQL Database Instance size

We found 3 different size of a MySQL Database Instance as follows: Mysqldump output Data directory size (even if we exclude size of bin-logs,error-logs) SUM (data_length + index_length ) ...
3
votes
1answer
32 views

Passing multiple value for a parameter in my sql

I have written the query below: SET @City = 'London,Lyon,Kln'; SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(@City, ',',@r:=@r+1),',',-1) City FROM (SELECT @r:=0) x, (SELECT 'x' xx UNION SELECT ...
1
vote
1answer
42 views

Does varchar(n) affect the number of records which can be stored per page even if you store less than n?

I'm struggling to find enough documentation to help me answer my own question. The common story seems to be that it doesn't make a difference to actual database size when you use a much higher value ...
0
votes
2answers
28 views

ulimit 'open files' and MySQL max_connection

When running mysql on SSD, does max_connections, if set more than the kernel's ulimit open files, be limited to the kernel's limit? My understanding is that if the kernel's ulimit open files is 1024 ...
1
vote
1answer
42 views

How do I stop tables from being created in my mysql database?

I have noticed recently that some tables are being created in my mysql database by a rogue process. These tables typically have six letters followed by 32 (e.g. ernidt32). They just have one column ...
2
votes
1answer
56 views

Can I use an index to optimize select clause, versus where clause?

I'm not sure if this question has been answered, because I'm not sure of the proper wording to describe what I need. So here it is: I am trying to optimize a database that is running very slowly, ...
0
votes
0answers
27 views

Access a remote mysql from a remote node application

I'm approaching MySQL for the first time in life. I have a machine with a MySQL and Wordpress environment correctly working (let's say at 1.1.3.4) but I want to access it from a remote node.js ...
2
votes
2answers
47 views

Is better to create a table for each room or make a single table that handles all the rooms in my case?

I need to make a server-side for iOS and android application that does something similar to chat(Is not really a chat), and I'm a PHP and MYSQL newbie. The process is that 2 users join a room and do ...
-1
votes
0answers
14 views

Discriminating rows where column start and/or end with dots

I have a table where rows are stored as follow: # id alias_desc state 1 3 Alison a 2 4 Alison. a 3 5 Alizon a 4 6 Alizon. a 5 7 Amada a 6 8 Amada. ...
1
vote
1answer
28 views

Where does MySQL's “show slave status” information come from?

two files "master.info" and "relay-log.info" were deleted after I "reset slave" I want to know why slave information still exists ~ confused >_< I think it shouldn't display any message about ...
2
votes
3answers
65 views

Remove duplicates in sequence based on keys

I am looking to remove duplicates on a row by row comparison based on keys Member and Group and data sorted ASC on Member, Group and StartDate. Just return the records in the select query and not ...
-2
votes
0answers
13 views

why database show vulnerable column when i give a wrong parameter in query? [closed]

When we try for inject a website for find vulnerable column then sometimes we need to give a wrong value in the website parameter. Like www.vhul-web.com/index.php?id=1 union select 1,2,3 -- - Now ...
1
vote
0answers
36 views

InnoDB AUTO_INCREMENT resetting itself without MySQL restart

We've recently noticed the following scenario happening in many of our databases: A record is inserted, and receives an AUTO_INCREMENT primary key. The record is deleted. Another record is inserted, ...
0
votes
0answers
32 views

Replication Error_code: 1032

I an unable to fix this as I don't know what cause this error. Replication was stoped for maintenance activity and after completing the maintenance we started it and then after some point the ...
0
votes
1answer
14 views

Does Mysql locks table while insert operation

I am using Mysql(INNODB) and does Mysql locks table when I do some insert operation? I have a huge table and it has lots of indexes. I do some research and Mysql doc says INNODB only locks rows not ...
1
vote
1answer
31 views

Design database -

I want to create database. I have two kind of clients which admins and employee should communicate with them ; Customers and Manager. I'm not sure about which place employee's place on database. is ...
0
votes
1answer
29 views

Recover lost MySQL password

I hate to ask a stupid question like forgetting the password, but this one is really hard to get back. Tried all the methods I can find online, and none is working. Even deleting the database requires ...
0
votes
1answer
23 views

MySQL: Enabling innodb_undo_tablespaces

We recently tried setting innodb_undo_tablespaces=2 for our mysql 5.7 server. But during the restart the server returned with: [ERROR] InnoDB: Expected to open 2 undo tablespaces but was able to ...
0
votes
0answers
2 views

What are the minimal MySQL grants for the debian-sys-maint user?

What are the minimal privileges that debian-sys-maint@localhost needs for the mysql service to work correctly? This answer on ServerFault suggests granting RELOAD only, but this is incorrect, as it ...
0
votes
0answers
18 views

Seeking Alternative To TEMPORARY Table For Limited Permissions [closed]

The following query is valid but I do not have permission to create tables. I am seeking an alternative with equivalent results. CREATE TEMPORARY TABLE temp_id(temp_name VARCHAR(50),id INT); INSERT ...
0
votes
2answers
29 views

Migrate MySQL tables to new server with same tables already on it?

We migrated our web server to a newer server. We have the old and new both running while we do testing on the new one. The old one is still being used in production by our clients and internal staff ...
0
votes
0answers
12 views

MYSQL hangs in sending data state

I have MySQL query which hangs in sending data phase. When analyzing slow query logs Rows_sent: 176975081 Rows_examined: 408406766 These numbers of rows are greater than the number of rows ...
0
votes
1answer
42 views

Index on integer and string fields

A table has about 300M records. Each has an unique ID that starts with 13 to 14 digits (with the first digit on the left being either 1 or 2), and is optionally followed by a string of up to 7 ASCII ...
0
votes
1answer
19 views

Mariadb uses all /tmp space

I am running a galera cluster with mariadb 10. One of my node report 100% usage disk for /tmp table. /dev/mapper/vg0-LV--Tmp 1,8G 1,7G 228K 100% /tmp I can't see files in /tmp with ls ...
-1
votes
0answers
27 views

Counting outdated records

I would like to know if I am able to add a subquery that will sum/count outdated ( FROM zlec ). The field that contains the date is zlec_do, and the type is datetime as such 0000-00-00 00:00:00. The ...
1
vote
1answer
30 views

MySQL 5.7 not accepting values of innodb_buffer_pool_instances greater than 1

I've been tweaking the values of the buffer pool size (innodb_buffer_pool_size) and the number of buffer pool instances (innodb_buffer_pool_instances) in the my.ini initialization file to optimize ...
0
votes
1answer
15 views

How to fix MySQL anonymous account security issue?

How to fix this security issue on MySQL? [!!] User '@localhost' is an anonymous account.
0
votes
2answers
27 views

MySQL : How do I partition based on Month of date

I have a table having id as primary key and date column. I want to partition the data.. I felt month would be the best option so that I have 12 partitions.. How do I achieve that ! I am using mysql ...
0
votes
0answers
14 views

MySQL Trigger Replication between Master and Slave

we are running a rather highly loaded MySQL Application replicating between Master and two Slave instances. We are using Statement-based replication. Recently, we have upgraded our hardware and a ...
0
votes
0answers
13 views

MySQL along with Firebase for data sync

I'm currently working on a mobile app powered by a web platform, and the mobile app will have some offline capabilities. The application has a small amount of DB entities, and only about 3 of them ...
0
votes
0answers
15 views

MySQL Enterprise Backup

Hi I've been looking for MEB version 3.12. But it seems the Oracle's eDeliver does not have this version. The available version is 4.0.xxx. I need this older version because my MySQL server version in ...
-1
votes
0answers
13 views

bonfire and codeigniter installation error [closed]

When installing bonfire i am getting below error...and even if i create this table manually then it says that incorrect timestamp 1454485603. Error Number: 1146 Table 'me.bf_ci3_sessions' doesn't ...
0
votes
2answers
32 views

How to check if a record is linked with two or more values in a left join

In MySQL, I have a table of products connected with a different table with categories. I often show the list by making a LEFT JOIN and GROUPING the results: e.g. LEFT JOIN gives me: Name | Category ...
1
vote
0answers
33 views

Does mysql's `SHOW PROCESSLIST` appreciably slow down other queries?

I'm just wondering if my measurement of the processes is affecting the speed of the processes. I was testing alternative methods of copying a database. 1.) mysqldump followed my mysql mydb < ...
0
votes
0answers
21 views

How can I restore a MySQL dump faster on Windows?

I am restoring some InnoDB and MyISAM .sql files that are on the order of GBs (ranging from 1 GB to ~ 10GBs) and they are taking a day or longer to restore. The command I am using currently is: use ...
0
votes
1answer
26 views

MySQL workbench alter table is incomplete

I have just upgraded MySQL 5.6 to 5.7 and workbench from 6.2 to 6.3.6 to have the latest and do some modelling. The upgrade went fine and the app runs perfectly but something is different and I can't ...
0
votes
0answers
13 views

Reliability of MySQL Events Table

Is there any limitation of usage of MySQL Events table. Let us say i will have 10K of entries which will be executed across 3k schemas. They all are not same time but at-least 3K events will be ...
0
votes
1answer
42 views

Copy table form MS-SQL server to MySQL, is it possible? [closed]

I have a procedure, say "proc1", inside a MS-SQL server. I would like to create a table (copy of proc1) inside a MySQL server. So far what I do is this: 1-Create a connection to MS-SQL Server 2- run ...
0
votes
1answer
31 views

Staging MySQL databases

I'm building a Web/Web service application based on a number of (MySQL) databases. The databases are all built from externally derived data from dozens to hundreds of sources. My general plan is to ...
3
votes
2answers
38 views

MySQL: Soft Delete post likes

I have implemented a like/unlike features for posts in one of my projects. The like table is normalized and has a column visible. The schema is as follows: Column Type Null Default ...
2
votes
2answers
121 views

How to get data from three different tables

This question is continuing of this issue: How to get data from two different tables? Now I need to connect the table Sessions with 2 tables: Input Downloads When I use this query with real ...
0
votes
0answers
22 views

MySQL Table Structure for Group User Permissions

I could use some assistance in restructuring the schema on mysql for more granular permissions. We have a website where for example there is data for site 1, 2, and 3. There are users A, B, and C. ...