MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
2answers
39 views

How to calculate mysql server reads per second,writes per second?

Can anyone let me know how to calculate mysql server writes,reads,deletes,updates per second.
0
votes
1answer
29 views

SELECT ROWS WITH SIMILAR ID AND MERGE THE FILED VALUES IN ONE

My situation is as follows. I have the query below and the query is doing its job pretty well. However I have excluded one able from it which is field_data_field_luogo and the rows inside this can ...
0
votes
0answers
9 views

Mysqlfailover command - No slave is listed in health status

I have suuccessfully created replication using GTID_MODE. It works perfectly. Now i need to setup automatic failover feature in it. I have run the following command. "mysqlfailover ...
1
vote
0answers
21 views

How to display all the dates between multiple two dates in a table?

I want to display all the dates between two dates for a particular record And this is the table : ID Start_Date End_Date 1 2013-01-14 2013-01-18 2 2013-02-01 2013-02-04 and now i want to get all ...
0
votes
2answers
26 views

MYSQL Row Count Limits?

What is the maximum row count for a table in MYSQL? I have a system with around 600,000,000 rows in three tables. Average Data Length (from data_length column) for these tables is 58,000,000,000 ...
0
votes
1answer
11 views

How to remove some data not needed on new row from mysql query with rollup

Hello I have a problem with the rollup mysql query. I want to get total of each column. I use mysql SUM() and ROLLUP to get the result. But on the new row that is added it copies the data of the last ...
0
votes
0answers
32 views

MySQL my.cnf performance tuning Need some advice

Our architecture is as follows: Memory : 132GB CPUs : 12 OS & Mysql : 64-bit Disk Space : 2.0 TB DB Engine : MyISAM i only have 1 table innodb (around 400mb) all the rest are ...
0
votes
0answers
31 views

CREATE OLAP server

I have a MySQL database server along with replication server, i.e. OLTP system altogether. As I have very heavy data fetching queries for the decision making reports. I need to create data-ware house ...
0
votes
0answers
39 views

slave mysql server crash : mysqld got signal 6

Hi I am trying import a mysql logical backup file on server A.Server A and B are in master slave configuration and both running on same unix server.slave is running while import is in progress.Due to ...
1
vote
1answer
31 views

MySQL: Why statement-based binlog format cannot work with Innodb READ UNCOMMITTED or READ COMMITTED Isolation levels?

In MySQL documentation it's written: If you are using InnoDB tables and the transaction isolation level is READ COMMITTED or READ UNCOMMITTED, only row-based logging can be used. Why ...
4
votes
3answers
99 views

MySQL JOIN query produces wrong result

I have two tables complaints and complaints_reply in my MySQl database. Users can add complaints which are stored in complaints the complaints reply are stored in complaints_reply table. I am trying ...
0
votes
1answer
43 views

Having four different tables or having one table with one more field?

I have a website with 4 translation (That is Arabic with 4 different Persian translation), and I had exported each of these translations to different tables. Which one of these ways are faster and ...
0
votes
2answers
59 views

In mysql, find all instances of a named column that are not foreign keys

This one has had me trumped for a while! I want to run a query to retrieve all instances of a column (from information_schema, I guess) that ARE or ARE NOT foreign keys. Now, let me back of a little ...
0
votes
0answers
15 views

Mysql Select Categories and count of sub items [duplicate]

I have some problems on handling date from multi tables an once for example SELECT fl_categories.*, COUNT(fl_seeds.id) AS seeds , COUNT(fl_feeds.id) AS feeds FROM fl_categories LEFT JOIN fl_seeds ...
1
vote
1answer
29 views

Create Table not working

Forgive me if the question is very simplistic; I am a bit of a novice when it comes to SQL. The following CREATE TABLE syntax was generated by MySQL workbench from my model; It gives me errno: 150. ...
1
vote
2answers
32 views

Mysql date_add returns wrong row in python, right row in phpmyadmin [closed]

I am trying to get the first and last record from a month. In phpmyadmin I ge the correct result. In python I don't. In fact python returns the same row for both of these queries. First number is ...
0
votes
0answers
21 views

what is causing Errors running from Localhost

wp_users: InnoDB: Tablespace is missing for table 'ftbw/wp_users' wp_usermeta: InnoDB: Tablespace is missing for table 'ftbw/wp_usermeta' wp_posts: InnoDB: Tablespace is missing for table ...
1
vote
0answers
51 views

