MySQL Forums
Forum List  »  Performance
Announcements Last Post
•   MySQL for Excel 1.3.8 has been released 06/10/2019 10:21PM

Advanced Search
New Topic
Pages:
« 1 2 3 4 5
...
75 »

Subject
Views
Written By
Posted
CREATE INDEX Online DDL Not Working  
944
Jayanath Dissanayake
06/20/2016 05:02AM
Re: CREATE INDEX Online DDL Not Working  
539
Øystein Grøvlen
06/22/2016 12:43AM
Re: CREATE INDEX Online DDL Not Working  
538
Rick James
06/23/2016 07:07PM
Select random rows when using UUID  
1,472
Jonathan Keen
06/09/2016 11:43AM
Re: Select random rows when using UUID  
705
Rick James
06/13/2016 01:36AM
Re: Select random rows when using UUID  
780
Jonathan Keen
06/14/2016 11:23AM
Re: Select random rows when using UUID  
641
Rick James
06/18/2016 01:35AM
SQLSTATE[HY000] [1044] Access denied  
5,461
YOONTAE KIM
06/16/2016 07:55PM
Index Not being used.  
1,734
Greg Mundt
05/26/2016 02:29PM
Re: Index Not being used.  
806
Peter Brawley
05/26/2016 03:53PM
Re: Index Not being used.  
675
Øystein Grøvlen
05/27/2016 12:45AM
Re: Index Not being used.  
627
Greg Mundt
05/27/2016 07:05AM
Re: Index Not being used.  
575
Rick James
05/27/2016 11:29PM
Re: Index Not being used.  
721
Greg Mundt
05/31/2016 07:04AM
Re: Index Not being used.  
589
Rick James
05/31/2016 09:26PM
Re: Index Not being used.  
661
Greg Mundt
06/01/2016 05:40AM
Re: Index Not being used.  
489
Rick James
06/01/2016 11:29AM
Re: Index Not being used.  
603
Greg Mundt
06/01/2016 11:41AM
Re: Index Not being used.  
606
Rick James
06/04/2016 05:14PM
Re: Index Not being used.  
666
Greg Mundt
05/27/2016 10:14AM
A proposal to make disk IO much faster under SSD  
1,163
suiyemin sui
05/29/2016 09:16PM
Re: A proposal to make disk IO much faster under SSD  
673
Rick James
05/31/2016 09:48PM
Re: A proposal to make disk IO much faster under SSD  
641
suiyemin sui
06/01/2016 02:05AM
Re: A proposal to make disk IO much faster under SSD  
578
Rick James
06/04/2016 04:38PM
query taking really long time.  
927
Mehraz Ahmed Sheikh
05/16/2016 09:45AM
Re: query taking really long time.  
538
Rick James
05/23/2016 02:58PM
Left join vs Inner join  
1,229
Vikas Sood
05/09/2016 06:10PM
Re: Left join vs Inner join  
656
Øystein Grøvlen
05/10/2016 08:04AM
Re: Left join vs Inner join  
591
Vikas Sood
05/10/2016 10:40AM
Re: Left join vs Inner join  
584
Rick James
05/10/2016 07:23PM
How can I improve the import speed of a large SQL file?  
11,594
Jeff Vincent
05/06/2016 09:46AM
Re: How can I improve the import speed of a large SQL file?  
5,085
Peter Brawley
05/06/2016 11:49AM
Re: How can I improve the import speed of a large SQL file?  
3,355
Jeff Vincent
05/06/2016 12:17PM
Re: How can I improve the import speed of a large SQL file?  
3,111
Rick James
05/06/2016 05:44PM
Re: How can I improve the import speed of a large SQL file?  
2,773
Shane Bester
05/08/2016 04:49AM
text vs varchar  
1,237
hua kai
04/28/2016 08:36AM
Re: text vs varchar  
790
Øystein Grøvlen
04/29/2016 12:41AM
Re: text vs varchar  
694
Rick James
04/30/2016 11:51PM
Re: text vs varchar  
670
Øystein Grøvlen
05/02/2016 04:37AM
Re: text vs varchar  
646
hua kai
05/02/2016 09:14PM
Re: text vs varchar  
634
Øystein Grøvlen
05/03/2016 02:19AM
Re: text vs varchar  
1,301
hua kai
05/03/2016 04:12AM
Re: text vs varchar  
632
hua kai
05/02/2016 08:02PM
Re: text vs varchar  
813
Øystein Grøvlen
05/03/2016 02:25AM
Query with 2 x subquery  
1,040
Jes Ramsing
04/29/2016 06:44AM
Re: Query with 2 x subquery  
586
Øystein Grøvlen
04/29/2016 08:01AM
Re: Query with 2 x subquery  
556
Jes Ramsing
05/01/2016 11:57PM
Re: Query with 2 x subquery  
558
Øystein Grøvlen
05/02/2016 03:45AM
Re: Query with 2 x subquery  
545
Jes Ramsing
05/02/2016 05:32AM
Re: Query with 2 x subquery  
555
Rick James
05/01/2016 11:58PM
Re: Query with 2 x subquery  
607
Jes Ramsing
05/02/2016 02:16AM
Slow Query, Optimization Advice Needed  
1,093
Michael Lawson
04/26/2016 09:30AM
Re: Slow Query, Optimization Advice Needed  
557
Øystein Grøvlen
04/27/2016 01:02AM
Re: Slow Query, Optimization Advice Needed  
647
Michael Lawson
04/27/2016 07:20PM
Re: Slow Query, Optimization Advice Needed  
509
Peter Brawley
04/27/2016 11:28PM
Re: Slow Query, Optimization Advice Needed  
569
Øystein Grøvlen
04/28/2016 01:25AM
Re: Slow Query, Optimization Advice Needed  
557
Rick James
05/01/2016 11:47PM
Re: Slow Query, Optimization Advice Needed  
566
Øystein Grøvlen
05/02/2016 01:28AM
Re: Slow Query, Optimization Advice Needed  
597
Øystein Grøvlen
04/28/2016 01:12AM
Reg table design and query performances  
1,012
Devrishi Shandilya
04/26/2016 03:02AM
Re: Reg table design and query performances  
559
Øystein Grøvlen
04/26/2016 06:02AM
Re: Reg table design and query performances  
670
Devrishi Shandilya
04/26/2016 06:16AM
Re: Reg table design and query performances  
568
Øystein Grøvlen
04/26/2016 06:35AM
Re: Reg table design and query performances  
530
Devrishi Shandilya
04/26/2016 06:50AM
Re: Reg table design and query performances  
540
Øystein Grøvlen
04/26/2016 07:04AM
Re: Reg table design and query performances  
501
Rick James
04/30/2016 11:46PM
Re: Reg table design and query performances  
502
Øystein Grøvlen
05/02/2016 01:00AM
Memory benefits of huge pages  
2,849
Olga Turetskaya
04/30/2016 11:21AM
Re: Memory benefits of huge pages  
1,368
Rick James
05/01/2016 02:36PM
Configuration review requested  
1,403
Jens Meier
04/13/2016 11:55AM
Re: Configuration review requested  
584
Rick James
04/14/2016 01:39PM
block_ops_in and block_ops_out meaning  
2,290
hua kai
03/18/2016 02:33AM
Re: block_ops_in and block_ops_out meaning  
1,091
Rick James
03/21/2016 11:34PM
Re: block_ops_in and block_ops_out meaning  
1,097
Peter Brawley
03/22/2016 02:03AM
Re: block_ops_in and block_ops_out meaning  
1,070
hua kai
03/25/2016 12:30AM
Re: block_ops_in and block_ops_out meaning  
1,008
hua kai
04/14/2016 12:52AM
order by primary key slowly  
1,335
varky chan
04/05/2016 10:42PM
Re: order by primary key slowly  
597
Øystein Grøvlen
04/06/2016 04:35AM
Re: order by primary key slowly  
606
varky chan
04/06/2016 10:15AM
Re: order by primary key slowly  
642
Peter Brawley
04/06/2016 11:23AM
Re: order by primary key slowly  
700
varky chan
04/06/2016 08:11PM
Re: order by primary key slowly  
607
Peter Brawley
04/06/2016 10:35PM
Re: order by primary key slowly  
629
varky chan
04/07/2016 12:34AM
Re: order by primary key slowly  
735
Øystein Grøvlen
04/07/2016 07:21AM
Re: order by primary key slowly  
656
Peter Brawley
04/07/2016 10:20AM
Re: order by primary key slowly  
622
varky chan
04/07/2016 11:26PM
Re: order by primary key slowly  
633
Rick James
04/12/2016 07:42PM
Re: order by primary key slowly  
604
Peter Brawley
04/06/2016 08:57AM
Re: order by primary key slowly  
592
varky chan
04/06/2016 10:17AM
[INNODB] why there are many "waiting for table level lock"?  
1,100
HANWEN YIN
04/11/2016 12:08AM
Re: [INNODB] why there are many "waiting for table level lock"?  
723
Rick James
04/12/2016 07:27PM
Improve performance when altering huge tables  
1,083
Davide Cicuta
04/04/2016 07:24AM
Re: Improve performance when altering huge tables  
630
Rick James
04/05/2016 02:59PM
MySql 5.7 - Poor Performance PURGE BINARY LOGS  
1,597
Davy Campano
03/23/2016 08:08PM
Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS  
670
Rick James
03/26/2016 11:58PM
Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS  
669
Davy Campano
03/29/2016 09:44AM
where the snapshot for select in transaction stored  
955
hua kai
03/21/2016 03:03AM
Re: where the snapshot for select in transaction stored  
514
Rick James
03/21/2016 11:21PM
Difference execution plans for same query  
1,252
Devrishi Shandilya
02/25/2016 12:05AM
Re: Difference execution plans for same query  
607
Peter Brawley
02/25/2016 01:51AM
Re: Difference execution plans for same query  
639
Øystein Grøvlen
02/25/2016 03:51AM
Re: Difference execution plans for same query  
644
Rick James
03/05/2016 01:19AM
Slow join performance  
1,183
Ra Nala
11/27/2015 04:55AM
Re: Slow join performance  
685
Rick James
11/28/2015 03:02PM
Re: Slow join performance  
562
Ra Nala
02/25/2016 06:22AM
which is best for JOIN approach  
1,162
Ra Nala
11/24/2015 09:39AM
Re: which is best for JOIN approach  
697
Øystein Grøvlen
11/25/2015 02:14AM
Re: which is best for JOIN approach  
725
Ra Nala
11/25/2015 02:42AM
Re: which is best for JOIN approach  
687
Rick James
11/29/2015 11:53AM
Re: which is best for JOIN approach  
615
Ra Nala
02/19/2016 05:28AM
Re: which is best for JOIN approach  
580
Peter Brawley
02/21/2016 04:56PM
Re: which is best for JOIN approach  
574
Ra Nala
02/19/2016 05:31AM
Re: which is best for JOIN approach  
555
Rick James
02/21/2016 01:40PM
Re: which is best for JOIN approach  
596
Rick James
02/21/2016 01:43PM
Re: which is best for JOIN approach  
611
Ra Nala
02/25/2016 05:50AM
Why is wrong index being selected  
906
Steve Bell
02/23/2016 01:54PM
Re: Why is wrong index being selected  
483
Rick James
02/23/2016 11:39PM
Re: Why is wrong index being selected  
596
Øystein Grøvlen
02/24/2016 03:22AM
Re: Why is wrong index being selected  
505
Steve Bell
02/25/2016 02:47AM
Distinct or Group by which is faster  
1,176
Ra Nala
02/22/2016 08:50AM
Re: Distinct or Group by which is faster  
570
Peter Brawley
02/22/2016 12:33PM
Re: Distinct or Group by which is faster  
542
Chandan Kumar
02/23/2016 12:51PM
MySQL server is not disk bound, how do I make it faster?  
977
Robert Gunther
02/21/2016 09:35PM
Re: MySQL server is not disk bound, how do I make it faster?  
462
Peter Brawley
02/22/2016 12:38PM
Re: MySQL server is not disk bound, how do I make it faster?  
503
Rick James
02/22/2016 06:18PM
mysql text datatype SELECT query slow even with tmp dir on tmpfs  
973
Muhammad Omair
02/22/2016 08:36AM
Re: mysql text datatype SELECT query slow even with tmp dir on tmpfs  
455
Peter Brawley
02/22/2016 12:35PM
How can I improve this table and query  
1,167
Adam Copley
02/17/2016 04:49AM
Re: How can I improve this table and query  
575
Øystein Grøvlen
02/17/2016 06:07AM
Re: How can I improve this table and query  
610
Adam Copley
02/17/2016 08:25AM
Re: How can I improve this table and query  
458
Adam Copley
02/17/2016 08:26AM
Re: How can I improve this table and query  
537
Øystein Grøvlen
02/17/2016 08:51AM
Re: How can I improve this table and query  
736
Adam Copley
02/17/2016 09:03AM
Re: How can I improve this table and query  
473
Rick James
02/21/2016 11:14PM
Does prefixing field names with their table name improve query speed?  
924
Guillaume TRUCHOT
02/18/2016 04:02PM
Re: Does prefixing field names with their table name improve query speed?  
503
Peter Brawley
02/18/2016 05:21PM
Re: Does prefixing field names with their table name improve query speed?  
520
Rick James
02/21/2016 07:19PM
slow response when where clause has a field from 2nd table in a left join  
919
Ravi Malghan
02/12/2016 12:51PM
Re: slow response when where clause has a field from 2nd table in a left join  
584
Øystein Grøvlen
02/15/2016 02:10AM
Re: slow response when where clause has a field from 2nd table in a left join  
448
Rick James
02/15/2016 04:17PM
Re: slow response when where clause has a field from 2nd table in a left join  
434
Ravi Malghan
02/19/2016 10:18AM
max_allowed_packet error  
1,230
Ra Nala
02/02/2016 05:12AM
Re: max_allowed_packet error  
480
Rick James
02/06/2016 07:26PM
Getting NULL digest_text for all queries in 2 of my 3 DBs (performance_schema)  
1,145
Bill Joyce
12/06/2015 11:41PM
Re: Getting NULL digest_text for all queries in 2 of my 3 DBs (performance_schema)  
593
Mayank Prasad
12/10/2015 03:53AM
Re: Getting NULL digest_text for all queries in 2 of my 3 DBs (performance_schema)  
680
Bill Joyce
02/04/2016 04:15PM
query performance optimization  
1,534
Devrishi Shandilya
01/18/2016 04:49AM
Re: query performance optimization  
575
Øystein Grøvlen
01/19/2016 02:30AM
Re: query performance optimization  
553
Devrishi Shandilya
01/19/2016 02:50AM
Re: query performance optimization  
589
Øystein Grøvlen
01/19/2016 06:24AM
Re: query performance optimization  
592
Rick James
01/22/2016 06:29PM
Re: query performance optimization  
518
Øystein Grøvlen
01/29/2016 04:37AM
Re: query performance optimization  
927
Devrishi Shandilya
01/22/2016 06:18AM
Re: query performance optimization  
502
Øystein Grøvlen
01/27/2016 06:56AM
Re: query performance optimization  
547
Peter Brawley
01/22/2016 01:08PM
Re: query performance optimization  
552
Peter Brawley
01/22/2016 11:10PM
Slow performance on join query using indexes  
1,372
Amit Kapoor
01/21/2016 02:36PM
Re: Slow performance on join query using indexes  
755
Øystein Grøvlen
01/22/2016 03:02AM
Re: Slow performance on join query using indexes  
563
Rick James
01/23/2016 07:43PM
high cpu on request with JOIN  
1,095
Gérard Moisset
01/15/2016 03:49AM
Re: high cpu on request with JOIN  
512
Øystein Grøvlen
01/15/2016 05:43AM
Lock wait timeout exceeded; try restarting transaction  
10,162
Ra Nala
01/07/2016 05:28AM
Re: Lock wait timeout exceeded; try restarting transaction  
2,427
Rick James
01/07/2016 10:47PM
Re: Lock wait timeout exceeded; try restarting transaction  
2,093
Ra Nala
01/08/2016 12:45AM
Re: Lock wait timeout exceeded; try restarting transaction  
1,626
Ra Nala
01/08/2016 06:23AM
Re: Lock wait timeout exceeded; try restarting transaction  
1,675
Rick James
01/09/2016 11:52PM
1 blob table vs multiple blob tables  
1,040
charles candy
01/08/2016 01:03AM
Re: 1 blob table vs multiple blob tables  
471
Benoit St-Jean
01/08/2016 02:26AM
Thread State - Query End  
2,358
Simon Green
01/04/2016 11:50AM
Re: Thread State - Query End  
1,213
Øystein Grøvlen
01/05/2016 03:09AM
Re: Thread State - Query End  
855
Øystein Grøvlen
01/06/2016 02:28AM
thread_cache_size: Need suggestion on this paramateer  
894
Gnanasekar A.
12/26/2015 10:49AM
Re: thread_cache_size: Need suggestion on this paramateer  
491
Rick James
12/27/2015 10:17AM
query hangs after migration from mysql 5.5 to mysql 5.6  
1,140
walter verdelocco
12/19/2015 12:00PM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
746
walter verdelocco
12/19/2015 01:21PM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
511
Rick James
12/20/2015 07:31PM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
544
walter verdelocco
12/21/2015 06:38AM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
496
Øystein Grøvlen
12/21/2015 03:41AM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
495
walter verdelocco
12/21/2015 06:40AM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
534
Øystein Grøvlen
12/21/2015 07:22AM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
497
walter verdelocco
12/22/2015 01:57AM
how to find out all sql and table of running transaction  
1,101
elison chen
12/17/2015 01:30AM
Re: how to find out all sql and table of running transaction  
504
Øystein Grøvlen
12/17/2015 03:08AM
show open tables in_use is high  
1,313
elison chen
12/15/2015 07:23PM
Re: show open tables in_use is high  
552
Rick James
12/16/2015 08:08PM
Slow query  
1,166
Gerry Whitmarsh
12/11/2015 01:00PM
Re: Slow query  
570
Peter Brawley
12/11/2015 05:00PM
Re: Slow query  
552
Rick James
12/11/2015 06:56PM
Re: Slow query (solved)  
488
Gerry Whitmarsh
12/12/2015 07:34AM
Re: Slow query  
520
Øystein Grøvlen
12/14/2015 02:34AM
Re: Slow query  
450
Gerry Whitmarsh
12/15/2015 08:48AM
Re: Slow query  
521
Rick James
12/15/2015 10:57AM
Re: Slow query  
548
Øystein Grøvlen
12/16/2015 02:33AM
query with bad performance after migration to mysql 5.6  
1,474
walter verdelocco
12/04/2015 05:35AM
Re: query with bad performance after migration to mysql 5.6  
704
Peter Brawley
12/05/2015 01:54PM
Re: query with bad performance after migration to mysql 5.6  
575
Rick James
12/07/2015 01:05AM
Re: query with bad performance after migration to mysql 5.6  
730
Øystein Grøvlen
12/09/2015 03:22AM
Re: query with bad performance after migration to mysql 5.6  
771
walter verdelocco
12/09/2015 03:38AM
Re: query with bad performance after migration to mysql 5.6  
559
Øystein Grøvlen
12/09/2015 04:21AM
Re: query with bad performance after migration to mysql 5.6  
755
walter verdelocco
12/09/2015 06:31AM
Re: query with bad performance after migration to mysql 5.6  
654
Øystein Grøvlen
12/09/2015 09:30AM
Re: query with bad performance after migration to mysql 5.6  
618
walter verdelocco
12/09/2015 09:49AM
Re: query with bad performance after migration to mysql 5.6  
569
walter verdelocco
12/09/2015 09:59AM
Re: query with bad performance after migration to mysql 5.6  
707
Øystein Grøvlen
12/10/2015 04:37AM
Re: query with bad performance after migration to mysql 5.6  
615
walter verdelocco
12/10/2015 07:39AM
Re: query with bad performance after migration to mysql 5.6  
756
walter verdelocco
12/10/2015 08:09AM
Re: query with bad performance after migration to mysql 5.6  
829
walter verdelocco
12/09/2015 03:44AM
Another Using temporary; Using filesort performance problem  
1,175
Drew Tennenbaum
12/07/2015 06:37PM
Re: Another Using temporary; Using filesort performance problem  
715
Drew Tennenbaum
12/07/2015 07:39PM
Re: Another Using temporary; Using filesort performance problem  
582
Rick James
12/08/2015 08:52PM
Re: Another Using temporary; Using filesort performance problem  
778
Drew Tanner
12/09/2015 10:31AM
Chinese data not appraing  
1,032
Ra Nala
11/25/2015 04:42AM
Re: Chinese data not appraing  
534
Rick James
11/29/2015 11:25AM
Re: Chinese data not appraing  
572
Ra Nala
11/30/2015 01:24AM
Re: Chinese data not appraing  
581
Rick James
12/01/2015 06:14PM
Re: Chinese data not appraing  
576
Ra Nala
12/02/2015 01:12AM
Re: Chinese data not appraing  
543
Rick James
12/07/2015 01:22AM
Re: Chinese data not appraing  
548
Ra Nala
12/07/2015 10:24AM
Re: Chinese data not appraing  
464
Rick James
12/08/2015 08:58PM
Re: Chinese data not appraing  
557
Ra Nala
12/09/2015 01:04AM
Slow mysql query, copying to tmp table, using filesort  
1,552
Aaron Bains
12/07/2015 04:50AM
Re: Slow mysql query, copying to tmp table, using filesort  
764
Rick James
12/08/2015 08:59PM
Re: Slow mysql query, copying to tmp table, using filesort  
1,072
Peter Brawley
12/08/2015 10:48PM
drop and recreate index in mysql DB  
1,106
Ra Nala
11/25/2015 05:48AM
Re: drop and recreate index in mysql DB  
697
Rick James
11/26/2015 02:31PM
Re: drop and recreate index in mysql DB  
605
Ra Nala
11/27/2015 12:33AM
Re: drop and recreate index in mysql DB  
974
Rick James
11/29/2015 11:38AM
Re: drop and recreate index in mysql DB  
814
Ra Nala
11/30/2015 01:34AM
Single host configuration suggest  
1,061
Yury Tsaregorodtsev
11/08/2015 01:50PM
Re: Single host configuration suggest  
504
Øystein Grøvlen
11/17/2015 06:05AM
Re: Single host configuration suggest  
432
Rick James
11/29/2015 12:20PM
Suddenly mysql server performance degraded  
1,172
Devrishi Shandilya
11/05/2015 12:26AM
Re: Suddenly mysql server performance degraded  
508
Peter Brawley
11/05/2015 11:41PM
Re: Suddenly mysql server performance degraded  
712
Rick James
11/26/2015 10:01PM
Pages:
« 1 2 3 4 5
...
75 »

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.