…the changelogs collected by FlexCDC to update the snapshot to reflect the changes… for querying: mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'dashboard_customer_sales’)); Query OK, … with flexviews.get_id(‘schema’,'table’). The second parameter reflects the refresh type. This parameter…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…have been no updates to our msl patch, …with-big-tables’ ‘–enable-assembler’ ‘–enable-local-infile’ ‘–with-mysqld-user=mysql‘ ‘–with-unix-socket-path=/var/lib/mysql/mysql.sock’ ‘–with-pic’ ‘–prefix=/’ ‘–with-extra-charsets=all’ ‘–with… when logging all the queries. This parameter allows you to…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…Query Cache works with query text and want full result set at once. In prepared statements there is query with placeholders and additional parameter…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
… a slow query log. The service starts with an empty my.cnf configuration so all parameters are …mysql-host=127.0.0.1 –mysql-user=root –mysql-schema=my_db –query-log-file=slow.log Executed 429467 queries… can test our changes or updates using real data and real queries from our application. The …
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…with execution time: 0.5s for MonetDB and 2.92s for InfoBright. Warnings: do not try EXPLAIN this query in InfoBright. MySQL… and pass query as parameter, otherwise I was not able to edit query or check history… LOAD DATA. InfoBright Enterprise allows INSERT / UPDATE but that also is not for online…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…we deal with that and avoid the resource to stop ? If we check the list of parameters on… pc.ignore_sb : Should we allow nodes to process updates even in the case of split brain? … percona1 mysql> insert into percona values (0,’percona1′,’vadim’); Query OK, 1 row affected (7.77 sec) percona1 mysql>…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…=ip-10-112-39-98 log_slave_updates innodb_locks_unsafe_for_binlog=1 innodb_… the client node with a browser pointed to /haproxy/stats, the stats auth parameter in the …Query OK, 0 rows affected (0.00 sec) Populate the table with data for the benchmark. # sysbench –test=oltp –db-driver=mysql –mysql…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…: 0 mysql> SELECT COUNT(*) FROM test_table; — 3 Tickets Used +———-+ | COUNT(*) | +———-+ | 3 | +———-+ 1 row in set (0.00 sec) mysql> UPDATE test_table SET id=4 WHERE id=1; — 4 Tickets Used (because no index, a table scan is performed) Query OK…, as with most other parameters, this is a balancing act. It really comes down to the importance of the applicable queries. Imagine those…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…/benchpbxt/phptest.lua The mysql.start script with startup parameters for InnoDB and PBXT http://www.mysqlperformanceblog.com/files/benchpbxt/mysql.start and script… to check PBXT performance on INSERT/UPDATE queries taking into account PBXT way to handle such queries, I hope I will be able…
Post: Poor man's query logging
November 7, 2008 By 5 Comments
…query being executed by MySQL to a file with limited amount of additional information. The other is slow log enabled by –log-slow-queries parameter (MySQL…3306 | strings | perl -e ‘ while() { chomp; next if /^[^ ]+[ ]*$/; if(/^(SELECT|UPDATE|DELETE|INSERT|SET|COMMIT|ROLLBACK|CREATE|DROP|ALTER)/i) { …
