MySQL Forums
Forum List  »  Performance
Announcements Last Post
•   MySQL Connector/Python 2.1.8 has been released 09/03/2018 11:16AM

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

Subject
Views
Written By
Posted
Query optimizatoin  
686
Syed Anjum
10/26/2016 03:32AM
Re: Query optimizatoin  
385
Øystein Grøvlen
10/26/2016 04:41AM
Writing sample data very fast from (TwinCAT) PLC to a MySQL database?  
814
sdgbfdsg fdhgfdhds
10/18/2016 08:14AM
Re: Writing sample data very fast from (TwinCAT) PLC to a MySQL database?  
706
Rick James
10/23/2016 12:08AM
How to Analyze and Tune MySQL Queries for Better Performance  
613
Edwin Desouza
10/21/2016 09:57AM
Locked queries  
889
Juan Nino
09/28/2016 06:31PM
Re: Locked queries  
464
Peter Brawley
09/29/2016 09:39AM
MySQL optimisation for single laptop with 16 GB RAM  
855
Philip Gladwin
09/08/2016 05:58AM
Re: MySQL optimisation for single laptop with 16 GB RAM  
447
Rick James
09/10/2016 12:17AM
Relationship between MySQL variable open_files_limit and table_open_cache  
862
salman khan
09/09/2016 04:34AM
Re: Relationship between MySQL variable open_files_limit and table_open_cache  
466
Rick James
09/10/2016 12:13AM
Millions of rows, storing aggregate/rollup results help please  
901
Jacqueline Jacobin
08/28/2016 12:23PM
Re: Millions of rows, storing aggregate/rollup results help please  
584
Rick James
08/30/2016 02:47PM
Re: Millions of rows, storing aggregate/rollup results help please  
505
Jacqueline Jacobin
08/31/2016 07:03AM
Re: Millions of rows, storing aggregate/rollup results help please  
479
Rick James
09/01/2016 04:35PM
Multiple indexes - how do they work?  
753
Rathi Rao
08/25/2016 03:51AM
Re: Multiple indexes - how do they work?  
436
Peter Brawley
08/25/2016 11:29AM
Re: Multiple indexes - how do they work?  
407
Rathi Rao
08/29/2016 03:48AM
Re: Multiple indexes - how do they work?  
406
Rick James
08/26/2016 02:20PM
Re: Multiple indexes - how do they work?  
394
Rathi Rao
08/29/2016 03:46AM
Re: Multiple indexes - how do they work?  
465
Øystein Grøvlen
08/29/2016 01:23AM
Re: Multiple indexes - how do they work?  
408
Rathi Rao
08/29/2016 03:45AM
Re: Multiple indexes - how do they work?  
416
Øystein Grøvlen
08/29/2016 04:17AM
Re: Multiple indexes - how do they work?  
398
Rathi Rao
08/29/2016 04:39AM
MySQL Table Valued Parameter  
1,586
tony mendoza
08/23/2016 11:29AM
Re: MySQL Table Valued Parameter  
713
Rick James
08/26/2016 02:17PM
Partitioned table details in the Explain Plan  
729
Rathi Rao
08/19/2016 01:54AM
Re: Partitioned table details in the Explain Plan  
383
Øystein Grøvlen
08/19/2016 07:00AM
Re: Partitioned table details in the Explain Plan  
460
Rick James
08/20/2016 06:10PM
Rolling unique user counts  
699
Paul Stam
08/09/2016 02:06AM
Re: Rolling unique user counts  
428
Rick James
08/14/2016 06:22PM
Re: Rolling unique user counts  
393
Paul Stam
08/15/2016 01:49AM
Re: Rolling unique user counts  
419
Paul Stam
08/18/2016 06:03AM
Re: Rolling unique user counts  
464
Rick James
08/18/2016 04:37PM
Wrong estimation of Rows in explain  
951
Rathi Rao
07/27/2016 06:19AM
Re: Wrong estimation of Rows in explain  
480
Peter Brawley
07/27/2016 08:55AM
Re: Wrong estimation of Rows in explain  
525
Rathi Rao
07/27/2016 11:58PM
Re: Wrong estimation of Rows in explain  
472
Peter Brawley
07/28/2016 09:14AM
Re: Wrong estimation of Rows in explain  
462
Rathi Rao
07/29/2016 05:11AM
Re: Wrong estimation of Rows in explain  
480
Peter Brawley
07/29/2016 01:10PM
Re: Wrong estimation of Rows in explain  
457
Rick James
07/29/2016 06:58PM
Re: Wrong estimation of Rows in explain  
465
Rathi Rao
08/02/2016 05:48AM
Re: Wrong estimation of Rows in explain  
461
Rick James
08/02/2016 06:23PM
Re: Wrong estimation of Rows in explain  
466
Rathi Rao
08/02/2016 05:38AM
Re: Wrong estimation of Rows in explain  
473
james wang
08/04/2016 05:31AM
30 millions reads/day  
756
Srinivas K
07/29/2016 05:34AM
Re: 30 millions reads/day  
463
Rick James
07/29/2016 07:03PM
Re: 30 millions reads/day  
425
james wang
08/04/2016 05:15AM
mysql commit slow,please help me  
1,043
jw maple
07/27/2016 02:11AM
Re: mysql commit slow,please help me  
582
Rick James
07/29/2016 05:15PM
Very slow query when too many joins  
1,608
As Os
06/05/2016 09:17AM
Re: Very slow query when too many joins  
746
As Os
06/05/2016 09:27AM
Re: Very slow query when too many joins  
668
Peter Brawley
06/05/2016 10:14AM
Re: Very slow query when too many joins  
613
As Os
06/05/2016 10:48AM
Re: Very slow query when too many joins  
652
Peter Brawley
06/05/2016 10:56AM
Re: Very slow query when too many joins  
568
As Os
06/05/2016 03:33PM
Re: Very slow query when too many joins  
589
Peter Brawley
06/05/2016 03:41PM
Re: Very slow query when too many joins  
630
Rick James
06/05/2016 05:36PM
Re: Very slow query when too many joins  
621
As Os
06/06/2016 02:23AM
Re: Very slow query when too many joins  
570
As Os
06/06/2016 03:33AM
Re: Very slow query when too many joins  
541
As Os
06/06/2016 08:36AM
Re: Very slow query when too many joins  
511
Peter Brawley
06/06/2016 08:52AM
Re: Very slow query when too many joins  
602
As Os
06/06/2016 09:02AM
Re: Very slow query when too many joins  
547
Peter Brawley
06/06/2016 11:16AM
Re: Very slow query when too many joins  
564
Peter Brawley
06/06/2016 08:29AM
Re: Very slow query when too many joins  
555
As Os
06/06/2016 11:30AM
Re: Very slow query when too many joins  
601
Peter Brawley
06/06/2016 12:08PM
Re: Very slow query when too many joins  
556
As Os
06/06/2016 02:11PM
Re: Very slow query when too many joins  
595
Rick James
06/07/2016 03:40PM
Re: Very slow query when too many joins  
578
james wang
07/20/2016 05:34AM
Re: Very slow query when too many joins  
531
Rick James
07/20/2016 09:37AM
Re: Very slow query when too many joins  
549
james wang
07/21/2016 04:43AM
Re: Very slow query when too many joins  
530
Rick James
07/22/2016 10:59PM
MySQL data volume  
786
Parfait Fortuné NDOLO
07/21/2016 10:21AM
Re: MySQL data volume  
492
Peter Brawley
07/21/2016 11:41PM
Re: MySQL data volume  
472
Rick James
07/22/2016 10:57PM
Query optimize on large database  
825
Pavel Volkov
07/13/2016 01:40AM
Re: Query optimize on large database  
467
Rick James
07/15/2016 05:12PM
Re: Query optimize on large database  
461
Pavel Volkov
07/16/2016 04:15AM
Re: Query optimize on large database  
444
Peter Brawley
07/16/2016 12:09PM
Re: Query optimize on large database  
477
Pavel Volkov
07/16/2016 12:36PM
Re: Query optimize on large database  
429
Rick James
07/16/2016 02:46PM
Re: Query optimize on large database  
482
Peter Brawley
07/17/2016 11:22AM
Re: Query optimize on large database  
451
Pavel Volkov
07/18/2016 04:28AM
Re: Query optimize on large database  
424
Peter Brawley
07/18/2016 08:40AM
Re: Query optimize on large database  
437
james wang
07/20/2016 04:46AM
Re: Query optimize on large database  
439
Pavel Volkov
07/20/2016 08:06AM
Re: Query optimize on large database  
451
Rick James
07/20/2016 09:29AM
Re: Query optimize on large database  
466
james wang
07/21/2016 04:35AM
Unexplained very bad subquery performance  
745
Arnaud Bertrand
07/18/2016 04:29AM
Re: Unexplained very bad subquery performance  
442
Peter Brawley
07/18/2016 08:44AM
Re: Unexplained very bad subquery performance  
542
Arnaud Bertrand
07/18/2016 01:06PM
Re: Unexplained very bad subquery performance  
428
Peter Brawley
07/18/2016 03:30PM
Re: Unexplained very bad subquery performance  
480
Arnaud Bertrand
07/19/2016 03:16AM
Re: Unexplained very bad subquery performance  
414
Peter Brawley
07/19/2016 04:21AM
Re: Unexplained very bad subquery performance  
426
james wang
07/20/2016 04:35AM
specify conditions from outer query on a materialized subquery  
658
Pratik Gandhi
07/12/2016 10:55PM
Re: specify conditions from outer query on a materialized subquery  
396
Rick James
07/15/2016 05:15PM
This topic has been moved.:  GOT PACKETS OUT OF ORDER  
12
Jeisson Sierra
07/11/2016 07:48PM
count(*) or count(id)  
1,482
Ra Nala
06/28/2016 06:22AM
Re: count(*) or count(id)  
566
Ra Nala
06/28/2016 06:26AM
Re: count(*) or count(id)  
499
Peter Brawley
06/28/2016 05:18PM
Re: count(*) or count(id)  
583
Rick James
07/04/2016 01:04PM
Re: count(*) or count(id)  
493
Ra Nala
07/06/2016 12:30AM
CREATE INDEX Online DDL Not Working  
853
Jayanath Dissanayake
06/20/2016 05:02AM
Re: CREATE INDEX Online DDL Not Working  
475
Øystein Grøvlen
06/22/2016 12:43AM
Re: CREATE INDEX Online DDL Not Working  
487
Rick James
06/23/2016 07:07PM
Select random rows when using UUID  
1,198
Jonathan Keen
06/09/2016 11:43AM
Re: Select random rows when using UUID  
567
Rick James
06/13/2016 01:36AM
Re: Select random rows when using UUID  
641
Jonathan Keen
06/14/2016 11:23AM
Re: Select random rows when using UUID  
524
Rick James
06/18/2016 01:35AM
SQLSTATE[HY000] [1044] Access denied  
3,828
YOONTAE KIM
06/16/2016 07:55PM
Index Not being used.  
1,491
Greg Mundt
05/26/2016 02:29PM
Re: Index Not being used.  
707
Peter Brawley
05/26/2016 03:53PM
Re: Index Not being used.  
583
Øystein Grøvlen
05/27/2016 12:45AM
Re: Index Not being used.  
555
Greg Mundt
05/27/2016 07:05AM
Re: Index Not being used.  
494
Rick James
05/27/2016 11:29PM
Re: Index Not being used.  
634
Greg Mundt
05/31/2016 07:04AM
Re: Index Not being used.  
525
Rick James
05/31/2016 09:26PM
Re: Index Not being used.  
577
Greg Mundt
06/01/2016 05:40AM
Re: Index Not being used.  
451
Rick James
06/01/2016 11:29AM
Re: Index Not being used.  
513
Greg Mundt
06/01/2016 11:41AM
Re: Index Not being used.  
527
Rick James
06/04/2016 05:14PM
Re: Index Not being used.  
578
Greg Mundt
05/27/2016 10:14AM
A proposal to make disk IO much faster under SSD  
1,016
suiyemin sui
05/29/2016 09:16PM
Re: A proposal to make disk IO much faster under SSD  
594
Rick James
05/31/2016 09:48PM
Re: A proposal to make disk IO much faster under SSD  
556
suiyemin sui
06/01/2016 02:05AM
Re: A proposal to make disk IO much faster under SSD  
490
Rick James
06/04/2016 04:38PM
query taking really long time.  
842
Mehraz Ahmed Sheikh
05/16/2016 09:45AM
Re: query taking really long time.  
472
Rick James
05/23/2016 02:58PM
Left join vs Inner join  
1,082
Vikas Sood
05/09/2016 06:10PM
Re: Left join vs Inner join  
554
Øystein Grøvlen
05/10/2016 08:04AM
Re: Left join vs Inner join  
505
Vikas Sood
05/10/2016 10:40AM
Re: Left join vs Inner join  
513
Rick James
05/10/2016 07:23PM
How can I improve the import speed of a large SQL file?  
8,171
Jeff Vincent
05/06/2016 09:46AM
Re: How can I improve the import speed of a large SQL file?  
3,536
Peter Brawley
05/06/2016 11:49AM
Re: How can I improve the import speed of a large SQL file?  
2,448
Jeff Vincent
05/06/2016 12:17PM
Re: How can I improve the import speed of a large SQL file?  
2,277
Rick James
05/06/2016 05:44PM
Re: How can I improve the import speed of a large SQL file?  
1,907
Shane Bester
05/08/2016 04:49AM
text vs varchar  
1,067
hua kai
04/28/2016 08:36AM
Re: text vs varchar  
663
Øystein Grøvlen
04/29/2016 12:41AM
Re: text vs varchar  
602
Rick James
04/30/2016 11:51PM
Re: text vs varchar  
599
Øystein Grøvlen
05/02/2016 04:37AM
Re: text vs varchar  
557
hua kai
05/02/2016 09:14PM
Re: text vs varchar  
550
Øystein Grøvlen
05/03/2016 02:19AM
Re: text vs varchar  
1,115
hua kai
05/03/2016 04:12AM
Re: text vs varchar  
537
hua kai
05/02/2016 08:02PM
Re: text vs varchar  
706
Øystein Grøvlen
05/03/2016 02:25AM
Query with 2 x subquery  
907
Jes Ramsing
04/29/2016 06:44AM
Re: Query with 2 x subquery  
527
Øystein Grøvlen
04/29/2016 08:01AM
Re: Query with 2 x subquery  
496
Jes Ramsing
05/01/2016 11:57PM
Re: Query with 2 x subquery  
480
Øystein Grøvlen
05/02/2016 03:45AM
Re: Query with 2 x subquery  
469
Jes Ramsing
05/02/2016 05:32AM
Re: Query with 2 x subquery  
478
Rick James
05/01/2016 11:58PM
Re: Query with 2 x subquery  
533
Jes Ramsing
05/02/2016 02:16AM
Slow Query, Optimization Advice Needed  
962
Michael Lawson
04/26/2016 09:30AM
Re: Slow Query, Optimization Advice Needed  
494
Øystein Grøvlen
04/27/2016 01:02AM
Re: Slow Query, Optimization Advice Needed  
571
Michael Lawson
04/27/2016 07:20PM
Re: Slow Query, Optimization Advice Needed  
455
Peter Brawley
04/27/2016 11:28PM
Re: Slow Query, Optimization Advice Needed  
488
Øystein Grøvlen
04/28/2016 01:25AM
Re: Slow Query, Optimization Advice Needed  
473
Rick James
05/01/2016 11:47PM
Re: Slow Query, Optimization Advice Needed  
486
Øystein Grøvlen
05/02/2016 01:28AM
Re: Slow Query, Optimization Advice Needed  
517
Øystein Grøvlen
04/28/2016 01:12AM
Reg table design and query performances  
909
Devrishi Shandilya
04/26/2016 03:02AM
Re: Reg table design and query performances  
502
Øystein Grøvlen
04/26/2016 06:02AM
Re: Reg table design and query performances  
607
Devrishi Shandilya
04/26/2016 06:16AM
Re: Reg table design and query performances  
496
Øystein Grøvlen
04/26/2016 06:35AM
Re: Reg table design and query performances  
485
Devrishi Shandilya
04/26/2016 06:50AM
Re: Reg table design and query performances  
481
Øystein Grøvlen
04/26/2016 07:04AM
Re: Reg table design and query performances  
455
Rick James
04/30/2016 11:46PM
Re: Reg table design and query performances  
432
Øystein Grøvlen
05/02/2016 01:00AM
Memory benefits of huge pages  
1,984
Olga Turetskaya
04/30/2016 11:21AM
Re: Memory benefits of huge pages  
976
Rick James
05/01/2016 02:36PM
Configuration review requested  
1,238
Jens Meier
04/13/2016 11:55AM
Re: Configuration review requested  
527
Rick James
04/14/2016 01:39PM
block_ops_in and block_ops_out meaning  
1,849
hua kai
03/18/2016 02:33AM
Re: block_ops_in and block_ops_out meaning  
873
Rick James
03/21/2016 11:34PM
Re: block_ops_in and block_ops_out meaning  
886
Peter Brawley
03/22/2016 02:03AM
Re: block_ops_in and block_ops_out meaning  
877
hua kai
03/25/2016 12:30AM
Re: block_ops_in and block_ops_out meaning  
839
hua kai
04/14/2016 12:52AM
order by primary key slowly  
1,192
varky chan
04/05/2016 10:42PM
Re: order by primary key slowly  
524
Øystein Grøvlen
04/06/2016 04:35AM
Re: order by primary key slowly  
539
varky chan
04/06/2016 10:15AM
Re: order by primary key slowly  
554
Peter Brawley
04/06/2016 11:23AM
Re: order by primary key slowly  
603
varky chan
04/06/2016 08:11PM
Re: order by primary key slowly  
515
Peter Brawley
04/06/2016 10:35PM
Re: order by primary key slowly  
528
varky chan
04/07/2016 12:34AM
Re: order by primary key slowly  
630
Øystein Grøvlen
04/07/2016 07:21AM
Re: order by primary key slowly  
564
Peter Brawley
04/07/2016 10:20AM
Re: order by primary key slowly  
528
varky chan
04/07/2016 11:26PM
Re: order by primary key slowly  
536
Rick James
04/12/2016 07:42PM
Re: order by primary key slowly  
523
Peter Brawley
04/06/2016 08:57AM
Re: order by primary key slowly  
520
varky chan
04/06/2016 10:17AM
[INNODB] why there are many "waiting for table level lock"?  
978
HANWEN YIN
04/11/2016 12:08AM
Re: [INNODB] why there are many "waiting for table level lock"?  
638
Rick James
04/12/2016 07:27PM
Improve performance when altering huge tables  
922
Davide Cicuta
04/04/2016 07:24AM
Re: Improve performance when altering huge tables  
549
Rick James
04/05/2016 02:59PM
MySql 5.7 - Poor Performance PURGE BINARY LOGS  
1,405
Davy Campano
03/23/2016 08:08PM
Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS  
591
Rick James
03/26/2016 11:58PM
Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS  
610
Davy Campano
03/29/2016 09:44AM
where the snapshot for select in transaction stored  
878
hua kai
03/21/2016 03:03AM
Re: where the snapshot for select in transaction stored  
464
Rick James
03/21/2016 11:21PM
Difference execution plans for same query  
1,125
Devrishi Shandilya
02/25/2016 12:05AM
Re: Difference execution plans for same query  
510
Peter Brawley
02/25/2016 01:51AM
Re: Difference execution plans for same query  
570
Øystein Grøvlen
02/25/2016 03:51AM
Re: Difference execution plans for same query  
566
Rick James
03/05/2016 01:19AM
Slow join performance  
1,088
Ra Nala
11/27/2015 04:55AM
Re: Slow join performance  
596
Rick James
11/28/2015 03:02PM
Re: Slow join performance  
492
Ra Nala
02/25/2016 06:22AM
which is best for JOIN approach  
1,072
Ra Nala
11/24/2015 09:39AM
Re: which is best for JOIN approach  
642
Øystein Grøvlen
11/25/2015 02:14AM
Re: which is best for JOIN approach  
634
Ra Nala
11/25/2015 02:42AM
Re: which is best for JOIN approach  
608
Rick James
11/29/2015 11:53AM
Re: which is best for JOIN approach  
524
Ra Nala
02/19/2016 05:28AM
Re: which is best for JOIN approach  
502
Peter Brawley
02/21/2016 04:56PM
Re: which is best for JOIN approach  
488
Ra Nala
02/19/2016 05:31AM
Re: which is best for JOIN approach  
481
Rick James
02/21/2016 01:40PM
Re: which is best for JOIN approach  
514
Rick James
02/21/2016 01:43PM
Re: which is best for JOIN approach  
526
Ra Nala
02/25/2016 05:50AM
Why is wrong index being selected  
824
Steve Bell
02/23/2016 01:54PM
Re: Why is wrong index being selected  
432
Rick James
02/23/2016 11:39PM
Re: Why is wrong index being selected  
519
Øystein Grøvlen
02/24/2016 03:22AM
Re: Why is wrong index being selected  
456
Steve Bell
02/25/2016 02:47AM
Distinct or Group by which is faster  
1,036
Ra Nala
02/22/2016 08:50AM
Re: Distinct or Group by which is faster  
487
Peter Brawley
02/22/2016 12:33PM
Re: Distinct or Group by which is faster  
469
Chandan Kumar
02/23/2016 12:51PM
MySQL server is not disk bound, how do I make it faster?  
850
Robert Gunther
02/21/2016 09:35PM
Re: MySQL server is not disk bound, how do I make it faster?  
416
Peter Brawley
02/22/2016 12:38PM
Re: MySQL server is not disk bound, how do I make it faster?  
443
Rick James
02/22/2016 06:18PM
mysql text datatype SELECT query slow even with tmp dir on tmpfs  
874
Muhammad Omair
02/22/2016 08:36AM
Re: mysql text datatype SELECT query slow even with tmp dir on tmpfs  
418
Peter Brawley
02/22/2016 12:35PM
How can I improve this table and query  
1,027
Adam Copley
02/17/2016 04:49AM
Re: How can I improve this table and query  
472
Øystein Grøvlen
02/17/2016 06:07AM
Re: How can I improve this table and query  
522
Adam Copley
02/17/2016 08:25AM
Re: How can I improve this table and query  
411
Adam Copley
02/17/2016 08:26AM
Re: How can I improve this table and query  
473
Øystein Grøvlen
02/17/2016 08:51AM
Re: How can I improve this table and query  
610
Adam Copley
02/17/2016 09:03AM
Re: How can I improve this table and query  
416
Rick James
02/21/2016 11:14PM
Does prefixing field names with their table name improve query speed?  
795
Guillaume TRUCHOT
02/18/2016 04:02PM
Re: Does prefixing field names with their table name improve query speed?  
427
Peter Brawley
02/18/2016 05:21PM
Re: Does prefixing field names with their table name improve query speed?  
466
Rick James
02/21/2016 07:19PM
This topic has been moved.:  MySQL optimisation for single laptop with 16 GB RAM  
0
Philip Gladwin
09/08/2016 09:41AM
Pages:
« 1 2 3 4 5
...
74 »

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.