just to add. i am thinking of working with temporary values getting posted immediately after a transaction eg customer balance on the customers table. Then i wont need a view.
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… enlighten me here. – audit_record_objs : List of database objects (tables, according to the docs) for which you want events written…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap… handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table create table t as SELECT ld.label_id, cai.inventory_id…) group by ld.label_id, cai.inventory_id All 4 tables in the query are locked!
Comment: What Are Full, Incremental, and Differential Backups?
May 22, 2013 By 9 Comments
… of the weeks. Can you give an example in a table? I am doing a project with Open university, and would…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… TABLE `SYS_TABLES` ( `NAME` varchar(255) NOT NULL DEFAULT ”, `ID` bigint(20) unsigned NOT NULL DEFAULT ’0′, `N_COLS` int(10) DEFAULT NULL, `TYPE` int… the table. CREATE TABLE `SYS_COLUMNS` ( `TABLE_ID` bigint(20) unsigned NOT NULL, `POS` int(10) unsigned NOT NULL, `NAME` varchar(255) DEFAULT NULL, `MTYPE` int…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested in… to what I need). Tables looks like: CREATE TABLE `sbtest1` ( `hid` int(10) unsigned NOT NULL DEFAULT ’0′, `mid` int(10) unsigned NOT NULL… –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on…
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
… CREATE TABLE `menu` ( `id` int(11) NOT NULL auto_increment, `label` varchar(50) NOT NULL default ”, `link` varchar(100) NOT NULL default ‘#’, `parent` int(11) NOT NULL default ’0′, `sort` int(11) default…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… within acceptable bounds. This is, however, only a hypothesis. vCache vs. FlashCache – dirty page threshold Finally, we examine the impact of… –num-threads=32 –test=tests/db/oltp.lua –oltp_tables_count=32 \ –oltp-table-size=10000000 –rand-init=on –report-interval=1…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
…_record_length(table_options),reclength); if (info_length+(ulong) create_fields.elements*FCOMP+288+ n_length+int_length+com_length > 65535L || int_count…’)+($n-10)) if $n >= 10; $c= int $c/36; } return $name } my $sql= “CREATE TABLE t (“; foreach(1..shift @ARGV) { my $n… $n >= 10; $c= int $c/36; } $name.=’0′ foreach(length $name .. shift); return $name } my $sql= “CREATE TABLE `”.cname(16,63).”` (“; foreach…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… a new table on the master: mysql> create table test.t (id int not null auto_increment primary key); Executing SHOW TABLES FROM test on both slaves shows that the table has…
