MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
0answers
93 views

select sequential rows

How would I go about selecting a sequence of rows. Where every row in the sequence: Must only be 1 day apart ~ Thereby the whole sequence of rows must have sequential dates Must have a count higher ...
0
votes
0answers
60 views

Reset relay files on lagging slave after MySQL crash signal 11?

MySQL crashed on this slave server with signal 11: Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) Slave I/O: Replication event checksum ...
0
votes
0answers
38 views

MySql backup for certain database contents

So i have a database containing custom functions and cleanup procedures and obviously content under tables which i want to back up using automating script which works but doesn't create a proper ...
0
votes
0answers
35 views

MySQL: migration huge tables between two databases

Hello guys (and sorry for my English). I have 2 DB's - DB1 (staging) and DB2 (production), each day some contend added/changed in some tables in DB1 and should be moved to DB2. Right now it works ...
0
votes
0answers
19 views

Is it proper to make a grand-parent key, a primary key, in its grand-child, in a multi-level identifying relationship?

I'm modeling a DB for a conference ticketing system. In this system attendees are members of an attendee group, which belong to a conference. These relationships are identifying, and therefore FKs ...
0
votes
0answers
51 views

Slow MySQL Query when Ordering

This query takes around 2 seconds when the order by is included, without the order it takes less than a tenth of a second. The field that is doing the sorting, qc_products.addedDate, is an index and ...
0
votes
0answers
636 views

insert data into mysql from mssql with arabic unicode

I insert data into MSSQL with arabic unicode. I want to insert this field into MYSQL but it insert empty. In MYSQL , I choose utf8-bin , I use php for this action, I declare name , character unicode. ...
0
votes
0answers
30 views

Advice on table structure change

I am in the process of converting an Access application that stores and reports evaluations to being web-based using php and mysql. I have converted the structure and data over from Access and I have ...
0
votes
0answers
92 views

How to notice data lost in innodb engine

I have a web-application installed in some desktop pc, and I experienced some troubles with mysql innodb. In case of hardware fault (disk failure) or just power fault I lost many data in my database ...
0
votes
0answers
182 views

How alter on infobright (BRIGHTHOUSE storage engine) actually works

I have been using infobright-3.4.1 (5.1.40) for data warehousing. I know it is outdated version but there no plan to upgrade the version currently. Even though infobright is build on mysql, the way it ...
0
votes
0answers
50 views

Enable general_log in Mysql 5.0.96

I want to enable general_log in MySql 5.0.96. I have set log variable but it isn't working. [mysqld] log=/var/log/mysql.log and restart mysql with following command /etc/init.d/mysql restart But ...
0
votes
0answers
19 views

mysql trigger help

I need to create a MySQL trigger. I don't know very well MySQL syntax but I've written something, maybe you would understand what I need, I need to insert the difference from 2 rows into a new row, ...
0
votes
0answers
121 views

MySQL Master-Master-Slave failover

I have setup a Master-Master configuration in MySQL with one additional slave, like this: Master1 <-> Master2 <- Slave Master1 is the write master used by my application, Master2 is used ...
0
votes
0answers
28 views

Checking for replication options

