MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

1
vote
1answer
21 views

MySQL Replication Master Slave Architecture - Web app that is based on the SLAVE DB

We are developing a web application (Spring mvc based app) that uses a MySQL DB. (lets call it the "original app") The DB architecture uses a MASTER-SLAVE configuration with replication. The web app ...
0
votes
1answer
13 views

Adding a column to aggregated data where new value only applies to a subset of the aggregation

Having trouble explaining this. I have a table like this: Label | Value A | 3 B | 1 C | 4 And another like this: Label | Value | ID A | 1 | ID1 A | 1 | ID2 C ...
0
votes
1answer
11 views

MySQL Replication, Can i add a trigger to the SLAVE db?

Is it possible to do so? The trigger will insert some rows into a unique table that exists only on the slave.
0
votes
0answers
39 views

Very high CPU caused by mysql service

A running mysql service uses CPU in a crazy way. (See attached screenshot from htop) I followed the instructions here with no luck. My server specs: CPU: 1900Mhz . Intel Hexa-Core Xeon E5-2420 ...
-3
votes
1answer
22 views

MySQL Insert Performance

i've been tasked to check whether MySQL can be used for Large DataWareHousing Requirement is as following the Table contains 83 column each row pay load size is 1272 bytes the requirement is the DB ...
0
votes
1answer
67 views

Select the last massage for each user [closed]

