mysql-5 : Version of MySQL Starting with MySQL 5.0
2
votes
3answers
454 views
MySQL optimization - year column grouping - using temporary table, filesort
I have a transactions table which is having 600,000 records, I need to list the count for the dashboard on financial year basis. The table used is MyISAM. I tried adding index for the transaction date ...
-1
votes
2answers
184 views
Insert ignore with conditional
I need to insert some records which might have duplicates. Column to overwrite/skip is mytable.email and mytable.fooFlag should be 1.
I came up with something like this:
INSERT IGNORE INTO mytable ...
2
votes
1answer
60 views
Problem in Fetching Result set in Desired Format
I have 2 tables having the following columns
Person
------
person_id,
first_name,
middle_name,
last_name
Items
-----
person_item_id,
person_id,
item_type,
status,
ordered_date
The query is
...
1
vote
1answer
143 views
Why would mysql “show global status” query be taking 15 minutes?
I'm reviewing the slow log, and on one of my slaves the average time for SHOW GLOBAL STATUS is 914s.
Any idea how to determine the cause of this?
0
votes
1answer
129 views
mysql duplicate entry error 1062 when restoring backup
Sorry, I seen similar threads but I still couldn't find it addressing my issue plus, I needed some more info on this.
Requirement: To create an exact replica 'db4' of an existing DB 'db3'.
Procedure ...
0
votes
1answer
67 views
How to removing or reduce the size of redo logs in MySQL cluster
Can anybody tell me that how can we reduce the redo log file size or can we remove the redo log file size in MySQL Cluster and also what will be the impact of it on performance of cluster.Also can we ...
3
votes
0answers
98 views
MySQL 1264 warning from libmysql
I'm using the libmysql.dll library to connect to my database from a 3rd party application (metatrader).
I managed to connect and things are going almost fine. I use mysql_real_connect and ...
1
vote
0answers
142 views
How to speed up this query
MySQL doesn't have nearest neighbor search so. So I try to come up with a "distance" that's reasonable so the number of returned query is around 20-200. That way innodb doesn't have to compute ...
1
vote
0answers
410 views
Tables don't exist after MySQL restart
I recently made changes to optimize performance for InnoDB engine-based DB and soon after when restarting I encounter into the following strange behavior:
I have some tables with data in them
I made ...
1
vote
0answers
728 views
My SQL 5.6.4 DATETIME column milliseconds is not getting stored
Beginning from MySQL 5.6.4, milliseconds support is provided for date columns like DATETIME etc.
I just created a table to check if its working:
create table testdata(startime DATETIME(5));
...
1
vote
0answers
316 views
mysql pre-start process (23901) terminated with status 1
I installed a new Mysql server version 5.1 on machine which was running on 5.0. Now when I try to start the mysql server using command service mysql start it gives me an error start: Job failed to ...
0
votes
0answers
46 views
Mysql query is very slow
I am developing a website like any other social networking site using mysql.
I wish it give people suggestion to my users, and I have implemented this functionality in my application, but It is ...
0
votes
0answers
80 views
UPDATE / SELECT incredibly slow in MySQL InnoDB
I have 1 table with 2.5 billion records(2.5 Cr.) and I am trying to get count of records based on indexed column. it takes 115 seconds to execute same.
Query : Select count(1) from table1 where ...
0
votes
0answers
24 views
MySQL becomes unresponsive because user reached its OS quota
In CentOS 6.3/MySQL 5.1.67 I had an user that runs wordpress reaching its OS space quota (mostly files, the DB is less than 100Mb). When the user tried to create a post it triggered an [ERROR] ...
0
votes
0answers
48 views
Returning multiple resultset from the same table
i am working with mysql procedure. final result set i have got in to one table.
now i need to return for each set i need to return the value.
example:
like this is contents in my the table.
i need ...
0
votes
0answers
110 views
how to improve performance of my query it was taking more than one hour in my environment
How can I improve performance of below query? It was running more than one hour to execute in my production environment. Query plan:
mysql> explain
SELECT transaction_detail.trans_id,
...
0
votes
0answers
186 views
Mysql 5.5 hangs from time to time with ubuntu 12.04
I am using Mysql 5.5 from ubuntu 12.04 64 Bits with both MyIsam and Innodb engines : From time to time, when I do some 'big' requests like dropping a database, altering a table, adding an index on a ...
