API tools faq
paste
Advertisement
paininbuttocks

LyX document

paininbuttocks
Nov 1st, 2012
206
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Latex 29.08 KB | None | 0 0
raw download clone embed print report
  1. #LyX 2.0 created this file. For more info see http://www.lyx.org/
  2. \lyxformat 413
  3. \begin_document
  4. \begin_header
  5. \textclass article
  6. \begin_preamble
  7.  
  8. \end_preamble
  9. \use_default_options true
  10. \maintain_unincluded_children false
  11. \language english
  12. \language_package default
  13. \inputencoding auto
  14. \fontencoding global
  15. \font_roman default
  16. \font_sans default
  17. \font_typewriter default
  18. \font_default_family default
  19. \use_non_tex_fonts false
  20. \font_sc false
  21. \font_osf false
  22. \font_sf_scale 100
  23. \font_tt_scale 100
  24.  
  25. \graphics default
  26. \default_output_format default
  27. \output_sync 0
  28. \bibtex_command default
  29. \index_command default
  30. \paperfontsize default
  31. \spacing single
  32. \use_hyperref false
  33. \papersize default
  34. \use_geometry false
  35. \use_amsmath 1
  36. \use_esint 1
  37. \use_mhchem 1
  38. \use_mathdots 1
  39. \cite_engine basic
  40. \use_bibtopic false
  41. \use_indices false
  42. \paperorientation portrait
  43. \suppress_date false
  44. \use_refstyle 1
  45. \index Index
  46. \shortcut idx
  47. \color #008000
  48. \end_index
  49. \secnumdepth 3
  50. \tocdepth 3
  51. \paragraph_separation indent
  52. \paragraph_indentation default
  53. \quotes_language english
  54. \papercolumns 1
  55. \papersides 1
  56. \paperpagestyle fancy
  57. \tracking_changes false
  58. \output_changes false
  59. \html_math_output 0
  60. \html_css_as_file 0
  61. \html_be_strict false
  62. \end_header
  63.  
  64. \begin_body
  65.  
  66. \begin_layout Standard
  67.  
  68. \end_layout
  69.  
  70. \begin_layout Title
  71. Coursework 1: Database Systems CO2209
  72. \end_layout
  73.  
  74. \begin_layout Author
  75. NICOLAS EMANUEL CARLO
  76. \end_layout
  77.  
  78. \begin_layout Date
  79. SRN: 050388459
  80. \end_layout
  81.  
  82. \begin_layout Section
  83. A1:
  84. \end_layout
  85.  
  86. \begin_layout Subsection
  87. MySQL:
  88. \end_layout
  89.  
  90. \begin_layout Standard
  91. I do not have any experience with SQL or databases at all.
  92.  However, I picked MySQL as the Database Management System (DBMS) of choice
  93.  because it is by far the most popular system on the internet.
  94.  The reason might be because of its availability as a free system, or it
  95.  maybe its ease of use.
  96.  I purely decided on it because of its popularity and also because it was
  97.  recommended in the coursework guidelines.
  98. \end_layout
  99.  
  100. \begin_layout Subsection
  101. Download:
  102. \end_layout
  103.  
  104. \begin_layout Standard
  105. I didn't have much difficulty at all in downloading and installing MySQL.
  106.  I went to
  107. \begin_inset CommandInset href
  108. LatexCommand href
  109. target "http://dev.mysql.com/downloads/mysql/"
  110.  
  111. \end_inset
  112.  
  113.  and downloaded MySQL Community Server for Mac.
  114.  Heeding the advice in the coursework guidelines I decided not to get the
  115.  GUI tool for MySQL.
  116.  I am somewhat comfortable with the command line because I have, in the
  117.  past, used Linux distributions such as Arch, Fedora and Ubuntu and have
  118.  tried to learn to work with the command line.
  119.  Keeping all of that in mind, I decided to learn MySQL on the command line
  120.  before I moved on to making use of the GUI tool available.
  121. \end_layout
  122.  
  123. \begin_layout Subsection
  124. Installation:
  125. \end_layout
  126.  
  127. \begin_layout Standard
  128. The download was smooth, like I mentioned, and the installation was typically
  129.  straight forward.
  130.  I just had to follow the commands on the screen and the installer took
  131.  care of the installation process.
  132.  The only trouble I had was when I was trying to find out if I had successfully
  133.  installed MySQL or not.
  134.  I had to dig around on the internet to figure out where and how to start
  135.  MySQL up.
  136.  After I figured that out, the basics of MySQL seemed very intuitive and
  137.  easy.
  138. \end_layout
  139.  
  140. \begin_layout Subsection
  141. Creating and Populating the Database:
  142. \end_layout
  143.  
  144. \begin_layout Standard
  145. This is where I spent most of the time.
  146.  I read the Reference Manual to see how one would go about using MySQL.
  147.  Basic tutorials make up Section 3 of the Manual.
  148.  I tried to use the Manual to create a database because at this time I was
  149.  unaware that once I copy and paste the code for Mondial from the website
  150.  provided, it would automatically create the database needed to populate
  151.  it with the necessary data.
  152.  This wasn't any particular trouble I ran into, it was just a learning experienc
  153. e.
  154. \end_layout
  155.  
  156. \begin_layout Standard
  157. Apart from the above everything else went smoothly and I had no trouble
  158.  copy-pasting the data from the website into my MySQL database.
  159. \end_layout
  160.  
  161. \begin_layout Standard
  162. \begin_inset Newpage newpage
  163. \end_inset
  164.  
  165.  
  166. \end_layout
  167.  
  168. \begin_layout Section
  169. A2:
  170. \end_layout
  171.  
  172. \begin_layout Subsection
  173. General Information
  174. \end_layout
  175.  
  176. \begin_layout Subsubsection
  177. About This Manual
  178. \end_layout
  179.  
  180. \begin_layout Subsubsection
  181. Typographical and Syntax Conventions
  182. \end_layout
  183.  
  184. \begin_layout Subsubsection
  185. Overview of the MySQL Database Management System
  186. \end_layout
  187.  
  188. \begin_layout Subsubsection
  189. What Is New in MySQL 5.5
  190. \end_layout
  191.  
  192. \begin_layout Subsubsection
  193. MySQL Development History
  194. \end_layout
  195.  
  196. \begin_layout Subsubsection
  197. MySQL Information Sources
  198. \end_layout
  199.  
  200. \begin_layout Subsubsection
  201. How to Report Bugs or Problems
  202. \end_layout
  203.  
  204. \begin_layout Subsubsection
  205. MySQL Standards Compliance
  206. \end_layout
  207.  
  208. \begin_layout Subsubsection
  209. Credits
  210. \end_layout
  211.  
  212. \begin_layout Subsection
  213. Installing and Upgrading MySQL
  214. \end_layout
  215.  
  216. \begin_layout Subsubsection
  217. General Installation Guidance
  218. \end_layout
  219.  
  220. \begin_layout Subsubsection
  221. Installing MySQL from Generic Binaries on Unix/Linux
  222. \end_layout
  223.  
  224. \begin_layout Subsubsection
  225. Intalling MySQL on Microsoft Windows
  226. \end_layout
  227.  
  228. \begin_layout Subsubsection
  229. Intalling MySQL on Mac OS X
  230. \end_layout
  231.  
  232. \begin_layout Subsubsection
  233. Intalling MySQL on Linux
  234. \end_layout
  235.  
  236. \begin_layout Subsubsection
  237. Intalling MySQL Using Unbreakable Linux Network (ULN)
  238. \end_layout
  239.  
  240. \begin_layout Subsubsection
  241. Intalling MySQL on Solaris and OpenSolaris
  242. \end_layout
  243.  
  244. \begin_layout Subsubsection
  245. Intalling MySQL on HP-UX
  246. \end_layout
  247.  
  248. \begin_layout Subsubsection
  249. Intalling MySQL on FreeBSD
  250. \end_layout
  251.  
  252. \begin_layout Subsubsection
  253. Intalling MySQL from Source
  254. \end_layout
  255.  
  256. \begin_layout Subsubsection
  257. Postinstallation Setup and Testing
  258. \end_layout
  259.  
  260. \begin_layout Subsubsection
  261. Upgrading or Downgrading MySQL
  262. \end_layout
  263.  
  264. \begin_layout Subsubsection
  265. Environment Variables
  266. \end_layout
  267.  
  268. \begin_layout Subsubsection
  269. Perl Installation Notes
  270. \end_layout
  271.  
  272. \begin_layout Subsection
  273. Tutorial
  274. \end_layout
  275.  
  276. \begin_layout Subsubsection
  277. Connecting to and Disconnecting from the Server
  278. \end_layout
  279.  
  280. \begin_layout Subsubsection
  281. Entering Queries
  282. \end_layout
  283.  
  284. \begin_layout Subsubsection
  285. Creating and Using a Database
  286. \end_layout
  287.  
  288. \begin_layout Subsubsection
  289. Getting Information About Databases and Tables
  290. \end_layout
  291.  
  292. \begin_layout Subsubsection
  293. Using MySQL in Batch Mode
  294. \end_layout
  295.  
  296. \begin_layout Subsubsection
  297. Examples of Common Queries
  298. \end_layout
  299.  
  300. \begin_layout Subsubsection
  301. Using MySQL with Apache
  302. \end_layout
  303.  
  304. \begin_layout Subsection
  305. MySQL Programs
  306. \end_layout
  307.  
  308. \begin_layout Subsubsection
  309. Overview of MySQL Programs
  310. \end_layout
  311.  
  312. \begin_layout Subsubsection
  313. Using MySQL Programs
  314. \end_layout
  315.  
  316. \begin_layout Subsubsection
  317. MySQL Server and Server-Startup Programs
  318. \end_layout
  319.  
  320. \begin_layout Subsubsection
  321. MySQL Installation-Related Programs
  322. \end_layout
  323.  
  324. \begin_layout Subsubsection
  325. MySQL Client Programs
  326. \end_layout
  327.  
  328. \begin_layout Subsubsection
  329. MySQL Administrative and Utility Programs
  330. \end_layout
  331.  
  332. \begin_layout Subsubsection
  333. MySQL Program Development Utilities
  334. \end_layout
  335.  
  336. \begin_layout Subsubsection
  337. Miscellaneous Programs
  338. \end_layout
  339.  
  340. \begin_layout Subsection
  341. MySQL Server Administration
  342. \end_layout
  343.  
  344. \begin_layout Subsubsection
  345. The MySQL Server
  346. \end_layout
  347.  
  348. \begin_layout Subsubsection
  349. MySQL Server Logs
  350. \end_layout
  351.  
  352. \begin_layout Subsubsection
  353. Running Multiple MySQL Instances on One Machine
  354. \end_layout
  355.  
  356. \begin_layout Subsubsection
  357. Tracing MySQL Using DTrace
  358. \end_layout
  359.  
  360. \begin_layout Subsection
  361. Security
  362. \end_layout
  363.  
  364. \begin_layout Subsubsection
  365. General Security Issues
  366. \end_layout
  367.  
  368. \begin_layout Subsubsection
  369. The MySQL Access Privilege System
  370. \end_layout
  371.  
  372. \begin_layout Subsubsection
  373. MySQL User Account Management
  374. \end_layout
  375.  
  376. \begin_layout Subsection
  377. Backup and Recovery
  378. \end_layout
  379.  
  380. \begin_layout Subsubsection
  381. Backup and Recovery Types
  382. \end_layout
  383.  
  384. \begin_layout Subsubsection
  385. Database Backup Methods
  386. \end_layout
  387.  
  388. \begin_layout Subsubsection
  389. Example Backup and Recovery Strategy
  390. \end_layout
  391.  
  392. \begin_layout Subsubsection
  393. Using mysqldump for Backup
  394. \end_layout
  395.  
  396. \begin_layout Subsubsection
  397. Point-in-Time (Incremental) Recovery Using the Binary Log
  398. \end_layout
  399.  
  400. \begin_layout Subsubsection
  401. MyISAM Table Maintenance and Crash Recovery
  402. \end_layout
  403.  
  404. \begin_layout Subsection
  405. Optimization
  406. \end_layout
  407.  
  408. \begin_layout Subsubsection
  409. Optimazation Overview
  410. \end_layout
  411.  
  412. \begin_layout Subsubsection
  413. Optimizing SQL Statements
  414. \end_layout
  415.  
  416. \begin_layout Subsubsection
  417. Optimization and Indexes
  418. \end_layout
  419.  
  420. \begin_layout Subsubsection
  421. Optimizing Database Structure
  422. \end_layout
  423.  
  424. \begin_layout Subsubsection
  425. Optimizing for InnoDB Tables
  426. \end_layout
  427.  
  428. \begin_layout Subsubsection
  429. Optimizing MyISAM Tables
  430. \end_layout
  431.  
  432. \begin_layout Subsubsection
  433. Optimizing for MEMORY Tables
  434. \end_layout
  435.  
  436. \begin_layout Subsubsection
  437. Understanding the Query Execution Plan
  438. \end_layout
  439.  
  440. \begin_layout Subsubsection
  441. Buffering and Caching
  442. \end_layout
  443.  
  444. \begin_layout Subsubsection
  445. Optimizing Locking Operations
  446. \end_layout
  447.  
  448. \begin_layout Subsubsection
  449. Optimizing the MySQL Server
  450. \end_layout
  451.  
  452. \begin_layout Subsubsection
  453. Measuring Performance (Benchmarking)
  454. \end_layout
  455.  
  456. \begin_layout Subsubsection
  457. Internal Details of MySQL Optimizations
  458. \end_layout
  459.  
  460. \begin_layout Subsection
  461. Language Structure
  462. \end_layout
  463.  
  464. \begin_layout Subsubsection
  465. Literal Values
  466. \end_layout
  467.  
  468. \begin_layout Subsubsection
  469. Schema Object Names
  470. \end_layout
  471.  
  472. \begin_layout Subsubsection
  473. Reserved Words
  474. \end_layout
  475.  
  476. \begin_layout Subsubsection
  477. User-Defined Variables
  478. \end_layout
  479.  
  480. \begin_layout Subsubsection
  481. Expression Syntax
  482. \end_layout
  483.  
  484. \begin_layout Subsubsection
  485. Comment Syntax
  486. \end_layout
  487.  
  488. \begin_layout Subsection
  489. Globalization
  490. \end_layout
  491.  
  492. \begin_layout Subsubsection
  493. Character Set Support
  494. \end_layout
  495.  
  496. \begin_layout Subsubsection
  497. Setting the Error Message Language
  498. \end_layout
  499.  
  500. \begin_layout Subsubsection
  501. Adding a Character Set
  502. \end_layout
  503.  
  504. \begin_layout Subsubsection
  505. Adding a Collation to a Character Set
  506. \end_layout
  507.  
  508. \begin_layout Subsubsection
  509. Character Set Configuration
  510. \end_layout
  511.  
  512. \begin_layout Subsubsection
  513. MySQL Server Time Zone Support
  514. \end_layout
  515.  
  516. \begin_layout Subsubsection
  517. MySQL Server Locale Support
  518. \end_layout
  519.  
  520. \begin_layout Subsection
  521. Data Types
  522. \end_layout
  523.  
  524. \begin_layout Subsubsection
  525. Data Type Overview
  526. \end_layout
  527.  
  528. \begin_layout Subsubsection
  529. Numeric Types
  530. \end_layout
  531.  
  532. \begin_layout Subsubsection
  533. Data and Time Types
  534. \end_layout
  535.  
  536. \begin_layout Subsubsection
  537. String Types
  538. \end_layout
  539.  
  540. \begin_layout Subsubsection
  541. Data Type Default Values
  542. \end_layout
  543.  
  544. \begin_layout Subsubsection
  545. Data Type Storage Requirements
  546. \end_layout
  547.  
  548. \begin_layout Subsubsection
  549. Choosing the Right Type for a Column
  550. \end_layout
  551.  
  552. \begin_layout Subsubsection
  553. Using Data Types from Other Database Engines
  554. \end_layout
  555.  
  556. \begin_layout Subsection
  557. Functions and Operators
  558. \end_layout
  559.  
  560. \begin_layout Subsubsection
  561. Function and Operator Reference
  562. \end_layout
  563.  
  564. \begin_layout Subsubsection
  565. Type Conversion in Expression Evaluation
  566. \end_layout
  567.  
  568. \begin_layout Subsubsection
  569. Operators
  570. \end_layout
  571.  
  572. \begin_layout Subsubsection
  573. Control Flow Functions
  574. \end_layout
  575.  
  576. \begin_layout Subsubsection
  577. String Functions
  578. \end_layout
  579.  
  580. \begin_layout Subsubsection
  581. Numeric Functions and Operators
  582. \end_layout
  583.  
  584. \begin_layout Subsubsection
  585. Date and Time Functions
  586. \end_layout
  587.  
  588. \begin_layout Subsubsection
  589. What Calendar Is Used By MySQL
  590. \end_layout
  591.  
  592. \begin_layout Subsubsection
  593. Full-Text Search Functions
  594. \end_layout
  595.  
  596. \begin_layout Subsubsection
  597. Cast Functions and Operators
  598. \end_layout
  599.  
  600. \begin_layout Subsubsection
  601. XML Functions
  602. \end_layout
  603.  
  604. \begin_layout Subsubsection
  605. Bit Functions
  606. \end_layout
  607.  
  608. \begin_layout Subsubsection
  609. Encryption and Compression Functions
  610. \end_layout
  611.  
  612. \begin_layout Subsubsection
  613. Information Functions
  614. \end_layout
  615.  
  616. \begin_layout Subsubsection
  617. Miscellaneous Functions
  618. \end_layout
  619.  
  620. \begin_layout Subsubsection
  621. Functions and Modifiers for Use with GROUP BY Clauses
  622. \end_layout
  623.  
  624. \begin_layout Subsubsection
  625. Spatial Extensions
  626. \end_layout
  627.  
  628. \begin_layout Subsubsection
  629. Precision Math
  630. \end_layout
  631.  
  632. \begin_layout Subsection
  633. SQL Statement Syntax
  634. \end_layout
  635.  
  636. \begin_layout Subsubsection
  637. Data Definition Statements
  638. \end_layout
  639.  
  640. \begin_layout Subsubsection
  641. Data Manipulation Statements
  642. \end_layout
  643.  
  644. \begin_layout Subsubsection
  645. MySQL Transactional and Locking Statements
  646. \end_layout
  647.  
  648. \begin_layout Subsubsection
  649. Replication Statements
  650. \end_layout
  651.  
  652. \begin_layout Subsubsection
  653. SQL Syntax for Prepared Statements
  654. \end_layout
  655.  
  656. \begin_layout Subsubsection
  657. MySQL Compound-Statement Syntax
  658. \end_layout
  659.  
  660. \begin_layout Subsubsection
  661. Database Administration Statements
  662. \end_layout
  663.  
  664. \begin_layout Subsubsection
  665. MySQL Utility Statements
  666. \end_layout
  667.  
  668. \begin_layout Subsection
  669. Storage Engines
  670. \end_layout
  671.  
  672. \begin_layout Subsubsection
  673. Setting the Storage Engine
  674. \end_layout
  675.  
  676. \begin_layout Subsubsection
  677. Overview of MySQL Storage Engine Architecture
  678. \end_layout
  679.  
  680. \begin_layout Subsubsection
  681. The InnoDB Storage Engine
  682. \end_layout
  683.  
  684. \begin_layout Subsubsection
  685. New Features of InnoDB 1.1
  686. \end_layout
  687.  
  688. \begin_layout Subsubsection
  689. The MyISAM Storage Engine
  690. \end_layout
  691.  
  692. \begin_layout Subsubsection
  693. The MEMORY Storage Engine
  694. \end_layout
  695.  
  696. \begin_layout Subsubsection
  697. The CSV Storage Engine
  698. \end_layout
  699.  
  700. \begin_layout Subsubsection
  701. The ARCHIVE Storage Engine
  702. \end_layout
  703.  
  704. \begin_layout Subsubsection
  705. The BLACKHOLE Storage Engine
  706. \end_layout
  707.  
  708. \begin_layout Subsubsection
  709. The MERGE Storage Engine
  710. \end_layout
  711.  
  712. \begin_layout Subsubsection
  713. The FEDERATED Storage Engine
  714. \end_layout
  715.  
  716. \begin_layout Subsubsection
  717. The EXAMPLE Storage Engine
  718. \end_layout
  719.  
  720. \begin_layout Subsubsection
  721. Other Storage Engines
  722. \end_layout
  723.  
  724. \begin_layout Subsection
  725. High Availability and Scalability
  726. \end_layout
  727.  
  728. \begin_layout Subsubsection
  729. Oracle VM Template for MySQL Enterprise Edition
  730. \end_layout
  731.  
  732. \begin_layout Subsubsection
  733. Using MySQL with DRBD
  734. \end_layout
  735.  
  736. \begin_layout Subsubsection
  737. Using Linux HA Heartbeat
  738. \end_layout
  739.  
  740. \begin_layout Subsubsection
  741. Using MySQL within an Amazon EC2 Instance
  742. \end_layout
  743.  
  744. \begin_layout Subsubsection
  745. Using ZFS Replication
  746. \end_layout
  747.  
  748. \begin_layout Subsubsection
  749. Using MySQL with memcached
  750. \end_layout
  751.  
  752. \begin_layout Subsubsection
  753. MySQL Proxy
  754. \end_layout
  755.  
  756. \begin_layout Subsection
  757. Replication
  758. \end_layout
  759.  
  760. \begin_layout Subsubsection
  761. Replication Configuration
  762. \end_layout
  763.  
  764. \begin_layout Subsubsection
  765. Replication Implementation
  766. \end_layout
  767.  
  768. \begin_layout Subsubsection
  769. Replication Solutions
  770. \end_layout
  771.  
  772. \begin_layout Subsubsection
  773. Replication Notes and Tips
  774. \end_layout
  775.  
  776. \begin_layout Subsection
  777. MySQL Cluster NDB 7.2
  778. \end_layout
  779.  
  780. \begin_layout Subsubsection
  781. MySQL Cluster Overview
  782. \end_layout
  783.  
  784. \begin_layout Subsubsection
  785. MySQL Cluster Installation
  786. \end_layout
  787.  
  788. \begin_layout Subsubsection
  789. MySQL Cluster Configuration
  790. \end_layout
  791.  
  792. \begin_layout Subsubsection
  793. MySQL Cluster Programs
  794. \end_layout
  795.  
  796. \begin_layout Subsubsection
  797. Management of MySQL Cluster
  798. \end_layout
  799.  
  800. \begin_layout Subsubsection
  801. MySQL Cluster Replication
  802. \end_layout
  803.  
  804. \begin_layout Subsubsection
  805. Changes in MySQL Cluster
  806. \end_layout
  807.  
  808. \begin_layout Subsection
  809. Partitioning
  810. \end_layout
  811.  
  812. \begin_layout Subsubsection
  813. Overview of Partitioning in MySQL
  814. \end_layout
  815.  
  816. \begin_layout Subsubsection
  817. Partitioning Types
  818. \end_layout
  819.  
  820. \begin_layout Subsubsection
  821. Partition Management
  822. \end_layout
  823.  
  824. \begin_layout Subsubsection
  825. Partition Pruning
  826. \end_layout
  827.  
  828. \begin_layout Subsubsection
  829. Restrictions and Limitations on Partitioning
  830. \end_layout
  831.  
  832. \begin_layout Subsection
  833. Stored Programs and Views
  834. \end_layout
  835.  
  836. \begin_layout Subsubsection
  837. Defining Stored Programs
  838. \end_layout
  839.  
  840. \begin_layout Subsubsection
  841. Using Stored Routines (Procedures and Functions)
  842. \end_layout
  843.  
  844. \begin_layout Subsubsection
  845. Using Triggers
  846. \end_layout
  847.  
  848. \begin_layout Subsubsection
  849. Using the Event Scheduler
  850. \end_layout
  851.  
  852. \begin_layout Subsubsection
  853. Using Views
  854. \end_layout
  855.  
  856. \begin_layout Subsubsection
  857. Access Control for Stored Programs and Views
  858. \end_layout
  859.  
  860. \begin_layout Subsubsection
  861. Binary Logging of Stored Programs
  862. \end_layout
  863.  
  864. \begin_layout Subsection
  865. INFORMATION_SCHEMA Tables
  866. \end_layout
  867.  
  868. \begin_layout Subsubsection
  869. The INFORMATION_SCHEMA COLLATIONS Table
  870. \end_layout
  871.  
  872. \begin_layout Subsubsection
  873. The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
  874. \end_layout
  875.  
  876. \begin_layout Subsubsection
  877. The INFORMATION_SCHEMA COLUMNS Table
  878. \end_layout
  879.  
  880. \begin_layout Subsubsection
  881. The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
  882. \end_layout
  883.  
  884. \begin_layout Subsubsection
  885. The INFORMATION_SCHEMA ENGINES Table
  886. \end_layout
  887.  
  888. \begin_layout Subsubsection
  889. The INFORMATION_SCHEMA EVENTS Table
  890. \end_layout
  891.  
  892. \begin_layout Subsubsection
  893. The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables
  894. \end_layout
  895.  
  896. \begin_layout Subsubsection
  897. The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables
  898. \end_layout
  899.  
  900. \begin_layout Subsubsection
  901. The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
  902. \end_layout
  903.  
  904. \begin_layout Subsubsection
  905. The INFORMATION_SCHEMA PARAMETERS Table
  906. \end_layout
  907.  
  908. \begin_layout Subsubsection
  909. The INFORMATION_SCHEMA PARTITIONS Table
  910. \end_layout
  911.  
  912. \begin_layout Subsubsection
  913. The INFORMATION_SCHEMA PLUGINS Table
  914. \end_layout
  915.  
  916. \begin_layout Subsubsection
  917. The INFORMATION_SCHEMA PROCESSLIST Table
  918. \end_layout
  919.  
  920. \begin_layout Subsubsection
  921. The INFORMATION_SCHEMA PROFILING Table
  922. \end_layout
  923.  
  924. \begin_layout Subsubsection
  925. The INFORMATION_SCHEMA REFERENTIAL_CONTRAINTS Table
  926. \end_layout
  927.  
  928. \begin_layout Subsubsection
  929. The INFORMATION_SCHEMA ROUTINES Table
  930. \end_layout
  931.  
  932. \begin_layout Subsubsection
  933. The INFORMATION_SCHEMA SCHEMATA Table
  934. \end_layout
  935.  
  936. \begin_layout Subsubsection
  937. The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
  938. \end_layout
  939.  
  940. \begin_layout Subsubsection
  941. The INFORMATION_SCHEMA STATISTICS Table
  942. \end_layout
  943.  
  944. \begin_layout Subsubsection
  945. The INFORMATION_SCHEMA TABLES Table
  946. \end_layout
  947.  
  948. \begin_layout Subsubsection
  949. The INFORMATION_SCHEMA TABLESPACES Table
  950. \end_layout
  951.  
  952. \begin_layout Subsubsection
  953. The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
  954. \end_layout
  955.  
  956. \begin_layout Subsubsection
  957. The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
  958. \end_layout
  959.  
  960. \begin_layout Subsubsection
  961. The INFORMATION_SCHEMA TRIGGERS Table
  962. \end_layout
  963.  
  964. \begin_layout Subsubsection
  965. The INFORMATION_SCHEMA USER_PRIVILEGES Table
  966. \end_layout
  967.  
  968. \begin_layout Subsubsection
  969. The INFORMATION_SCHEMA VIEWS Table
  970. \end_layout
  971.  
  972. \begin_layout Subsubsection
  973. INFORMATION_SCHEMA Tables for InnoDB
  974. \end_layout
  975.  
  976. \begin_layout Subsubsection
  977. INFORMATION_SCHEMA Tables for MySQL Cluster
  978. \end_layout
  979.  
  980. \begin_layout Subsubsection
  981. Thread Pool INFORMATION_SCHMA Tables
  982. \end_layout
  983.  
  984. \begin_layout Subsubsection
  985. Extendions to SHOW Statements
  986. \end_layout
  987.  
  988. \begin_layout Subsection
  989. MySQL Performace Schema
  990. \end_layout
  991.  
  992. \begin_layout Subsubsection
  993. Performance Schema Quick Start
  994. \end_layout
  995.  
  996. \begin_layout Subsubsection
  997. Performance Schema Configuration
  998. \end_layout
  999.  
  1000. \begin_layout Subsubsection
  1001. Performance Schema Queries
  1002. \end_layout
  1003.  
  1004. \begin_layout Subsubsection
  1005. Performance Schema Instrument Naming Conventions
  1006. \end_layout
  1007.  
  1008. \begin_layout Subsubsection
  1009. Performance Schema Status Monitoring
  1010. \end_layout
  1011.  
  1012. \begin_layout Subsubsection
  1013. Performance Schema General Table Characteristics
  1014. \end_layout
  1015.  
  1016. \begin_layout Subsubsection
  1017. Performance Schema Table Descriptions
  1018. \end_layout
  1019.  
  1020. \begin_layout Subsubsection
  1021. Performance Schema System Variables
  1022. \end_layout
  1023.  
  1024. \begin_layout Subsubsection
  1025. Performance Schema Status Variables
  1026. \end_layout
  1027.  
  1028. \begin_layout Subsubsection
  1029. Performance Schema and Plugins
  1030. \end_layout
  1031.  
  1032. \begin_layout Subsubsection
  1033. Using the Performance Schema to Diagnose Problems
  1034. \end_layout
  1035.  
  1036. \begin_layout Subsection
  1037. Connectors and APIs
  1038. \end_layout
  1039.  
  1040. \begin_layout Subsubsection
  1041. MySQL Connector/ODBC
  1042. \end_layout
  1043.  
  1044. \begin_layout Subsubsection
  1045. MySQL Connector/Net
  1046. \end_layout
  1047.  
  1048. \begin_layout Subsubsection
  1049. MySQL Connector/J
  1050. \end_layout
  1051.  
  1052. \begin_layout Subsubsection
  1053. MySQL Connector/C++
  1054. \end_layout
  1055.  
  1056. \begin_layout Subsubsection
  1057. MySQL Connector/C
  1058. \end_layout
  1059.  
  1060. \begin_layout Subsubsection
  1061. MySQL Connector/Python
  1062. \end_layout
  1063.  
  1064. \begin_layout Subsubsection
  1065. MySQL Connector/OpenOffice.org
  1066. \end_layout
  1067.  
  1068. \begin_layout Subsubsection
  1069. libmysqld, the Embedded MySQL Server Library
  1070. \end_layout
  1071.  
  1072. \begin_layout Subsubsection
  1073. MySQL C API
  1074. \end_layout
  1075.  
  1076. \begin_layout Subsubsection
  1077. MySQL PHP API
  1078. \end_layout
  1079.  
  1080. \begin_layout Subsubsection
  1081. MySQL Perl API
  1082. \end_layout
  1083.  
  1084. \begin_layout Subsubsection
  1085. MySQL Python API
  1086. \end_layout
  1087.  
  1088. \begin_layout Subsubsection
  1089. MySQL Ruby API
  1090. \end_layout
  1091.  
  1092. \begin_layout Subsubsection
  1093. MySQL Tcl API
  1094. \end_layout
  1095.  
  1096. \begin_layout Subsubsection
  1097. MySQL Eiffel Wrapper
  1098. \end_layout
  1099.  
  1100. \begin_layout Subsection
  1101. Extending MySQL
  1102. \end_layout
  1103.  
  1104. \begin_layout Subsubsection
  1105. MySQL Internals
  1106. \end_layout
  1107.  
  1108. \begin_layout Subsubsection
  1109. The MySQL Plugin API
  1110. \end_layout
  1111.  
  1112. \begin_layout Subsubsection
  1113. Adding New Functions to MySQL
  1114. \end_layout
  1115.  
  1116. \begin_layout Subsubsection
  1117. Debugging and Porting MySQL
  1118. \end_layout
  1119.  
  1120. \begin_layout Subsection
  1121. MySQL Enterprise Monitor
  1122. \end_layout
  1123.  
  1124. \begin_layout Subsection
  1125. MySQL Enterprise Backup
  1126. \end_layout
  1127.  
  1128. \begin_layout Subsection
  1129. MySQL Workbench
  1130. \end_layout
  1131.  
  1132. \begin_layout Subsection
  1133. MySQL for Excel
  1134. \end_layout
  1135.  
  1136. \begin_layout Subsubsection
  1137. Installing and Configuring
  1138. \end_layout
  1139.  
  1140. \begin_layout Subsubsection
  1141. Edit MySQL Data
  1142. \end_layout
  1143.  
  1144. \begin_layout Subsubsection
  1145. Import MySQL Data
  1146. \end_layout
  1147.  
  1148. \begin_layout Subsubsection
  1149. Append MySQL Data
  1150. \end_layout
  1151.  
  1152. \begin_layout Subsubsection
  1153. Export MySQL Data
  1154. \end_layout
  1155.  
  1156. \begin_layout Subsection
  1157. A.
  1158.  Licenses for Third-Party Components
  1159. \end_layout
  1160.  
  1161. \begin_layout Subsubsection
  1162. Anti-Contrib License
  1163. \end_layout
  1164.  
  1165. \begin_layout Subsubsection
  1166. ANTLR 3 License
  1167. \end_layout
  1168.  
  1169. \begin_layout Subsubsection
  1170. ANTLR 3.3 License
  1171. \end_layout
  1172.  
  1173. \begin_layout Subsubsection
  1174. Boost Library License
  1175. \end_layout
  1176.  
  1177. \begin_layout Subsubsection
  1178. dtoa.c License
  1179. \end_layout
  1180.  
  1181. \begin_layout Subsubsection
  1182. Editing Library (libedit) License
  1183. \end_layout
  1184.  
  1185. \begin_layout Subsubsection
  1186. FindGTest.cmake License
  1187. \end_layout
  1188.  
  1189. \begin_layout Subsubsection
  1190. Fred Fish's Dbug Library License
  1191. \end_layout
  1192.  
  1193. \begin_layout Subsubsection
  1194. getarg License
  1195. \end_layout
  1196.  
  1197. \begin_layout Subsubsection
  1198. GLib License (for MySQL Proxy)
  1199. \end_layout
  1200.  
  1201. \begin_layout Subsubsection
  1202. GNU General Public License Version 2.0, June 1991
  1203. \end_layout
  1204.  
  1205. \begin_layout Subsubsection
  1206. GNU Lesser General Public License Version 2.1, February 1999
  1207. \end_layout
  1208.  
  1209. \begin_layout Subsubsection
  1210. GNU Libtool License
  1211. \end_layout
  1212.  
  1213. \begin_layout Subsubsection
  1214. GNU Readline License
  1215. \end_layout
  1216.  
  1217. \begin_layout Subsubsection
  1218. Google Controlling Master Thread I/O Rate Patch License
  1219. \end_layout
  1220.  
  1221. \begin_layout Subsubsection
  1222. Google Perftools (TCMalloc Utility) License
  1223. \end_layout
  1224.  
  1225. \begin_layout Subsubsection
  1226. Google SMP Patch License
  1227. \end_layout
  1228.  
  1229. \begin_layout Subsubsection
  1230. lib_sql.cc License
  1231. \end_layout
  1232.  
  1233. \begin_layout Subsubsection
  1234. Libaio License
  1235. \end_layout
  1236.  
  1237. \begin_layout Subsubsection
  1238. libevent License
  1239. \end_layout
  1240.  
  1241. \begin_layout Subsubsection
  1242. Libiconv License
  1243. \end_layout
  1244.  
  1245. \begin_layout Subsubsection
  1246. libintl License
  1247. \end_layout
  1248.  
  1249. \begin_layout Subsubsection
  1250. Linux-PAM License
  1251. \end_layout
  1252.  
  1253. \begin_layout Subsubsection
  1254. LPeg Library License
  1255. \end_layout
  1256.  
  1257. \begin_layout Subsubsection
  1258. Lua (libiua) License
  1259. \end_layout
  1260.  
  1261. \begin_layout Subsubsection
  1262. LuaFileSystem Library License
  1263. \end_layout
  1264.  
  1265. \begin_layout Subsubsection
  1266. md5 (Message-Digest Algorithm 5) License
  1267. \end_layout
  1268.  
  1269. \begin_layout Subsubsection
  1270. memcached License
  1271. \end_layout
  1272.  
  1273. \begin_layout Subsubsection
  1274. nt_serv (Windows NT Service class library) License
  1275. \end_layout
  1276.  
  1277. \begin_layout Subsubsection
  1278. OpenPAM License
  1279. \end_layout
  1280.  
  1281. \begin_layout Subsubsection
  1282. Paramiko License
  1283. \end_layout
  1284.  
  1285. \begin_layout Subsubsection
  1286. PCRE License
  1287. \end_layout
  1288.  
  1289. \begin_layout Subsubsection
  1290. Percona Multiple I/O Threads Patch License
  1291. \end_layout
  1292.  
  1293. \begin_layout Subsubsection
  1294. Python License
  1295. \end_layout
  1296.  
  1297. \begin_layout Subsubsection
  1298. Red HAT RPM Spec File License
  1299. \end_layout
  1300.  
  1301. \begin_layout Subsubsection
  1302. RegEX-Spencer Library License
  1303. \end_layout
  1304.  
  1305. \begin_layout Subsubsection
  1306. RFC 3174 - US Secure Hash Algorithm 1 (SHA1) License
  1307. \end_layout
  1308.  
  1309. \begin_layout Subsubsection
  1310. Richard A.
  1311.  O'Keefe String Library License
  1312. \end_layout
  1313.  
  1314. \begin_layout Subsubsection
  1315. SHA-1 in C License
  1316. \end_layout
  1317.  
  1318. \begin_layout Subsubsection
  1319. Simple Logging Facade for Java (SLF4J) License
  1320. \end_layout
  1321.  
  1322. \begin_layout Subsubsection
  1323. zlib License
  1324. \end_layout
  1325.  
  1326. \begin_layout Subsubsection
  1327. ZLIP.NET License
  1328. \end_layout
  1329.  
  1330. \begin_layout Subsection
  1331. B.
  1332.  MySQL 5.5 Frequently Asked Questions
  1333. \end_layout
  1334.  
  1335. \begin_layout Subsubsection
  1336. MySQL 5.5 FAQ: General
  1337. \end_layout
  1338.  
  1339. \begin_layout Subsubsection
  1340. MySQL 5.5 FAQ: Storage Engines
  1341. \end_layout
  1342.  
  1343. \begin_layout Subsubsection
  1344. MySQL 5.5 FAQ: Server SQL Mode
  1345. \end_layout
  1346.  
  1347. \begin_layout Subsubsection
  1348. MySQL 5.5 FAQ: Stored Procedures and Functions
  1349. \end_layout
  1350.  
  1351. \begin_layout Subsubsection
  1352. MySQL 5.5 FAQ: Triggers
  1353. \end_layout
  1354.  
  1355. \begin_layout Subsubsection
  1356. MySQL 5.5 FAQ: Views
  1357. \end_layout
  1358.  
  1359. \begin_layout Subsubsection
  1360. MySQL 5.5 FAQ: INFORMATION_SCHEMA
  1361. \end_layout
  1362.  
  1363. \begin_layout Subsubsection
  1364. MySQL 5.5 FAQ: Migration
  1365. \end_layout
  1366.  
  1367. \begin_layout Subsubsection
  1368. MySQL 5.5 FAQ: Security
  1369. \end_layout
  1370.  
  1371. \begin_layout Subsubsection
  1372. MySQL FAQ: MySQL 5.5 and MySQL Cluster
  1373. \end_layout
  1374.  
  1375. \begin_layout Subsubsection
  1376. MySQL 5.5 FAQ: MySQL Chinese, Japanese, and Korean Character Set
  1377. \end_layout
  1378.  
  1379. \begin_layout Subsubsection
  1380. MySQL 5.5 FAQ: Connectors & APIs
  1381. \end_layout
  1382.  
  1383. \begin_layout Subsubsection
  1384. MySQL 5.5 FAQ: Replication
  1385. \end_layout
  1386.  
  1387. \begin_layout Subsubsection
  1388. MySQL 5.5 FAQ: MySQL Enterprise Scalability Thread Pool
  1389. \end_layout
  1390.  
  1391. \begin_layout Subsubsection
  1392. MySQL 5.5 FAQ: MySQL, DRBD, and Heartbeat
  1393. \end_layout
  1394.  
  1395. \begin_layout Subsection
  1396. C.
  1397.  Errors, Error Codes, and Common Problems
  1398. \end_layout
  1399.  
  1400. \begin_layout Subsubsection
  1401. Sources of Error Information
  1402. \end_layout
  1403.  
  1404. \begin_layout Subsubsection
  1405. Types of Error Values
  1406. \end_layout
  1407.  
  1408. \begin_layout Subsubsection
  1409. Server Error Codes and Messages
  1410. \end_layout
  1411.  
  1412. \begin_layout Subsubsection
  1413. Client Error Codes and Messages
  1414. \end_layout
  1415.  
  1416. \begin_layout Subsubsection
  1417. Problems and Common Errors
  1418. \end_layout
  1419.  
  1420. \begin_layout Subsection
  1421. D.
  1422.  MySQL Change History
  1423. \end_layout
  1424.  
  1425. \begin_layout Subsubsection
  1426. Changes in Release 5.5.x (Production)
  1427. \end_layout
  1428.  
  1429. \begin_layout Subsubsection
  1430. MySQL Connector/ODBC (MyODBC) Change History
  1431. \end_layout
  1432.  
  1433. \begin_layout Subsubsection
  1434. MySQL Connector/Net Change History
  1435. \end_layout
  1436.  
  1437. \begin_layout Subsubsection
  1438. MySQL Visual Studio Plugin Change History
  1439. \end_layout
  1440.  
  1441. \begin_layout Subsubsection
  1442. MySQL Connector/J Change History
  1443. \end_layout
  1444.  
  1445. \begin_layout Subsubsection
  1446. MySQL Connector/C++ Change History
  1447. \end_layout
  1448.  
  1449. \begin_layout Subsubsection
  1450. MySQL Proxy Change History
  1451. \end_layout
  1452.  
  1453. \begin_layout Subsubsection
  1454. MySQL for Excel Change History
  1455. \end_layout
  1456.  
  1457. \begin_layout Subsubsection
  1458. MySQL Installer Change History
  1459. \end_layout
  1460.  
  1461. \begin_layout Subsection
  1462. E.
  1463.  Restrictions and Limits
  1464. \end_layout
  1465.  
  1466. \begin_layout Subsubsection
  1467. Restrictions on Stored Programs
  1468. \end_layout
  1469.  
  1470. \begin_layout Subsubsection
  1471. Restrictions on Condition Handling
  1472. \end_layout
  1473.  
  1474. \begin_layout Subsubsection
  1475. Restrictions on Server-Side Cursors
  1476. \end_layout
  1477.  
  1478. \begin_layout Subsubsection
  1479. Restrictions on Subqueries
  1480. \end_layout
  1481.  
  1482. \begin_layout Subsubsection
  1483. Restrictions on Views
  1484. \end_layout
  1485.  
  1486. \begin_layout Subsubsection
  1487. Restrictions on XA Transactions
  1488. \end_layout
  1489.  
  1490. \begin_layout Subsubsection
  1491. Restrictions on Character Sets
  1492. \end_layout
  1493.  
  1494. \begin_layout Subsubsection
  1495. Restrictions on Performance Schema
  1496. \end_layout
  1497.  
  1498. \begin_layout Subsubsection
  1499. Restrictions on Pluggable Authentication
  1500. \end_layout
  1501.  
  1502. \begin_layout Subsubsection
  1503. Limits in MySQL
  1504. \end_layout
  1505.  
  1506. \begin_layout Subsection
  1507. F.
  1508.  MySQL Glossary
  1509. \end_layout
  1510.  
  1511. \begin_layout Subsection
  1512. General Index
  1513. \end_layout
  1514.  
  1515. \begin_layout Subsection
  1516. C Function Index
  1517. \end_layout
  1518.  
  1519. \begin_layout Subsection
  1520. Command Index
  1521. \end_layout
  1522.  
  1523. \begin_layout Subsection
  1524. Function Index
  1525. \end_layout
  1526.  
  1527. \begin_layout Subsection
  1528. INFORMATION_SCHEMA Index
  1529. \end_layout
  1530.  
  1531. \begin_layout Subsection
  1532. Transaction Isolation Level Index
  1533. \end_layout
  1534.  
  1535. \begin_layout Subsection
  1536. Join Types Index
  1537. \end_layout
  1538.  
  1539. \begin_layout Subsection
  1540. Operator Index
  1541. \end_layout
  1542.  
  1543. \begin_layout Subsection
  1544. Option Index
  1545. \end_layout
  1546.  
  1547. \begin_layout Standard
  1548. \begin_inset Newpage newpage
  1549. \end_inset
  1550.  
  1551.  
  1552. \end_layout
  1553.  
  1554. \begin_layout Section
  1555. A3:
  1556. \end_layout
  1557.  
  1558. \begin_layout Standard
  1559. \begin_inset Newpage newpage
  1560. \end_inset
  1561.  
  1562.  
  1563. \end_layout
  1564.  
  1565. \end_body
  1566. \end_document
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!