… been added to the mysqlbinlog utility that allows the changing names of the used databases in both Row-Based and Statement-Based replication…, awk and sed but only for SBR, because with RBR database name is encoded within the BINLOG ‘….’ statement. Release notes for Percona…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… the salaries tables from the employees database! (Oops, I can have an … (6.51 sec) Rows matched: 300024 Changed: 300024 Warnings: 0 With the …: mysql> show binary logs; +——————+———–+ | Log_name | File_size | +——————+———–+ … | mysql-bin.000022 | 336797725 | | …
Post: Percona XtraDB Cluster 5.5.20 - Beta release
February 23, 2012 By 10 Comments
… Despite Galera 2.0 has status “production ready”, we still name our release “beta”, as we want to give an additional… XtraDB Cluster works with databases created in MySQL / Percona Server Application compatibility. There is no or minimal application changes required to start…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…. What is Change Data Capture (CDC)? As the name implies, CDC software captures the changes made to database rows and makes those changes available in… contents of database rows which change into special tables called changelogs. Each changelog is located in the flexviews database and is named $SCHEMA_$TABLE…
Post: PHP Sessions - Files vs Database Based
March 27, 2007 By 38 Comments
One may think changing PHP session handler from file based to database driven is fully transparent. In many cases it is, sometimes… they also will be serialized for single user on database level. If you change to store PHP sessions in MySQL instead this… this external lock on session name should be done before session data is read from database for things to work properly. This…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… you need to have proper “snapshot” – consistent state of the database as it was on master and corresponding position in masters… see people using wrong values to restore the replication using CHANGE MASTER TO statement. It is very important to understand the… and CHANGE MASTER TO accepts Master_Log_File parameter, while you actually want to use Relay_Master_Log_File instead. This naming…
Post: Database access Optimization in Web Applications.
September 12, 2006 By 10 Comments
… information delivered from the database most efficient way. Investigate how dynamic is this information If information rarely changes or is static it… you can use. Just remember avoiding accessing database is the best way you can optimize database access. This applies to anything else… killer queries are GROUP BY Queries and Sort Queries – SELECT name,descr FROM titles ORDER BY rank DESC LIMIT 10 – If…
Comment: Why MySQL could be slow with large tables ?
March 20, 2009 By 139 Comments
Peter, I am relatively new to working with databases and have a table that is about 7 million rows. It seems to be taking forever (2+ hrs) if I need to make any changes to the table (i.e. adding columns, changing column names, etc.) Is there an easy way to make these operations go faster? Thanks!
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… date’ since changes to the database may have happened since the backup was taken. Replaying the binary logs brings the database up-to-date by replaying the changes…_id’,'customer_id’); CALL flexviews.add_expr(@mvid,’GROUP’,'customer_name‘,’customer_name‘); CALL flexviews.add_expr(@mvid,’GROUP’,'DATE_FORMAT(order…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… because things changed along the way. Installation In order to use the patch first you will need to build the database binaries….51a) % su root Password: First you should apply the changes to the database configuration, specifically you need to enable slow logging (see…_examined_row_limit AND log_slow_filter. log-slow-queries[=name] Log slow queries to this log file. Defaults logging to…
