Tag » Posts Tagged ‘MySQL’

How to Optimize a MySQL Database using phpMyAdmin?

phpMyAdmin

Optimizing Table in database is just like the doing Disk Defragmentation in your PC.

Optimize Table should be used if you have deleted a large part of a table or if you have made many changes to a table with variable length rows, such as VARCHAR, TEXT, BLOB or VARBINARY columns. Deleted rows are maintained in the linked list and insert operations reuse the old row positions. You can use “Optimize Table” to reclaim unused space and defragment the data file for optimal performance. If a lot of changes have been made to a table, optimizing the table can sometimes significantly improve performance.

Continue reading »

MySql data directory size is very large, how to fix?

MySql

My C:\ drive partion space was almost full, so I tried to analyse junk data on my machine to free some space. I noticed that MySql ‘data’ folder was using around 16GB. Further looking into the data folder I noticed that many mysql binary log files had been created and they were occupying GBs of the space.

After cleaning the log file the ‘data’ folder size reduced to ~6GB.

Continue reading »

Magento System Requirements

Magento

Magento is an open source e-commerce platform built on PHP/MySql. It uses parts of the PHP Zend Framework. Like any other software, Magento also has certain system requirements which must be met in order to install and run it.

Lets go through the list of requirements which must be met for successful setup and functioning of Magento.

Continue reading »

Importing large database (> 2 MB) using phpMyAdmin

phpMyAdmin

If you try importing a mysql database backup file greater than 2 MB then you may receive an error – “No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.”. No Worries! you just need to make few changes to your php.ini file.

Continue reading »

Back to top