…to agree with me. Number of vendors would claim they are in…table while server is running and it would typically work. Even if table…SQL database because SQL language itself is way to…
Post: Advanced index analysis with mk-index-usage
November 11, 2010 By 2 Comments
…index usage into tables in a database, so you can query them with SQL. I logged all queries to the … to query EXPLAIN and find out the index usage on the remote server, and store the results in …see how this goes — you can query these tables any way you want. The documentation includes a number of …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…number of reasons: Almost Hot backup In most cases you can perform this type of backup while your application is running. No need to…database to the slave database directory. 10) Start MySQL Server. Wait for it to perform recovery. 11) Use CHANGE MASTER TO to point slave to…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…to retrieve the same number of rows on each benchmark (I noticed 100 rows on SQL…of these external indexing technologies depend on being able to reindex as data in the source database…of recently-changed data. Your application would have to be coded to search both indexes to find…