I have a master/master setup with one DB in each. DB name and tables in one server are different from the other, and few 'user' tables are being replicated with the option replicate-do-table. (It's ...
0
votes
0answers
48 views

How can I see all the incoming queries in real time to my MariaDB 10 server on windows?

I just want to see the queries coming in to MariaDB (very similar to mysql) in real time to help debug my application. What windows frontends are there that do this sort of thing? Thanks
0
votes
0answers
34 views

WHERE in CASE in mysql

$sQuery = "SELECT SQL_CALC_FOUND_ROWS ".str_replace(" , ", " ", implode(", ", $aColumns))." FROM (select CASE when r.agent_id=24 THEN r.Unit ELSE '--' END AS MyUnit, CASE when r.agent_id=24 THEN ...
0
votes
0answers
51 views

Data on the slave becomes inconsistent after couple of days

We are planning on upgrading our production MySQL server from MySQL 5.0.77 to Percona 5.6.19-67.0. Since our downtime window is small, we setup a slave of the production master on a new host and ...
0
votes
0answers
39 views

Table maintenance after dump/source

I just completed a major DB migration, all went well. I had a 450 GB DB on old underpowered windows hardware using MySQL 5.0 and I moved everything to much more powerful (512gb memory, server 2012) ...
0
votes
0answers
154 views

Performance tuning self-joining MySQL query

I asked a question recently on the correct way to update a table using multiple joins to itself in order to generate the desired values. Updating MySQL innodb table based on multiple joins After ...
0
votes
0answers
71 views

Using triggers or php code

I have a table called Salons, which has over 15k Salon names. I have another table which takes count of the pageviews of each salon. My question is that if I want to update reputation of the Salons ...
0
votes
0answers
211 views

Migrate existing database onto Percona XtraDB Cluster (using innobackupex?)

I'm setting up Percona XtraDB Cluster on 3 nodes to replace an existing MySQL database server. The existing databases will need to be migrated to the cluster with as little down time as possible. ...
0
votes
0answers
88 views

Very poor MySQL query performance after upgrading from server-5.5 to server-5.6

I'm in the process of trying to migrate a database from an old server to a new one. The old server is running an Xampp installation which has been more than adequate for the use case. For the new ...
0
votes
0answers
51 views

Recursive view for dynamic tree in MySql

Lets assume that there is a factory that produces products. the factory have catalog of a products, therefore tbl_catalog will be. ...
0
votes
0answers
109 views

mysql uses a lot of virtual memory

I've a mysql server with a lot of small size innodb databases (each db also contains a lot of small tables) & 6GB of RAM dedicated to mysql server. Recently I've increased my ...
0
votes
0answers
64 views

MySQL 5.6: creating users kills mysql, and mysql_upgrade fails

I have a fresh (not upgrade) installation of mysql 5.6.19 community edition win64 running on windows 8. I have had no problems with it until today I tried to create a new user. When I do this, mysql ...
0
votes
0answers
130 views

Configuration help my.cnf Mysql

Is the following my.cnf file OK for a dedicated server with 56GB of RAM (on ubuntu server and 8 processors)? I'm running just one website on the server and there is a high demand on my cpu from ...
0
votes
0answers
21 views

Is it possible to seperate one MySql-Account in a Firewall

I'm having a discussion with a software developer in my nears. He is using MySql direct connections for a software. There is no PHP/SSH/whatever-Bridge involved for the communication, neither at ...
0
votes
0answers
39 views

mysql:Multi tables SELECT Query

I have 2 tables in my database table_names, with the fields: id, name, join_date, country table_sigs, with the fields: id, pet_title, act_date, member_id I would like to know how many members ...
0
votes
0answers
142 views

How to insert a row which contains a foreign key in mysql

Here's the original question regarding PostgreSQL. I'd like to know of a similar solution for MySql. The simplest syntax provided in the answer works fine as long as the relevant rows already exist ...
0
votes
0answers
87 views

Billion records mysql performance with large result sets

I'm currently developing an application which will have several mysql tables where 3 of them have very large amounts of records. The thing is that my app will have to sync each account on a hourly ...
0
votes
0answers
97 views

Convert J1950 Date to Gregorian Date using a MySQL Query

I have a database table with a column named "time." The cells in the "time" column each contain a timestamp entry which was inserted in J1950 time format. I would like to convert the J1950 time to a ...
0
votes
0answers
109 views

MySQL multiple update queries vs. one insert … on duplicated key update query

I need to update hundreds to thousands rows. I wonder which of the following options is better: sending multiple (hundreds to thousands) "UPDATE" queries sending one (big) "INSERT INTO ... ON ...
0
votes
0answers
191 views

How to partition a MySQL table by Week using a timestamp column?

I have the following MySQL 5.6 table, which uses InnoDB and contains a timestamp column (I've omitted all the extra columns, in order to simplify my question): create table partition_by_week ( id ...
0
votes
0answers
51 views

Displaying SELECT Query Results Row as Columns

I have 3 tables: scoreboards, problems, and users. A user can do several problems, and the score will be stored in scoreboards table. Every user will have same amount of row in scoreboards table ...
0
votes
0answers
67 views

High CPU Usage for Mysql after adding partitions

On an amazon m3.large instance (vCPU:2, Mem: 7.5), I run a mysql(5.5.29) server. Initially, the state of the server is OK except that the query is too slow. However, after partitioning the table ...
0
votes
0answers
204 views

MariaDB Galera cluster nod won't start

I have configured a MariaDB Galera cluster with three nodes. The master node and one of the slave-master node is up and running, but the third node just won't run. The system specs and cluster config ...
0
votes
0answers
38 views

WHERE NOT a = b vs WHERE a <> b

Do the following queries have identical effects in MySQL, and are they just a different way of writing? I am asking this because I am creating a query builder in php, ideally if one way is identical ...
0
votes
0answers
75 views

Differing AUTO_INCREMENT values between 5.1 vs 5.6 slaves

I have a MySQL 5.6.21 slave and a MySQL 5.1.73 slave that are both replicating from the same MySQL 5.1.73 master. I noticed that for several of the tables ( I said several because when I try to rerun ...
0
votes
0answers
290 views

MySQL Inno DB Crash

This is the log of the crash. Basically every time I run a query it looses connection an crash. 2014-11-03 19:46:42 58021 [Note] Event Scheduler: Loaded 0 events 2014-11-03 19:46:42 58021 [Note] ...
0
votes
0answers
21 views

SQL nodes in MySQL Cluster

I running mysql cluster in windows 8.1 on 3 machines 2 mngmd 2 sql node 3 data nodes in the first machine I tried to connect MySQL server with localhost and tried to put my old database it ...
0
votes
0answers
23 views

Mysql table size reported, on disk and on slave

I thought I understood MySQL table sizes, but I have some confusion about it. I have two database servers, one primary and one slave (which was created recently). All DBs are replicated; no dangerous ...
0
votes
0answers
342 views

How to avoid 2013 error when executing ALTER TABLE

I have a huge table (2.8 GB) and I need to add a column. After I run this query I experience a lost connection error (Error code: 2013. Lost connection to MySQL server during query): ALTER TABLE ...
0
votes
0answers
125 views

mysql trigger Update a row after insert according to condition

I am writing a MySQL trigger. In which I would like to update branch_form_no with auto increment form number according to branch id. How should I do? I have table hcm_staffing_applicantform with ...
0
votes
0answers
30 views

Database still slow after index added

I have a mysql database with 2 million rows. when using "order by firstname" which firstname is not an index, the database is exteremely slow. I added an index for "firstname" and I thought it will ...
0
votes
0answers
87 views

MySQL Crash due to “InnoDB Assertion” after Query

Current setup: Ubuntu 12.04 LTS MySQL 5.5.31 Current Use: Slave - Only ETL queries 64 GB RAM Intel(R) Xeon(R) CPU X5670 @ 2.93GHz - 12 Cores - Hyperthreaded (24 Logical) MySQL Main Settings: ...
0
votes
0answers
75 views

MySQL performance_schema not working properly?

I have MySQL 5.6.19 community server running on my Ubuntu 14.04. Lately I have been trying to monitor MySQL server using performance_schema. Previously I used to do this by running SHOW FULL ...
0
votes
0answers
55 views

Last synchronization time between master and slave (replication)

During replication process where a Master is connected with slave. Some times connection between these two goes down. Any options to get the details of the last synchronization time?
0
votes
0answers
50 views

Improve processing of data and structure design from flat file to CMS DB (using intermediate DB)

I have a flat file (CSV) that brings me the data I want, but it needs to be cleaned and processed before it can be used, so I built an intermediate Database (MySQL) in order to get the structure from ...
0
votes
0answers
72 views

Entity Schema Design

I'm working on an application that has an "entities" system (built before my time) that models users, customers, contractors, vendors, etc. These are all types of people, but have different needs in ...
0
votes
0answers
86 views

Getting Error During install_master_slave in Tungsten Replicator

Master Node:- 192.168.126.138 TNGSTN_RPL1 Slave Node:- 192.168.126.139 TNGSTN_RPL2 On Master Node:- [root@TNGSTN_RPL1 tungsten-replicator-2.1.1-25]# cat /etc/hosts 127.0.0.1 localhost ...