… screens use a DVI-D connector, not a DVI-I one). Alternatively, if you really do end up needing to view the…, here is how to get Percona Server for MySQL up and running: Insert the SD card into a slot on your laptop… start mysqld Connect using the mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql> SHOW ENGINES…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… knowing index is UNIQUE the drawback is insert buffer will not be able to be used, which can be important for large… can slow down your inserts and make primary key significantly fragmented. I also would note there are some MySQL optimizer restrictions in… view ? Is there any management required or server does everything itself. Especially when using a CMS where DB structure is prepdefined A: MySQL…
Post: Checking the subset sum set problem with set processing
May 16, 2011 By Leave a Comment
… in set (20.47 sec) Now insert a value which will cause our check to pass: mysql> insert into data (val) values (16); Query OK, 1 row affected (0.01 sec) mysql> SELECT val as… rows in set (40.01 sec) Of course, I can use a materialized view and check the expression in subsecond.
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
…, from the glance view. If you take a closer look you however would notice hardware is different – MySQL benchmark use Sun Fire X4100… most of MySQL sweet spots come from. MySQL performance gains usually come from MySQL unique features – non transactional MyISAM, Multi Value inserts, Query Cache…
Comment: Using VIEW to reduce number of tables used
October 5, 2007 By 12 Comments
… use a BEFORE INSERT trigger for the shared table (owner_id field should be in the view as well): [CODE]CREATE TRIGGER post_insert BEFORE INSERT…’t be used inside a view definition. I have [URL=http://omelnyk.net/blog/2007/06/18/using-views-with-variables-in-mysql/]outlined[/URL…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…view optimizations that can be applied to INSERT-only workloads, and their are other optimizations that can be applied to views… can automatically partition sets into subsets using basic relational algebra substitution rules …speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’…
Post: EXPLAIN EXTENDED can tell you all kinds of interesting things
June 15, 2010 By 7 Comments
… test the plan: mysql> insert into j1 values (1); insert into j2 select * from j1; insert into j3 select * from j2; mysql> explain extended select… about the query rewrites that MySQL makes when accessing views which use the MERGE algorithm. For example: mysql> create view v1 as select * from j1…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… given object – blog post, forum thread, image, movie etc was viewed. This is sometimes handy feature but it can be rather… trick you can use here is standard “shadow table” trick – use two tables insert into one and process and truncate another. MySQL offers atomic RENAME TABLE call which can be used to swap…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…thought I would share my own view on using MyISAM in production. For …to keep into account while using MyISAM tables. Recovery. MySQL was running stable for …uses table locks and has concurrent inserts which can go concurrently with selects. This is sometimes presented as great concurrency for inserts…
Post: Preprocessing Data
August 8, 2011 By 3 Comments
… submit the message. It also means that when a user views their messages, they quickly get results from prepared tables. 3… Insert This is when you insert data into the database. Your application or the database itself (using TRIGGERs) does additional calculations or data insertions. This adds some overhead when data is being inserted, but according to…
