MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
0answers
43 views

Is there a MySQL setup for my use case?

I have multiple nodes that are mostly independent of each other, meaning 99% of traffic is reads to data contained inside themselves, plus some writes that need to be instantly available for the node ...
0
votes
0answers
140 views

Performance: Interleaving several statement handles in MySQL

Does interleaving several statement handles slow the system down? Example (Perl): $sth1->execute(...); $sth2->execute(...); $sth1->execute(...); $sth2->execute(...); (interleaved) vs ...
0
votes
0answers
47 views

Select changes in table by date

I have following table schema name type id int key string count int date date url_id id with example data id key count date url_id 1 system 100 ...
0
votes
0answers
20 views

Installing database

I have created database in my system using mysql.I tried to use in one of my friend's system.How can install the database in other system?
0
votes
0answers
953 views

eCommerce product table design - MySQL

I am designing database for an web application, I have designed the product and specification details database as follows, create table pr_size ( size_id int not null auto_increment, ...
0
votes
0answers
68 views

Mysql / ASP.net Timeout IO error

I have the following MySQL Query that when executed in my aspx page, yields a connection timeout error - the connection timeout is 15 which is the problem but I can not change it - have tried changing ...
0
votes
0answers
48 views

mysql restoration suddenly became slow

Recently I reinstalled couple of servers from Ubuntu to RHEL. I was having problems in restoring the mysql database from the dump file. I modified the below parameters in the /etc/my.cnf file. ...
0
votes
0answers
18 views

Create multiple columns after summing a single column

I have a single MySQL table, which includes company names and orders covering a 10 year time span. I want to create a query which summarizes the totals by company and creates a column with the totals ...
0
votes
0answers
66 views

MySQL One - to -Many Select Statement in Single Column

I'd like to output this tabular structure from a Select Statement, if possible: TaskID TaskTitle Users 1 Trash John, Barry 2 Dishes Spencer 3 Dusting ...
0
votes
0answers
36 views

Redesign tables, multiple foreign key and related table to same table

Hello I have this database: Table Teams is used in each one table. Match table contains teamA and teamB and round contains team that win the SET and team that start the set. But I dont know how I ...
0
votes
0answers
18 views

MySQL Recursive query

I have a table EventScheduleID Col Level 1 - 0 2 - 0 3 - 0 4 1 0 5 - 0 6 ...
0
votes
0answers
193 views

MySQL Chain Replication without log-slave-updates

I have three server's say A -> B-> C B as both Master and Slave.I have enabled log-slave-updates in B server so that replication is possible on C. So what if happens when log-slave-updates is not ...
0
votes
0answers
97 views

output from mysqltuner.pl (from mariadb.service)

While running mysqltuner.pl script, I'm getting following message: [OK] Currently running supported MySQL version 5.5.35-MariaDB-log [OK] Operating on 64-bit architecture -------- Storage Engine ...
0
votes
0answers
292 views

mysql service failed to start when datadir changein ubuntu

I have dual Operating system on PC, windows 8 and ubuntu 14.0, and I am mostely using ubuntu because my MySql database is hosted on ubuntu. Recently when I am trying to restore my database, which is ...
0
votes
0answers
36 views

How do I stop views (large data sets) from freezing my database

I am working with tables that contain upwards of 200,000 rows. My boss wants to use views that refer to other views in order to have things be more automated. The problem is that the MySQL server ...
0
votes
0answers
57 views

Innodb Deadlock During Insert

What could be the reason behind 2 inserts causing a deadlock? Here is what I get from log file: *** (1) TRANSACTION: TRANSACTION 6CA06B9, ACTIVE 6 sec inserting mysql tables in use 1, locked 1 LOCK ...
0
votes
0answers
63 views

Excesive use of RAM on MysqlServer

The RAM of a server where I have installed mysql is always 100% and looking at the processes that are running, MySQL is the most consumer on CPU and memory and I can see the cause of great use RAM.   ...
0
votes
0answers
118 views

Which local port does MySQL Workbench forward to in 'Standard TCP/IP over SSH' connections?

So if I was to set up an ssh tunnel for MySQL in terminal I would forward remote 3306 to local 3307: ssh -L 3307:127.0.0.1:3306 user@domain.com mysql -h 127.0.0.1 -P 3307 -u user -p db When ...
0
votes
0answers
11 views

Large data migration from DBO to DBO - memory & time efficient?

I need to migrate data from one database (Mysql vendor, used as Alfresco DB) to custom designed Mysql DB used for reporting. Both DB's are on same DB host. My initial idea was to use view as data ...
0
votes
0answers
134 views

What is a good database design (schema) for an article search engine application?

I'm trying to make a article search engine application. There are about 1 million articles that will be stored in the DB. I've tried looking around for some similar examples, but I couldn't find any ...
0
votes
0answers
96 views

Slow query (Wordpress)

Can I speed up somehow the following query? Somehow to stop from creating a tmp table/filesort. Tried a couple of indexes but no luck. mysql> explain SELECT wp_posts.ID FROM wp_posts LEFT JOIN ...
0
votes
0answers
896 views

How to fix “Access denied for user 'root'@'localhost'” error for MySQL using Mac OS X?

After reading a few of the similar problems to mine and none of them working, I thought I'd attempt to be more specific to see if my root problem needed to be fixed differently than the others. I've ...
0
votes
0answers
35 views

mysql-zrm regular raw backup restoration

Could someone explain how mysql-zrm restores a backup that is configured as raw (lvm snapshot - regular) and selective databases? I notice the backup backs up the ibdata* files also, question is if I ...
0
votes
0answers
36 views

Checking for records in lookup table before deleting

In my MySQL database, I have products table, a locations table and a lookup table (called location_products) where the ID of the product and ID of the location are stored. I am creating a transaction ...
0
votes
0answers
11 views

BackUP six servers to one Master server using MySQL

I have developed a .net Windows application that stores customer's ID copy in MySQL Database. We are planing to deploy this application in our seven branches. To avoid network congestion to our main ...
0
votes
0answers
167 views

How to include a GROUP_CONCAT list to result from subquery

I am trying to construct a nested query over the following 3 tables users, cars and bookings. Table users Table cars Table bookings +---------+ +--------+------------+ ...
0
votes
0answers
26 views

View dependency error

I am going to import a lot of views from my old mysql server. There is a lot of dependencies between views and tables and other views. MySQL does not allow creating a view if its referenced queries ...
0
votes
0answers
79 views

tables don't exist after unmounting and remounting external drive where database was installed

I want to create a database that's too big to keep on my own machine, so I'm trying to create one on an external hard drive. It works up until I unmount and remount the drive, at which point show ...
0
votes
0answers
12 views

What is the preferred mode of replication for a MySQL Cluster?

Reading about MySQL Cluster, I'd like to know about what are the preferred models of replication. I understand that it supports asynchronous replication out of the box, but I'm not sure of how it ...
0
votes
0answers
63 views

Would an INNER JOIN query in a sharded relational database hit the same shard when using a compound primary key?

In this question I have asked about modulus calculation in sharded tables, this design is used: CREATE TABLE Orders (order_id INT PRIMARY KEY, ...); CREATE TABLE LineItems (order_id INT, lineitem_id ...
0
votes
0answers
26 views

Indexed column INSERT vs. UPDATE

I have an indexed column. I could give it a value on INSERT. But it would be easier if I would add this value via UPDATE later (I have to update this row anyway). But I was thinking if it would be ...
0
votes
0answers
18 views

XAMPP do not show MySQL running though it's status is running

What does it mean.? When I am executing mysql_start.bat it show this. And when I open Xampp is still doent change its status. The below snip is from XAMPP.... After executing mysql_start.bat. And ...
0
votes
0answers
31 views

Generate report from visitor counter

I have a visitor counter, the table looks like this: id | country_code | datetime | Browser | ... --------------------------------------------------------- 1 | FR | ...
0
votes
0answers
376 views

MySQL LOAD INFILE Contains Multiple Escaped Characters Enclosed by Double Quotes in CSV

When loading data infile via MYSQL from massive CSV files with ENCLOSED BY '"' (double quote), there is a comment field containing multiple escaped characters like /',:" How can I import the data ...
0
votes
0answers
130 views

Unable to load innodb log file settings from my.cnf

I'm coming up against the error: InnoDB: ERROR: the age of the last checkpoint is 9449527, which exceeds the log group capacity 9433498. If you are using big BLOB or TEXT rows, you must set ...
0
votes
0answers
82 views

Mysql Show records according to their positions by grouping and order by

I am writing a query i should show the records according to the rank position given along with price order and group by sitename shopdetails id | productid | productname | sitename | siteid | ...
0
votes
0answers
48 views

Migrate from mysql to oracle

I'm trying to migrate a db from mysql to oracle, I'm trying to follow the videos from the official page of oracle: Here! But I have a doubt, when I'm trying to do the step of "translate" I don't have ...
0
votes
0answers
48 views

MySQL Structure - Need some feedback

I am trying to create a movie database (wiki style) and I am stuck on the database structure. I would like some help and suggestions please. Here is my basic idea: movie_table ...
0
votes
0answers
112 views

Cohort analisis for gamers activity

I want to do some cohort analysis of gamer activity in my games. By cohort I mean some set of users who registered (or had first activity) on some particular date. For example: users registered on 16 ...
0
votes
0answers
2k views

Multiple SELECT subqueries in an INSERT statement in a stored procedure

So I had the following (genericized), which works just fine for me (barring errors in making the example generic) : DELIMITER // CREATE PROCEDURE stored_proc(IN val1 INT, IN date1 DATETIME, IN date2 ...
0
votes
0answers
447 views

Openquery insert not working

I have a linked MySQL -server to MSSQL-server and I am trying to INSERT data to the table admin_user on the MySQL -server, but end up getting the error: annot process the object "dbo.admin_user". ...
0
votes
0answers
118 views

MySql query, 3 tables join takes 10+ sec

I need help refactoring this query, it joins 3 tables and subquery 4th. Order by should be possible by selected fields from 3 tables. t1 has 70k rows t2 has 20 rows t3 has 10 rows post_cc about 1500 ...
0
votes
0answers
112 views

How to skip already created table while importing dump file in MySql

Is there any way to skip already created tables while importing ? I am trying to import 2GB of database using command prompt but the operation is aborted by mistake. Now if i will do the import again ...
0
votes
0answers
270 views

Using a `mysql_query` to insert category values

Ok I'm importing direct from a csv to MySQL, using a mysql_query to insert values. How do you insert category terms into the Wordpress database structure assigning them to a post. Below are two import ...
0
votes
0answers
213 views

MySQL my.cnf File Optimization help

I need help for Optimizing my MySQL Server for my Dedicated server with configuration of Intel Core 2 Duo CPU E7500 @ 2.93GHz 4GB of RAM installed. OS installed is CentOS 6.5. Mostly on my Dedicated ...
0
votes
0answers
57 views

mysql logs same query multiple times or is it application problem?

I have temporarily switched on logging on the server. The site is used in the US and local time there was 4 in the morning so not many people are using it at that time. What I did was delete any logs ...
0
votes
0answers
14 views

Users_With_Messages Table normal form

I have the following tables in my database: Above these tables (not pictured) is a Users table where the SendingUserId and ReceivingUserId are keyed onto (they are foreign keys). Are these tables ...
0
votes
0answers
17 views

High bandwidth on virtual IP

Description of the environment : An apache server (Drupal) connected to mysql server using a virtual IP. The problem : The (outgoing) bandwidth on VIP has exploded (after a new site version ...
0
votes
0answers
58 views

Percona slower than vanilla Mysql 5.6

A lot of folks had suggested to use Percona as more robust and enhanced version of Vanilla Mysql. I just setup Percona 5.6 today on our server to see how it holds up against our traffic. I noticed ...
0
votes
0answers
99 views

Log-slave-updates in multi master replication using Tungsten replicator

I m setting up a system as follows with 2 masters and 2 slaves. M1 <----> M2 (Tungsten Replication) M1 ----> S1 (MySQL Replication) M1 ----> S2 (MySQL Replication) I have enabled the ...