MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
2answers
29 views

Updating a table with a single UPDATE statement vs several UPDATE statements

CREATE TABLE `messages` ( `mes_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'номер объявления', `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'дата/время дачи/изменения ...
0
votes
0answers
12 views

Uninstalling phpMyAdmin after deleting associated MySQL Database

I'm new to MySQL and phpMyAdmin so please forgive me if this is a stupid question. This morning I created a MySQL database and user on my web server. I then installed phpMyAdmin onto this database. I ...
0
votes
0answers
24 views

MySQL Enterprise Monitor - Query Analyzer configuration problem

I'm using MySQL 5.1.69. protocol_version 10 version 5.1.69-log version_compile_os redhat-linux-gnu I have a problem with configuration/using MySQL ENTERPRISE MONITOR. I don't see data in ...
0
votes
0answers
17 views

Merge colums from two different databases using phpMyAdmin

Is there a way to: Replace all the data from database1 > table1 > column2 With Data from Database2 > table1 > column2 ONLY under the condition that the ID value in database1 > table1 > column1 ...
0
votes
0answers
25 views

MySQL moving large data from one schema to another

Good day, I have a DB schema that has a single table that grows about 30 million rows per week, or about 25GB. Every day we hit our limit of the data that can stay there so we move the data on to ...
-4
votes
1answer
59 views

When you type an SQL query in interpreter, what does happen? [closed]

Actully this question is asked in an interview from me . When you type an SQL query in interpreter, what does happen? How is the query processed?
0
votes
1answer
30 views

Sudden periods of performance degradation

For the past couple of days, Ive been observing periods of huge performance degradation. CPU usage on our master MySQL server (Percona Server (GPL), Release rel24.1, Revision 217, InnoDB version ...
0
votes
0answers
21 views

MySQL: What should I do if too many tables opened during peak hours?

In Peak hours: When I run below statement, I found around 100 tables out of 250 have opened. show open tables where in_use>0; There are around 10 tables for which in_use value are >50. Storage ...
0
votes
1answer
42 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 ...
1
vote
1answer
23 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 ...
2
votes
1answer
44 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 ...
2
votes
3answers
99 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
36 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
41 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
13 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
53 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: ...
1
vote
1answer
38 views

Updating mysql trigger via information_schema — access denied?

I have some wrong "definer"s for some triggers in MySQL (actually MariaDB). I figured the easiest way of correcting them would be some version of: use information_schema; update triggers set ...
0
votes
1answer
28 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
15 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
30 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
30 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
21 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
25 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
22 views

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

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
51 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
69 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
44 views

Select data from one table with id from another [closed]

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
2answers
52 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
58 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
26 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
26 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
22 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
49 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
17 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
18 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
31 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
46 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
39 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
115 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
33 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
46 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
48 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
51 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
244 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
21 views

Mysql Server Crashing Regularly

Error Log : MYSQLD log 140925 20:47:19 mysqld_safe Number of processes running now: 0 140925 20:47:19 mysqld_safe mysqld restarted 140925 20:47:26 InnoDB: Initializing buffer pool, size = 56.0M ...
0
votes
1answer
18 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
31 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 ...