Please help me with a query. I know, that my english is not even on basic level, but I try to explain. I want to write a query that selects every last massage from each user (I want to create a dialog ...
0
votes
1answer
33 views

Suitable schema to record email sent and response received and invoicing in DB

When a form submission is made on a website: An email with form's details is sent to a set of recipients email addresses stored in a DB. The email contains a link for the recipient to show interest. ...
-3
votes
1answer
63 views

one or multiple tables mysql [closed]

I have a table with 3 columns and i want to split it according to 3 last character in string of one column , it will be more faster or more performant or it's same one and large table ..?? i talk ...
0
votes
0answers
29 views

Centos 5.11 mysql-server 5.0.95 upgrade to mysql55w-server

Here's my thought process on my upgrade: mysqldump --all-databases > backup.sql service mysqld stop yum remove mysql mysql-server yum install mysql55w mysql55w-server service mysqld start ...
0
votes
1answer
21 views

MySQL UTF-8 Encoding Problem

I have two MySQL databases that are for Wordpress websites. One db is for a live version of a site, the second is a copy of the original that is used in conjunction with a copy of the original site. ...
0
votes
0answers
7 views

mysql workbench connection type tcp/ip over ssh with libpam-google-authenticator enabled

I'm attempting to connect to my MySQL Database using the Connection Method "Standard TCP/IP over SSH". I filled out all the SSH and MySQL connection details correctly, however I get the message: ...
1
vote
1answer
16 views

mysql RANGE partitioning - how do I find partition boundaries?

I am implementing partitioning support for mysql in eludia engine I need to compare partitioning description in model with actual database contents and alter table, if necessary. To extract all ...
1
vote
1answer
30 views

'accidentally' set 'CHANGE MASTER TO' on wrong server

while setting up the replication I accidentally did the 'CHANGE MASTER TO' on the master server instead the slave. When I noticed the mistake I just did a 'STOP SLAVE' on the master and setup the ...
0
votes
1answer
41 views

SQL CLR in MySQL? [on hold]

Can we call SQL CLR in MySQL Server using User Define Function? I want to create trigger in mysql. It will call user define function and this UDF will update the table in SQL Server.
0
votes
1answer
27 views

Mysql master master with high latency

We have a single master setup with many slaves in germany and some slaves in australia. To have faster writes in australia we want a master-master setup between germany and australia. Read slaves ...
1
vote
1answer
31 views

federated tables? synchronization? replication? [mysql]

I have a REMOTE suppliers table with, lets say, a code and a name, and several client databases will be creating new suppliers. Server database code | name ______________ 1 | Mark 2 | ...
0
votes
0answers
13 views

Suddenly high CPU usage

I've read a lot about MySQL optimisation and I already optimised MySQL about a year ago. Reason for that was a high system load average. I tuned many queries and edited the my.cnf file. Since then ...
0
votes
1answer
22 views

Only LIMIT rows with specific number

Sorry for the title, As I'm not that experienced I had a real hard time trying to come up with a proper title. So I have this query to fetch all the comments of a specific topic. Now for my paging I ...
1
vote
1answer
26 views

My HD crashed and I can't start MySQL

I am on Windows 8, my SSD got corrupted and I installed Windows on a new drive. I had before MySQL 5.6.12, now I installed 5.6.17 and tried to move the entire data dir. The location of the MySQL ...
0
votes
0answers
18 views

MYSQL — Inventory View with calculated fields

Trying To create an inventory view. I have created this query using MS Access query builder since I am no pro at SQL and this is pretty convoluted. When translating this into MYSQL syntax I get an ...
1
vote
1answer
30 views

Why is the subquery apparently correlated? How to avoid it?

I have a table orders and a table orderpositions. The orderpositions (basically the items bought with the order) are linked via orderid (indexed) to the orders primary key. For a given set of orders ...
0
votes
0answers
22 views

MySQL workbench: Cannot Connect to Database Server (ssh)

General pointers would be appreciated -- it's likely I'm misunderstanding the mechanisms involved in a remote connection through ssh. I can use ssh to connect remotely, and then, through the CLI, ...
0
votes
0answers
17 views

Unable to count/Insert into database [closed]

I am a beginner trying to select data from a table with seemingly millions of records. I tried running the select count(*) from MyTable; It doesnt return any results and either takes forever or ...
1
vote
1answer
39 views

MySQL Deadlock - accessing different primary key values also creating deadlock

I went through MySQL logs and found the reason for deadlock 1st thread is trying to execute below query. Which is waiting for thread 2. UPDATE M_SAMP SET MM_Q_IND=0 WHERE M_ID IN (SELECT M_ID FROM ...
0
votes
0answers
24 views
0
votes
0answers
13 views

Different encoding in one file after importing to MySQL

Trying to import ONE SQL dump into the MySQL database by "source " command, and half of text (posts table on the forum) is going ok ("as is") but second half converted to another encoding. Anybody ...
1
vote
1answer
21 views

Import SQL dumps (tables) in folder from shell

Im trying to import SQL tables (actually this is files, one file for 1 table), and this is files are too big for importing in phpMyAdmin. It needs to be imported from shell. I know the command "source ...
1
vote
1answer
15 views

Alter all table's - discard tablespace

After having an awful experience with a dedicated server and spending 3 whole days repairing corrupted databases (Yes I know.... backup!).... I have narrowed the issues down to a few websites. The ...
0
votes
1answer
14 views

Mysql events table

I am trying to create a script to backup all mysql databases. This is the command that I am trying : sudo mysqldump -u user -ppassword --all-databases > /tmp/all-database.sql And this is the ...
0
votes
2answers
25 views

How to export image filenames from Wordpress database?

I have a Wordpress install that's using about 10,000 images. I'd like to export all filenames used in Wordpress to a file, filenames.log filenames.log would look like this: car.jpg boat.jpg milf.jpg ...
-1
votes
1answer
15 views

mysql database table corruption [closed]

Today when I opened MySQL database and I couldn't see very important table which were present/created about couple months ago. Yesterday I worked on it. Do you have some suggestions, how to get my ...
1
vote
2answers
17 views

How pt-online-schema-change ensures consistency during data copy

I have read pt-online-schema-change documentation and understood that it works by creating triggers and copying data in chunks with in chunk-time seconds(0.5 seconds in default) Let us consider this ...
1
vote
1answer
23 views

Replace string in the all tables of DB

I'm moving my website to new domain, need to replace all references of old domain to a new, in fact actually replace one string on another in all tables of MySQL DB. Please help me build the query to ...
0
votes
1answer
34 views

What can I do about this MariaDB 10.0 error?

I have a serious error that crashes the mariadb service, and it won't start up again until I delete the database folder in the data directory of the database I was working on at the time. Here is the ...
1
vote
1answer
42 views

Use a set database schema or EAV design? [duplicate]

I have already created a database design with a set schema. The database schema is for a web quotation form. PS it is not a simple quotation form and hence need to customise the form, form builders ...
0
votes
0answers
15 views

How the statement based replication works internal on secondary node of mongodb?

Mongodb supports statement-based-replication. Would like to know, how the statement based replication converts the code internally on secondary node of mongodb. Is that working related to the ...
0
votes
0answers
15 views

Finding all possible combinations of data set

I know I have seen other variations of this question, however I do not think any of them seem to handle my unique case. I have a database table that will be queried monthly, currently at 88,000 rows ...
0
votes
4answers
26 views

If all tables are myisam, should I use myisam engine instead of default innodb?

I have read all of the innodb/myisam threads and they are confusing. Everyone says innodb but I am assuming that they are saying innodb engine with innodb tables.? The software I am using creates ...
0
votes
1answer
15 views

When you use a replica to backup from so you don't have to turn off the master, is this considered High Availablity?

I read somewhere that MySQL can have a master / slave setup in which the master database can continue to run live and in production while the slave database can be turned off to snatch a backup. And ...
0
votes
0answers
24 views

Select items matching whole list

I have 2 tables: TABLE 1 and TABLE 2 I would like to select all items in TABLE 1 who fulfill all criterias (PHP variable). The criterias are made of multiple table2 values AND must match TABLE1.id ...
0
votes
0answers
18 views

How to get list of ids from joining two tables (one to many) whose results is not present in a list?

Say Table 1: tID, tName Table 3: t2ID, tID, tSubjects One tID can be have multiple t2ID. What I want is list of tIDs who's t2IDs should not just have a list of t2IDs (1,5,6). i.e They can 1,2,5,6 ...
1
vote
1answer
25 views

Are CREATE INDEX statements replicated in row-based Mysql Replication?

I've not been able to find a simple explanation of what kinds of statements are or are not replicated from a master db to a slave in MySQL, row-based replication. Specifically I want to add a ...
-4
votes
1answer
17 views

ExecuteNonQuery () not fungsional and database failed [closed]

Public Class Form1 Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load Dim SumberDb As String = "Data Source=c:\users\ogieuntung\documents\visual studio ...
0
votes
0answers
25 views

Getting Waiting for table metadata lock for select statements

I am using MySQL server 5.6.23 on CentOS and server configuration is like RAM - 32 GB Cores - 6 cores Innodb buffer pool size = 8 GB Key cache size = 2 GB We are using only select queries. But all ...
0
votes
1answer
36 views

MySQL Syntax Error 1064 On Set

Let's see if I can edit this and put the whole procedure in. I am trying to convert an Oracle database to MySQL. I have all the tables, keys, indexes, and views converted. I now need to convert a ...
0
votes
1answer
7 views

Check mysql domain that is using resources

I have a webserver hosting about 300 websites and sometimes my CPU usage gets close to 100% and when I use "top" in my CENTOS to check who is using all CPU, I discover it's mysql. I would like then to ...
0
votes
1answer
19 views

MySQL - Is it possible to assign permission to count the number of tables in a database without permissions on individual tables?

As part of a script I am trying to count the number of tables that exist in a particular MySql schema. Using my own user I am using the query SELECT COUNT(*) FROM information_schema.tables WHERE ...
0
votes
0answers
32 views

How to fetch data on a single column from a table having composite key

I am working on a messaging application, where the users can have a group conversation with multiple recipients. So in my database, I have a table called user_message where user_id and message_id is ...
1
vote
0answers
51 views

Limit relation one to many or one to one

In a relationship one to many or one to one you can limit the relationship of the related table? For example, I have a table 'cliente' and another 'acct', each 'cliente' can have thousands (perhaps ...
0
votes
0answers
27 views

Export the pivot-table-with-dynamic-columns as CSV

Export the pivot-table-with-dynamic-columns as CSV. I Need to export the following Query As CSV. SELECT id, name, description,GROUP_CONCAT(if (DAYS='2015-01-01',AMOUNT,NULL)) As ...