| List: | Commits | « Previous MessageNext Message » | |
| From: | mcbrown | Date: | September 7 2006 4:57pm |
| Subject: | svn commit - mysqldoc@docsrva: r3282 - in trunk/refman-5.1: . images images/PSEArch.graffle images/PSEArch.svg | ||
| View as plain text | |||
Author: mcbrown Date: 2006-09-07 16:57:12 +0200 (Thu, 07 Sep 2006) New Revision: 3282 Log: Merging Pluggable Storage Engines with Storage Engines chapter Reoformatting the introductory material New PSE Architecture diagram (re-drawn) Added: trunk/refman-5.1/images/PSEArch.graffle/data.plist trunk/refman-5.1/images/PSEArch.png trunk/refman-5.1/images/PSEArch.svg/Canvas_1.svg trunk/refman-5.1/images/PSEArch.svg/image1.pdf trunk/refman-5.1/images/PSEArch.svg/image10.tiff trunk/refman-5.1/images/PSEArch.svg/image11.tiff trunk/refman-5.1/images/PSEArch.svg/image12.tiff trunk/refman-5.1/images/PSEArch.svg/image13.tiff trunk/refman-5.1/images/PSEArch.svg/image14.tiff trunk/refman-5.1/images/PSEArch.svg/image16.tiff trunk/refman-5.1/images/PSEArch.svg/image6.tiff trunk/refman-5.1/images/PSEArch.svg/image7.tiff Modified: trunk/refman-5.1/storage-engines.xml Property changes on: trunk/refman-5.1/images/PSEArch.png ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Property changes on: trunk/refman-5.1/images/PSEArch.svg/image10.tiff ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Property changes on: trunk/refman-5.1/images/PSEArch.svg/image11.tiff ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Property changes on: trunk/refman-5.1/images/PSEArch.svg/image12.tiff ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Property changes on: trunk/refman-5.1/images/PSEArch.svg/image13.tiff ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Property changes on: trunk/refman-5.1/images/PSEArch.svg/image14.tiff ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Property changes on: trunk/refman-5.1/images/PSEArch.svg/image16.tiff ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Property changes on: trunk/refman-5.1/images/PSEArch.svg/image6.tiff ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Property changes on: trunk/refman-5.1/images/PSEArch.svg/image7.tiff ___________________________________________________________________ Name: svn:mime-type + application/octet-stream Added: trunk/refman-5.1/images/PSEArch.graffle/data.plist =================================================================== --- trunk/refman-5.1/images/PSEArch.graffle/data.plist (rev 0) +++ trunk/refman-5.1/images/PSEArch.graffle/data.plist 2006-09-07 14:57:12 UTC (rev 3282) Changed blocks: 1, Lines Added: 1980, Lines Deleted: 0; 46403 bytes @@ -0,0 +1,1980 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> +<plist version="1.0"> +<dict> + <key>ActiveLayerIndex</key> + <integer>0</integer> + <key>AutoAdjust</key> + <true/> + <key>CanvasColor</key> + <dict> + <key>w</key> + <string>1</string> + </dict> + <key>CanvasOrigin</key> + <string>{0, 0}</string> + <key>CanvasScale</key> + <real>1</real> + <key>ColumnAlign</key> + <integer>1</integer> + <key>ColumnSpacing</key> + <real>36</real> + <key>CreationDate</key> + <string>2006-09-07 13:40:25 +0100</string> + <key>Creator</key> + <string>Martin MC Brown, MySQL</string> + <key>DisplayScale</key> + <string>1 cm = 1 cm</string> + <key>GraphDocumentVersion</key> + <integer>5</integer> + <key>GraphicsList</key> + <array> + <dict> + <key>Bounds</key> + <string>{{476.088, 330.706}, {44.0001, 45.7144}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>ID</key> + <integer>165</integer> + <key>ImageID</key> + <integer>16</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>shadow</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>stroke</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + </dict> + </dict> + <dict> + <key>Bounds</key> + <string>{{67, 336.85}, {37.3025, 32.6397}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>ID</key> + <integer>163</integer> + <key>ImageID</key> + <integer>14</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>shadow</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>stroke</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + </dict> + </dict> + <dict> + <key>Bounds</key> + <string>{{485.5, 278}, {34.5882, 33.8824}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Arial-BoldMS</string> + <key>Size</key> + <real>9</real> + </dict> + <key>ID</key> + <integer>162</integer> + <key>ImageID</key> + <integer>13</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>shadow</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.5</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Arial-BoldMS;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs18 \cf0 Custom}</string> + </dict> + <key>TextPlacement</key> + <integer>2</integer> + <key>TextRelativeArea</key> + <string>{{0, 0.35}, {1, 1}}</string> + <key>Wrap</key> + <string>NO</string> + </dict> + <dict> + <key>Bounds</key> + <string>{{437.157, 278}, {34.5882, 33.8824}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Arial-BoldMS</string> + <key>Size</key> + <real>9</real> + </dict> + <key>ID</key> + <integer>161</integer> + <key>ImageID</key> + <integer>13</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>shadow</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.5</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Arial-BoldMS;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs18 \cf0 Community}</string> + </dict> + <key>TextPlacement</key> + <integer>2</integer> + <key>TextRelativeArea</key> + <string>{{0, 0.35}, {1, 1}}</string> + <key>Wrap</key> + <string>NO</string> + </dict> + <dict> + <key>Bounds</key> + <string>{{388.814, 278}, {34.5882, 33.8824}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Arial-BoldMS</string> + <key>Size</key> + <real>9</real> + </dict> + <key>ID</key> + <integer>160</integer> + <key>ImageID</key> + <integer>13</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>shadow</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.5</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Arial-BoldMS;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs18 \cf0 Partner}</string> + </dict> + <key>TextPlacement</key> + <integer>2</integer> + <key>TextRelativeArea</key> + <string>{{0, 0.35}, {1, 1}}</string> + <key>Wrap</key> + <string>NO</string> + </dict> + <dict> + <key>Bounds</key> + <string>{{340.471, 278}, {34.5882, 33.8824}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Arial-BoldMS</string> + <key>Size</key> + <real>9</real> + </dict> + <key>ID</key> + <integer>159</integer> + <key>ImageID</key> + <integer>13</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>shadow</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.5</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Arial-BoldMS;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs18 \cf0 NDB}</string> + </dict> + <key>TextPlacement</key> + <integer>2</integer> + <key>TextRelativeArea</key> + <string>{{0, 0.35}, {1, 1}}</string> + <key>Wrap</key> + <string>NO</string> + </dict> + <dict> + <key>Bounds</key> + <string>{{292.127, 278}, {34.5882, 33.8824}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Arial-BoldMS</string> + <key>Size</key> + <real>9</real> + </dict> + <key>ID</key> + <integer>158</integer> + <key>ImageID</key> + <integer>13</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>shadow</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.5</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Arial-BoldMS;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs18 \cf0 Merge}</string> + </dict> + <key>TextPlacement</key> + <integer>2</integer> + <key>TextRelativeArea</key> + <string>{{0, 0.35}, {1, 1}}</string> + <key>Wrap</key> + <string>NO</string> + </dict> + <dict> + <key>Bounds</key> + <string>{{243.784, 278}, {34.5882, 33.8824}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Arial-BoldMS</string> + <key>Size</key> + <real>9</real> + </dict> + <key>ID</key> + <integer>157</integer> + <key>ImageID</key> + <integer>13</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>shadow</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.5</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Arial-BoldMS;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs18 \cf0 Memory}</string> + </dict> + <key>TextPlacement</key> + <integer>2</integer> + <key>TextRelativeArea</key> + <string>{{0, 0.35}, {1, 1}}</string> + <key>Wrap</key> + <string>NO</string> + </dict> + <dict> + <key>Bounds</key> + <string>{{195.441, 278}, {34.5882, 33.8824}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Arial-BoldMS</string> + <key>Size</key> + <real>9</real> + </dict> + <key>ID</key> + <integer>156</integer> + <key>ImageID</key> + <integer>13</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>shadow</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.5</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Arial-BoldMS;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs18 \cf0 Federated}</string> + </dict> + <key>TextPlacement</key> + <integer>2</integer> + <key>TextRelativeArea</key> + <string>{{0, 0.35}, {1, 1}}</string> + <key>Wrap</key> + <string>NO</string> + </dict> + <dict> + <key>Bounds</key> + <string>{{147.098, 278}, {34.5882, 33.8824}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Arial-BoldMS</string> + <key>Size</key> + <real>9</real> + </dict> + <key>ID</key> + <integer>155</integer> + <key>ImageID</key> + <integer>13</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>shadow</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.5</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Arial-BoldMS;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs18 \cf0 Archive}</string> + </dict> + <key>TextPlacement</key> + <integer>2</integer> + <key>TextRelativeArea</key> + <string>{{0, 0.35}, {1, 1}}</string> + <key>Wrap</key> + <string>NO</string> + </dict> + <dict> + <key>Bounds</key> + <string>{{98.7549, 278}, {34.5882, 33.8824}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Arial-BoldMS</string> + <key>Size</key> + <real>9</real> + </dict> + <key>ID</key> + <integer>154</integer> + <key>ImageID</key> + <integer>13</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>shadow</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.5</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Arial-BoldMS;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs18 \cf0 InnoDB}</string> + </dict> + <key>TextPlacement</key> + <integer>2</integer> + <key>TextRelativeArea</key> + <string>{{0, 0.35}, {1, 1}}</string> + <key>Wrap</key> + <string>NO</string> + </dict> + <dict> + <key>Bounds</key> + <string>{{526.5, 289}, {16.5, 16.5}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>ID</key> + <integer>7</integer> + <key>Magnets</key> + <array> + <string>{1, 1}</string> + <string>{1, -1}</string> + <string>{-1, 1}</string> + <string>{-1, -1}</string> + </array> + <key>Shape</key> + <string>Cross</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Color</key> + <dict> + <key>b</key> + <string>0.25098</string> + <key>g</key> + <string>0.501961</string> + <key>r</key> + <string>0</string> + </dict> + <key>FillType</key> + <integer>2</integer> + <key>GradientAngle</key> + <real>265</real> + <key>GradientColor</key> + <dict> + <key>b</key> + <string>0</string> + <key>g</key> + <string>1</string> + <key>r</key> + <string>0</string> + </dict> + </dict> + <key>stroke</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + </dict> + </dict> + <dict> + <key>Bounds</key> + <string>{{50.4118, 278}, {34.5882, 33.8824}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Arial-BoldMS</string> + <key>Size</key> + <real>9</real> + </dict> + <key>ID</key> + <integer>145</integer> + <key>ImageID</key> + <integer>13</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>shadow</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.5</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Arial-BoldMS;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs18 \cf0 MyISAM}</string> + </dict> + <key>TextPlacement</key> + <integer>2</integer> + <key>TextRelativeArea</key> + <string>{{0, 0.35}, {1, 1}}</string> + <key>Wrap</key> + <string>NO</string> + </dict> + <dict> + <key>Bounds</key> + <string>{{368.858, 211.431}, {34.5882, 31.0588}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>ID</key> + <integer>144</integer> + <key>ImageID</key> + <integer>12</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>shadow</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>stroke</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + </dict> + </dict> + <dict> + <key>Bounds</key> + <string>{{478.839, 211.107}, {34.5882, 31.7059}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>ID</key> + <integer>143</integer> + <key>ImageID</key> + <integer>11</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>shadow</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>stroke</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + </dict> + </dict> + <dict> + <key>Bounds</key> + <string>{{317.625, 75.866}, {28, 16.5}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>ID</key> + <integer>142</integer> + <key>Magnets</key> + <array> + <string>{1, 0}</string> + <string>{-1, 0}</string> + </array> + <key>Rotation</key> + <real>90</real> + <key>Shape</key> + <string>DoubleHorizontalArrow</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Color</key> + <dict> + <key>b</key> + <string>1</string> + <key>g</key> + <string>0.501961</string> + <key>r</key> + <string>0</string> + </dict> + <key>FillType</key> + <integer>2</integer> + <key>GradientAngle</key> + <real>232</real> + </dict> + <key>stroke</key> + <dict> + <key>Width</key> + <real>0.25</real> + </dict> + </dict> + </dict> + <dict> + <key>Bounds</key> + <string>{{270.438, 75.866}, {28, 16.5}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>ID</key> + <integer>141</integer> + <key>Magnets</key> + <array> + <string>{1, 0}</string> + <string>{-1, 0}</string> + </array> + <key>Rotation</key> + <real>90</real> + <key>Shape</key> + <string>DoubleHorizontalArrow</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Color</key> + <dict> + <key>b</key> + <string>1</string> + <key>g</key> + <string>0.501961</string> + <key>r</key> + <string>0</string> + </dict> + <key>FillType</key> + <integer>2</integer> + <key>GradientAngle</key> + <real>232</real> + </dict> + <key>stroke</key> + <dict> + <key>Width</key> + <real>0.25</real> + </dict> + </dict> + </dict> + <dict> + <key>Bounds</key> + <string>{{223.25, 75.866}, {28, 16.5}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>ID</key> + <integer>2</integer> + <key>Magnets</key> + <array> + <string>{1, 0}</string> + <string>{-1, 0}</string> + </array> + <key>Rotation</key> + <real>90</real> + <key>Shape</key> + <string>DoubleHorizontalArrow</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Color</key> + <dict> + <key>b</key> + <string>1</string> + <key>g</key> + <string>0.501961</string> + <key>r</key> + <string>0</string> + </dict> + <key>FillType</key> + <integer>2</integer> + <key>GradientAngle</key> + <real>232</real> + </dict> + <key>stroke</key> + <dict> + <key>Width</key> + <real>0.25</real> + </dict> + </dict> + </dict> + <dict> + <key>Bounds</key> + <string>{{515, 118.384}, {28, 28}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>ID</key> + <integer>140</integer> + <key>ImageID</key> + <integer>10</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>shadow</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>stroke</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + </dict> + </dict> + <dict> + <key>Bounds</key> + <string>{{149.85, 208.96}, {34.5882, 36}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>ID</key> + <integer>137</integer> + <key>ImageID</key> + <integer>7</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>shadow</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>stroke</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + </dict> + </dict> + <dict> + <key>Bounds</key> + <string>{{262.789, 209.992}, {34.5882, 33.9356}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>ID</key> + <integer>136</integer> + <key>ImageID</key> + <integer>6</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>shadow</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>stroke</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + </dict> + </dict> + <dict> + <key>Bounds</key> + <string>{{113.5, 115.768}, {436.25, 33.2318}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>ID</key> + <integer>134</integer> + <key>Magnets</key> + <array> + <string>{0, 1}</string> + <string>{0, -1}</string> + <string>{1, 0}</string> + <string>{-1, 0}</string> + </array> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.5</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Helvetica-Bold;\f1\fswiss\fcharset77 Helvetica;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs20 \cf0 Connection Pool +\f1\b0 \ +Authentication, Thread Reuse, Connection Limits, Check Memory, Caches}</string> + </dict> + </dict> + <dict> + <key>Bounds</key> + <string>{{29, 116.232}, {81.5, 128.728}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>ID</key> + <integer>133</integer> + <key>Magnets</key> + <array> + <string>{0, 1}</string> + <string>{0, -1}</string> + <string>{1, 0}</string> + <string>{-1, 0}</string> + </array> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.5</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Helvetica-Bold;\f1\fswiss\fcharset77 Helvetica;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs20 \cf0 Management Services & Utilities +\fs16 \ + +\f1\b0 \ +Backup & Recovery, Security, Replication, Cluster, Administration, Configuration, Migration & Metadata}</string> + </dict> + </dict> + <dict> + <key>Bounds</key> + <string>{{443.859, 170.46}, {106, 73}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Helvetica-Bold</string> + <key>Size</key> + <real>11</real> + </dict> + <key>ID</key> + <integer>132</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Draws</key> + <string>NO</string> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Helvetica;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\fs18 \cf0 Global and Engine Specific Caches & Buffers}</string> + </dict> + <key>TextPlacement</key> + <integer>0</integer> + </dict> + <dict> + <key>Bounds</key> + <string>{{333.515, 170.96}, {106, 73}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Helvetica-Bold</string> + <key>Size</key> + <real>11</real> + </dict> + <key>ID</key> + <integer>131</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Draws</key> + <string>NO</string> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Helvetica;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\fs18 \cf0 Access Paths,\ +Statistics}</string> + </dict> + <key>TextPlacement</key> + <integer>0</integer> + </dict> + <dict> + <key>Bounds</key> + <string>{{223.789, 170.46}, {106, 73}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Helvetica-Bold</string> + <key>Size</key> + <real>11</real> + </dict> + <key>ID</key> + <integer>130</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Draws</key> + <string>NO</string> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Helvetica;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\fs18 \cf0 Query Translation,\ +Object Privilege}</string> + </dict> + <key>TextPlacement</key> + <integer>0</integer> + </dict> + <dict> + <key>Bounds</key> + <string>{{114.117, 172}, {106, 73}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Helvetica-Bold</string> + <key>Size</key> + <real>11</real> + </dict> + <key>ID</key> + <integer>129</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Draws</key> + <string>NO</string> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Helvetica;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\fs18 \cf0 DML, DDL,\ +Stored Procedures\ +Views, Triggers, etc.}</string> + </dict> + <key>TextPlacement</key> + <integer>0</integer> + </dict> + <dict> + <key>Bounds</key> + <string>{{442.515, 154.5}, {107.235, 91}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Helvetica-Bold</string> + <key>Size</key> + <real>11</real> + </dict> + <key>ID</key> + <integer>128</integer> + <key>Magnets</key> + <array> + <string>{0, 1}</string> + <string>{0, -1}</string> + <string>{1, 0}</string> + <string>{-1, 0}</string> + </array> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.5</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Helvetica-Bold;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs20 \cf0 Caches & Buffers}</string> + </dict> + <key>TextPlacement</key> + <integer>0</integer> + </dict> + <dict> + <key>Bounds</key> + <string>{{332.844, 154.5}, {107.235, 91}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Helvetica-Bold</string> + <key>Size</key> + <real>11</real> + </dict> + <key>ID</key> + <integer>127</integer> + <key>Magnets</key> + <array> + <string>{0, 1}</string> + <string>{0, -1}</string> + <string>{1, 0}</string> + <string>{-1, 0}</string> + </array> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.5</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Helvetica-Bold;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs20 \cf0 Optimizer}</string> + </dict> + <key>TextPlacement</key> + <integer>0</integer> + </dict> + <dict> + <key>Bounds</key> + <string>{{223.172, 154.5}, {107.235, 91}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Helvetica-Bold</string> + <key>Size</key> + <real>11</real> + </dict> + <key>ID</key> + <integer>126</integer> + <key>Magnets</key> + <array> + <string>{0, 1}</string> + <string>{0, -1}</string> + <string>{1, 0}</string> + <string>{-1, 0}</string> + </array> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.5</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Helvetica-Bold;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs20 \cf0 Parser}</string> + </dict> + <key>TextPlacement</key> + <integer>0</integer> + </dict> + <dict> + <key>Bounds</key> + <string>{{113.5, 154.5}, {107.235, 91}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Helvetica-Bold</string> + <key>Size</key> + <real>11</real> + </dict> + <key>ID</key> + <integer>120</integer> + <key>Magnets</key> + <array> + <string>{0, 1}</string> + <string>{0, -1}</string> + <string>{1, 0}</string> + <string>{-1, 0}</string> + </array> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.5</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Helvetica-Bold;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs20 \cf0 SQL Interface}</string> + </dict> + <key>TextPlacement</key> + <integer>0</integer> + </dict> + <dict> + <key>Bounds</key> + <string>{{301.5, 333.42}, {194.5, 39.5}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Helvetica-Bold</string> + <key>Size</key> + <real>11</real> + </dict> + <key>ID</key> + <integer>123</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Draws</key> + <string>NO</string> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Helvetica-Bold;\f1\fswiss\fcharset77 Helvetica;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs20 \cf0 Files & Logs\ +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f1\b0 \cf0 Redo, Undo, Data, Index, Binary, \ +Error, Query and Slow}</string> + </dict> + </dict> + <dict> + <key>Bounds</key> + <string>{{111, 333.42}, {106, 39.5}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Helvetica-Bold</string> + <key>Size</key> + <real>11</real> + </dict> + <key>ID</key> + <integer>124</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Draws</key> + <string>NO</string> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Helvetica-Bold;\f1\fswiss\fcharset77 Helvetica;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs20 \cf0 File system\ +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f1\b0 \cf0 NTFS, ufs, ext2/3\ + NFS, SAN, NAS}</string> + </dict> + </dict> + <dict> + <key>Bounds</key> + <string>{{55, 329.42}, {474, 47.5}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Helvetica-Bold</string> + <key>Size</key> + <real>11</real> + </dict> + <key>ID</key> + <integer>125</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.25</real> + </dict> + </dict> + </dict> + <dict> + <key>Class</key> + <string>Group</string> + <key>Graphics</key> + <array> + <dict> + <key>Bounds</key> + <string>{{67, 28}, {27, 35}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Helvetica-Bold</string> + <key>Size</key> + <real>12</real> + </dict> + <key>ID</key> + <integer>109</integer> + <key>ImageID</key> + <integer>1</integer> + <key>Magnets</key> + <array> + <string>{0, 1}</string> + <string>{0, -1}</string> + <string>{1, 0}</string> + <string>{-1, 0}</string> + </array> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Draws</key> + <string>NO</string> + </dict> + <key>shadow</key> + <dict> + <key>Color</key> + <dict> + <key>a</key> + <string>0.5</string> + <key>b</key> + <string>0</string> + <key>g</key> + <string>0</string> + <key>r</key> + <string>0</string> + </dict> + <key>Fuzziness</key> + <real>4</real> + <key>ShadowVector</key> + <string>{0, 2}</string> + </dict> + <key>stroke</key> + <dict> + <key>Cap</key> + <integer>0</integer> + <key>Draws</key> + <string>NO</string> + <key>Join</key> + <integer>0</integer> + </dict> + </dict> + </dict> + <dict> + <key>Class</key> + <string>Group</string> + <key>Graphics</key> + <array> + <dict> + <key>Bounds</key> + <string>{{80.6662, 40.3019}, {428.668, 28.3962}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Helvetica-Bold</string> + <key>Size</key> + <real>12</real> + </dict> + <key>ID</key> + <integer>111</integer> + <key>Magnets</key> + <array> + <string>{0, 1}</string> + <string>{0, -1}</string> + <string>{1, 0}</string> + <string>{-1, 0}</string> + </array> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.25</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Helvetica-Bold;\f1\fswiss\fcharset77 Helvetica;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs22 \cf0 Connectors +\f1\b0 \ +Native C API, JDBC, ODBC, .NET, PHP, Perl, Python, Ruby, Cobol}</string> + </dict> + </dict> + <dict> + <key>Bounds</key> + <string>{{73, 33.5}, {444, 42}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Helvetica-Bold</string> + <key>Size</key> + <real>12</real> + </dict> + <key>ID</key> + <integer>112</integer> + <key>Magnets</key> + <array> + <string>{0, 1}</string> + <string>{0, -1}</string> + <string>{1, 0}</string> + <string>{-1, 0}</string> + </array> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Color</key> + <dict> + <key>a</key> + <string>0.26</string> + <key>b</key> + <string>1</string> + <key>g</key> + <string>1</string> + <key>r</key> + <string>0.4</string> + </dict> + </dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.25</real> + </dict> + </dict> + </dict> + </array> + <key>ID</key> + <integer>110</integer> + </dict> + </array> + <key>ID</key> + <integer>108</integer> + </dict> + <dict> + <key>Bounds</key> + <string>{{34.25, 251.36}, {515.5, 74.66}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Helvetica-Bold</string> + <key>Size</key> + <real>11</real> + </dict> + <key>ID</key> + <integer>121</integer> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + <key>Width</key> + <real>0.25</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Helvetica-Bold;\f1\fswiss\fcharset77 Helvetica;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qc\pardirnatural + +\f0\b\fs20 \cf0 Pluggable Storage Engines +\f1\b0 \ +Memory, Index & Storage Management}</string> + </dict> + <key>TextPlacement</key> + <integer>0</integer> + </dict> + <dict> + <key>Bounds</key> + <string>{{23, 90}, {538, 295}}</string> + <key>Class</key> + <string>ShapedGraphic</string> + <key>FontInfo</key> + <dict> + <key>Font</key> + <string>Helvetica-Bold</string> + <key>Size</key> + <real>11</real> + </dict> + <key>ID</key> + <integer>4</integer> + <key>Magnets</key> + <array> + <string>{0, 1}</string> + <string>{0, -1}</string> + <string>{1, 0}</string> + <string>{-1, 0}</string> + </array> + <key>Shape</key> + <string>Rectangle</string> + <key>Style</key> + <dict> + <key>fill</key> + <dict> + <key>Color</key> + <dict> + <key>a</key> + <string>0.11</string> + <key>b</key> + <string>0.8</string> + <key>g</key> + <string>1</string> + <key>r</key> + <string>0.4</string> + </dict> + </dict> + <key>stroke</key> + <dict> + <key>CornerRadius</key> + <real>5</real> + </dict> + </dict> + <key>Text</key> + <dict> + <key>Align</key> + <integer>2</integer> + <key>Text</key> + <string>{\rtf1\mac\ansicpg10000\cocoartf824\cocoasubrtf410 +{\fonttbl\f0\fswiss\fcharset77 Helvetica-Bold;} +{\colortbl;\red255\green255\blue255;} +\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\qr\pardirnatural + +\f0\b\fs36 \cf0 MySQL Server}</string> + </dict> + <key>TextPlacement</key> + <integer>0</integer> + </dict> + </array> + <key>GridInfo</key> + <dict/> + <key>GuidesLocked</key> + <string>NO</string> + <key>GuidesVisible</key> + <string>YES</string> + <key>HPages</key> + <integer>1</integer> + <key>ImageCounter</key> + <integer>17</integer> + <key>ImageLinkBack</key> + <array> + <dict/> + <dict/> + <dict/> + <dict/> + <dict/> + <dict/> + <dict/> + <dict/> + <dict/> + </array> + <key>ImageList</key> + <array> + <string>image16.tiff</string> + <string>image14.tiff</string> + <string>image13.tiff</string> + <string>image12.tiff</string> + <string>image11.tiff</string> + <string>image10.tiff</string> + <string>image7.tiff</string> + <string>image6.tiff</string> + <string>image1.pdf</string> + </array> + <key>IsPalette</key> + <string>NO</string> + <key>KeepToScale</key> + <false/> + <key>Layers</key> + <array> + <dict> + <key>Lock</key> + <string>NO</string> + <key>Name</key> + <string>Layer 1</string> + <key>Print</key> + <string>YES</string> + <key>View</key> + <string>YES</string> + </dict> + </array> + <key>LayoutInfo</key> + <dict> + <key>LayoutTarget</key> + <integer>3</integer> + </dict> + <key>LinksVisible</key> + <string>NO</string> + <key>MagnetsVisible</key> + <string>NO</string> + <key>MasterSheet</key> + <string>Master 1</string> + <key>MasterSheets</key> + <array> + <dict> + <key>ActiveLayerIndex</key> + <integer>0</integer> + <key>AutoAdjust</key> + <true/> + <key>CanvasColor</key> + <dict> + <key>w</key> + <string>1</string> + </dict> + <key>CanvasOrigin</key> + <string>{0, 0}</string> + <key>CanvasScale</key> + <real>1</real> + <key>ColumnAlign</key> + <integer>1</integer> + <key>ColumnSpacing</key> + <real>36</real> + <key>DisplayScale</key> + <string>1 cm = 1 cm</string> + <key>GraphicsList</key> + <array/> + <key>GridInfo</key> + <dict/> + <key>HPages</key> + <integer>1</integer> + <key>IsPalette</key> + <string>NO</string> + <key>KeepToScale</key> + <false/> + <key>Layers</key> + <array> + <dict> + <key>Lock</key> + <string>NO</string> + <key>Name</key> + <string>Layer 1</string> + <key>Print</key> + <string>YES</string> + <key>View</key> + <string>YES</string> + </dict> + </array> + <key>LayoutInfo</key> + <dict> + <key>LayoutTarget</key> + <integer>3</integer> + </dict> + <key>Orientation</key> + <integer>2</integer> + <key>OutlineStyle</key> + <string>Basic</string> + <key>RowAlign</key> + <integer>1</integer> + <key>RowSpacing</key> + <real>36</real> + <key>SheetTitle</key> + <string>Master 1</string> + <key>UniqueID</key> + <integer>1</integer> + <key>VPages</key> + <integer>1</integer> + </dict> + </array> + <key>ModificationDate</key> + <string>2006-09-07 14:58:40 +0100</string> + <key>Modifier</key> + <string>Martin MC Brown, MySQL</string> + <key>NotesVisible</key> + <string>NO</string> + <key>Orientation</key> + <integer>2</integer> + <key>OriginVisible</key> + <string>NO</string> + <key>OutlineStyle</key> + <string>Basic</string> + <key>PageBreaks</key> + <string>YES</string> + <key>PrintInfo</key> + <dict> + <key>NSBottomMargin</key> + <array> + <string>float</string> + <string>0</string> + </array> + <key>NSLeftMargin</key> + <array> + <string>float</string> + <string>0</string> + </array> + <key>NSRightMargin</key> + <array> + <string>float</string> + <string>0</string> + </array> + <key>NSTopMargin</key> + <array> + <string>float</string> + <string>0</string> + </array> + </dict> + <key>ReadOnly</key> + <string>NO</string> + <key>RowAlign</key> + <integer>1</integer> + <key>RowSpacing</key> + <real>36</real> + <key>SheetTitle</key> + <string>Canvas 1</string> + <key>SmartAlignmentGuidesActive</key> + <string>YES</string> + <key>SmartDistanceGuidesActive</key> + <string>YES</string> + <key>UniqueID</key> + <integer>1</integer> + <key>UseEntirePage</key> + <true/> + <key>VPages</key> + <integer>1</integer> + <key>WindowInfo</key> + <dict> + <key>CurrentSheet</key> + <string>0</string> + <key>DrawerOpen</key> + <false/> + <key>DrawerTab</key> + <string>Outline</string> + <key>DrawerWidth</key> + <real>209</real> + <key>FitInWindow</key> + <false/> + <key>Frame</key> + <string>{{-1263, -126}, {1238, 1136}}</string> + <key>ShowRuler</key> + <false/> + <key>ShowStatusBar</key> + <true/> + <key>VisibleRegion</key> + <string>{{-17, 0}, {611.5, 511}}</string> + <key>Zoom</key> + <string>2</string> + </dict> +</dict> +</plist> Added: trunk/refman-5.1/images/PSEArch.png =================================================================== Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 301 bytes Added: trunk/refman-5.1/images/PSEArch.svg/Canvas_1.svg =================================================================== --- trunk/refman-5.1/images/PSEArch.svg/Canvas_1.svg (rev 0) +++ trunk/refman-5.1/images/PSEArch.svg/Canvas_1.svg 2006-09-07 14:57:12 UTC (rev 3282) Changed blocks: 1, Lines Added: 75, Lines Deleted: 0; 41056 bytes @@ -0,0 +1,75 @@ +<?xml version="1.0"?> +<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd"> +<svg xmlns="http://www.w3.org/2000/svg" xmlns:xl="http://www.w3.org/1999/xlink" version="1.1" viewBox="3 15 578 394" width="578pt" height="394pt"><metadata xmlns:dc="http://purl.org/dc/elements/1.1/"><dc:date>2006-09-07 13:58Z</dc:date><!-- Produced by OmniGraffle Professional 4.1.1 --></metadata><defs><filter id="Shadow" filterUnits="userSpaceOnUse"><feGaussianBlur in="SourceAlpha" result="blur" stdDeviation="3.488"/><feOffset in="blur" result="offset" dx="0" dy="4"/><feFlood flood-color="Black" flood-opacity=".75" result="flood"/><feComposite in="flood" in2="offset" operator="in"/></filter><font-face font-size="18pt" units-per-em="1000" underline-position="-75.683594" underline-thickness="49.316406" slope="0" x-height="555.55554" cap-height="722.22223" ascent="770.01953" descent="-229.98047" font-weight="bold"><!--{ + NSCTFontTraitsAttribute = { + NSCTFontProportionTrait = 0; + NSCTFontSlantTrait = 0; + NSCTFontSymbolicTrait = 2; + NSCTFontWeightTrait = 0.4; + }; + NSFontNameAttribute = "Helvetica-Bold"; + NSFontSizeAttribute = 18; +}--><font-face-src><font-face-name name="Helvetica-Bold"/></font-face-src></font-face><font-face font-size="10pt" units-per-em="1000" underline-position="-75.683594" underline-thickness="49.316406" slope="0" x-height="550" cap-height="700" ascent="770.01953" descent="-229.98047" font-weight="bold"><!--{ + NSCTFontTraitsAttribute = { + NSCTFontProportionTrait = 0; + NSCTFontSlantTrait = 0; + NSCTFontSymbolicTrait = 2; + NSCTFontWeightTrait = 0.4; + }; + NSFontNameAttribute = "Helvetica-Bold"; + NSFontSizeAttribute = 10; +}--><font-face-src><font-face-name name="Helvetica-Bold"/></font-face-src></font-face><font-face font-size="10pt" units-per-em="1000" underline-position="-75.683594" underline-thickness="49.316406" slope="0" x-height="600" cap-height="800" ascent="770.01953" descent="-229.98047" font-weight="500"><!--{ + NSCTFontTraitsAttribute = { + NSCTFontProportionTrait = 0; + NSCTFontSlantTrait = 0; + NSCTFontSymbolicTrait = 0; + NSCTFontWeightTrait = 0; + }; + NSFontNameAttribute = Helvetica; + NSFontSizeAttribute = 10; +}--><font-face-src><font-face-name name="Helvetica"/></font-face-src></font-face><font-face font-size="11pt" units-per-em="1000" underline-position="-75.683594" underline-thickness="49.316406" slope="0" x-height="545.45453" cap-height="727.2727" ascent="770.01953" descent="-229.98047" font-weight="bold"><!--{ + NSCTFontTraitsAttribute = { + NSCTFontProportionTrait = 0; + NSCTFontSlantTrait = 0; + NSCTFontSymbolicTrait = 2; + NSCTFontWeightTrait = 0.4; + }; + NSFontNameAttribute = "Helvetica-Bold"; + NSFontSizeAttribute = 11; +}--><font-face-src><font-face-name name="Helvetica-Bold"/></font-face-src></font-face><font-face font-size="11pt" units-per-em="1000" underline-position="-75.683594" underline-thickness="49.316406" slope="0" x-height="545.45453" cap-height="727.2727" ascent="770.01953" descent="-229.98047" font-weight="500"><!--{ + NSCTFontTraitsAttribute = { + NSCTFontProportionTrait = 0; + NSCTFontSlantTrait = 0; + NSCTFontSymbolicTrait = 0; + NSCTFontWeightTrait = 0; + }; + NSFontNameAttribute = Helvetica; + NSFontSizeAttribute = 11; +}--><font-face-src><font-face-name name="Helvetica"/></font-face-src></font-face><font-face font-size="9pt" units-per-em="1000" underline-position="-75.683594" underline-thickness="49.316406" slope="0" x-height="555.55554" cap-height="777.77783" ascent="770.01953" descent="-229.98047" font-weight="500"><!--{ + NSCTFontTraitsAttribute = { + NSCTFontProportionTrait = 0; + NSCTFontSlantTrait = 0; + NSCTFontSymbolicTrait = 0; + NSCTFontWeightTrait = 0; + }; + NSFontNameAttribute = Helvetica; + NSFontSizeAttribute = 9; +}--><font-face-src><font-face-name name="Helvetica"/></font-face-src></font-face><font-face font-size="8pt" units-per-em="1000" underline-position="-75.683594" underline-thickness="49.316406" slope="0" x-height="500" cap-height="750" ascent="770.01953" descent="-229.98047" font-weight="500"><!--{ + NSCTFontTraitsAttribute = { + NSCTFontProportionTrait = 0; + NSCTFontSlantTrait = 0; + NSCTFontSymbolicTrait = 0; + NSCTFontWeightTrait = 0; + }; + NSFontNameAttribute = Helvetica; + NSFontSizeAttribute = 8; +}--><font-face-src><font-face-name name="Helvetica"/></font-face-src></font-face><linearGradient x1="0" x2="1" id="Gradient" gradientUnits="userSpaceOnUse"><stop offset="0" stop-color="#0080ff"/><stop offset="1" stop-color="#aaa"/></linearGradient><linearGradient id="Obj_Gradient" xl:href="#Gradient" gradientTransform="translate(225.335 93.42498) rotate(-37.999991) scale(30.240701)"/><linearGradient id="Obj_Gradient_2" xl:href="#Gradient" gradientTransform="translate(272.52249 93.42498) rotate(-37.999991) scale(30.240701)"/><linearGradient id="Obj_Gradient_3" xl:href="#Gradient" gradientTransform="translate(319.71 93.42499) rotate(-37.999993) scale(30.240708)"/><font-face font-size="9pt" units-per-em="1000" underline-position="-105.95703" underline-thickness="104.98047" slope="0" x-height="555.55554" cap-height="722.22223" ascent="905.27344" descent="-211.91406" font-weight="bold"><!--{ + NSCTFontTraitsAttribute = { + NSCTFontProportionTrait = 0; + NSCTFontSlantTrait = 0; + NSCTFontSymbolicTrait = -2147483646; + NSCTFontWeightTrait = 0.4; + }; + NSFontNameAttribute = "Arial-BoldMS"; + NSFontSizeAttribute = 9; +}--><font-face-src><font-face-name name="Arial-BoldMS"/></font-face-src></font-face><linearGradient x1="0" x2="1" id="Gradient_2" gradientUnits="userSpaceOnUse"><stop offset="0" stop-color="#008040"/><stop offset="1" stop-color="Lime"/></linearGradient><linearGradient id="Obj_Gradient_4" xl:href="#Gradient_2" gradientTransform="translate(535.529 306.15366) rotate(-95) scale(17.875306)"/></defs><g stroke="none" stroke-opacity="1" stroke-dasharray="none" fill="none" fill-opacity="1"><title>Canvas 1</title><rect fill="White" width="576" height="753.84003"/><g><title>Layer 1</title><g><use xl:href="#id4_Graphic" filter="url(#Shadow)"/><use xl:href="#id121_Graphic" filter="url(#Shadow)"/><use xl:href="#id125_Graphic" filter="url(#Shadow)"/><use xl:href="#id124_Graphic" filter="url(#Shadow)"/><use xl:href="#id123_Graphic" filter="url(#Shadow)"/><use xl:href="#id120_Graphic" filter="url(#Shadow)"/><use xl:href="#id126_Graphic" filter="url(#Shadow)"/><use xl:href="#id127_Graphic" f! ilter="url(#Shadow)"/><use xl:href="#id128_Graphic" filter="url(#Shadow)"/><use xl:href="#id129_Graphic" filter="url(#Shadow)"/><use xl:href="#id130_Graphic" filter="url(#Shadow)"/><use xl:href="#id131_Graphic" filter="url(#Shadow)"/><use xl:href="#id132_Graphic" filter="url(#Shadow)"/><use xl:href="#id133_Graphic" filter="url(#Shadow)"/><use xl:href="#id134_Graphic" filter="url(#Shadow)"/><use xl:href="#id2_Graphic" filter="url(#Shadow)"/><use xl:href="#id141_Graphic" filter="url(#Shadow)"/><use xl:href="#id142_Graphic" filter="url(#Shadow)"/><use xl:href="#id7_Graphic" filter="url(#Shadow)"/></g><g id="id4_Graphic"><path d="M 292 90 L 556 90 C 558.7614 90 561 92.23858 561 95 L 561 380 C 561 382.76141 558.7614 385 556 385 L 28 384.99994 C 25.238577 384.99994 23 382.76135 23 379.99994 L 22.999989 95 C 22.999989 92.23858 25.238565 90 27.999989 90 Z" fill="#6fc" fill-opacity=".11"/><path d="M 292 90 L 556 90 C 558.7614 90 561 92.23858 561 95 L 561 380 C 561 382.76141 558.7614! 385 556 385 L 28 384.99994 C 25.238577 384.99994 23 382.76135! 23 379. 99994 L 22.999989 95 C 22.999989 92.23858 25.238565 90 27.999989 90 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width="1"/><text transform="translate(28 90)" fill="Black"><tspan font-size="18pt" font-weight="bold" fill="Black" x="405.26074" y="18" textLength="62.006">MySQL</tspan><tspan font-size="18pt" font-weight="bold" fill="Black" x="466.95117" y="18" textLength="61.048"> Server</tspan></text></g><g id="id121_Graphic"><path d="M 292 251.3601 L 544.75 251.3601 C 547.5114 251.3601 549.75 253.59868 549.75 256.3601 L 549.75 321.02008 C 549.75 323.7815 547.5114 326.02008 544.75 326.02008 L 39.25 326.02005 C 36.488575 326.02005 34.25 323.78146 34.25 321.02005 L 34.249996 256.3601 C 34.249996 253.59868 36.488571 251.3601 39.249996 251.3601 Z" fill="White"/><path d="M 292 251.3601 L 544.75 251.3601 C 547.5114 251.3601 549.75 253.59868 549.75 256.3601 L 549.75 321.02008 C 549.75 323.7815 547.5114 326.02008 544.75 326.02008 L 39.25 326.02005 C 36.488575! 326.02005 34.25 323.78146 34.25 321.02005 L 34.249996 256.3601 C 34.249996 253.59868 36.488571 251.3601 39.249996 251.3601 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".25"/><text transform="translate(39.25 251.3601)" fill="Black"><tspan font-size="10pt" font-weight="bold" fill="Black" x="188.01611" y="10" textLength="129.466995">Pluggable Storage Engines</tspan><tspan font-size="10pt" fill="Black" x="165.85303" y="22" textLength="36.113">Memory</tspan><tspan font-size="10pt" fill="Black" x="201.229" y="22" textLength="138.41701">, Index & Storage Management</tspan></text></g><path d="M 295 33.5 L 512 33.5 C 514.7614 33.5 517 35.738575 517 38.5 L 517 70.5 C 517 73.26142 514.7614 75.5 512 75.5 L 78 75.49996 C 75.23858 75.49996 73 73.261383 73 70.49996 L 72.999985 38.500004 C 72.999985 35.738579 75.238564 33.5 77.999985 33.5 C 77.999985 33.5 77.999985 33.5 77.999985 33.5 Z" fill="#6ff" fill-opacity=".25999999"/><path d="M 295 33.5 L 512 ! 33.5 C 514.7614 33.5 517 35.738575 517 38.5 L 517 70.5 C 517 7! 3.26142 514.7614 75.5 512 75.5 L 78 75.49996 C 75.23858 75.49996 73 73.261383 73 70.49996 L 72.999985 38.500004 C 72.999985 35.738579 75.238564 33.5 77.999985 33.5 C 77.999985 33.5 77.999985 33.5 77.999985 33.5 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".25"/><path d="M 295 40.301926 L 504.3338 40.301926 C 507.0952 40.301926 509.3338 42.5405 509.3338 45.301926 L 509.3338 63.698082 C 509.3338 66.459503 507.0952 68.69808 504.3338 68.69808 L 85.6662 68.698044 C 82.904778 68.698044 80.6662 66.459465 80.6662 63.698044 L 80.6662 45.301926 C 80.6662 42.5405 82.904778 40.301926 85.6662 40.301926 Z" fill="White"/><path d="M 295 40.301926 L 504.3338 40.301926 C 507.0952 40.301926 509.3338 42.5405 509.3338 45.301926 L 509.3338 63.698082 C 509.3338 66.459503 507.0952 68.69808 504.3338 68.69808 L 85.6662 68.698044 C 82.904778 68.698044 80.6662 66.459465 80.6662 63.698044 L 80.6662 45.301926 C 80.6662 42.5405 82.904778 40.301926 85.6662 40.301926 Z" stroke="Bla! ck" stroke-linecap="round" stroke-linejoin="round" stroke-width=".25"/><text transform="translate(85.6662 42.000004)" fill="Black"><tspan font-size="11pt" font-weight="bold" fill="Black" x="178.77496" y="10" textLength="61.117">Connectors</tspan><tspan font-size="11pt" fill="Black" x="47.22345" y="23" textLength="45.235">Native C </tspan><tspan font-size="11pt" fill="Black" x="91.85724" y="23" textLength="121.628">API, JDBC, ODBC, .NET</tspan><tspan font-size="11pt" fill="Black" x="212.26642" y="23" textLength="28.729">, PHP</tspan><tspan font-size="11pt" fill="Black" x="239.57843" y="23" textLength="97.823">, Perl, Python, Ruby</tspan><tspan font-size="11pt" fill="Black" x="336.59113" y="23" textLength="34.853">, Cobol</tspan></text><rect x="67" y="28" width="27" height="35" id="path"/><clipPath id="clip_path"><use xl:href="#path"/></clipPath><g clip-path="url(#clip_path)"><image xl:href="image1.pdf" width="275" height="325" transform="matrix(.09818182 0 0 .10769231 66.5 2! 7.5)"/></g><g id="id125_Graphic"><path d="M 292 329.42001 L 52! 4 329.42 001 C 526.7614 329.42001 529 331.6586 529 334.42001 L 529 371.92001 C 529 374.68143 526.7614 376.92001 524 376.92001 L 60 376.91998 C 57.238575 376.91998 55 374.6814 55 371.91998 L 55 334.42001 C 55 331.6586 57.238575 329.42001 60 329.42001 Z" fill="White"/><path d="M 292 329.42001 L 524 329.42001 C 526.7614 329.42001 529 331.6586 529 334.42001 L 529 371.92001 C 529 374.68143 526.7614 376.92001 524 376.92001 L 60 376.91998 C 57.238575 376.91998 55 374.6814 55 371.91998 L 55 334.42001 C 55 331.6586 57.238575 329.42001 60 329.42001 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".25"/></g><g id="id124_Graphic"><path d="M 164 333.42001 L 212 333.42001 C 214.76143 333.42001 217 335.6586 217 338.42001 L 217 367.92001 C 217 370.68143 214.76143 372.92001 212 372.92001 L 116 372.92001 C 113.23858 372.92001 111 370.68143 111 367.92001 L 111 338.42001 C 111 335.6586 113.23858 333.42001 116 333.42001 Z" fill="White"/><text transform="translate(116 335.670! 01)" fill="Black"><tspan font-size="10pt" font-weight="bold" x="20.763672" y="10" textLength="54.472">File system</tspan><tspan font-size="10pt" x="9.098633" y="22" textLength="77.802">NTFS, ufs, ext2/3</tspan><tspan font-size="10pt" x="10.492676" y="34" textLength="75.014"> NFS, SAN, NAS</tspan></text></g><g id="id123_Graphic"><path d="M 398.75 333.42001 L 491 333.42001 C 493.7614 333.42001 496 335.6586 496 338.42001 L 496 367.92001 C 496 370.68143 493.7614 372.92001 491 372.92001 L 306.5 372.91998 C 303.73859 372.91998 301.5 370.6814 301.5 367.91998 L 301.5 338.42001 C 301.5 335.6586 303.73859 333.42001 306.5 333.42001 Z" fill="White"/><text transform="translate(306.5 335.67001)" fill="Black"><tspan font-size="10pt" font-weight="bold" x="62.523438" y="10" textLength="59.453">Files & Logs</tspan><tspan font-size="10pt" x="19.244629" y="22" textLength="143.96899">Redo, Undo, Data, Index, Binary</tspan><tspan font-size="10pt" x="162.47705" y="22" textLength="5.5560002">,! </tspan><tspan font-size="10pt" x="43.060547" y="34" textLeng! th="22.2 21001">Error</tspan><tspan font-size="10pt" x="64.73535" y="34" textLength="76.704002">, Query and Slow</tspan></text></g><g id="id120_Graphic"><path d="M 167.11734 154.5 L 215.73466 154.5 C 218.4961 154.5 220.73466 156.73857 220.73466 159.5 L 220.73466 240.5 C 220.73466 243.26143 218.4961 245.5 215.73466 245.5 L 118.500015 245.49998 C 115.738594 245.49998 113.500015 243.26141 113.500015 240.49998 L 113.500015 159.5 C 113.500015 156.73857 115.738594 154.5 118.500015 154.5 C 118.500015 154.5 118.500015 154.5 118.500015 154.5 Z" fill="White"/><path d="M 167.11734 154.5 L 215.73466 154.5 C 218.4961 154.5 220.73466 156.73857 220.73466 159.5 L 220.73466 240.5 C 220.73466 243.26143 218.4961 245.5 215.73466 245.5 L 118.500015 245.49998 C 115.738594 245.49998 113.500015 243.26141 113.500015 240.49998 L 113.500015 159.5 C 113.500015 156.73857 115.738594 154.5 118.500015 154.5 C 118.500015 154.5 118.500015 154.5 118.500015 154.5 Z" stroke="Black" stroke-linecap="round" stroke-linejoin! ="round" stroke-width=".5"/><text transform="translate(118.500015 154.5)" fill="Black"><tspan font-size="10pt" font-weight="bold" fill="Black" x="16.195446" y="10" textLength="20.556">SQL</tspan><tspan font-size="10pt" font-weight="bold" fill="Black" x="36.576305" y="10" textLength="44.462002"> Interface</tspan></text></g><g id="id126_Graphic"><path d="M 276.78915 154.5 L 325.40646 154.5 C 328.16788 154.5 330.40646 156.73857 330.40646 159.5 L 330.40646 240.5 C 330.40646 243.26143 328.16788 245.5 325.40646 245.5 L 228.17183 245.49998 C 225.4104 245.49998 223.17183 243.26141 223.17183 240.49998 L 223.17183 159.5 C 223.17183 156.73857 225.4104 154.5 228.17183 154.5 C 228.17183 154.5 228.17183 154.5 228.17183 154.5 Z" fill="White"/><path d="M 276.78915 154.5 L 325.40646 154.5 C 328.16788 154.5 330.40646 156.73857 330.40646 159.5 L 330.40646 240.5 C 330.40646 243.26143 328.16788 245.5 325.40646 245.5 L 228.17183 245.49998 C 225.4104 245.49998 223.17183 243.26141 223.17183 240.49! 998 L 223.17183 159.5 C 223.17183 156.73857 225.4104 154.5 228! .17183 1 54.5 C 228.17183 154.5 228.17183 154.5 228.17183 154.5 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".5"/><text transform="translate(228.17183 154.5)" fill="Black"><tspan font-size="10pt" font-weight="bold" x="33.048473" y="10" textLength="31.137">Parser</tspan></text></g><g id="id127_Graphic"><path d="M 386.46085 154.5 L 435.07816 154.5 C 437.83957 154.5 440.07816 156.73857 440.07816 159.5 L 440.07816 240.5 C 440.07816 243.26143 437.83957 245.5 435.07816 245.5 L 337.84354 245.49998 C 335.08212 245.49998 332.84354 243.26141 332.84354 240.49998 L 332.84354 159.5 C 332.84354 156.73857 335.08212 154.5 337.84354 154.5 C 337.84354 154.5 337.84354 154.5 337.84354 154.5 Z" fill="White"/><path d="M 386.46085 154.5 L 435.07816 154.5 C 437.83957 154.5 440.07816 156.73857 440.07816 159.5 L 440.07816 240.5 C 440.07816 243.26143 437.83957 245.5 435.07816 245.5 L 337.84354 245.49998 C 335.08212 245.49998 332.84354 243.26141 332.84354 240.49998 L 332.84354 ! 159.5 C 332.84354 156.73857 335.08212 154.5 337.84354 154.5 C 337.84354 154.5 337.84354 154.5 337.84354 154.5 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".5"/><text transform="translate(337.84354 154.5)" fill="Black"><tspan font-size="10pt" font-weight="bold" x="25.558239" y="10" textLength="46.118">Optimizer</tspan></text></g><g id="id128_Graphic"><path d="M 496.13275 154.5 L 544.75006 154.5 C 547.51147 154.5 549.75006 156.73857 549.75006 159.5 L 549.75006 240.5 C 549.75006 243.26143 547.51147 245.5 544.75006 245.5 L 447.51544 245.49998 C 444.75403 245.49998 442.51544 243.26141 442.51544 240.49998 L 442.51544 159.5 C 442.51544 156.73857 444.75403 154.5 447.51544 154.5 C 447.51544 154.5 447.51544 154.5 447.51544 154.5 Z" fill="White"/><path d="M 496.13275 154.5 L 544.75006 154.5 C 547.51147 154.5 549.75006 156.73857 549.75006 159.5 L 549.75006 240.5 C 549.75006 243.26143 547.51147 245.5 544.75006 245.5 L 447.51544 245.49998 C 444.75403 245! .49998 442.51544 243.26141 442.51544 240.49998 L 442.51544 159! .5 C 442 .51544 156.73857 444.75403 154.5 447.51544 154.5 C 447.51544 154.5 447.51544 154.5 447.51544 154.5 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".5"/><text transform="translate(447.51544 154.5)" fill="Black"><tspan font-size="10pt" font-weight="bold" x="6.9376335" y="10" textLength="83.359">Caches & Buffers</tspan></text></g><g id="id129_Graphic"><path d="M 167.11734 172 L 215.11734 172 C 217.87877 172 220.11734 174.23857 220.11734 177 L 220.11734 240 C 220.11734 242.76143 217.87877 245 215.11734 245 L 119.11734 244.99998 C 116.35592 244.99998 114.11734 242.76141 114.11734 239.99998 L 114.11734 177 C 114.11734 174.23857 116.35592 172 119.11734 172 C 119.11734 172 119.11734 172 119.11734 172 Z" fill="White"/><text transform="translate(119.11734 172)" fill="Black"><tspan font-size="9pt" x="25.746094" y="9" textLength="44.507">DML, DDL,</tspan><tspan font-size="9pt" x="10.479492" y="20" textLength="75.041">Stored Procedures</tspan><tspan fon! t-size="9pt" x="7.5615234" y="31" textLength="6.002">V</tspan><tspan font-size="9pt" x="13.40625" y="31" textLength="23.004999">iews, </tspan><tspan font-size="9pt" x="36.253418" y="31" textLength="5.4970002">T</tspan><tspan font-size="9pt" x="41.421387" y="31" textLength="47.016998">riggers, etc.</tspan></text></g><g id="id130_Graphic"><path d="M 276.78915 170.46017 L 324.78915 170.46017 C 327.55057 170.46017 329.78915 172.69875 329.78915 175.46017 L 329.78915 238.46017 C 329.78915 241.2216 327.55057 243.46017 324.78915 243.46017 L 228.78915 243.46016 C 226.02773 243.46016 223.78915 241.22159 223.78915 238.46016 L 223.78915 175.46017 C 223.78915 172.69875 226.02773 170.46017 228.78915 170.46017 C 228.78915 170.46017 228.78915 170.46017 228.78915 170.46017 Z" fill="White"/><text transform="translate(228.78915 170.46017)" fill="Black"><tspan font-size="9pt" x="11.22876" y="9" textLength="27.008">Query </tspan><tspan font-size="9pt" x="38.079346" y="9" textLength="5.4970002">! T</tspan><tspan font-size="9pt" x="43.247314" y="9" textLength! ="41.523 ">ranslation,</tspan><tspan font-size="9pt" x="16.486816" y="20" textLength="63.026">Object Privilege</tspan></text></g><g id="id131_Graphic"><path d="M 386.51544 170.96017 L 434.51544 170.96017 C 437.27686 170.96017 439.51544 173.19875 439.51544 175.96017 L 439.51544 238.96017 C 439.51544 241.7216 437.27686 243.96017 434.51544 243.96017 L 338.51544 243.96016 C 335.75403 243.96016 333.51544 241.72159 333.51544 238.96016 L 333.51544 175.96017 C 333.51544 173.19875 335.75403 170.96017 338.51544 170.96017 C 338.51544 170.96017 338.51544 170.96017 338.51544 170.96017 Z" fill="White"/><text transform="translate(338.51544 170.96017)" fill="Black"><tspan font-size="9pt" x="19.488281" y="9" textLength="57.023">Access Paths,</tspan><tspan font-size="9pt" x="29.995605" y="20" textLength="36.008">Statistics</tspan></text></g><g id="id132_Graphic"><path d="M 496.85907 170.46017 L 544.85907 170.46017 C 547.62048 170.46017 549.85907 172.69875 549.85907 175.46017 L 549.85907 238.46017 C 54! 9.85907 241.2216 547.62048 243.46017 544.85907 243.46017 L 448.85907 243.46016 C 446.09766 243.46016 443.85907 241.22159 443.85907 238.46016 L 443.85907 175.46017 C 443.85907 172.69875 446.09766 170.46017 448.85907 170.46017 C 448.85907 170.46017 448.85907 170.46017 448.85907 170.46017 Z" fill="White"/><text transform="translate(448.85907 170.46017)" fill="Black"><tspan font-size="9pt" x="10.97168" y="9" textLength="76.557">Global and Engine </tspan><tspan font-size="9pt" x="11.4836426" y="20" textLength="27.013">Specifi</tspan><tspan font-size="9pt" x="38.496826" y="20" textLength="48.52">c Caches & </tspan><tspan font-size="9pt" x="33.823242" y="31" textLength="13.508">Buf</tspan><tspan font-size="9pt" x="47.173828" y="31" textLength="15.002">fers</tspan></text></g><g id="id133_Graphic"><path d="M 69.75 116.23184 L 105.5 116.23184 C 108.26142 116.23184 110.5 118.47042 110.5 121.23184 L 110.49999 239.96017 C 110.49999 242.7216 108.261414 244.96017 105.49999 244.96017 L! 34 244.96017 C 31.238577 244.96017 29 242.7216 29 239.96017 L! 28.9999 96 121.23184 C 28.999996 118.47042 31.238573 116.23184 33.999996 116.23184 Z" fill="White"/><path d="M 69.75 116.23184 L 105.5 116.23184 C 108.26142 116.23184 110.5 118.47042 110.5 121.23184 L 110.49999 239.96017 C 110.49999 242.7216 108.261414 244.96017 105.49999 244.96017 L 34 244.96017 C 31.238577 244.96017 29 242.7216 29 239.96017 L 28.999996 121.23184 C 28.999996 118.47042 31.238573 116.23184 33.999996 116.23184 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".5"/><text transform="translate(34 123.09601)" fill="Black"><tspan font-size="10pt" font-weight="bold" fill="Black" x="5.1884766" y="10" textLength="63.901">Management </tspan><tspan font-size="10pt" font-weight="bold" fill="Black" x="10.1762695" y="22" textLength="53.925">Services & </tspan><tspan font-size="10pt" font-weight="bold" fill="Black" x="17.690918" y="34" textLength="36.118">Utilities</tspan><tspan font-size="8pt" fill="Black" x="18.628906" y="54" textLength="36.464">B! ackup & </tspan><tspan font-size="8pt" fill="Black" x="1.6621094" y="64" textLength="33.789001">Recovery</tspan><tspan font-size="8pt" fill="Black" x="34.861328" y="64" textLength="33.342999">, Security</tspan><tspan font-size="8pt" fill="Black" x="67.615234" y="64" textLength="4.4450002">, </tspan><tspan font-size="8pt" fill="Black" x=".17578125" y="74" textLength="69.363">Replication, Cluster</tspan><tspan font-size="8pt" fill="Black" x="69.101562" y="74" textLength="4.4450002">, </tspan><tspan font-size="8pt" fill="Black" x="9.294922" y="84" textLength="55.132">Administration, </tspan><tspan font-size="8pt" fill="Black" x="10.845703" y="94" textLength="18.674999">Confi</tspan><tspan font-size="8pt" fill="Black" x="29.521484" y="94" textLength="33.355">guration, </tspan><tspan font-size="8pt" fill="Black" x="15.519531" y="104" textLength="42.682999">Migration & </tspan><tspan font-size="8pt" fill="Black" x="19.072266" y="114" textLength="33.355">Metadata</tspan></! text></g><g id="id134_Graphic"><path d="M 331.625 115.76816 L ! 544.75 1 15.76816 C 547.5114 115.76816 549.75 118.00674 549.75 120.76816 L 549.75 144 C 549.75 146.76143 547.5114 149 544.75 149 L 118.5 148.99997 C 115.73858 148.99997 113.5 146.7614 113.5 143.99997 L 113.5 120.76816 C 113.5 118.00674 115.73858 115.76816 118.5 115.76816 Z" fill="White"/><path d="M 331.625 115.76816 L 544.75 115.76816 C 547.5114 115.76816 549.75 118.00674 549.75 120.76816 L 549.75 144 C 549.75 146.76143 547.5114 149 544.75 149 L 118.5 148.99997 C 115.73858 148.99997 113.5 146.7614 113.5 143.99997 L 113.5 120.76816 C 113.5 118.00674 115.73858 115.76816 118.5 115.76816 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".5"/><text transform="translate(118.5 120.88408)" fill="Black"><tspan font-size="10pt" font-weight="bold" fill="Black" x="173.40576" y="10" textLength="79.438004">Connection Pool</tspan><tspan font-size="10pt" fill="Black" x="48.781738" y="22" textLength="68.934998">Authentication, </tspan><tspan font-size="10pt" fill="Black" ! x="117.541504" y="22" textLength="221.201">Thread Reuse, Connection Limits, Check Memory</tspan><tspan font-size="10pt" fill="Black" x="338.00537" y="22" textLength="39.462002">, Caches</tspan></text></g><rect x="262.78915" y="209.99236" width="34.588257" height="33.935638" id="path_2"/><clipPath id="clip_path_2"><use xl:href="#path_2"/></clipPath><g clip-path="url(#clip_path_2)"><image xl:href="image6.tiff" width="53" height="52" transform="translate(262.28915 209.49236) scale(.6526082)"/></g><rect x="149.85046" y="208.96017" width="34.588226" height="36" id="path_3"/><clipPath id="clip_path_3"><use xl:href="#path_3"/></clipPath><g clip-path="url(#clip_path_3)"><image xl:href="image7.tiff" width="49" height="51" transform="translate(149.35046 208.46017) scale(.70588235)"/></g><rect x="515" y="118.38408" width="28" height="28" id="path_4"/><clipPath id="clip_path_4"><use xl:href="#path_4"/></clipPath><g clip-path="url(#clip_path_4)"><image xl:href="image10.tiff" width="47" ! height="47" transform="translate(514.5 117.88408) scale(.59574! 467)"/>< /g><g id="id2_Graphic"><path d="M 241.375 77.115967 L 241.375 91.115967 L 245.5 91.115967 L 237.25 98.115967 L 229 91.115967 L 233.125 91.115967 L 233.125 77.115967 L 229 77.115967 L 237.25 70.115967 L 245.5 77.115967 Z" fill="url(#Obj_Gradient)"/><path d="M 241.375 77.115967 L 241.375 91.115967 L 245.5 91.115967 L 237.25 98.115967 L 229 91.115967 L 233.125 91.115967 L 233.125 77.115967 L 229 77.115967 L 237.25 70.115967 L 245.5 77.115967 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".25"/></g><g id="id141_Graphic"><path d="M 288.5625 77.115967 L 288.5625 91.115967 L 292.6875 91.115967 L 284.4375 98.115967 L 276.1875 91.115967 L 280.3125 91.115967 L 280.3125 77.115967 L 276.1875 77.115967 L 284.4375 70.115967 L 292.6875 77.115967 Z" fill="url(#Obj_Gradient_2)"/><path d="M 288.5625 77.115967 L 288.5625 91.115967 L 292.6875 91.115967 L 284.4375 98.115967 L 276.1875 91.115967 L 280.3125 91.115967 L 280.3125 77.115967 L 276.1875 77.115967 L 284.4! 375 70.115967 L 292.6875 77.115967 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".25"/></g><g id="id142_Graphic"><path d="M 335.75 77.115967 L 335.75 91.115967 L 339.875 91.115967 L 331.625 98.115967 L 323.375 91.115967 L 327.5 91.115967 L 327.5 77.115967 L 323.375 77.115967 L 331.625 70.115967 L 339.875 77.115967 Z" fill="url(#Obj_Gradient_3)"/><path d="M 335.75 77.115967 L 335.75 91.115967 L 339.875 91.115967 L 331.625 98.115967 L 323.375 91.115967 L 327.5 91.115967 L 327.5 77.115967 L 323.375 77.115967 L 331.625 70.115967 L 339.875 77.115967 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".25"/></g><rect x="478.83862" y="211.10724" width="34.588257" height="31.705872" id="path_5"/><clipPath id="clip_path_5"><use xl:href="#path_5"/></clipPath><g clip-path="url(#clip_path_5)"><image xl:href="image11.tiff" width="48" height="44" transform="translate(478.33862 210.60724) scale(.7205882)"/></g><rect x="368.85818"! y="211.43076" width="34.588257" height="31.058838" id="path_6! "/><clip Path id="clip_path_6"><use xl:href="#path_6"/></clipPath><g clip-path="url(#clip_path_6)"><image xl:href="image12.tiff" width="49" height="44" transform="translate(368.35818 210.93076) scale(.7058823)"/></g><path d="M 67.705887 278 L 80 278 C 82.76142 278 85 280.23859 85 283 L 85 306.88232 C 85 309.64374 82.76142 311.88232 80 311.88232 L 55.41177 311.88232 C 52.650345 311.88232 50.41177 309.64374 50.41177 306.88232 L 50.41177 283 C 50.41177 280.23859 52.650345 278 55.41177 278 Z" id="path_7"/><clipPath id="clip_path_7"><use xl:href="#path_7"/></clipPath><g clip-path="url(#clip_path_7)"><image xl:href="image13.tiff" width="49" height="48" transform="translate(49.91177 277.5) scale(.7058823)"/></g><path d="M 67.705887 278 L 80 278 C 82.76142 278 85 280.23859 85 283 L 85 306.88232 C 85 309.64374 82.76142 311.88232 80 311.88232 L 55.41177 311.88232 C 52.650345 311.88232 50.41177 309.64374 50.41177 306.88232 L 50.41177 283 C 50.41177 280.23859 52.650345 278 55.41177 278 Z" stroke! ="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".5"/><text transform="translate(50.411774 312.74118)" fill="Black"><tspan font-size="9pt" font-weight="bold" fill="Black" x=".4987793" y="8" textLength="35.001999">MyISAM</tspan></text><g id="id7_Graphic"><path d="M 526.5 294.5011 L 532.0011 294.5011 L 532.0011 289 L 537.4989 289 L 537.4989 294.5011 L 543 294.5011 L 543 299.9989 L 537.4989 299.9989 L 537.4989 305.5 L 532.0011 305.5 L 532.0011 299.9989 L 526.5 299.9989 Z" fill="url(#Obj_Gradient_4)"/></g><path d="M 116.04904 278 L 128.34314 278 C 131.10457 278 133.34314 280.23859 133.34314 283 L 133.34314 306.88239 C 133.34314 309.6438 131.10457 311.88239 128.34314 311.88239 L 103.754944 311.88239 C 100.99352 311.88239 98.754944 309.6438 98.754944 306.88239 L 98.754944 283 C 98.754944 280.23859 100.99352 278 103.754944 278 Z" id="path_8"/><clipPath id="clip_path_8"><use xl:href="#path_8"/></clipPath><g clip-path="url(#clip_path_8)"><image xl:href="image13.! tiff" width="49" height="48" transform="matrix(.7058816 0 0 .7! 0588332 98.254944 277.5)"/></g><path d="M 116.04904 278 L 128.34314 278 C 131.10457 278 133.34314 280.23859 133.34314 283 L 133.34314 306.88239 C 133.34314 309.6438 131.10457 311.88239 128.34314 311.88239 L 103.754944 311.88239 C 100.99352 311.88239 98.754944 309.6438 98.754944 306.88239 L 98.754944 283 C 98.754944 280.23859 100.99352 278 103.754944 278 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".5"/><text transform="translate(100.754944 312.74121)" fill="Black"><tspan font-size="9pt" font-weight="bold" x=".00390625" y="8" textLength="31.992">InnoDB</tspan></text><path d="M 164.39217 278 L 176.68626 278 C 179.44769 278 181.68626 280.23859 181.68626 283 L 181.68626 306.88239 C 181.68626 309.6438 179.44769 311.88239 176.68626 311.88239 L 152.09807 311.88239 C 149.33664 311.88239 147.09807 309.6438 147.09807 306.88239 L 147.09807 283 C 147.09807 280.23859 149.33664 278 152.09807 278 Z" id="path_9"/><clipPath id="clip_path_9"><use xl:href="#path_9"/><! /clipPath><g clip-path="url(#clip_path_9)"><image xl:href="image13.tiff" width="49" height="48" transform="matrix(.7058816 0 0 .70588332 146.59807 277.5)"/></g><path d="M 164.39217 278 L 176.68626 278 C 179.44769 278 181.68626 280.23859 181.68626 283 L 181.68626 306.88239 C 181.68626 309.6438 179.44769 311.88239 176.68626 311.88239 L 152.09807 311.88239 C 149.33664 311.88239 147.09807 309.6438 147.09807 306.88239 L 147.09807 283 C 147.09807 280.23859 149.33664 278 152.09807 278 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".5"/><text transform="translate(148.09807 312.74121)" fill="Black"><tspan font-size="9pt" font-weight="bold" x=".49194336" y="8" textLength="33.015999">Archive</tspan></text><path d="M 212.73529 278 L 225.02939 278 C 227.79082 278 230.02939 280.23859 230.02939 283 L 230.02939 306.88239 C 230.02939 309.6438 227.79082 311.88239 225.02939 311.88239 L 200.44119 311.88239 C 197.67976 311.88239 195.44119 309.6438 195.44119 306.8! 8239 L 195.44119 283 C 195.44119 280.23859 197.67976 278 200.4! 4119 278 Z" id="path_10"/><clipPath id="clip_path_10"><use xl:href="#path_10"/></clipPath><g clip-path="url(#clip_path_10)"><image xl:href="image13.tiff" width="49" height="48" transform="matrix(.7058816 0 0 .70588332 194.94119 277.5)"/></g><path d="M 212.73529 278 L 225.02939 278 C 227.79082 278 230.02939 280.23859 230.02939 283 L 230.02939 306.88239 C 230.02939 309.6438 227.79082 311.88239 225.02939 311.88239 L 200.44119 311.88239 C 197.67976 311.88239 195.44119 309.6438 195.44119 306.88239 L 195.44119 283 C 195.44119 280.23859 197.67976 278 200.44119 278 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".5"/><text transform="translate(191.44119 312.74121)" fill="Black"><tspan font-size="9pt" font-weight="bold" x=".49316406" y="8" textLength="43.013">Federated</tspan></text><path d="M 261.07843 278 L 273.37253 278 C 276.13394 278 278.37253 280.23859 278.37253 283 L 278.37253 306.88239 C 278.37253 309.6438 276.13394 311.88239 273.37253 311.88239 L 248.7! 8433 311.88239 C 246.0229 311.88239 243.78433 309.6438 243.78433 306.88239 L 243.78433 283 C 243.78433 280.23859 246.0229 278 248.78433 278 Z" id="path_11"/><clipPath id="clip_path_11"><use xl:href="#path_11"/></clipPath><g clip-path="url(#clip_path_11)"><image xl:href="image13.tiff" width="49" height="48" transform="matrix(.7058816 0 0 .70588332 243.28433 277.5)"/></g><path d="M 261.07843 278 L 273.37253 278 C 276.13394 278 278.37253 280.23859 278.37253 283 L 278.37253 306.88239 C 278.37253 309.6438 276.13394 311.88239 273.37253 311.88239 L 248.78433 311.88239 C 246.0229 311.88239 243.78433 309.6438 243.78433 306.88239 L 243.78433 283 C 243.78433 280.23859 246.0229 278 248.78433 278 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".5"/><text transform="translate(243.78432 312.74121)" fill="Black"><tspan font-size="9pt" font-weight="bold" x=".24487305" y="8" textLength="34.509998">Memory</tspan></text><path d="M 309.42157 277.99997 L 321.71567 ! 277.99997 C 324.47708 277.99997 326.71567 280.23856 326.71567 ! 282.9999 7 L 326.71567 306.88235 C 326.71567 309.64377 324.47708 311.88235 321.71567 311.88235 L 297.12747 311.88235 C 294.36606 311.88235 292.12747 309.64377 292.12747 306.88235 L 292.12747 282.99997 C 292.12747 280.23856 294.36606 277.99997 297.12747 277.99997 Z" id="path_12"/><clipPath id="clip_path_12"><use xl:href="#path_12"/></clipPath><g clip-path="url(#clip_path_12)"><image xl:href="image13.tiff" width="49" height="48" transform="matrix(.7058816 0 0 .70588332 291.62747 277.49997)"/></g><path d="M 309.42157 277.99997 L 321.71567 277.99997 C 324.47708 277.99997 326.71567 280.23856 326.71567 282.99997 L 326.71567 306.88235 C 326.71567 309.64377 324.47708 311.88235 321.71567 311.88235 L 297.12747 311.88235 C 294.36606 311.88235 292.12747 309.64377 292.12747 306.88235 L 292.12747 282.99997 C 292.12747 280.23856 294.36606 277.99997 297.12747 277.99997 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".5"/><text transform="translate(296.12747 312.74121)"! fill="Black"><tspan font-size="9pt" font-weight="bold" x=".24609375" y="8" textLength="26.507">Merge</tspan></text><path d="M 357.7647 277.99994 L 370.0588 277.99994 C 372.82022 277.99994 375.0588 280.23853 375.0588 282.99994 L 375.0588 306.88232 C 375.0588 309.64374 372.82022 311.88232 370.0588 311.88232 L 345.47061 311.88232 C 342.7092 311.88232 340.47061 309.64374 340.47061 306.88232 L 340.47061 282.99994 C 340.47061 280.23853 342.7092 277.99994 345.47061 277.99994 Z" id="path_13"/><clipPath id="clip_path_13"><use xl:href="#path_13"/></clipPath><g clip-path="url(#clip_path_13)"><image xl:href="image13.tiff" width="49" height="48" transform="matrix(.7058816 0 0 .70588332 339.97061 277.49994)"/></g><path d="M 357.7647 277.99994 L 370.0588 277.99994 C 372.82022 277.99994 375.0588 280.23853 375.0588 282.99994 L 375.0588 306.88232 C 375.0588 309.64374 372.82022 311.88232 370.0588 311.88232 L 345.47061 311.88232 C 342.7092 311.88232 340.47061 309.64374 340.47061 306.88232 L 3! 40.47061 282.99994 C 340.47061 280.23853 342.7092 277.99994 34! 5.47061 277.99994 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".5"/><text transform="translate(345.47061 312.74115)" fill="Black"><tspan font-size="9pt" font-weight="bold" x="2.5448322" y="8" textLength="19.497999">NDB</tspan></text><path d="M 406.10785 277.99994 L 418.40195 277.99994 C 421.16336 277.99994 423.40195 280.23853 423.40195 282.99994 L 423.40195 306.88232 C 423.40195 309.64374 421.16336 311.88232 418.40195 311.88232 L 393.81375 311.88232 C 391.05234 311.88232 388.81375 309.64374 388.81375 306.88232 L 388.81375 282.99994 C 388.81375 280.23853 391.05234 277.99994 393.81375 277.99994 Z" id="path_14"/><clipPath id="clip_path_14"><use xl:href="#path_14"/></clipPath><g clip-path="url(#clip_path_14)"><image xl:href="image13.tiff" width="49" height="48" transform="matrix(.7058816 0 0 .70588332 388.31375 277.49994)"/></g><path d="M 406.10785 277.99994 L 418.40195 277.99994 C 421.16336 277.99994 423.40195 280.23853 423.40195 282.99994 L 423.40195 ! 306.88232 C 423.40195 309.64374 421.16336 311.88232 418.40195 311.88232 L 393.81375 311.88232 C 391.05234 311.88232 388.81375 309.64374 388.81375 306.88232 L 388.81375 282.99994 C 388.81375 280.23853 391.05234 277.99994 393.81375 277.99994 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".5"/><text transform="translate(390.81375 312.74115)" fill="Black"><tspan font-size="9pt" font-weight="bold" x=".2434082" y="8" textLength="31.513">Partner</tspan></text><path d="M 454.451 277.99994 L 466.7451 277.99994 C 469.5065 277.99994 471.7451 280.23853 471.7451 282.99994 L 471.7451 306.88232 C 471.7451 309.64374 469.5065 311.88232 466.7451 311.88232 L 442.1569 311.88232 C 439.39548 311.88232 437.1569 309.64374 437.1569 306.88232 L 437.1569 282.99994 C 437.1569 280.23853 439.39548 277.99994 442.1569 277.99994 Z" id="path_15"/><clipPath id="clip_path_15"><use xl:href="#path_15"/></clipPath><g clip-path="url(#clip_path_15)"><image xl:href="image13.tiff" wid! th="49" height="48" transform="matrix(.7058816 0 0 .70588332 4! 36.6569 277.49994)"/></g><path d="M 454.451 277.99994 L 466.7451 277.99994 C 469.5065 277.99994 471.7451 280.23853 471.7451 282.99994 L 471.7451 306.88232 C 471.7451 309.64374 469.5065 311.88232 466.7451 311.88232 L 442.1569 311.88232 C 439.39548 311.88232 437.1569 309.64374 437.1569 306.88232 L 437.1569 282.99994 C 437.1569 280.23853 439.39548 277.99994 442.1569 277.99994 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".5"/><text transform="translate(430.1569 312.74115)" fill="Black"><tspan font-size="9pt" font-weight="bold" x=".25" y="8" textLength="49.5">Community</tspan></text><path d="M 502.7941 278 L 515.0882 278 C 517.8496 278 520.0882 280.23859 520.0882 283 L 520.0882 306.88239 C 520.0882 309.6438 517.8496 311.88239 515.0882 311.88239 L 490.5 311.88239 C 487.7386 311.88239 485.5 309.6438 485.5 306.88239 L 485.5 283 C 485.5 280.23859 487.7386 278 490.5 278 Z" id="path_16"/><clipPath id="clip_path_16"><use xl:href="#path_16"/></clipPath><g clip-p! ath="url(#clip_path_16)"><image xl:href="image13.tiff" width="49" height="48" transform="matrix(.7058816 0 0 .70588332 485 277.5)"/></g><path d="M 502.7941 278 L 515.0882 278 C 517.8496 278 520.0882 280.23859 520.0882 283 L 520.0882 306.88239 C 520.0882 309.6438 517.8496 311.88239 515.0882 311.88239 L 490.5 311.88239 C 487.7386 311.88239 485.5 309.6438 485.5 306.88239 L 485.5 283 C 485.5 280.23859 487.7386 278 490.5 278 Z" stroke="Black" stroke-linecap="round" stroke-linejoin="round" stroke-width=".5"/><text transform="translate(486.5 312.74121)" fill="Black"><tspan font-size="9pt" font-weight="bold" x=".25024414" y="8" textLength="33.499">Custom</tspan></text><rect x="67" y="336.85016" width="37.30252" height="32.63971" id="path_17"/><clipPath id="clip_path_17"><use xl:href="#path_17"/></clipPath><g clip-path="url(#clip_path_17)"><image xl:href="image14.tiff" width="48" height="42" transform="translate(66.5 336.35016) scale(.77713604)"/></g><rect x="476.08807" y="330.70563! " width="44.000122" height="45.714417" id="path_18"/><clipPath! id="cli p_path_18"><use xl:href="#path_18"/></clipPath><g clip-path="url(#clip_path_18)"><image xl:href="image16.tiff" width="77" height="80" transform="translate(475.58807 330.20563) scale(.57142997)"/></g></g></g></svg> Added: trunk/refman-5.1/images/PSEArch.svg/image1.pdf =================================================================== --- trunk/refman-5.1/images/PSEArch.svg/image1.pdf (rev 0) +++ trunk/refman-5.1/images/PSEArch.svg/image1.pdf 2006-09-07 14:57:12 UTC (rev 3282) Changed blocks: 1, Lines Added: 211, Lines Deleted: 0; 55195 bytes @@ -0,0 +1,211 @@ +%PDF-1.4 %+1 0 obj << /Type /Catalog /Pages 2 0 R /Metadata 73 0 R >> endobj 2 0 obj << /Type /Pages /Kids [ 5 0 R ] /Count 1 >> endobj 3 0 obj << /ModDate (D:20040109123528-08'00') /CreationDate (D:20020318163449-08'00') /Producer (Adobe PDF library 5.00) /Creator (Adobe Illustrator 10) >> endobj 5 0 obj << /Type /Page /MediaBox [ 169 233 444 558 ] /Parent 2 0 R /PieceInfo << /Illustrator 36 1 R >> /LastModified (D:20040109123528-08'00') /ArtBox [ 173.99707 236.75 439.49707 552.99609 ] /TrimBox [ 169 233 444 558 ] /Group 70 0 R /Contents 71 0 R /Resources << /ColorSpace << /CS0 44 0 R /CS1 47 0 R >> /XObject << /Im0 46 0 R /Im1 49 0 R /Im2 51 0 R /Im3 53 0 R /Im4 55 0 R /Im5 57 0 R /Im6 59 0 R /Im7 61 0 R /Im8 63 0 R /Im9 65 0 R /Im10 67 0 R /Im11 69 0 R >> /ProcSet [ /PDF /ImageB /ImageC ] >> >> endobj 6 1 obj << /Length 1105 >> stream +%!PS-Adobe-3.0 %%Creator: Adobe Illustrator(R) 10.0 %%AI8_CreatorVersion: 10.0 %%For: (Kevin Steele) () %%Title: (image24.pdf) %%CreationDate: 1/9/04 12:35 PM %%BoundingBox: 173 236 440 553 %%HiResBoundingBox: 173.9971 236.75 439.4971 552.9961 %%DocumentProcessColors: Black %AI5_FileFormat 6.0 %AI3_ColorUsage: Color %AI7_ImageSettings: 0 %%CMYKProcessColor: 1 1 1 1 ([Registration]) %%AI6_ColorSeparationSet: 1 1 (AI6 Default Color Separation Set) %%+ Options: 1 16 0 1 0 1 0 0 0 0 1 1 1 18 0 0 0 0 0 0 0 0 -1 -1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 1 2 3 4 %%+ PPD: 1 21 0 0 60 45 2 2 1 0 0 1 0 0 0 0 0 0 0 0 0 0 () %AI3_TemplateBox: 306.5 395.5 306.5 395.5 %AI3_TileBox: 187 -216 763 516 %AI3_DocumentPreview: None %AI5_ArtSize: 275 325 %AI5_RulerUnits: 2 %AI9_ColorModel: 2 %AI5_ArtFlags: 0 0 0 1 0 0 1 0 0 %AI5_TargetResolution: 100 %AI5_NumLayers: 1 %AI9_OpenToView: -466 877 1 1550 976 26 0 1 6 42 0 0 1 1 1 0 %AI5_OpenViewLayers: 7 %%PageOrigin:187 -216 %%AI3_PaperRect:-18 774 594 -! 18 %%AI3_Margin:18 -40 -18 18 %AI7_GridSettings: 72 8 72 8 1 0 0.8 0.8 0.8 0.9 0.9 0.9 %AI9_Flatten: 0 %%EndComments endstream endobj 36 1 obj << /Private 37 1 R /LastModified (D:20040109123528-08'00') >> endobj 37 1 obj << /CreatorVersion 10 /ContainerVersion 9 /AIMetaData 6 1 R >> endobj 44 0 obj /DeviceGray endobj 45 0 obj 278 endobj 46 0 obj << /Type /XObject /Subtype /Image /Name /X /Width 14 /Height 19 /BitsPerComponent 8 /Intent /Perceptual /ColorSpace /DeviceGray /Filter /FlateDecode /DecodeParms << /Predictor 15 /Columns 14 /Colors 1 /BitsPerComponent 8 >> /Length 45 0 R >> stream +H++H++B++#Դ++Bz++]+M-+mt~E++(+++k+F+S+- +y++(yz!++|+ڥ+ ( ++++++++HћO+++4R+r++P!++&6!+ E+- +:I++++1X+JH+ +1@i+++8ol+i'5+++M++u++o ej++(jFd+ w+%++~+++Aq++H++ ++ Z+ +4"++\#8+++H+v?++(@+H++0b+;+++H++8+H+H+H+!9)3M&ߍ"*++|+H+H+@,+H++++++m+++++$+BIO+ؗ7+=++Z+k ++++ÓG+3N++-p+++_+++G++!++sW+ƍ+++++++ƕy++++N++Ѳ+kf+++++o++h̴/֣+쟯|ܞ+++Df +H++++++++++++++++<?xpacket begin='' id='W5M0MpCehiHzreSzNTczkc9d' bytes='932'?> + +<rdf:RDF xmlns:rdf='http://www.w3.org/1999/02/22-rdf-syntax-ns#' + xmlns:iX='http://ns.adobe.com/iX/1.0/'> + + <rdf:Description about='' + xmlns='http://ns.adobe.com/pdf/1.3/' + xmlns:pdf='http://ns.adobe.com/pdf/1.3/'> + <pdf:CreationDate>2002-03-18T16:34:49-08:00</pdf:CreationDate> + <pdf:ModDate>2004-01-09T12:35:28-08:00</pdf:ModDate> + <pdf:Creator>Adobe Illustrator 10</pdf:Creator> + <pdf:Producer>Adobe PDF library 5.00</pdf:Producer> + </rdf:Description> + + <rdf:Description about='' + xmlns='http://ns.adobe.com/xap/1.0/' + xmlns:xap='http://ns.adobe.com/xap/1.0/'> + <xap:CreateDate>2002-03-18T16:34:49-08:00</xap:CreateDate> + <xap:ModifyDate>2004-01-09T12:35:28-08:00</xap:ModifyDate> + <xap:CreatorTool>Adobe Illustrator 10</xap:CreatorTool> + <xap:MetadataDate>2004-01-09T12:35:28-08:00</xap:MetadataDate> + </rdf:Description> + +</rdf:RDF> +<?xpacket end='r'?> endstream endobj xref 0 74 0000000004 65535 f 0000000016 00000 n 0000000087 00000 n 0000000151 00000 n 0000000007 00002 f 0000000316 00000 n 0000000846 00001 n 0000000008 00001 f 0000000009 00001 f 0000000010 00001 f 0000000011 00001 f 0000000012 00001 f 0000000013 00001 f 0000000014 00001 f 0000000015 00001 f 0000000016 00001 f 0000000017 00001 f 0000000018 00001 f 0000000019 00001 f 0000000020 00001 f 0000000021 00001 f 0000000022 00001 f 0000000023 00001 f 0000000024 00001 f 0000000025 00001 f 0000000026 00001 f 0000000027 00001 f 0000000028 00001 f 0000000029 00001 f 0000000030 00001 f 0000000031 00001 f 0000000032 00001 f 0000000033 00001 f 0000000034 00001 f 0000000035 00001 f 0000000038 00001 f 0000002004 00001 n 0000002085 00001 n 0000000039 00001 f 0000000040 00001 f 0000000041 00001 f 0000000042 00001 f 0000000043 00001 f 0000000000 00001 f 0000002169 00000 n 0000002198 00000 n 0000002219 00000 n ! 0000002778 00000 n 0000002807 00000 n 0000002830 00000 n 0000018576 00000 n 0000018598 00000 n 0000023842 00000 n 0000023863 00000 n 0000024474 00000 n 0000024495 00000 n 0000025625 00000 n 0000025647 00000 n 0000027409 00000 n 0000027429 00000 n 0000027780 00000 n 0000027800 00000 n 0000028102 00000 n 0000028124 00000 n 0000029452 00000 n 0000029472 00000 n 0000029816 00000 n 0000029836 00000 n 0000030185 00000 n 0000030208 00000 n 0000045696 00000 n 0000045789 00000 n 0000052208 00000 n 0000052230 00000 n trailer << /Size 74 /Info 3 0 R /Root 1 0 R /ID[<f07ff1737e3b25a1ae111b82e05c86c9><9c4e74921967400740515deb2ab426ee>] >> startxref 53246 %%EOF \ No newline at end of file Added: trunk/refman-5.1/images/PSEArch.svg/image10.tiff =================================================================== Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 327 bytes Added: trunk/refman-5.1/images/PSEArch.svg/image11.tiff =================================================================== Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 327 bytes Added: trunk/refman-5.1/images/PSEArch.svg/image12.tiff =================================================================== Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 327 bytes Added: trunk/refman-5.1/images/PSEArch.svg/image13.tiff =================================================================== Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 327 bytes Added: trunk/refman-5.1/images/PSEArch.svg/image14.tiff =================================================================== Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 327 bytes Added: trunk/refman-5.1/images/PSEArch.svg/image16.tiff =================================================================== Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 327 bytes Added: trunk/refman-5.1/images/PSEArch.svg/image6.tiff =================================================================== Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 325 bytes Added: trunk/refman-5.1/images/PSEArch.svg/image7.tiff =================================================================== Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 325 bytes Modified: trunk/refman-5.1/storage-engines.xml =================================================================== --- trunk/refman-5.1/storage-engines.xml 2006-09-07 12:12:19 UTC (rev 3281) +++ trunk/refman-5.1/storage-engines.xml 2006-09-07 14:57:12 UTC (rev 3282) Changed blocks: 1, Lines Added: 756, Lines Deleted: 232; 38538 bytes @@ -81,301 +81,825 @@ non-transaction-safe tables: </para> - <itemizedlist> + <para> + With MySQL 5.1, MySQL AB has introduced a new pluggable storage + engine architecture that allows storage engines to be loaded into + and unloaded from a running MySQL server. + </para> - <listitem> - <para> - <literal>MyISAM</literal> manages non-transactional tables. It - provides high-speed storage and retrieval, as well as fulltext - searching capabilities. <literal>MyISAM</literal> is supported - in all MySQL configurations, and is the default storage engine - unless you have configured MySQL to use a different one by - default. - </para> - </listitem> + <para> + This chapter describes the pluggable storage engine architecture and + described the array of storage engines that are available. + </para> - <listitem> - <para> - The <literal>MEMORY</literal> storage engine provides in-memory - tables. The <literal>MERGE</literal> storage engine allows a - collection of identical <literal>MyISAM</literal> tables to be - handled as a single table. Like <literal>MyISAM</literal>, the - <literal>MEMORY</literal> and <literal>MERGE</literal> storage - engines handle non-transactional tables, and both are also - included in MySQL by default. - </para> + <section id="pluggable-storage-overview"> - <para> - <emphasis role="bold">Note</emphasis>: The - <literal>MEMORY</literal> storage engine formerly was known as - the <literal>HEAP</literal> engine. - </para> - </listitem> + <title>Overview of MySQL Storage Engine Architecture</title> - <listitem> - <para> - The <literal>InnoDB</literal> storage engine provides - transaction-safe tables. <literal>InnoDB</literal> is included - by default in all MySQL ¤t-series; binary distributions. - In source distributions, you can enable or disable either engine - by configuring MySQL as you like. - </para> - </listitem> + <para> + The MySQL pluggable storage engine architecture allows a database + professional to select a specialized storage engine for a + particular application need while being completely shielded from + the need to manage any specific application coding requirements. + The MySQL server architecture isolates the application programmer + and DBA from all of the low-level implementation details at the + storage level, providing a consistent and easy application model + and API. Thus, although there are different capabilities across + different storage engines, the application is shielded from these + differences. + </para> - <listitem> - <para> - The <literal>EXAMPLE</literal> storage engine is a - <quote>stub</quote> engine that does nothing. You can create - tables with this engine, but no data can be stored in them or - retrieved from them. The purpose of this engine is to serve as - an example in the MySQL source code that illustrates how to - begin writing new storage engines. As such, it is primarily of - interest to developers. - </para> - </listitem> + <para> + The MySQL pluggable storage engine architecture has the structure + shown in the following figure: + </para> - <listitem> - <para> - <literal>NDB Cluster</literal> is the storage engine used by - MySQL Cluster to implement tables that are partitioned over many - computers. It is available in MySQL-Max ¤t-series; binary - distributions. This storage engine is currently supported on a - number of Unix platforms. We intend to add support for this - engine on other platforms, including Windows, in future MySQL - releases. - </para> + <figure> + <title>The MySQL pluggable storage engine architecture</title> + <mediaobject> + <imageobject> + <imagedata fileref="images/PSEArch.png" format="PNG" lang="en"/> + </imageobject> + <textobject> + <phrase lang="en">The MySQL pluggable storage engine + architecture</phrase> + </textobject> + </mediaobject> + </figure> - <para> - MySQL Cluster is covered in a separate chapter of this Manual. - See <xref linkend="mysql-cluster"/>, for more information. - </para> - </listitem> + <para> + The pluggable storage engine architecture provides a standard set + of management and support services that are common among all + underlying storage engines. The storage engines themselves are the + components of the database server that actually perform actions on + the underlying data that is maintained at the physical server + level. + </para> - <listitem> + <para> + This efficient and modular architecture provides huge benefits for + those wishing to specifically target a particular application need + — such as data warehousing, transaction processing, or high + availability situations — while enjoying the advantage of + utilizing a set of interfaces and services that are independent of + any one storage engine. + </para> + + <para> + The application programmer and DBA interact with the MySQL + database through Connector APIs and service layers that are above + the storage engines. If application changes bring about + requirements that demand the underlying storage engine change, or + that one or more additional storage engines be added to support + new needs, no significant coding or process changes are required + to make things work. The MySQL server architecture shields the + application from the underlying complexity of the storage engine + by presenting a consistent and easy-to-use API that applies across + storage engines. + </para> + + <section id="pluggable-storage-common-layer"> + + <title>The Common Database Server Layer</title> + <para> - The <literal>ARCHIVE</literal> storage engine is used for - storing large amounts of data without indexes with a very small - footprint. + A MySQL pluggable storage engine is the component in the MySQL + database server that is responsible for performing the actual + data I/O operations for a database as well as enabling and + enforcing certain feature sets that target a specific + application need. A major benefit of using specific storage + engines is that you are only delivered the features needed for a + particular application, and therefore you have less system + overhead in the database, with the end result being more + efficient and higher database performance. This is one of the + reasons that MySQL has always been known to have such high + performance, matching or beating proprietary monolithic + databases in industry standard benchmarks. </para> - </listitem> - <listitem> <para> - The <literal>CSV</literal> storage engine stores data in text - files using comma-separated values format. + From a technical perspective, what are some of the unique + supporting infrastructure components that are in a storage + engine? Some of the key feature differentiations include: </para> - </listitem> - <listitem> + <itemizedlist> + + <listitem> + <para> + <emphasis>Concurrency</emphasis> — some applications + have more granular lock requirements (such as row-level + locks) than others. Choosing the right locking strategy can + reduce overhead and therefore improve overall performance. + This area also includes support for capabilities such as + multi-version concurrency control or <quote>snapshot</quote> + read. + </para> + </listitem> + + <listitem> + <para> + <emphasis>Transaction Support</emphasis> — Not every + application needs transactions, but for those that do, there + are very well defined requirements such as ACID compliance + and more. + </para> + </listitem> + + <listitem> + <para> + <emphasis>Referential Integrity</emphasis> — The need + to have the server enforce relational database referential + integrity through DDL defined foreign keys. + </para> + </listitem> + + <listitem> + <para> + <emphasis>Physical Storage</emphasis> — This involves + everything from the overall page size for tables and indexes + as well as the format used for storing data to physical + disk. + </para> + </listitem> + + <listitem> + <para> + <emphasis>Index Support</emphasis> — Different + application scenarios tend to benefit from different index + strategies. Each storage engine generally has its own + indexing methods, although some (such as B-tree indexes) are + common to nearly all engines. + </para> + </listitem> + + <listitem> + <para> + <emphasis>Memory Caches</emphasis> — Different + applications respond better to some memory caching + strategies than others, so although some memory caches are + common to all storage engines (such as those used for user + connections or MySQL's high-speed Query Cache), others are + uniquely defined only when a particular storage engine is + put in play. + </para> + </listitem> + + <listitem> + <para> + <emphasis>Performance Aids</emphasis> — This includes + multiple I/O threads for parallel operations, thread + concurrency, database checkpointing, bulk insert handling, + and more. + </para> + </listitem> + + <listitem> + <para> + <emphasis>Miscellaneous Target Features</emphasis> — + This may include support for geospatial operations, security + restrictions for certain data manipulation operations, and + other similar features. + </para> + </listitem> + + </itemizedlist> + <para> - The <literal>BLACKHOLE</literal> storage engine accepts but does - not store data and retrievals always return an empty set. + Each set of the pluggable storage engine infrastructure + components are designed to offer a selective set of benefits for + a particular application. Conversely, avoiding a set of + component features helps reduce unnecessary overhead. It stands + to reason that understanding a particular application's set of + requirements and selecting the proper MySQL storage engine can + have a dramatic impact on overall system efficiency and + performance. </para> - </listitem> - <listitem> + </section> + + <section id="pluggable-storage"> + + <title>Pluggable Storage Engine Architecture</title> + <para> - The <literal>FEDERATED</literal> storage engine stores data in a - remote database. Currently, it works with MySQL only, using the - MySQL C Client API. In future releases, we intend to enable it - to connect to other data sources using other drivers or client - connection methods. + With MySQL 5.1, MySQL AB has introduced a new pluggable storage + engine architecture that allows storage engines to be loaded + into and unloaded from a running MySQL server. </para> - </listitem> - </itemizedlist> + <section id="pluggable-storage-plugging"> -<!--<para> - For assistance in choosing a storage engine, see - <xref linkend="pluggable-storage-choosing"/>. - </para>--> + <title>Plugging in a Storage Engine</title> - <para> - This chapter describes each of the MySQL storage engines except for - <literal>NDB Cluster</literal>, which is covered in - <xref linkend="mysql-cluster"/>. - </para> + <para> + Before a storage engine can be used, the storage engine plugin + shared library must be loaded into MySQL using the + <literal>INSTALL PLUGIN</literal> statement. For example, if + the <literal>EXAMPLE</literal> engine plugin is named + <literal>ha_example</literal> and the shared library is named + <filename>ha_example.so</filename>, you load it with the + following statement: + </para> - <para> - When you create a new table, you can specify which storage engine to - use by adding an <literal>ENGINE</literal> table option to the - <literal>CREATE TABLE</literal> statement: - </para> - <programlisting> -CREATE TABLE t (i INT) ENGINE = INNODB; +INSTALL PLUGIN ha_example SONAME 'ha_example.so'; </programlisting> - <para> - If you omit the <literal>ENGINE</literal> or <literal>TYPE</literal> - option, the default storage engine is used. Normally, this is - <literal>MyISAM</literal>, but you can change it by using the - <option>--default-storage-engine</option> or - <option>--default-table-type</option> server startup option, or by - setting the <literal>default-storage-engine</literal> or - <literal>default-table-type</literal> option in the - <filename>my.cnf</filename> configuration file. - </para> + <para> + The shared library must be located in the MySQL server plugin + directory, the location of which is given by the + <literal>plugin_dir</literal> system variable. + </para> - <para> - You can set the default storage engine to be used during the current - session by setting the <literal>storage_engine</literal> or - <literal>table_type</literal> variable: - </para> + </section> -<programlisting> -SET storage_engine=MYISAM; -SET table_type=INNODB; -</programlisting> + <section id="pluggable-storage-unplugging"> - <para> - When MySQL is installed on Windows using the MySQL Configuration - Wizard, the <literal>InnoDB</literal> storage engine can be selected - as the default instead of <literal>MyISAM</literal>. See - <xref linkend="mysql-config-wizard-database-usage"/>. - </para> + <title>Unplugging a Storage Engine</title> - <para> - To convert a table from one storage engine to another, use an - <literal>ALTER TABLE</literal> statement that indicates the new - engine: - </para> + <para> + To unplug a storage engine, use the <literal>UNINSTALL + PLUGIN</literal> statement: + </para> <programlisting> -ALTER TABLE t ENGINE = MYISAM; +UNINSTALL PLUGIN ha_example; </programlisting> - <para> - See <xref linkend="create-table"/>, and - <xref linkend="alter-table"/>. - </para> + <para> + If you unplug a storage engine that is needed by existing + tables, those tables become inaccessible, but will still be + present on disk (where applicable). Ensure that there are no + tables using a storage engine before you unplug the storage + engine. + </para> - <remark> - We should consider removing this or making a new section 'What - happens when a table is created'. Currently it seems a bit out of - place and not that helpful. - </remark> + </section> - <para> - If you try to use a storage engine that is not compiled in or that - is compiled in but deactivated, MySQL instead creates a table using - the default storage engine, usually <literal>MyISAM</literal>. This - behavior is convenient when you want to copy tables between MySQL - servers that support different storage engines. (For example, in a - replication setup, perhaps your master server supports transactional - storage engines for increased safety, but the slave servers use only - non-transactional storage engines for greater speed.) - </para> + <section id="pluggable-storage-security"> - <para> - This automatic substitution of the default storage engine for - unavailable engines can be confusing for new MySQL users. A warning - is generated whenever a storage engine is automatically changed. - </para> + <title>Security Implications of Pluggable Storage</title> - <para> - For new tables, MySQL always creates an <filename>.frm</filename> - file to hold the table and column definitions. The table's index and - data may be stored in one or more other files, depending on the - storage engine. The server creates the <filename>.frm</filename> - file above the storage engine level. Individual storage engines - create any additional files required for the tables that they - manage. If a table name contains special characters, the names for - the table files contain encoded versions of those characters as - described in <xref linkend="identifier-mapping"/>. - </para> + <para> + To install a pluggable storage engine, the plugin file must be + located in the MySQL plugin directory, and the user issuing + the <literal>INSTALL PLUGIN</literal> statement must have + <literal>INSERT</literal> privileges for the + <literal>mysql.plugin</literal> table. + </para> - <para> - A database may contain tables of different types. That is, tables - need not all be created with the same storage engine. - </para> + </section> - <para> - Transaction-safe tables (TSTs) have several advantages over - non-transaction-safe tables (NTSTs): - </para> + </section> - <itemizedlist> + </section> - <listitem> - <para> - They are safer. Even if MySQL crashes or you get hardware - problems, you can get your data back, either by automatic - recovery or from a backup plus the transaction log. - </para> - </listitem> + <section id="storage-engine-overview"> - <listitem> - <para> - You can combine many statements and accept them all at the same - time with the <literal>COMMIT</literal> statement (if autocommit - is disabled). - </para> - </listitem> + <title>Supported Storage Engines</title> - <listitem> - <para> - You can execute <literal>ROLLBACK</literal> to ignore your - changes (if autocommit is disabled). - </para> - </listitem> + <para> + MySQL 5.1 supports the following storage engines: + </para> - <listitem> - <para> - If an update fails, all of your changes are reverted. (With - non-transaction-safe tables, all changes that have taken place - are permanent.) - </para> - </listitem> + <itemizedlist> - <listitem> + <listitem> + <para> + <link linkend="myisam-storage-engine"><literal>MyISAM</literal></link> + — The default MySQL storage engine and the one that is + used the most in Web, data warehousing, and other application + environments. <literal>MyISAM</literal> is supported in all + MySQL configurations, and is the default storage engine unless + you have configured MySQL to use a different one by default. + </para> + </listitem> + + <listitem> + <para> + <link linkend="innodb"><literal>InnoDB</literal></link> + — Used for transaction processing applications, and + sports a number of features including ACID transaction support + and foreign keys. <literal>InnoDB</literal> is included by + default in all MySQL ¤t-series; binary distributions. In + source distributions, you can enable or disable either engine + by configuring MySQL as you like. + </para> + </listitem> + + <listitem> + <para> + <link linkend="memory-storage-engine"><literal>Memory</literal></link> + — Stores all data in RAM for extremely fast access in + environments that require quick lookups of reference and other + like data. This engine was formerly known as the + <literal>HEAP</literal> engine. + </para> + </listitem> + + <listitem> + <para> + <link linkend="merge-storage-engine"><literal>Merge</literal></link> + — Allows a MySQL DBA or developer to logically group a + series of identical <literal>MyISAM</literal> tables and + reference them as one object. Good for VLDB environments such + as data warehousing. + </para> + </listitem> + + <listitem> + <para> + <link linkend="archive-storage-engine"><literal>Archive</literal></link> + — Provides the perfect solution for storing and + retrieving large amounts of seldom-referenced historical, + archived, or security audit information. + </para> + </listitem> + + <listitem> + <para> + <link linkend="federated-storage-engine"><literal>Federated</literal></link> + — Offers the ability to link separate MySQL servers to + create one logical database from many physical servers. Very + good for distributed or data mart environments. + </para> + </listitem> + + <listitem> + <para> + <link linkend="mysql-cluster"><literal>NDB</literal></link> + — The Clustered database engine that is particularly + suited for applications with high performance lookup needs + that also require the highest possible degree of uptime and + availability. + </para> + </listitem> + + <listitem> + <para> + <link linkend="csv-storage-engine"><literal>CSV</literal></link> + — The CSV storage engine stores data in text files using + comma-separated values format. You can use the CSV engine to + easily exchange data between other software and applications + that can import and export in CSV format. + </para> + </listitem> + + <listitem> + <para> + <link linkend="blackhole-storage-engine"><literal>Blackhole</literal></link> + — The Blackhole storage engine accepts but does not + store data and retrievals always return an empty set. The + functionality can be used in distributed database design where + data is automatically replicated, but not stored locally. + </para> + </listitem> + + <listitem> + <para> + <link linkend="example-storage-engine"><literal>Example</literal></link> + — The Example storage engine is <quote>stub</quote> + engine that does nothing. You can create tables with this + engine, but no data can be stored in them or retrieved from + them. The purpose of this engine is to serve as an example in + the MySQL source code that illustrates how to begin writing + new storage engines. As such, it is primarily of interest to + developers. + </para> + </listitem> + + </itemizedlist> + + <para> + This chapter describes each of the MySQL storage engines except + for <literal>NDB Cluster</literal>, which is covered in + <xref linkend="mysql-cluster"/>. + </para> + + <para> + It is important to remember that you are not restricted to using + the same storage engine for an entire server or schema: you can + use a different storage engine for each table in your schema. + </para> + + <section id="storage-engine-choosing"> + + <title>Choosing a Storage Engine</title> + <para> - Transaction-safe storage engines can provide better concurrency - for tables that get many updates concurrently with reads. + The various storage engines provided with MySQL are designed + with different use-cases in mind. To use the pluggable storage + architecture effectively, it is good to have an idea of the + benefits and drawbacks of the various storage engines. The + following table provides an overview of some storage engines + provided with MySQL: </para> - </listitem> - </itemizedlist> + <informaltable> + <tgroup cols="6"> + <colspec colwidth="18*"/> + <colspec colwidth="12*"/> + <colspec colwidth="12*"/> + <colspec colwidth="12*"/> + <colspec colwidth="12*"/> + <colspec colwidth="12*"/> + <tbody> + <row> + <entry><emphasis role="bold">Feature</emphasis></entry> + <entry><emphasis role="bold">MyISAM</emphasis></entry> + <entry><emphasis role="bold">Memory</emphasis></entry> + <entry><emphasis role="bold">InnoDB</emphasis></entry> + <entry><emphasis role="bold">Archive</emphasis></entry> + <entry><emphasis role="bold">NDB</emphasis></entry> + </row> + <row> + <entry>Storage limits</entry> + <entry>256TB</entry> + <entry>Yes</entry> + <entry>64TB</entry> + <entry>No</entry> + <entry>384EB<superscript>[4]</superscript></entry> + </row> + <row> + <entry>Transactions</entry> + <entry>No</entry> + <entry>No</entry> + <entry>Yes</entry> + <entry>No</entry> + <entry>Yes</entry> + </row> + <row> + <entry>Locking granularity</entry> + <entry>Table</entry> + <entry>Table</entry> + <entry>Row</entry> + <entry>Row</entry> + <entry>Row</entry> + </row> + <row> + <entry>MVCC (snapshot read)</entry> + <entry>No</entry> + <entry>No</entry> + <entry>Yes</entry> + <entry>Yes</entry> + <entry>No</entry> + </row> + <row> + <entry>Geospatial support</entry> + <entry>Yes</entry> + <entry>No</entry> + <entry>Yes<superscript>[1]</superscript></entry> + <entry>Yes<superscript>[1]</superscript></entry> + <entry>Yes<superscript>[1]</superscript></entry> + </row> + <row> + <entry>B-tree indexes</entry> + <entry>Yes</entry> + <entry>Yes</entry> + <entry>Yes</entry> + <entry>No</entry> + <entry>Yes</entry> + </row> + <row> + <entry>Hash indexes</entry> + <entry>No</entry> + <entry>Yes</entry> + <entry>No</entry> + <entry>No</entry> + <entry>Yes</entry> + </row> + <row> + <entry>Full-text search indexes</entry> + <entry>Yes</entry> + <entry>No</entry> + <entry>No</entry> + <entry>No</entry> + <entry>No</entry> + </row> + <row> + <entry>Clustered indexes</entry> + <entry>No</entry> + <entry>No</entry> + <entry>Yes</entry> + <entry>No</entry> + <entry>No</entry> + </row> + <row> + <entry>Data caches</entry> + <entry>No</entry> + <entry>N/A</entry> + <entry>Yes</entry> + <entry>No</entry> + <entry>Yes</entry> + </row> + <row> + <entry>Index caches</entry> + <entry>Yes</entry> + <entry>N/A</entry> + <entry>Yes</entry> + <entry>No</entry> + <entry>Yes</entry> + </row> + <row> + <entry>Compressed data</entry> + <entry>Yes</entry> + <entry>No</entry> + <entry>No</entry> + <entry>Yes</entry> + <entry>No</entry> + </row> + <row> + <entry>Encrypted data<superscript>[2]</superscript></entry> + <entry>Yes</entry> + <entry>Yes</entry> + <entry>Yes</entry> + <entry>Yes</entry> + <entry>Yes</entry> + </row> + <row> + <entry>Cluster database support</entry> + <entry>No</entry> + <entry>No</entry> + <entry>No</entry> + <entry>No</entry> + <entry>Yes</entry> + </row> + <row> + <entry>Replication support<superscript>[3]</superscript></entry> + <entry>Yes</entry> + <entry>Yes</entry> + <entry>Yes</entry> + <entry>Yes</entry> + <entry>Yes</entry> + </row> + <row> + <entry>Foreign key support</entry> + <entry>No</entry> + <entry>No</entry> + <entry>Yes</entry> + <entry>No</entry> + <entry>No</entry> + </row> + <row> + <entry>Backup / point-in-time recovery<superscript>[3]</superscript></entry> + <entry>Yes</entry> + <entry>Yes</entry> + <entry>Yes</entry> + <entry>Yes</entry> + <entry>Yes</entry> + </row> + <row> + <entry>Query cache support</entry> + <entry>Yes</entry> + <entry>Yes</entry> + <entry>Yes</entry> + <entry>Yes</entry> + <entry>Yes</entry> + </row> + <row> + <entry>Update statistics for data dictionary</entry> + <entry>Yes</entry> + <entry>Yes</entry> + <entry>Yes</entry> + <entry>Yes</entry> + <entry>Yes</entry> + </row> + </tbody> + </tgroup> + </informaltable> - <para> - You can combine transaction-safe and non-transaction-safe tables in - the same statements to get the best of both worlds. However, - although MySQL supports several transaction-safe storage engines, - for best results, you should not mix different storage engines - within a transaction with autocommit disabled. For example, if you - do this, changes to non-transaction-safe tables still are committed - immediately and cannot be rolled back. For information about this - and other problems that can occur in transactions that use mixed - storage engines, see <xref linkend="commit"/>. - </para> + <itemizedlist> - <para> - Non-transaction-safe tables have several advantages of their own, - all of which occur because there is no transaction overhead: - </para> + <listitem> + <para> + [1] Storage engine supports spatial data types but no + indexing of such data + </para> + </listitem> - <itemizedlist> + <listitem> + <para> + [2] Implemented in the server (via encryption functions), + rather than in the storage engine + </para> + </listitem> - <listitem> + <listitem> + <para> + [3] Implemented in the server, rather than in the storage + engine + </para> + </listitem> + + <listitem> + <para> + [4] EB = exabyte (1024 * 1024 terabyte) + </para> + </listitem> + + </itemizedlist> + + </section> + + <section> + + <title>Comparing Transaction and Non-Transaction Engines</title> + <para> - Much faster + Transaction-safe tables (TSTs) have several advantages over + non-transaction-safe tables (NTSTs): </para> - </listitem> - <listitem> + <itemizedlist> + + <listitem> + <para> + They are safer. Even if MySQL crashes or you get hardware + problems, you can get your data back, either by automatic + recovery or from a backup plus the transaction log. + </para> + </listitem> + + <listitem> + <para> + You can combine many statements and accept them all at the + same time with the <literal>COMMIT</literal> statement (if + autocommit is disabled). + </para> + </listitem> + + <listitem> + <para> + You can execute <literal>ROLLBACK</literal> to ignore your + changes (if autocommit is disabled). + </para> + </listitem> + + <listitem> + <para> + If an update fails, all of your changes are reverted. (With + non-transaction-safe tables, all changes that have taken + place are permanent.) + </para> + </listitem> + + <listitem> + <para> + Transaction-safe storage engines can provide better + concurrency for tables that get many updates concurrently + with reads. + </para> + </listitem> + + </itemizedlist> + <para> - Lower disk space requirements + You can combine transaction-safe and non-transaction-safe tables + in the same statements to get the best of both worlds. However, + although MySQL supports several transaction-safe storage + engines, for best results, you should not mix different storage + engines within a transaction with autocommit disabled. For + example, if you do this, changes to non-transaction-safe tables + still are committed immediately and cannot be rolled back. For + information about this and other problems that can occur in + transactions that use mixed storage engines, see + <xref linkend="commit"/>. </para> - </listitem> - <listitem> <para> - Less memory required to perform updates + Non-transaction-safe tables have several advantages of their + own, all of which occur because there is no transaction + overhead: </para> - </listitem> - </itemizedlist> + <itemizedlist> + <listitem> + <para> + Much faster + </para> + </listitem> + + <listitem> + <para> + Lower disk space requirements + </para> + </listitem> + + <listitem> + <para> + Less memory required to perform updates + </para> + </listitem> + + </itemizedlist> + + </section> + + </section> + + <section> + + <title>Setting the Storage Engine</title> + + <para> + When you create a new table, you can specify which storage engine + to use by adding an <literal>ENGINE</literal> table option to the + <literal>CREATE TABLE</literal> statement: + </para> + +<programlisting>CREATE TABLE t (i INT) ENGINE = INNODB;</programlisting> + + <para> + If you omit the <literal>ENGINE</literal> or + <literal>TYPE</literal> option, the default storage engine is + used. Normally, this is <literal>MyISAM</literal>, but you can + change it by using the <option>--default-storage-engine</option> + or <option>--default-table-type</option> server startup option, or + by setting the <literal>default-storage-engine</literal> or + <literal>default-table-type</literal> option in the + <filename>my.cnf</filename> configuration file. + </para> + + <para> + You can set the default storage engine to be used during the + current session by setting the <literal>storage_engine</literal> + or <literal>table_type</literal> variable: + </para> + +<programlisting> +SET storage_engine=MYISAM; +SET table_type=INNODB; +</programlisting> + + <para> + When MySQL is installed on Windows using the MySQL Configuration + Wizard, the <literal>InnoDB</literal> storage engine can be + selected as the default instead of <literal>MyISAM</literal>. See + <xref linkend="mysql-config-wizard-database-usage"/>. + </para> + + <para> + To convert a table from one storage engine to another, use an + <literal>ALTER TABLE</literal> statement that indicates the new + engine: + </para> + +<programlisting> +ALTER TABLE t ENGINE = MYISAM; +</programlisting> + + <para> + See <xref linkend="create-table"/>, and + <xref linkend="alter-table"/>. + </para> + + <remark> + We should consider removing this or making a new section 'What + happens when a table is created'. Currently it seems a bit out of + place and not that helpful. + </remark> + + <para> + If you try to use a storage engine that is not compiled in or that + is compiled in but deactivated, MySQL instead creates a table + using the default storage engine, usually + <literal>MyISAM</literal>. This behavior is convenient when you + want to copy tables between MySQL servers that support different + storage engines. (For example, in a replication setup, perhaps + your master server supports transactional storage engines for + increased safety, but the slave servers use only non-transactional + storage engines for greater speed.) + </para> + + <para> + This automatic substitution of the default storage engine for + unavailable engines can be confusing for new MySQL users. A + warning is generated whenever a storage engine is automatically + changed. + </para> + + <para> + For new tables, MySQL always creates an <filename>.frm</filename> + file to hold the table and column definitions. The table's index + and data may be stored in one or more other files, depending on + the storage engine. The server creates the + <filename>.frm</filename> file above the storage engine level. + Individual storage engines create any additional files required + for the tables that they manage. If a table name contains special + characters, the names for the table files contain encoded versions + of those characters as described in + <xref linkend="identifier-mapping"/>. + </para> + + <para> + A database may contain tables of different types. That is, tables + need not all be created with the same storage engine. + </para> + + </section> + <xi:include href="se-myisam.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/> <xi:include href="se-innodb.xml" xmlns:xi="http://www.w3.org/2001/XInclude"/>
| Thread | ||
|---|---|---|
| • svn commit - mysqldoc@docsrva: r3282 - in trunk/refman-5.1: . images images/PSEArch.graffle images/PSEArch.svg | mcbrown | 7 Sep |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 2.155 sec. using MySQL 5.1.14-beta-log