MySQL :: Re: How to reduce ibtmp1 file in mysql 5.7?

New Topic

Re: How to reduce ibtmp1 file in mysql 5.7?

Posted by: Peter Brawley
Date: April 04, 2016 05:48PM

http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-1.html

It's a tablespace for uncompressed InnoDB temp tables. Are you using many of them in multiple threads?

Set its location with innodb_temp_data_file_path.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

How to reduce ibtmp1 file in mysql 5.7?

5097

Magi Home

April 04, 2016 12:51PM

Re: How to reduce ibtmp1 file in mysql 5.7?

3081

Peter Brawley

April 04, 2016 05:48PM

Re: How to reduce ibtmp1 file in mysql 5.7?

9862

Magi Home

April 08, 2016 12:38AM

Re: How to reduce ibtmp1 file in mysql 5.7?

2628

Peter Brawley

April 08, 2016 09:38AM

Re: How to reduce ibtmp1 file in mysql 5.7?

3405

Magi Home

April 08, 2016 01:53PM

Re: How to reduce ibtmp1 file in mysql 5.7?

2079

Peter Brawley

April 08, 2016 03:43PM

Re: How to reduce ibtmp1 file in mysql 5.7?

2030

Magi Home

April 09, 2016 02:57PM

Re: How to reduce ibtmp1 file in mysql 5.7?

1978

Peter Brawley

April 09, 2016 03:09PM

Re: How to reduce ibtmp1 file in mysql 5.7?

11314

Magi Home

April 11, 2016 01:39AM

Re: How to reduce ibtmp1 file in mysql 5.7?

2789

Peter Brawley

April 11, 2016 11:42AM

Re: How to reduce ibtmp1 file in mysql 5.7?

2338

Magi Home

April 14, 2016 04:50AM

Re: How to reduce ibtmp1 file in mysql 5.7?

4204

Peter Brawley

April 14, 2016 08:49AM

Re: How to reduce ibtmp1 file in mysql 5.7?

2663

Magi Home

April 20, 2016 07:18AM

Re: How to reduce ibtmp1 file in mysql 5.7?

3167

Peter Brawley

April 20, 2016 11:48AM

Sorry, you can't reply to this topic. It has been closed.

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.