MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
1answer
9 views

MySQL slave doesn't disconnect quickly from prior HA master after failover

I have an AWS-external MySQL bare-metal server that is replicating as a slave of an RDS Multi-AZ (failover-capable/HA) endpoint. All MySQL servers involved are running 5.6.19. I've configured the ...
0
votes
1answer
3 views

Optimisation and Performance Mysql , Zend Framework 2 and Doctrine 2?

i'm facing some problem with performance in an application using zend framework2 and doctrine 2. i would like to optimis it but i don't know from where to start , i read some many questions/ answers ...
0
votes
1answer
14 views

Do threads in cache still use memory?

I was studying about how and how much memory allocated to each connection thread and found below MySQL tutorial: http://dev.mysql.com/doc/refman/5.1/en/memory-use.html There is a point mentioned as ...
0
votes
0answers
4 views

Creation of insert and update trigger accross database on same server

I have 2 websites and both are hosted on same server with different database and I wanted to create insert and update triggers between tow tables of different database. Example if we consider ...
0
votes
0answers
15 views

Insert table column data into another table column in mysql [on hold]

I have to table with category and subcategory. I want to insert category table id into subcategory that have foreign key(category id)using a stored procedure. category table cat_id primary key ...
2
votes
1answer
28 views

3 minutes to import 327Mo database

We do database import a lot of times per day on a server with those specs : Xeon E5-1620v2 4c/8t @ 3,8Ghz 32 Go DDR3 ECC 1600MHz Hard Drive 2x 3 To SATA3 MariaDB 10.14 with XtraDB Given a 327Mb ...
0
votes
1answer
11 views

how to make for each user, documents start in this order 1,2,3… mysql database [on hold]