MariaDB is ignoring /etc/my.cnf

The variable I am trying to change is innodb_buffer_pool_size. As you can see below the settings is 512M. But SELECT @@innodb_buffer_pool_size; returns 134217728. When I execute: /usr/libexec/mysqld ...
0
votes
1answer
36 views

Mysql - Examine last query run by thread in sleep state

I am seeing some threads in the "sleep" state for longer than normal. Normal maybe being 1-3 seconds with the abnormal being up to 60 seconds or longer. It makes sense that this is an application ...
2
votes
4answers
101 views

Mysql Order By affecting a Query with column alias, group by, and having

Description: I have a query with column alias, group by and having. It's getting altered when I add an order by. This strange behavior is only happening in 5.6.16 and 5.6.21 (which I was using in ...
1
vote
1answer
32 views

Getting Data Type ID in MySQL

So, In SQL, We have the following query to find the system data type ID of columns in SQL Server; select name, system_type_id from sys.columns where object_id = OBJECT_ID(N'sometable') It gives the ...
0
votes
1answer
59 views

mysql Lock wait timeout exceeded; try restarting transaction

we are running java application, running for ages, back end is db is MySQL, recently updated to mysql 5.6. Everything was running fine, past week started getting this error Lock wait timeout ...
0
votes
2answers
37 views

Table partition should not be selected

