Ltj_bukem Posted October 17, 2007 Share Posted October 17, 2007 Hi, I have a table that stores information on pdf files which are uploaded to a temp folder. The pdf's upload / download fine untill there are about twenty files stored. Using PHPAdmin I can see that the table size is only 14.7 KiB but the overhead is now 0. I'm sure there must be a way to increase the table size but I'm struggling to find out how. Thanks Quote Link to comment https://forums.phpfreaks.com/topic/73625-table-optimization/ Share on other sites More sharing options...
Ltj_bukem Posted October 17, 2007 Author Share Posted October 17, 2007 Well, Ive managed to query the databse as follow; SHOW TABLE STATUS FROM db_name LIKE 'tbl_name'; and get the following Name ***** Engine MyISAM Version 10 Row_format Dynamic Rows 58 Avg_row_length 134 Data_length 7776 Max_data_length 281474976710655 Index_length 6144 Data_free 0 Auto_increment 100 Collation latin1_swedish_ci The fact that 'Data_free' is 0 points towards a space issue with this table, I just need to find a way to increase the available size. Anyone? Quote Link to comment https://forums.phpfreaks.com/topic/73625-table-optimization/#findComment-371483 Share on other sites More sharing options...
fenway Posted October 17, 2007 Share Posted October 17, 2007 What are you trying to do? Quote Link to comment https://forums.phpfreaks.com/topic/73625-table-optimization/#findComment-371537 Share on other sites More sharing options...
Ltj_bukem Posted October 17, 2007 Author Share Posted October 17, 2007 I've got a table which contains information on pdf documents, ID, name, size ect which are uploaded and stored on a temporary folder on the server. These work fine for both uploading and downloading, the pdf's also open fine once downloaded. The problem I have is that I can upload as many files as I want until the total data for that table exceeds 4MB, once this threshold has been reached any files that I download are corrupt & wont open. Nothing tells me that there is anything wrong with the table, I can upload as many files as I want & they seem to be fine, it's only once the table data goes above 4MB that the downloaded pdf's don't open. If I delete rows from the table & go below 4MB they download fine again. It's almost as if the moment the table goes above 4MB everything comes corrupt. I read something about table cache, could be thge problem? Quote Link to comment https://forums.phpfreaks.com/topic/73625-table-optimization/#findComment-371583 Share on other sites More sharing options...
fenway Posted October 17, 2007 Share Posted October 17, 2007 There is no way to fix the size of the table (well, in InnoDB, you could exceed it)... something else funny (non-mysql related) is going on. Quote Link to comment https://forums.phpfreaks.com/topic/73625-table-optimization/#findComment-371739 Share on other sites More sharing options...
Ltj_bukem Posted October 17, 2007 Author Share Posted October 17, 2007 Could well be the case, maybe in OS issue. Like I say, there's nothing within MYSQL that warns me there's an issue. Quote Link to comment https://forums.phpfreaks.com/topic/73625-table-optimization/#findComment-371786 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.