…, you have security, for example, we have an log/register. We have one stored procedure/function wich allow adding data to the table… it impossible to anyone to delete any data from our log. secondly, i prefer to have all my querys in the…
Comment: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… the database. I also need to add a clean-up stored procedure to remove the rows from changelog tables, the mview_uow… then delete the signal rows with the following: set sql_log_bin=0; delete from flexviews.mview_signal; Don’t do…
Post: Is VoltDB really as scalable as they claim?
February 28, 2011 By 3 Comments
… keeping more copies of each partition. You query VoltDB with stored procedures, not with arbitrary SQL queries. It is designed to be…-end machines, by doing away with the usual buffer pools, logs, latching, and so on. The benchmark is VoltDB’s “voter…
Post: Wanted: Better memory profiling for MySQL
May 18, 2008 By 4 Comments
Quite frequently I would log in to customers system and find MySQL using too much … ? It also could be memory leak in MySQL or runaway stored procedure consuming too much memory, but there is no way to…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…schema’s. It does not handle views/triggers/procedures etc. Run with –no-schemas, instead use …mysqlbinlog 5.6, you can now pull binary logs in real time to another server using “mysqlbinlog… feature and allows you to cost effectively store long term backups with little additional work Tips/…
Post: xtrabackup-0.5, bugfixes, incremental backup introduction
April 7, 2009 By 6 Comments
… of procedure you can see output: The latest check point (for incremental): ’1319:813219999′ >> log scanned up to (1319 813701532) Transaction log of… release. Beside putting last checkpoint LSN to output we also store it in xtrabackup_checkpoint file to use it in scripts…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… 3.40GHz. InfoBright (ICE) version: 5.1.14-log build number (revision)=IB_3.2_GA_5316… starting with “Div*” are not really used. Load procedure: Infobright: the loader that comes with ICE version… For query Q8 (1year range) traditional transactional oriented stored engine took 30min to get result. I …