I am looking to partition a table (nearly 30M rows) by date ranges (mysql version : 5.1.73) CREATE TABLE `TABLE_X` ( `name_x` varchar(50) NOT NULL, `type_x` varchar(5) NOT NULL, `status_x` ...
1
vote
2answers
26 views

mysql copying to tmp table duration

I have a web site which started to have performance issues because of a mysql query which is executed for each request. I have the following table structure. Post table (125000+ records) id: ...
0
votes
1answer
54 views

Does AWS Aurora suffer from the same limitations that MySQL suffer from? [closed]

Specifically, MySQL has a limitations max row size as 64kB. I would like to know if Amazon Aurora, which is supposedly a drop in replacement for MySQL suffer the same limitation.
1
vote
2answers
28 views

Does InnoDB allow adding columns to a table with concurrent READ/WRITE of rows?

I have a large (3M rows) InnoDB table in MySQL 5.6.21 in production and I want to add some columns. From the MySQL Documentation on Overview of Online DDL I understand that, even if this is an ...
0
votes
2answers
42 views

Best configuration for MySQL? InnoDB and MyISAM

I read that InnoDB is supposed to be better at writing into MySQL than MyISAM, however, I'm trying it out, by running 3000 MySQL queries(Inserting rows, 8 Columns + id)... but results haven't turned ...
0
votes
0answers
37 views

error 1067 process terminated unexpectedly

I am facing the following error while creating the Mysql instance from command line in Windows server 2012. Steps i follwed for creating a new Mysql Instance as a window service: I have stopped the ...
0
votes
1answer
35 views

Display the choices even if no rows found in associated table

I have the following 3 tables for a small voting/polling feature: CREATE TABLE IF NOT EXISTS `options` ( `option_id` tinyint(4) unsigned NOT NULL, `poll_id` mediumint(8) unsigned NOT NULL, ...
0
votes
1answer
14 views

'mysql' database in fresh MySQL installation

I installed MySQL database and according to show databases command I have a database named 'mysql'. Is this database used for holding some internal values for MySQL? In addition, is it possible to ...
0
votes
0answers
24 views

where does MySQL store data which is inserted into tables?

I have a small table named animals in database named test: mysql> select * from animals; +----+------------+-----------+ | ID | species | location | +----+------------+-----------+ | 1 | ...
1
vote
0answers
21 views

Correct sentence and paragraph casing [migrated]

I have a database full of descriptions in all lower case. This doesn't look very nice. I am trying to figure out a way to correct the casing, ie., capitalize the first letter after every period, and ...
1
vote
1answer
87 views

Table with more than 100 columns

I have a table in my MySQL database which contains data about XRF analyses. There are about 50 chemical elements and for each element there are two values to be stored (Area and Count). Users need ...
0
votes
1answer
50 views

Database MySQL - Transpoing Table from one form to other

SET @sql = NULL; SELECT GROUP_CONCAT(DISTINCT CONCAT( 'MAX(IF(function_NAME = ', function_NAME, ',budget, NULL)) AS ', function_NAME)) INTO @sql FROM country_report dr ...
0
votes
1answer
26 views

Intermittent “access denied” (1045) message from MySQL

I'm importing a fairly large (100GB+) database from MySQL to PostgreSQL using pgloader. After a seemingly random amount of time the process dies with the following error: An unhandled error condition ...
0
votes
0answers
21 views

Mysql is not starting while using xampp.

Mysql is not working when I try to view my site on locahost. I keep getting 'Error: MySQL shutdown unexpectedly.' The Mysql log says: 2015-05-06 19:39:13 5268 [Note] Plugin 'FEDERATED' is disabled. ...
1
vote
1answer
36 views

Getting the count of same value in consecutive rows that are ordered by different field

I have a table with the following structure finals(ID, name, result) CREATE TABLE `finals` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(10) DEFAULT NULL, `result` char(4) ...
0
votes
1answer
26 views

improve database design for monitoring application

I need assistance with my DB design, I have a monitoring script that produce the following data every minute , and produce stats about virtual machine performance. Array ( [timestamp] => ...
0
votes
1answer
33 views

OR Operation in JOINS SQL(MYSQL)

I am using MYSQL SELECT m.proposalId, m.title, n.stageNumber, n.committeeId, n.modifiedDate, o.msNumber , o.description,o.ics,o.edition FROM mystands_Proposal m INNER join ...
0
votes
1answer
38 views

Scale MySQL trigger for thousands of inserts per seconds

We are using MYSQL database for an Analytics app. I have two table token and token-big (for overview of actual data) both have id(int) unix_starttime(int) unix_endtime(int) details(varchar 256) A row ...
0
votes
0answers
8 views

Changing Numbers from standard form without clicking every cell- Excel [migrated]

I have imported a csv file from MySQL, documenting part numbers and descriptions. Some of these part numbers have values like 1234567890987654321, which is then shortened by excel to 1.23e18. Problem ...
1
vote
1answer
45 views

Why MySQL SELECT performance depends on table size? [closed]

I've got two identical tables with the following structure: CREATE TABLE words ( id bigint(20) NOT NULL, `text` int(11) NOT NULL, w1 int(11) NOT NULL, w2 int(11) NOT NULL, w3 int(11) NOT ...
-1
votes
1answer
28 views

Set up MySQL server database [closed]

I want to set up MySQL server database for my office on my windows 8 pc, but i dont know exactly which products to use. Can anybody help me with it. I want to set the database such as my pc would be ...
0
votes
1answer
59 views

Get data faster from databasse

My site having a more than 1.5 million records and my question is the how may i fetch record fast. i am spending so much time to find the way for it finally find out the one way which is to apply the ...
0
votes
1answer
29 views

Filling not applicable fields with N/A rather than leaving them empty or Null [duplicate]

I have a database of few million records, many of the fields (call them Ec1 to EcN) have either Null or empty string in them. When I looked at them more closely, I found that for many records, several ...
0
votes
1answer
56 views

unable to add index to column, duplicate entry

I have a table that collects virtual machines usage metrics, I'm trying to add an index to timestamp column, to speed up queries, when selecting time, this is a sample of the table I have, it has ...
0
votes
1answer
41 views

InnoDB Index Doesn't Fit in Memory

I am using InnoDB tables in my database and total index_size is 250 GB and my data size is 500 GB. Server has 128 GB RAM, and innodb_buffer_pool_size is set to 64 GB. Data size is increasing every day ...
2
votes
3answers
63 views

Track entity updates (by who and when)

I need some advice on how to store information about who created/updated an "entity". I keep going back and forth between Option1, 2 and 3 (see below): Background This is a legacy system and there ...
0
votes
3answers
79 views

Adding order by to a query is slowing down the query even after Indexing

While joining columns with huge data even after indexing the column order by is slowing down the query. Without order by query is executing within 2 secs. But with order by query is taking 145 secs. ...
1
vote
2answers
27 views

How to define partition according to Date?

I am currently using MySQL 5.6. In my database, I have a log table called paramlog_ems. It has 2M rows I want like to partition this log table according to Date. Here is the table structure: ...