MySQL Forums :: Performance


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.3 GA has been released 09/15/2016 03:06PM
MySQL Connector/Python 2.2.1 m2 Development Release has been released 09/13/2016 09:58AM
Oracle Enterprise Manager for MySQL Database 12.1.0.4.0 has been released 09/12/2016 02:59PM
MySQL Community Server 8.0.0-dmr has been released (part 3/3) 09/12/2016 08:52AM
MySQL Community Server 8.0.0-dmr has been released (part 2/3) 09/12/2016 08:50AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 72
Subject Views Written By Posted
Sticky:  MySQL 8.0: Performance Schema (1 Posts)   55 Edwin Desouza 09/16/2016 09:07AM
Sticky:  MySQL XProtocol: Asynchronous Query Execution (1 Posts)   350 Edwin Desouza 05/27/2016 03:34PM
Sticky:  MySQL 5.7: Performance Benchmarks -- 1.6million QPS (1 Posts)   1,122 Edwin Desouza 10/27/2015 08:14AM
Sticky:  MySQL 5.7: includes SYS Schema (metrics, instumentation) (1 Posts)   1,343 Edwin Desouza 04/10/2015 02:40PM
Sticky:  MySQL Performance Tuning: Deep Dive (1 Posts)   1,873 Edwin Desouza 02/27/2015 08:09PM
Sticky:  MySQL Workbench: Performance Dashboard (1 Posts)   2,350 Edwin Desouza 04/01/2014 08:21AM
Sticky:  MySQL 5.6: Performance Benchmarks (1 Posts)   4,007 Edwin Desouza 02/12/2013 06:11PM
Sticky:  Finding/killing long running InnoDB transactions (1 Posts)   6,296 Edwin DeSouza 08/04/2011 09:09AM
Sticky:  MySQL Performance Tuning: Benchmarks, Best Practices, FAQs (1 Posts)   166,949 Edwin DeSouza 05/25/2006 10:50AM
Locked queries   28 Juan Nino 09/28/2016 06:31PM
Re: Locked queries   11 Peter Brawley 09/29/2016 09:39AM
MySQL optimisation for single laptop with 16 GB RAM   86 Philip Gladwin 09/08/2016 05:58AM
Re: MySQL optimisation for single laptop with 16 GB RAM   38 Rick James 09/10/2016 12:17AM
Relationship between MySQL variable open_files_limit and table_open_cache   70 salman khan 09/09/2016 04:34AM
Re: Relationship between MySQL variable open_files_limit and table_open_cache   38 Rick James 09/10/2016 12:13AM
Millions of rows, storing aggregate/rollup results help please   112 Jacqueline Jacobin 08/28/2016 12:23PM
Re: Millions of rows, storing aggregate/rollup results help please   57 Rick James 08/30/2016 02:47PM
Re: Millions of rows, storing aggregate/rollup results help please   51 Jacqueline Jacobin 08/31/2016 07:03AM
Re: Millions of rows, storing aggregate/rollup results help please   44 Rick James 09/01/2016 04:35PM
Multiple indexes - how do they work?   106 Rathi Rao 08/25/2016 03:51AM
Re: Multiple indexes - how do they work?   69 Peter Brawley 08/25/2016 11:29AM
Re: Multiple indexes - how do they work?   45 Rathi Rao 08/29/2016 03:48AM
Re: Multiple indexes - how do they work?   52 Rick James 08/26/2016 02:20PM
Re: Multiple indexes - how do they work?   38 Rathi Rao 08/29/2016 03:46AM
Re: Multiple indexes - how do they work?   57 Øystein Grøvlen 08/29/2016 01:23AM
Re: Multiple indexes - how do they work?   48 Rathi Rao 08/29/2016 03:45AM
Re: Multiple indexes - how do they work?   43 Øystein Grøvlen 08/29/2016 04:17AM
Re: Multiple indexes - how do they work?   43 Rathi Rao 08/29/2016 04:39AM
MySQL Table Valued Parameter   104 tony mendoza 08/23/2016 11:29AM
Re: MySQL Table Valued Parameter   54 Rick James 08/26/2016 02:17PM
Partitioned table details in the Explain Plan   121 Rathi Rao 08/19/2016 01:54AM
Re: Partitioned table details in the Explain Plan   56 Øystein Grøvlen 08/19/2016 07:00AM
Re: Partitioned table details in the Explain Plan   57 Rick James 08/20/2016 06:10PM
Rolling unique user counts   111 Paul Stam 08/09/2016 02:06AM
Re: Rolling unique user counts   69 Rick James 08/14/2016 06:22PM
Re: Rolling unique user counts   67 Paul Stam 08/15/2016 01:49AM
Re: Rolling unique user counts   55 Paul Stam 08/18/2016 06:03AM
Re: Rolling unique user counts   57 Rick James 08/18/2016 04:37PM
Wrong estimation of Rows in explain   156 Rathi Rao 07/27/2016 06:19AM
Re: Wrong estimation of Rows in explain   76 Peter Brawley 07/27/2016 08:55AM
Re: Wrong estimation of Rows in explain   78 Rathi Rao 07/27/2016 11:58PM
Re: Wrong estimation of Rows in explain   82 Peter Brawley 07/28/2016 09:14AM
Re: Wrong estimation of Rows in explain   72 Rathi Rao 07/29/2016 05:11AM
Re: Wrong estimation of Rows in explain   77 Peter Brawley 07/29/2016 01:10PM
Re: Wrong estimation of Rows in explain   71 Rick James 07/29/2016 06:58PM
Re: Wrong estimation of Rows in explain   66 Rathi Rao 08/02/2016 05:48AM
Re: Wrong estimation of Rows in explain   65 Rick James 08/02/2016 06:23PM
Re: Wrong estimation of Rows in explain   66 Rathi Rao 08/02/2016 05:38AM
Re: Wrong estimation of Rows in explain   70 james wang 08/04/2016 05:31AM
30 millions reads/day   138 Srinivas K 07/29/2016 05:34AM
Re: 30 millions reads/day   75 Rick James 07/29/2016 07:03PM
Re: 30 millions reads/day   64 james wang 08/04/2016 05:15AM
mysql commit slow,please help me   155 jw maple 07/27/2016 02:11AM
Re: mysql commit slow,please help me   112 Rick James 07/29/2016 05:15PM
Very slow query when too many joins   342 As Os 06/05/2016 09:17AM
Re: Very slow query when too many joins   146 As Os 06/05/2016 09:27AM
Re: Very slow query when too many joins   148 Peter Brawley 06/05/2016 10:14AM
Re: Very slow query when too many joins   143 As Os 06/05/2016 10:48AM
Re: Very slow query when too many joins   150 Peter Brawley 06/05/2016 10:56AM
Re: Very slow query when too many joins   132 As Os 06/05/2016 03:33PM
Re: Very slow query when too many joins   143 Peter Brawley 06/05/2016 03:41PM
Re: Very slow query when too many joins   139 Rick James 06/05/2016 05:36PM
Re: Very slow query when too many joins   132 As Os 06/06/2016 02:23AM
Re: Very slow query when too many joins   157 As Os 06/06/2016 03:33AM
Re: Very slow query when too many joins   123 As Os 06/06/2016 08:36AM
Re: Very slow query when too many joins   122 Peter Brawley 06/06/2016 08:52AM
Re: Very slow query when too many joins   123 As Os 06/06/2016 09:02AM
Re: Very slow query when too many joins   119 Peter Brawley 06/06/2016 11:16AM
Re: Very slow query when too many joins   131 Peter Brawley 06/06/2016 08:29AM
Re: Very slow query when too many joins   130 As Os 06/06/2016 11:30AM
Re: Very slow query when too many joins   122 Peter Brawley 06/06/2016 12:08PM
Re: Very slow query when too many joins   129 As Os 06/06/2016 02:11PM
Re: Very slow query when too many joins   166 Rick James 06/07/2016 03:40PM
Re: Very slow query when too many joins   82 james wang 07/20/2016 05:34AM
Re: Very slow query when too many joins   86 Rick James 07/20/2016 09:37AM
Re: Very slow query when too many joins   88 james wang 07/21/2016 04:43AM
Re: Very slow query when too many joins   84 Rick James 07/22/2016 10:59PM
MySQL data volume   186 Parfait Fortuné NDOLO 07/21/2016 10:21AM
Re: MySQL data volume   95 Peter Brawley 07/21/2016 11:41PM
Re: MySQL data volume   105 Rick James 07/22/2016 10:57PM
Query optimize on large database   210 Pavel Volkov 07/13/2016 01:40AM
Re: Query optimize on large database   106 Rick James 07/15/2016 05:12PM
Re: Query optimize on large database   96 Pavel Volkov 07/16/2016 04:15AM
Re: Query optimize on large database   97 Peter Brawley 07/16/2016 12:09PM
Re: Query optimize on large database   93 Pavel Volkov 07/16/2016 12:36PM
Re: Query optimize on large database   86 Rick James 07/16/2016 02:46PM
Re: Query optimize on large database   83 Peter Brawley 07/17/2016 11:22AM
Re: Query optimize on large database   92 Pavel Volkov 07/18/2016 04:28AM
Re: Query optimize on large database   81 Peter Brawley 07/18/2016 08:40AM
Re: Query optimize on large database   83 james wang 07/20/2016 04:46AM
Re: Query optimize on large database   89 Pavel Volkov 07/20/2016 08:06AM
Re: Query optimize on large database   87 Rick James 07/20/2016 09:29AM
Re: Query optimize on large database   81 james wang 07/21/2016 04:35AM
Unexplained very bad subquery performance   160 Arnaud Bertrand 07/18/2016 04:29AM
Re: Unexplained very bad subquery performance   90 Peter Brawley 07/18/2016 08:44AM
Re: Unexplained very bad subquery performance   80 Arnaud Bertrand 07/18/2016 01:06PM
Re: Unexplained very bad subquery performance   80 Peter Brawley 07/18/2016 03:30PM
Re: Unexplained very bad subquery performance   86 Arnaud Bertrand 07/19/2016 03:16AM
Re: Unexplained very bad subquery performance   93 Peter Brawley 07/19/2016 04:21AM
Re: Unexplained very bad subquery performance   80 james wang 07/20/2016 04:35AM
specify conditions from outer query on a materialized subquery   149 Pratik Gandhi 07/12/2016 10:55PM
Re: specify conditions from outer query on a materialized subquery   83 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)   194 Ra Nala 06/28/2016 06:22AM
Re: count(*) or count(id)   96 Ra Nala 06/28/2016 06:26AM
Re: count(*) or count(id)   97 Peter Brawley 06/28/2016 05:18PM
Re: count(*) or count(id)   101 Rick James 07/04/2016 01:04PM
Re: count(*) or count(id)   93 Ra Nala 07/06/2016 12:30AM
CREATE INDEX Online DDL Not Working   249 Jayanath Dissanayake 06/20/2016 05:02AM
Re: CREATE INDEX Online DDL Not Working   119 Øystein Grøvlen 06/22/2016 12:43AM
Re: CREATE INDEX Online DDL Not Working   110 Rick James 06/23/2016 07:07PM
Select random rows when using UUID   273 Jonathan Keen 06/09/2016 11:43AM
Re: Select random rows when using UUID   124 Rick James 06/13/2016 01:36AM
Re: Select random rows when using UUID   124 Jonathan Keen 06/14/2016 11:23AM
Re: Select random rows when using UUID   125 Rick James 06/18/2016 01:35AM
SQLSTATE[HY000] [1044] Access denied   315 YOONTAE KIM 06/16/2016 07:55PM
Index Not being used.   302 Greg Mundt 05/26/2016 02:29PM
Re: Index Not being used.   149 Peter Brawley 05/26/2016 03:53PM
Re: Index Not being used.   149 Øystein Grøvlen 05/27/2016 12:45AM
Re: Index Not being used.   138 Greg Mundt 05/27/2016 07:05AM
Re: Index Not being used.   138 Rick James 05/27/2016 11:29PM
Re: Index Not being used.   121 Greg Mundt 05/31/2016 07:04AM
Re: Index Not being used.   127 Rick James 05/31/2016 09:26PM
Re: Index Not being used.   127 Greg Mundt 06/01/2016 05:40AM
Re: Index Not being used.   118 Rick James 06/01/2016 11:29AM
Re: Index Not being used.   148 Greg Mundt 06/01/2016 11:41AM
Re: Index Not being used.   125 Rick James 06/04/2016 05:14PM
Re: Index Not being used.   134 Greg Mundt 05/27/2016 10:14AM
A proposal to make disk IO much faster under SSD   318 suiyemin sui 05/29/2016 09:16PM
Re: A proposal to make disk IO much faster under SSD   169 Rick James 05/31/2016 09:48PM
Re: A proposal to make disk IO much faster under SSD   155 suiyemin sui 06/01/2016 02:05AM
Re: A proposal to make disk IO much faster under SSD   125 Rick James 06/04/2016 04:38PM
query taking really long time.   328 Mehraz Ahmed Sheikh 05/16/2016 09:45AM
Re: query taking really long time.   155 Rick James 05/23/2016 02:58PM
Left join vs Inner join   317 Vikas Sood 05/09/2016 06:10PM
Re: Left join vs Inner join   168 Øystein Grøvlen 05/10/2016 08:04AM
Re: Left join vs Inner join   158 Vikas Sood 05/10/2016 10:40AM
Re: Left join vs Inner join   160 Rick James 05/10/2016 07:23PM
How can I improve the import speed of a large SQL file?   324 Jeff Vincent 05/06/2016 09:46AM
Re: How can I improve the import speed of a large SQL file?   165 Peter Brawley 05/06/2016 11:49AM
Re: How can I improve the import speed of a large SQL file?   166 Jeff Vincent 05/06/2016 12:17PM
Re: How can I improve the import speed of a large SQL file?   160 Rick James 05/06/2016 05:44PM
Re: How can I improve the import speed of a large SQL file?   173 Shane Bester 05/08/2016 04:49AM
text vs varchar   374 hua kai 04/28/2016 08:36AM
Re: text vs varchar   180 Øystein Grøvlen 04/29/2016 12:41AM
Re: text vs varchar   176 Rick James 04/30/2016 11:51PM
Re: text vs varchar   171 Øystein Grøvlen 05/02/2016 04:37AM
Re: text vs varchar   152 hua kai 05/02/2016 09:14PM
Re: text vs varchar   154 Øystein Grøvlen 05/03/2016 02:19AM
Re: text vs varchar   174 hua kai 05/03/2016 04:12AM
Re: text vs varchar   155 hua kai 05/02/2016 08:02PM
Re: text vs varchar   158 Øystein Grøvlen 05/03/2016 02:25AM
Query with 2 x subquery   337 Jes Ramsing 04/29/2016 06:44AM
Re: Query with 2 x subquery   205 Øystein Grøvlen 04/29/2016 08:01AM
Re: Query with 2 x subquery   177 Jes Ramsing 05/01/2016 11:57PM
Re: Query with 2 x subquery   145 Øystein Grøvlen 05/02/2016 03:45AM
Re: Query with 2 x subquery   147 Jes Ramsing 05/02/2016 05:32AM
Re: Query with 2 x subquery   157 Rick James 05/01/2016 11:58PM
Re: Query with 2 x subquery   208 Jes Ramsing 05/02/2016 02:16AM
Slow Query, Optimization Advice Needed   369 Michael Lawson 04/26/2016 09:30AM
Re: Slow Query, Optimization Advice Needed   165 Øystein Grøvlen 04/27/2016 01:02AM
Re: Slow Query, Optimization Advice Needed   177 Michael Lawson 04/27/2016 07:20PM
Re: Slow Query, Optimization Advice Needed   176 Peter Brawley 04/27/2016 11:28PM
Re: Slow Query, Optimization Advice Needed   158 Øystein Grøvlen 04/28/2016 01:25AM
Re: Slow Query, Optimization Advice Needed   153 Rick James 05/01/2016 11:47PM
Re: Slow Query, Optimization Advice Needed   164 Øystein Grøvlen 05/02/2016 01:28AM
Re: Slow Query, Optimization Advice Needed   173 Øystein Grøvlen 04/28/2016 01:12AM
Reg table design and query performances   355 Devrishi Shandilya 04/26/2016 03:02AM
Re: Reg table design and query performances   175 Øystein Grøvlen 04/26/2016 06:02AM
Re: Reg table design and query performances   201 Devrishi Shandilya 04/26/2016 06:16AM
Re: Reg table design and query performances   181 Øystein Grøvlen 04/26/2016 06:35AM
Re: Reg table design and query performances   188 Devrishi Shandilya 04/26/2016 06:50AM
Re: Reg table design and query performances   175 Øystein Grøvlen 04/26/2016 07:04AM
Re: Reg table design and query performances   166 Rick James 04/30/2016 11:46PM
Re: Reg table design and query performances   140 Øystein Grøvlen 05/02/2016 01:00AM
Memory benefits of huge pages   347 Olga Turetskaya 04/30/2016 11:21AM
Re: Memory benefits of huge pages   161 Rick James 05/01/2016 02:36PM
Configuration review requested   442 Jens Meier 04/13/2016 11:55AM
Re: Configuration review requested   194 Rick James 04/14/2016 01:39PM
block_ops_in and block_ops_out meaning   561 hua kai 03/18/2016 02:33AM
Re: block_ops_in and block_ops_out meaning   274 Rick James 03/21/2016 11:34PM
Re: block_ops_in and block_ops_out meaning   274 Peter Brawley 03/22/2016 02:03AM
Re: block_ops_in and block_ops_out meaning   282 hua kai 03/25/2016 12:30AM
Re: block_ops_in and block_ops_out meaning   232 hua kai 04/14/2016 12:52AM
order by primary key slowly   438 varky chan 04/05/2016 10:42PM
Re: order by primary key slowly   222 Øystein Grøvlen 04/06/2016 04:35AM
Re: order by primary key slowly   234 varky chan 04/06/2016 10:15AM
Re: order by primary key slowly   231 Peter Brawley 04/06/2016 11:23AM
Re: order by primary key slowly   217 varky chan 04/06/2016 08:11PM
Re: order by primary key slowly   203 Peter Brawley 04/06/2016 10:35PM
Re: order by primary key slowly   208 varky chan 04/07/2016 12:34AM
Re: order by primary key slowly   198 Øystein Grøvlen 04/07/2016 07:21AM
Re: order by primary key slowly   214 Peter Brawley 04/07/2016 10:20AM
Re: order by primary key slowly   201 varky chan 04/07/2016 11:26PM
Re: order by primary key slowly   180 Rick James 04/12/2016 07:42PM
Re: order by primary key slowly   196 Peter Brawley 04/06/2016 08:57AM
Re: order by primary key slowly   191 varky chan 04/06/2016 10:17AM
[INNODB] why there are many "waiting for table level lock"?   403 HANWEN YIN 04/11/2016 12:08AM
Re: [INNODB] why there are many "waiting for table level lock"?   199 Rick James 04/12/2016 07:27PM
Improve performance when altering huge tables   396 Davide Cicuta 04/04/2016 07:24AM
Re: Improve performance when altering huge tables   193 Rick James 04/05/2016 02:59PM
MySql 5.7 - Poor Performance PURGE BINARY LOGS   509 Davy Campano 03/23/2016 08:08PM
Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS   243 Rick James 03/26/2016 11:58PM
Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS   259 Davy Campano 03/29/2016 09:44AM
where the snapshot for select in transaction stored   459 hua kai 03/21/2016 03:03AM
Re: where the snapshot for select in transaction stored   200 Rick James 03/21/2016 11:21PM
Difference execution plans for same query   515 Devrishi Shandilya 02/25/2016 12:05AM
Re: Difference execution plans for same query   227 Peter Brawley 02/25/2016 01:51AM
Re: Difference execution plans for same query   236 Øystein Grøvlen 02/25/2016 03:51AM
Re: Difference execution plans for same query   227 Rick James 03/05/2016 01:19AM
Slow join performance   630 Ra Nala 11/27/2015 04:55AM
Re: Slow join performance   341 Rick James 11/28/2015 03:02PM
Re: Slow join performance   228 Ra Nala 02/25/2016 06:22AM
which is best for JOIN approach   683 Ra Nala 11/24/2015 09:39AM
Re: which is best for JOIN approach   390 Øystein Grøvlen 11/25/2015 02:14AM
Re: which is best for JOIN approach   359 Ra Nala 11/25/2015 02:42AM
Re: which is best for JOIN approach   342 Rick James 11/29/2015 11:53AM
Re: which is best for JOIN approach   245 Ra Nala 02/19/2016 05:28AM
Re: which is best for JOIN approach   240 Peter Brawley 02/21/2016 04:56PM
Re: which is best for JOIN approach   232 Ra Nala 02/19/2016 05:31AM
Re: which is best for JOIN approach   232 Rick James 02/21/2016 01:40PM
Re: which is best for JOIN approach   255 Rick James 02/21/2016 01:43PM
Re: which is best for JOIN approach   276 Ra Nala 02/25/2016 05:50AM
Why is wrong index being selected   504 Steve Bell 02/23/2016 01:54PM
Re: Why is wrong index being selected   226 Rick James 02/23/2016 11:39PM
Re: Why is wrong index being selected   259 Øystein Grøvlen 02/24/2016 03:22AM
Re: Why is wrong index being selected   221 Steve Bell 02/25/2016 02:47AM
Distinct or Group by which is faster   541 Ra Nala 02/22/2016 08:50AM
Re: Distinct or Group by which is faster   250 Peter Brawley 02/22/2016 12:33PM
Re: Distinct or Group by which is faster   236 Chandan Kumar 02/23/2016 12:51PM
MySQL server is not disk bound, how do I make it faster?   478 Robert Gunther 02/21/2016 09:35PM
Re: MySQL server is not disk bound, how do I make it faster?   240 Peter Brawley 02/22/2016 12:38PM
Re: MySQL server is not disk bound, how do I make it faster?   252 Rick James 02/22/2016 06:18PM
mysql text datatype SELECT query slow even with tmp dir on tmpfs   475 Muhammad Omair 02/22/2016 08:36AM
Re: mysql text datatype SELECT query slow even with tmp dir on tmpfs   227 Peter Brawley 02/22/2016 12:35PM
How can I improve this table and query   508 Adam Copley 02/17/2016 04:49AM
Re: How can I improve this table and query   248 Øystein Grøvlen 02/17/2016 06:07AM
Re: How can I improve this table and query   259 Adam Copley 02/17/2016 08:25AM
Re: How can I improve this table and query   244 Adam Copley 02/17/2016 08:26AM
Re: How can I improve this table and query   250 Øystein Grøvlen 02/17/2016 08:51AM
Re: How can I improve this table and query   251 Adam Copley 02/17/2016 09:03AM
Re: How can I improve this table and query   246 Rick James 02/21/2016 11:14PM
Does prefixing field names with their table name improve query speed?   477 Guillaume TRUCHOT 02/18/2016 04:02PM
Re: Does prefixing field names with their table name improve query speed?   239 Peter Brawley 02/18/2016 05:21PM
Re: Does prefixing field names with their table name improve query speed?   256 Rick James 02/21/2016 07:19PM
slow response when where clause has a field from 2nd table in a left join   526 Ravi Malghan 02/12/2016 12:51PM
Re: slow response when where clause has a field from 2nd table in a left join   256 Øystein Grøvlen 02/15/2016 02:10AM
Re: slow response when where clause has a field from 2nd table in a left join   235 Rick James 02/15/2016 04:17PM
Re: slow response when where clause has a field from 2nd table in a left join   223 Ravi Malghan 02/19/2016 10:18AM
max_allowed_packet error   588 Ra Nala 02/02/2016 05:12AM
Re: max_allowed_packet error   262 Rick James 02/06/2016 07:26PM
Getting NULL digest_text for all queries in 2 of my 3 DBs (performance_schema)   590 Bill Joyce 12/06/2015 11:41PM
Re: Getting NULL digest_text for all queries in 2 of my 3 DBs (performance_schema)   321 Mayank Prasad 12/10/2015 03:53AM
Re: Getting NULL digest_text for all queries in 2 of my 3 DBs (performance_schema)   276 Bill Joyce 02/04/2016 04:15PM
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 ...Last Next
Current Page: 1 of 72

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.