…for the test (5.5.28-29.1). This is needed as the plugin needs the offset to some MySQL data… connections. Yes, it had to be a capital Q in Quit for that to work, and no, …”,”host”:”localhost”,”cmd”:”Connect”,”query”:”Connect”} {“msg-type“:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…for no particular reason except that it is a quick-running one. ==9090== Possible data… by 0x6BC72CE: innobase_start_or_create_for_mysql (srv0start.c:1514) ==9090== by … char const*, st_mysql_show_var*, enum_var_type, system_status_var*,…I simply haven’t analyzed them (yes, there is remains a …
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… of MySQL 5.0 to MySQL 5.5 should be rather safe from data standpoint. There are still possibilities for sorting order and data type related changes, so you still need to run mysql_upgrade to… ALTER TABLE statements? Yes. This is exactly how it is done in many cases. There is really no gain in dumping table…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…machines and with no external and …yes this could cause problems with replication lag (and performance in general). Typical problems for…to check the types and frequencies …data growth which just a bit different workload and when backup taken at the wrong time may be responsible for unexpected MySQL…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…for data mining. I wrote an earlier blog post which describes the differences between major schema types. I used the SSB data…: Default config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5….count(*) pages, sum(is_old=’YES‘) old, count(*) – sum(is_old=’YES‘) hot, sum(number_records) …
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… of their respective owners. Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement. percona1 mysql> use test ERROR 1047 (08S01): Unknown command If you try to insert data…: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3 2012-07-24 11:42:51.273 INFO: STATE EXCHANGE: Waiting for state…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…Use the smallest data types you can, the simplest character sets you can, and watch out for NULLable … With Table Structures Suppose you have some yes/no fact about an ad impression, such as…MySQL is, especially for more complex queries. Percona is not tied to MySQL, although we’re most famous for…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… 4 fpu : yes fpu_exception : yes cpuid level : 10 wp : yes flags…MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server that has the Percona patches for…the moment there is no other technique that…be rewritten. Indexes and data types and table structures …
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…yes, which one seems the best? No, I didn’t compare relevancy. I was focused solely on query response time for… SSD drives: one for the Windows partition, and one for the MySQL data partition. I …No, I don’t know of a reference that compares these technologies for different application types…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…data_pending_readsblogpercona.commanual Innodb_data_pending_writesblogpercona.commanual Innodb_data_readblogpercona.commanual Innodb_data_readsblogpercona.commanual Innodb_data_writesblogpercona.commanual Innodb_data…unsafe_for_…commanual no_…master_yes_…slave_type_conversionsblogpercona…
