There are two methods you can use to determine the size of your MySQL tables. One method is to check the size of the file on disk. 'MYD' file is the size of your data, 'MYI' is the size of your indexes.
The problem with this method is that it does not tell you how much space MySQL tables are consuming. Altering or deleting rows from a table does not reduce the size on disk. MySQL will mark that space as usable. To be filled by additional records.
The method I use is to query MySQL information_schema database. This is the query that I use to determine size of tables in my commerce database.
SELECT
table_name table_name,engine,
ROUND(data_length/1024/1024,2) total_size_mb,
table_rows
FROM
information_schema.tables
WHERE
table_schema = 'commerce'
ORDER BY
table_name
Last Updated (Friday, 09 July 2010 18:12)
|
Tuesday, 08 September 2009 17:54 | Author: Sam Phomsopha |
If you have MySQL replication setup and running, you may encounter a similar replication error. I've encountered this from time to time. This is a MySQL replication error that I've encountered before: Slave SQL: Query partially completed on the master (error on master: 1317) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; . Query: 'Create table `input_data_schedules` ( Last Updated (Tuesday, 08 September 2009 20:41)
Wednesday, 12 August 2009 20:17 | Author: Sam Phomsopha |
Q: How to disable Joomla from displaying Site Name Joomla version 1.0 and 1.5 by default will display the site name on the home page. It's not obvious where to disable this. You would think it would be from the Fontpage manager, but its not that easy. To disable the Site Name from appearing on the home page, you have to disable it from the Main Menu Manager. This is where it would be by default.
That should work for you.
Last Updated (Thursday, 13 August 2009 13:30) |
Thursday, 13 August 2009 00:18 | Author: Sam Phomsopha |
You've purchased a good domain name and created a great site, now how do you make sure that search engines index your website? Well search engines like Google and Yahoo do a pretty good job of indexing new websites on their own. If you want to be indexed sooner rather then later, you need to submit your website URL to each of the major search engines. Google: You will need to use Google's Webmaster Tools to submit your site to Google. Once you've signed up, just click add site from the main page. Bing.com(live.com): Just submit your website on this page http://www.bing.com/docs/submit.aspx?FORM=WSUT. Yahoo.com: http://siteexplorer.search.yahoo.com/submit, requires registration. |