tag:blogger.com,1999:blog-18337119.post115109533291226265..comments2024-01-22T07:09:30.574-05:00Comments on MySQL Consulting and NoSQL Consulting: MySQL DBA: MySQL Slaves Behind Master 2Unknownnoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-18337119.post-43551908474647521702008-10-30T19:04:00.000-04:002008-10-30T19:04:00.000-04:00I'm new to PHP and recently setup my local machine...I'm new to PHP and recently setup my local machine with PHP and MySQL for doing development. I was sort of stuck when I needed to post my work for the user to test and review. After looking around a bit I found a site that hosts PHP and MySQL apps. I was surprised that it was free - it seems they're offering the service at no cost until 2012. At that point they'll change over to a fee-based service. However, in the meantime, it's a great place to do anything from demo and sandbox right up to posting sites for real.<BR/><BR/>Their pitch is as follows:<BR/><BR/>"This is absolutely free, there is no catch. You get 350 MB of disk space and 100 GB bandwidth. They also have cPanel control panel which is amazing and easy to use website builder. Moreover, there is not any kind of advertising on your pages."<BR/><BR/>Check it out using this link:<BR/><BR/>http://www.000webhost.com/83188.html<BR/><BR/>Important: There's one catch in that you must make sure you visit the account every 14 days - otherwise the account is marked 'Inactive' and the files are deleted!!!<BR/><BR/>Thanks and good luck!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-1151165487170080592006-06-24T12:11:00.000-04:002006-06-24T12:11:00.000-04:00Hi Tobias,Thank you for an insightful comment.So t...Hi Tobias,<BR/><BR/>Thank you for an insightful comment.<BR/><BR/>So the higher values of Data_free would indicate that the table needs optimization.<BR/><BR/>FrankFrankhttps://www.blogger.com/profile/04086666898806120300noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-1151136624502878102006-06-24T04:10:00.000-04:002006-06-24T04:10:00.000-04:00--delay-key-writes is good even for read heavy tab...--delay-key-writes is good even for read heavy tables, since it doesn't have to wait as much for disk on writes.<BR/>The biggest problem with this flag of course is that if your server goes down, your indexes *WILL* have to be rebuilt.<BR/><BR/>If you want to see on a MyISAM table if you should optimize, one simple way can be the data_free in SHOW TABLE STATUS output. This displays how much fragmentation you have within the datafile.<BR/>The datafile itself may be fragmented, though, this you will have to check with filesystem fragmentation tools.<BR/><BR/>A detailed analysis you can get from the shell with myisamchk -dvv tablename (just make sure nothing is using the table while you run this. a LOCK TABLE blah READ; FLUSH TABLE blah; in another shell will fix this - don't forget to unlock after the check is ran with UNLOCK TABLES;)<BR/>This will give you detailed statistics about your table.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-1151103033729933242006-06-23T18:50:00.000-04:002006-06-23T18:50:00.000-04:00I have read many articles and comments about optim...I have read many articles and comments about optimizing tables for InnoDB and MyISAM... they range from it should be performed once a week to once a month or the manual states "..if you have deleted a large part of a table or if you have made many changes to a table with variable-length rows ...". However, when does one really know when to optimize tables? Can one actually assess when a specific table needs optimization? and if so, how does one do that?Anonymousnoreply@blogger.com