…query/type has started. # Save the old one (if it exists), and reinitialise the vars # for the next push @{$queries{$connection}{$datetime}}, $query if length($query…
Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL
September 4, 2012 By 7 Comments
… disallowing use of query cache or …the job is trivial – however for companies like Google, Facebook and Twitter the job is enormous. Sometimes, custom building is not the last…the other way around – can you make your application behave properly with MySQL? A paradigm shift like this can save…
Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
March 14, 2013 By 2 Comments
…the word ‘Jaime’ somewhere in the field note. The original query had a stable execution time of 1.09 sec, while the…the MySQL 5.6 release, and get advantage of the latest integrated tools that MySQL provides with its last…
Comment: MySQL Partitioning - can save you or kill you
July 2, 2012 By 45 Comments
… of saved files on disk. This does not interact with the DB at all. The second App server has to interact with both the… older than last 60 days. 50 users would simultaneously access the database, with the 3 queries that I mentioned before, almost all the time. So… the new InnoDb table as mentioned before, using load infile. Query result ( during inserts 100 rows per sec) : Query 3 in 30 sec. Queries…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…save time and make the recovery process more straightforward. Now the scenario is worse because we don’t have a backup or the…”2000-07-31″ 4- Import the rows With the data in our hands the last step is to import …salaries\t’ (emp_no, from_date, salary, to_date); Query OK, 3 rows affected (0.01 sec) …
Post: Finding out largest tables on MySQL Server
February 4, 2008 By 27 Comments
… GB so I can save on counting zeros. The last column shows how much does the index take compared to the data which is mainly… perfectly fine tables but it is worth to look. Changing the query a bit to look for different sorting order or extra…: To make things easier I’ve added INFORMATION_SCHEMA to the query so it works whatever database you have active. It does…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… place logs in LVM, I mean binary logs, slow query log, general query log etc, if they get any serious traffic. You… in the backup and you do not want query log and general logs anyway. However DO place Innodb Log Files on the same… of such space. The last advice I would give on snapshot space estimation would be not to try to save too much on…
Post: The perils of uniform hardware and RAID auto-learn cycles
November 16, 2010 By 16 Comments
…The data had changed subtly, pushing it over some threshold. I’ve seen this before — for example, a query…saving links to reference material), sent that over the Skype chat, and the customer tried that. We weren’t sure the…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… “real-time.” None of the big three (Google, Yahoo, MSN) provides real-time reporting last time I was involved with them… again by month. Then write your queries to use the most aggregated data possible to save work. Avoid operations that update huge… work for the database server. If you do it on the master with INSERT..SELECT queries, it will propagate to the slaves and…
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
… in many cases generates the “DROP TABLE” instruction before the “CREATE TABLE”: DROP TABLE IF EXISTS `actor`; /*!40101 SET @saved_cs_client = @@character… KEY (actor_id), -> KEY idx_actor_last_name (last_name) -> )ENGINE=InnoDB DEFAULT CHARSET=utf8; Query OK, 0 rows affected (0.56 sec…
