| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Cui Shijun | Date: | February 1 2010 1:21pm |
| Subject: | Is table_open_cache a private cache of a session? | ||
| View as plain text | |||
hi, I'm a little confused by the document(http://dev.mysql.com/doc/refman/5.1/en/table-cache.html), which only says: "To minimize the problem with multiple client sessions having different states on the same table, the table is opened independently by each concurrent session." Are sessions using private table caches? if I have M concurrent sessions and N tables, assume each session will access tables one by one, will mysql open M*N tables?
| Thread | ||
|---|---|---|
| • Is table_open_cache a private cache of a session? | Cui Shijun | 1 Feb |
| • Re: Is table_open_cache a private cache of a session? | Johan De Meersman | 1 Feb |
| • Re: Is table_open_cache a private cache of a session? | Cui Shijun | 1 Feb |
| • Re: Is table_open_cache a private cache of a session? | Johan De Meersman | 1 Feb |
| • Re: Is table_open_cache a private cache of a session? | Cui Shijun | 1 Feb |
| • Re: Is table_open_cache a private cache of a session? | Wagner Bianchi | 1 Feb |
| • Re: Is table_open_cache a private cache of a session? | Wagner Bianchi | 1 Feb |
| • Re: Is table_open_cache a private cache of a session? | Cui Shijun | 1 Feb |
