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
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
41 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
18 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 ...
0
votes
0answers
25 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
11 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
14 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
12 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
29 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
25 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
30 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
36 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
119 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. ...
0
votes
1answer
68 views

MySQL - Compare record value against previous [closed]

Rewording my question: This is how my data looks like: Member Group Status Start_date End Date 1 2 Active 4/12/2011 11:19 NULL 1 2 Active ...
-2
votes
0answers
28 views

Guys I need lost data from master to slave after resyncing [closed]

First the replication was running fine but after some time replication got broken for 10hrs and after that i re sync to slave its running fine but what about the 10hrs data?????
0
votes
1answer
31 views

Phpmyadmin / mysql error defining primary keys as foreign keys of two separate tables

I am designing a mysql database using phpmyadmin 3.3.10.4. Everything in the database is InnoDB. I have two tables, person with primary key person.id_numberand e-mail_address with pk ...
0
votes
0answers
18 views

MySQL replication slave master [closed]

working on sync project using MySQL i'd like to replicate specific table rows from slave to multi masters What is done: Replication from masters to slave work perfectly Aiming for : Now we consider ...
1
vote
1answer
54 views

Does INFORMATION_SCHEMA always contain up-to-date metadata?

This query prints the size (in terms of data and indexes) of the tables in mydatabase: SELECT table_name "Table name", round(((data_length)/1024/1024),2) "Data size", ...
2
votes
2answers
138 views
+100

Mysql 5.5.45 crashing after refreshing web page rapidly(Too Many Connection warning)

I am using ec2 aws instance for my wordpress webiste.after every 5 to 10 minute and randomly my website going down i tried lots of things like increasing buffer memory ,memory limit but that not ...
1
vote
1answer
27 views

mysql workbench migration changed my database. Can I trust it?

I'm migrating a large production database(s) from mysql 5.5 to 5.6. Used Mysql Workbench Migration Wizard which creates a shell script to run on source and taget machines. The process worked well but ...
0
votes
1answer
34 views

MYSQL: weird bug with nested stored procedure

I have two stored procedures. The first one fetch language codes in my language table. CREATE PROCEDURE `updateCategoryNameAll` ( IN categorieNumber VARCHAR (10), IN categoryName VARCHAR (128) ) ...
3
votes
1answer
140 views

How to get data from two different tables? [closed]

I have these two MySQL tables: tab1: +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | ...
0
votes
0answers
29 views

Can we update mysql database table through .csv file And pls update not loading data from .csv [closed]

I have a mysql database table and I am updating few elements of an attribute of the table trying to do this by importing .csv and then what should be the approach as the csv file contains the updated ...
0
votes
2answers
31 views

how to insert values in a table with foreign key field

I am creating a database where I have a table with a foreign key. I am using the following command: insert into ques_bank (q_no, uid, question) values (NULL, select uid from user_info ...
1
vote
2answers
44 views

mysql query gets slower with increasing page number

I use laravel 5.2 with mariadb (ARIA engine) and found that my query for creating a gallery gets slower with increasing page number. select `pics`.`id`, `pics`.`title`, `pics`.`hits`, ...
0
votes
2answers
47 views

Error while installing MySQL on RedHat Linux

I am new to RedHat Linux and am referring to this link for the installation :https://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-repo.html I finished the first two steps and ...
1
vote
0answers
39 views

Data nodes stuck at starting

After updating the config.ini (I updated my MaxNoOfAttributes, MaxNoOfTables, MaxNoOfOrderedIndexes,etc.) on my management node and running the ndb_mgmd with --initial command. I can't seem to start ...
1
vote
0answers
18 views

implement geo / spatial / proximity search with php and mysql — what have you done successfully

For my website's users, I want to implement a worldwide geo / spatial / proximity search with php and mysql. I want to do this as simply and minimally as possible. What is the minimum data I should ...
3
votes
2answers
91 views

Tuning MySQL variables to accommodate high load

My site is generating error 500s to users when load is high ("cannot allocate memory" errors appear in my logs). I have a VPS with GoDaddy, 8GB RAM (on average only about 40% of RAM is being used at ...
0
votes
0answers
13 views

MySQL 5.6.27 keep logging ERROR : Got an error reading communication packets

I have a two nodes MySQL replication set with M1-M2 configuration. The MySQL version is 5.6.27. After deployed and the application(which is jboss 7) connected the M1 and ran few queries for ...
1
vote
2answers
26 views

Correct way to write this view? Total sales/purchases/profits by day

I'm currently trying to create a view that lists a sum of sales, purchases and profits done by each person per day. This data comes from 3 tables: transaction: idtransaction (pk) user_iduser (fk) ...
0
votes
0answers
18 views

Split data from a column into multiple rows and split data from other column into new column in MySQL

I want split data's separated by comma(,) from a column into multiple rows and also with this I want split data's from other column into multiple new columns. Finally result will insert into new ...
0
votes
0answers
34 views

Is there an equivalent of virtual columns in mysql?

Currently I'm taking a look at amazon's new aurora database and I'd like to check how my current setup performs there. The original table is on maria DB and contains a virtual column ...
0
votes
0answers
34 views

database constraint using trigger [closed]

I have modified my question as follows. I have created 3 tables as follows. create table s ( sno char(5), sname varchar(25), status int, city varchar(25), primary key(sno)); create table p ...
-1
votes
0answers
23 views

update other column in mysql table from concat and substr values from first column and variables in php [closed]

I need a help regarding this. How to Update second and third column in MySQL table from substr and concat values from first column along with variables in php. My query is: mysql_query ('UPDATE ...
0
votes
0answers
17 views

Mysql Replication break Error_code: 1032

Created new slave replication, it was working fine but suddenly after 2 days its giving me this error and the replication stopped. Both on Centos 6.7 Master Version ...
0
votes
1answer
19 views

enabling slow_query without general_log

I have been playing a bit to enable slow_query_log, i never got any results until i enabled the general_log (1), but i also get logged ALL the queries, which i do not need, and it causes a performance ...
1
vote
0answers
34 views

how to force MySQL unsafe replication warnings to throw an error

I understand that MySQL WARNING statements, with respect to replication unsafe statements, are not 100% valid. That is, if you know what you are doing, if you understand the schema, there are indeed ...
0
votes
1answer
31 views

Mysql high CPU and RAM usage

I have a mysql server which has 60gb of ram and it uses too much system resources. Top command result; Mem: 64555285k total, 64151125k used I think there is something terribly wrong with my mysql ...
0
votes
1answer
20 views

Mysql datadir and binlogs: same partition or not?

On a MySQL cluster, does it make sense to store MySQL database files and binlogs in different partitions? (This is about partitions on the same physical disk. If they were on different physical ...
2
votes
3answers
79 views

MySQL query takes over a minute to complete

I am trying to pull calls associated with website visits from our huge database... I have got SQL that works, pulls correct results it just takes over minute to complete... Here is the SQL SELECT ...
0
votes
0answers
20 views

Mysql server keeps stopping unexpectedly on centos

My mysqlserver stops periodically. 160128 8:43:20 [Note] Event Scheduler: Purging the queue. 0 events 160128 8:43:20 InnoDB: Starting shutdown... 160128 8:43:21 InnoDB: Shutdown completed; ...