Open tables question

    Date: 09/24/07 (MySQL Communtiy)    Keywords: mysql, sql

    Following with my previous post (thanks to everyone who answered!) I've been looking around and I've seen there are a lot of unused open tables. mysql_stat says 244 open tables while SHOW OPEN TABLES lists 66. This seems a lot of tables. There is a way to close all these tables? Could it be part of the reason the max_user_connections is reached so quickly?

    Also, my host says they updated my connections from 100 to 200. Is that much?

    Many thanks in advance!

    Source: http://community.livejournal.com/mysql/119588.html

« Pattern match problem || Importing data »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home