Changes between Version 15 and Version 16 of neb-touch-gory-details

Timestamp:

Feb 9, 2011, 5:10:43 PM (15 years ago)

Author:

Serge CHASTEL

Comment:

--

neb-touch-gory-details

@@ -22 +22 @@
 (Another experiment with neb-touch neb://ippc01.0/that/command/has/never/been/run give 23 calls to _stringify_key and 5 to _db_index_for_key for create_object -- stat_object is unchanged)
 
-  === SQL statements decomposition ===
-
-Stat_object statement:
+=== SQL statements decomposition ===
+
+ * Stat_object statement:
 
 {{{
@@ -48 +48 @@
    
 with ? = this/is/a/test/never/done/before
+
+ * Create_object statements:
+
+   * Statement 1:
+{{{
+        INSERT INTO storage_object
+        (so_id, ext_id, ext_id_basename, type, dir_id)
+        VALUES (?, ?, ?, 'REG_FILE', ?)
+}}}
+with ? = ('NULL', 'this/is/a/test/never/done/before', 'before', 12257)
+
+   * Statement 2:
+
+{{{
+        SELECT LAST_INSERT_ID()
+}}}
+
+   * Statement 3
+
+{{{
+        INSERT INTO storage_object_attr
+        (so_id, read_lock, write_lock)
+        VALUES (?, 0, NULL)
+}}}
+    
+with ? = 804337
+
+   * Statement 4
+
+{{{
+        INSERT INTO instance 
+        (so_id, vol_id, uri)
+        VALUES (LAST_INSERT_ID(), ?, 'error')
+}}}
+with ? = 1
+
+   * Statement 5
+
+{{{
+        SELECT LAST_INSERT_ID()
+}}}
+
+   * Statement 6
+
+{{{
+        UPDATE instance
+        SET vol_id = ?, uri = ?
+        WHERE ins_id = ?
+}}}
+where ? = (1, 'file:///export/ippc01.0/nebulous/96/9a/584332.this:is:a:test:never:done:before', 584332)
   === Trace ===
 {{{