… working on the system with custom compiled MySQL. How to upgrade to the new MySQL Options while preserving as much of original… be looking at “Configure-Command”: Configure command: ./configure ‘–localstatedir=/var/db/mysql‘ ‘–without-debug’ ‘–without-readline’ ‘–without-libedit’ ‘–without-bench’ ‘–without-extra…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…of the query The complete method completely rebuilds an MV from scratch at each …or more “CREATE TABLE db.schema … AS SELECT” and/or “INSERT INTO db.schema … AS …155187034 | <-- too high +------------------+ 1 row in set (0.68 sec) mysql> select sum(total_lines) from dashboard_customer_sales ;…
Comment: Finding your MySQL High-Availability solution – The questions
October 17, 2009 By 36 Comments
… * mysql becomes unavailable (best case) * mysql connection are unresponsive connection happen very slowly * mysql …categories: * kernel panics – with hundreds of DB servers we get kernel panics weekly. * …risk by rebuilding your tables occasionally (on the secondary) and also rebuild them after …
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… one of our MySQL support customers as they were upgrading their application and mysql schema. We deployed and used MySQL Master-Master replication… db1 now. 3. on db2: load the sql scripts $ mysql -u root db < changes.sql At this step we load sql commands... replication mysql> START SLAVE; db1 will receive the updates that were executed by changes.sql or some other script and rebuild its…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 84 Comments
…Recompile the same version of mysql, with this patch applied (we compile mysql from source ourselves anyway,…to work acceptably well in our case. It rebuilds the timing, connections, and queries the server …use Time::Local; use DBI(); # Setup who your DB host host, and a hash of copnnection passwords….
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
…pool pages, Innodb recovery must be done to rebuild the last consistent picture of the database. Recovery…log checkpointing and what does it tell us? mysql> SHOW ENGINE INNODB STATUS\G — LOG — Log sequence …SHOW ENGINE INNODB STATUS: Database pages 65530 … Modified db pages 3 So we have 3 pages …