I need to make database for users and every user have documents which will line up in this order for user1(document1 have id 1, documnet2 have id 2, documnet3 have id 3, etc...) user2(document1 have ...
1
vote
2answers
23 views

mysql service takes too much memory

i have a mysql 5.6.19 on linux server, and it takes about 8 Gb of memory. That is much more than i expect. There are about 150 db, each with 700 tables. All of them are innodb. We do not care about ...
1
vote
1answer
24 views

Simple query hangs on a specific column condition

I have two servers, and I a dumped the database of the first to restore it on the second. Everything works great, except that on the second server, I can't do any selection based on a specific column ...
1
vote
1answer
15 views

Shut Down MySQL during InnoDB rollback after crash

I am puzzled once again. We had a server crash last night during some huge queries. Upon restart in the morning MySQL went into recovery mode. I needed to shut down the MySQL service and it is ...
0
votes
0answers
11 views

Handle a Search on 2 Big Tables

Hello i want to realize a exchange system with 2 tables. 1 Table for "the user is looking for" 1 Table for "the user has to share" the Tables are very simple id bigint user_id bigint object_id ...
0
votes
0answers
5 views

slave with binlog with performance issues [on hold]

With some production servers which target to run as HA service, we worry about performance issues which don't appear in a reliable or reproducible way. Sometimes on regular and sometimes on high load, ...
0
votes
0answers
20 views

MySQL 5.6: explicit_defaults_for_timestamp

I have the following replication topology: DB1 (MySQL 5.5) -> DB2 (MySQL 5.6, explicit_defaults_for_timestamp = 1) -> DB3 (MySQL 5.6, explicit_defaults_for_timestamp = 1) - "date" field: ...
0
votes
1answer
15 views

Clarification on MySQL Workbench Options File Configuring

When in the MySQL Workbench tool, configuring the "Options File," I see a drop-down in the lower right corner with the options: client mysql mysqld By default, 'mysqld' is selected and I see my ...
0
votes
0answers
5 views

connecting Pervasive PSQL and MYSQL

I have Peachtree/Sage 50 on the server and trying to sync/integrate with MySQL, I already created a ODBC datasource but how can import all tables in sage to MySQL. What im trying to accomplish is to ...
0
votes
0answers
24 views

innodb fulltext Table handler out of memory

I am running mariadb 10 and have a large innodb table with a fulltext index. When searching I am regularly getting this error ERROR 128 (HY000): Table handler out of memory Is there some way I ...
0
votes
1answer
22 views

How do you record & replay mySQL queries for performance analysis?

We would like to record a real workload (i.e. the queries run against the database) so that we can replay the same (web application) workload against a clone of the database with different mySQL ...
0
votes
1answer
16 views

Find points within a distance using MySQL

I have a MySQL table with State Name,City Name,Zip Code, latitude and longitude of the user. I would like to get a list of user who are inside the circle or square of a given latitude and longitude ...
0
votes
0answers
19 views

MySQL master slave replication

I Had mysql master/slave replication working properly but suddenly replication stopped and accidentally someone has changed mysql.binxxx file in salve so i am getting this error ERROR: 'Got fatal ...
0
votes
1answer
17 views

1000 visitors per day have my web page and MySQL scratching at certain times and my.cnf [on hold]

1000 visitors per day have my web page and MySQL scratching at certain times. "tuning primary" and I edit my my.cnf file is as follows. In what way do you optimize it the best I can. nice = 0 ...
0
votes
2answers
39 views

Complex query: find all users who rated all the movies rated by user_id='1234'

So we have the following relational schema: users(user_id, ..) movies(movie_id, ..) ratings(user_id, movie_id, rate) So, we want to find all the users who have rated all the movies which are rated ...
0
votes
1answer
33 views

Select Multiple Values from Same Column; one sql statment

I am looking to return a list of users from a database. There are hundreds of users in the db. Each user has it's own unique user_id. All of the values that I am trying to return reside in the same ...
-2
votes
2answers
33 views

Select data from one table with id from another [on hold]

so as text is saying I need to grab user id by name from one table and then select count from another table by that ID. is it possible? users table ID | User online table ID
0
votes
1answer
27 views

MySQL thousands connections after convert MyISAM to InnoDB on fail-over structure

I've acquired a fail-over structure and I migrated my databases to new structure converting all tables of my database from MyISAM to InnoDB engine, but, after import all databases, I have a problem ...
0
votes
2answers
41 views

How can I tune MySQL to behave better under load

We have a typical master-slave set up. When we find ourselves under considerable load, the master grinds to a halt. The slave continues to march along all happy like. So during a recent slow-down, I ...
1
vote
0answers
12 views

“Unexpected EOF” during SELECT on huge MyISAM table

When executing a SELECT query that uses filesort on a huge table (2 billion rows) the execution stops after ~30mins with the following error message: ERROR 9 (HY000) at line 1: Unexpected EOF found ...
1
vote
1answer
24 views

Is there a data type I can use for RA & Dec in astronomy

I need to have fields in my database for the following: RA (hh:mm:ss.00) Dec (Degrees:arcseconds:arcminutes.00) I need to have the facility to search for a range within each field. Any ideas?
0
votes
0answers
17 views

MYSQL Tables Join Filtering For Favorites

I am in need of some help figuring out the best way to join separate tables I am using. I am essentially trying to output a list of schools (first table in MYSQL) where one column is an empty star ...
0
votes
1answer
27 views

insert row if table is empty, else update row (mysql)

i have 2 tables "table1" and "table2" both have TIMESTAMP cols for starttime and endtime. i want something like if (table2 is empty) insert into table2 (table2.starttime, table2.endtime) value ...
0
votes
0answers
12 views

3TB limit in MySQL NDB engine

The NDB documentation comparing NDB and InnoDB states that NDB has a 3TB limit, but it implies that it is not a hard limit, and is hardware or performance expectation dependent: (Practical upper ...
0
votes
0answers
16 views

How to pass ouput parameter values in mysql procedure

I am new with mysql and i getting issues at time of using output parameters in mysql procedure. Scenario: I have two tables MyProcedure code: DELIMITER $$ CREATE ...
0
votes
0answers
26 views

MySQL Crash (mysqld)

I decided myself to add space to one section. Booted from LiveCd, launched gparted, pitched wrong. After rebooting fell lilo, but to this I was ready and fixed the problem, but what was not ready, so ...
1
vote
0answers
20 views

MySQL master slave replication not working

I had MySQL master slave running and working fine but suddenly it stopped. I don't know which commands have been executed but now replication is not working. I am very new to MySQL can anyone help me? ...
0
votes
1answer
28 views

What is the cost of adding a foreign key in mysql?

I have an application which has a product_def table defining all products. The recrods in product_def are fixed and will never be deleted. CREATE TABLE `product_def` ( `product_id` INT( 5 ) ...
0
votes
1answer
34 views

MYSQL High CPU Usage

Recently, I changed my server to a better server. My new configs Centos 6.5 128GB RAM 32 CPUs 2.8GHz My.cnf: [mysqld] innodb_buffer_pool_size = 90G innodb_log_file_size=256M ...
0
votes
1answer
29 views

Joining a column from another table with InnoDB engine

I'm using MySQL with InnoDB and I want to join the location column from products table into a productStock table. I have this table 'products' mysql> select * from products; ...
0
votes
1answer
32 views

MySQL dies when trying to access a specific database

For some reason, whatever I do I cannot access one of my databases (through command line or through something like phpmyadmin). However, the application that depends on this database is not having any ...
0
votes
1answer
43 views

MySql: Slow join and group by on indexed columns

The following query takes 15-20s to run SELECT "Trade_US"."ID" AS "Trade_US.ID", "Server_US"."Name" AS "Server_US.Name", "Trade_US"."TradeTypeID" AS "Trade_US.TradeTypeID", "Users"."ID" AS ...
0
votes
0answers
22 views

get mysql index size split by index [duplicate]

I have ran this query : SELECT Table_NAME "TableName", data_length /1024 /1024 "table data_length in GBytes", index_length /1024 /1024 "table index_length in GBytes", ...
1
vote
1answer
39 views

Why does MySQL increment the auto_increment value when there's a constraint violation?

I have a table in a MySQL database with one column id, which has auto_increment and the Primary Key. There's also a Unique constraint in this table, on different columns. I noticed that when I try to ...
1
vote
1answer
178 views

MySQL backing up MyISAM tables by copying the physical files - and automating the process

I have 2 databases with MyISAM tables running on a Windows 2008 Server. These databases are about 20GB in size with a few tables with millions of rows. My question regards backing them up on a weekly ...
0
votes
1answer
28 views

Moved database (percona mysql) to larger disk, now everything is missing (though the files exist)

I dont know anything about databases or MySQL beyond the absolute basics so lets start with that. I moved the /var/lib/mysql from the / to a mounted volume which I remounted as /var/lib/mysql after ...
0
votes
1answer
13 views

SQL: Repair With Keycache

Now my MySQL server running a REPAIR TABLE, table is almost 15gb size. Status - Repair with keycache. How I can restart REPAIR TABLE with normal (repair with sort) mode?
0
votes
1answer
38 views

Order by one column inside other column

I've a MySQL table that looks like the following: http://sqlfiddle.com/#!2/ca67ac/1 I use it to build a grid where i put my content. The resultant is this: I've to render every row separatelly ...
0
votes
2answers
20 views

Subquery or multiple left joins, or both?

I have two tables, for simplicity table1, with id as Primary key, and a field name, and table2 with the same. Each table has quite a few records, but during a complicated form process, the user is ...
0
votes
0answers
35 views

SQL syntax error [on hold]

I am working with a MySQL DB. When I run the code I get the following error: Error 1064. You have an error in your SQL syntax. What am I doing wrong? UPDATE project SET STATUS = 2, REACT_TIME = CASE ...
1
vote
1answer
23 views

SQL: SOS: MySQL indexes overloads disk

My server is down now, 'couse indexes of 84GB DB are overloads disc. Here is output of df-h: /dev/ploop58097p1 193G 187G 16M 100% / tmpfs 2,0G 0 2,0G 0% /lib/init/rw ...
0
votes
0answers
13 views

Restoring Magento MySQL db to

We are moving a Magento site to a new server. When restoring the database, it terminates with error message: ERROR 1064 (42000) at line 11953: You have an error in your SQL syntax; check the ...
0
votes
2answers
33 views

Combine two queries from 1 table, 1 to Many

I have the following queries select o.increment_id, o.customer_id, round(o.base_grand_total * o.base_to_global_rate,2) as revGBP, DATE_FORMAT(o.created_at, '01/%m/%Y') as 'MonthofOrder', from ...
0
votes
1answer
21 views

Unresponsive database, sleeping processes

my mysql database suddenly became unresponsive: OperationalError: (2003, "Can't connect to MySQL server on '<IP_address>' (110)") After killing the processes: ...