phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

Session (Heap) table - max rows


 
Search this topic... | Search phpBB2 Discussion... | Search Box
Register or Login to Post    Index » phpBB2 Discussion  Previous TopicPrint TopicNext Topic
Author Message
JLA
Board Member



Joined: 30 Apr 2009

Posts: 298
Location: U.S.A


flag
PostPosted: Wed Jul 17, 2013 2:22 pm 
Post subject: Session (Heap) table - max rows

For those of you using MYSQL - what do you have max rows set to for your sessions table?
_________________
http://www.jlaforums.com
Back to top
StarWolf3000
Board Member



Joined: 10 Jun 2010

Posts: 83
Location: Stolpen, Saxony, Germany


flag
PostPosted: Wed Jul 17, 2013 3:23 pm 
Post subject: Re: Session (Heap) table - max rows

I don't have any MAX_ROWS on the session table set, because it is by default installed using the default storage engine, which is MyISAM on my installations. In 10 of 10 installations I forget to change it to MEMORY.

max_heap_table_size is set to 16,777,216 (without the thousand separators) by default (16 MBytes of data). This value can range from 16,384 to 4,294,967,295 on 32bit systems and 16,384 to 1,844,674,407,370,954,752 on 64bit systems.

max_heap_table_size is used to calculate the MAX_ROWS on MEMORY tables. If you set MAX_ROWS too low in CREATE/ALTER TABLE, then you probably will encounter early "xxx table is full" errors, so you have to balance it out.

If MAX_ROWS is not set with CREATE/ALTER TABLE, then MySQL uses the myisam_data_pointer_size variable, whom default value is 6 bytes, which allows for up to 256 TBytes data.
Back to top
JLA
Board Member



Joined: 30 Apr 2009

Posts: 298
Location: U.S.A


flag
PostPosted: Thu Jul 18, 2013 7:51 pm 
Post subject: Re: Session (Heap) table - max rows

StarWolf3000 wrote:
I don't have any MAX_ROWS on the session table set, because it is by default installed using the default storage engine, which is MyISAM on my installations. In 10 of 10 installations I forget to change it to MEMORY.

max_heap_table_size is set to 16,777,216 (without the thousand separators) by default (16 MBytes of data). This value can range from 16,384 to 4,294,967,295 on 32bit systems and 16,384 to 1,844,674,407,370,954,752 on 64bit systems.

max_heap_table_size is used to calculate the MAX_ROWS on MEMORY tables. If you set MAX_ROWS too low in CREATE/ALTER TABLE, then you probably will encounter early "xxx table is full" errors, so you have to balance it out.

If MAX_ROWS is not set with CREATE/ALTER TABLE, then MySQL uses the myisam_data_pointer_size variable, whom default value is 6 bytes, which allows for up to 256 TBytes data.


Thanks

_________________
http://www.jlaforums.com
Back to top
Display posts from previous:   
Register or Login to Post    Index » phpBB2 Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0173 seconds using 15 queries. (SQL 0.0021 Parse 0.0005 Other 0.0147)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo