/Users/andrea/_magisterarbeit/korpus/clean/trainkorpus/27/file2.html NN ----------------------------------------- : . SENT . SENT DEVELOPER NN ZONE NN Login NP Register NP MySQL NP . SENT com NN Developer NN Zone NP Partners NP Online JJ Shop NP Downloads NP Documentation NN Forums NNS Lists VVZ Bugs NP Events NNS User NP Groups NNS Guilds NNS Blogs NP Developer NN Support NN Tech NP Resources NP Books NPS FAQ NP MySQL NP 5 CD . SENT 0 CD Technical NP FAQ NP Overview NN Articles NNS News NP Quick NP Polls NNS Feature VVP Comparison NN Interviews NNS MySQL NP 5 CD . SENT 0 CD Technical NP FAQ NP Last JJ updated VVN August NP 2 CD , , 2005 CD General NP When WRB will MD MySQL NP 5 CD . SENT 0 CD become VVN Production NP GA NP . SENT Can MD MySQL NP 5 CD . SENT 0 CD do VVP subqueries NNS . SENT Can MD MySQL NP 5 CD . SENT 0 CD do NP multi NNS table NN inserts NNS and CC updates NNS . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD have VHP a DT Query NP Cache NP . SENT Does VVZ it PP work VV on IN Server NP , , Instance NN or CC Database NN . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD have VHP Sequences NNS . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD have VHP a DT NOW RB with IN fractions NNS of IN seconds NNS . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD work NN with IN Dual JJ Core NP Opterons NP . SENT Is VBZ there RB a DT MyISAM NP Hot NP Backup NN like IN the DT InnoDB NP Hot NP Backup NN . SENT . SENT Is VBZ there RB any DT improvement NN in IN error NN reporting NN when WRB Foreign NP Key NP fails VVZ i NP . SENT e SYM . SENT currently RB does VVZ not RB report VV which WDT column NN and CC reference NN failed VVD . SENT Can MD MySQL NP 5 CD . SENT 0 CD do VVP ACID JJ Transactions NNS . SENT Storage NN Engines NNS What WP are VBP the DT new JJ Storage NN Engines NNS in IN MySQL NP 5 CD . SENT 0 CD . SENT What WP are VBP the DT unique JJ benefits NNS of IN the DT ARCHIVE NP Storage NP Engine NP . SENT Do VV the DT new JJ features NNS in IN MySQL NP 5 CD . SENT 0 CD apply VVP to TO all PDT the DT Storage NP Engines NNS . SENT Server NP SQL NP Mode NP What WP is VBZ Server NP SQL NP Mode NP . SENT How WRB many JJ modes NNS are VBP there RB in IN Server NP SQL NP Mode NP . SENT How WRB do VVP you PP configure VV Server NP SQL NP Mode NP . SENT Is VBZ the DT mode NN dependent JJ on IN the DT Database NN or CC the DT Connection NN . SENT Can MD Strict JJ Mode NP rules NNS be VB extended VVN . SENT Does VVZ Strict JJ Mode NP impact NN performance NN . SENT What WP is VBZ the DT default NN mode NN when WRB MySQL NP 5 CD . SENT 0 CD is VBZ installed VVN . SENT Stored VVN Procedures NNS Where WRB can MD I PP find VV documentation NN for IN MySQL NP Stored VVD Procedures NNS . SENT Where WRB is VBZ the DT discussion NN forum NN for IN MySQL NP Stored VVD Procedures NNS . SENT Where WRB can MD I PP find VV the DT ANSI NP SQL NP 2003 CD specification NN for IN Stored VVN Procedures NNS . SENT How WRB do VVP you PP manage VV Stored VVN Procedures NNS . SENT Is VBZ there RB a DT way NN to TO view VV all DT Stored VVN Procedures NNS in IN a DT database NN . SENT Where WRB are VBP Stored VVN Procedures NNS stored VVN . SENT Is VBZ it PP possible JJ to TO group NN SPs NP into IN a DT package NN e NN . SENT g NN . SENT like IN Oracle NP . SENT Can MD a DT SP NP call VVP another DT SP NP . SENT Can MD a DT SP NP call VVP a DT Trigger NN . SENT Can MD SPs NP access NN a DT single JJ Table NN . SENT Multiple JJ Tables NP . SENT Do VV SPs NP have VH a DT raise NN statement NN to TO raise VV application NN errors NNS . SENT Do VV SPs NP have VH Exception NN Handling NN . SENT Can MD SPs NP return NN result NN sets VVZ as RB do VV MS NN SQL NP and CC Sybase NP . SENT Can MD I PP do VV a DT WITH IN RECOMPILE NP for IN SPs NP . SENT Oracle NP uses VVZ mod JJ plsql NN as IN a DT gateway NN on IN Apache NP to TO talk VV directly RB to TO a DT SP NP in IN the DT database NN . SENT What WP is VBZ the DT MySQL NP equivalent NN . SENT Can MD I PP pass VV an DT array NN as IN input NN to TO a DT SP NP . SENT Can MD I PP pass VV a DT cursor NN as IN an DT IN IN parameter NN to TO a DT SP NP . SENT Can MD I PP return VV a DT cursor NN as IN an DT OUT JJ parameter NN from IN a DT SP NP . SENT Can MD I PP print VV out RP a DT variable JJ value NN in IN a DT SP NP for IN debugging VVG . SENT Can MD I PP do VV a DT Transaction NN inside IN a DT SP NP i NP . SENT e SYM . SENT committing VVG or CC rolling VVG back RB a DT set NN of IN SQL NP statements NNS in IN a DT batch NN . SENT Triggers VVZ Where WRB can MD I PP find VV documentation NN for IN MySQL NP Triggers VVZ . SENT Where WRB is VBZ the DT discussion NN forum NN for IN MySQL NP Triggers VVZ . SENT Do VV you PP have VHP Statement NN level NN Triggers VVZ or CC Row NN level NN Triggers VVZ . SENT Are VBP there RB any DT default NN Triggers VVZ . SENT How WRB do VVP you PP manage VVP Triggers VVZ . SENT Is VBZ there RB a DT way NN to TO view VV all DT Triggers VVZ in IN a DT Database NN . SENT Where WRB are VBP Triggers NNS stored VVD . SENT Can MD a DT Trigger NN call VVP a DT Stored VVN Procedure NN . SENT Can NN Triggers VVZ access NN a DT single JJ Table NN . SENT Multiple JJ Tables NP . SENT Can NN Triggers VVZ call VV an DT external JJ application NN through IN a DT UDF NP . SENT Is VBZ there RB an DT example NN of IN a DT Trigger NN updating VVG Tables NP on IN remote JJ servers NNS . SENT Views VVZ Where WRB can MD I PP find VV documentation NN for IN MySQL NP Views NNS . SENT Where WRB is VBZ the DT discussion NN forum NN for IN MySQL NP Views NNS . SENT What WP happens VVZ if IN an DT underlying JJ Table NN is VBZ dropped VVN , , renamed VVD , , etc FW . SENT . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD have VHP Table NN Snapshots NNS . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD have VHP Materialized VVN Views NNS . SENT Can MD you PP insert VV into IN Views NNS based VVN on IN Joins NNS . SENT Can MD updating VVG a DT View NP affect VV multiple JJ tables NNS or CC single JJ table NN . SENT INFORMATION NN SCHEMA NN Where WRB can MD I PP find VV documentation NN for IN MySQL NP INFORMATION NN SCHEMA NN . SENT Where WRB is VBZ the DT discussion NN forum NN for IN MySQL NP INFORMATION NN SCHEMA NN . SENT Where WRB can MD I PP find VV the DT ANSI NP SQL NP 2003 CD specification NN for IN INFORMATION NN SCHEMA NN . SENT What WP is VBZ the DT difference NN between IN the DT Oracle NP Data NP Dictionary NP and CC MySQL NP INFORMATION NN SCHEMA NN . SENT Can MD I PP organize VV groups NNS of IN Tables NP in IN MySQL NP e NN . SENT g NN . SENT PostgreSQL NP does VVZ this DT with IN SCHEMA NN . SENT Can MD I PP add VV or CC modify VV the DT Tables NP in IN the DT INFORMATION NN SCHEMA NN . SENT Connectors NNS Does VVZ MySQL NP Connector NN J NP work NN with IN the DT new JJ features NNS in IN MySQL NP 5 CD . SENT 0 CD . SENT Does NP MySQL NP Connector NN NET JJ work NN with IN the DT new JJ features NNS in IN MySQL NP 5 CD . SENT 0 CD . SENT Does NP MySQL NP Connector NN ODBC NP work NN with IN the DT new JJ features NNS in IN MySQL NP 5 CD . SENT 0 CD . SENT Does NP DBD NP . SENT . SENT MySQL NP the DT Perl NP MySQL NP driver NN work NN with IN the DT new JJ features NNS in IN MySQL NP 5 CD . SENT 0 CD . SENT Do VV the DT mysql NN and CC mysqli NN extensions NNS the DT PHP NP MySQL NP APIs NP work NN with IN the DT new JJ features NNS in IN MySQL NP 5 CD . SENT 0 CD . SENT Tools NNS Can MD Instance NN Manager NN enable VV management NN of IN remote JJ MySQL NP servers NNS . SENT Can MD you PP run VV Instance NN Manager NN on IN a DT Windows NNS machine NN to TO manage VV MySQL NP on IN remote JJ Linux NP machines NNS . SENT Are VBP GUI NP Graphical JJ User NP Interface NP Tools NP available JJ on IN Linux NP . SENT Can MD MySQL NP Administrator NP work NN with IN the DT new JJ features NNS in IN MySQL NP 5 CD . SENT 0 CD . SENT Can MD MySQL NP Query NP Browser NN work NN with IN the DT new JJ features NNS in IN MySQL NP 5 CD . SENT 0 CD . SENT Can MD you PP use VV MySQL NP GUI NP Tools NP to TO build VV Stored VVN Procedures NNS and CC Views NNS . SENT When WRB will MD Backup JJ Restore NP and CC mysqldump NN work NN with IN SPs NP . SENT When WRB will MD mysqldump VV actually RB dump VV the DT definitions NNS of IN SPs NP , , Triggers VVZ , , and CC Functions NNS . SENT Cluster NN Does VVZ MySQL NP 5 CD . SENT 0 CD work NN with IN MySQL NP Cluster NP . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD provide VVP any DT new JJ features NNS capabilities NNS for IN MySQL NP Cluster NP . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD include VVP a DT disk NN based VVN MySQL NP Cluster NP . SENT Migration NN How WRB do VVP you PP migrate VV from IN MySQL NP 4 CD . SENT x SYM to TO 5 CD . SENT 0 CD . SENT Have VHP the DT Table NN Types NNS changed VVN from IN MySQL NP 4 CD . SENT x SYM to TO 5 CD . SENT 0 CD . SENT Security NP Does NP MySQL NP 5 CD . SENT 0 CD have VHP native JJ support NN for IN SSL NP . SENT Will MD the DT SSL NP Support NN be VB built VVN into IN the DT MySQL NP Binaries NNS or CC will MD it PP require VV a DT recompile NN . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD have VHP built VVN in IN Authentication NN against IN LDAP NP directories NNS . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD have VHP built VVN in IN Roles NP Based VVN Access NP Control NP RBAC NP . SENT General JJ GEN NN 1 CD . SENT When WRB will MD MySQL NP 5 CD . SENT 0 CD become VVN Production NP GA NP . SENT Quality NN has VHZ an DT overriding JJ priority NN in IN our PP$ release NN schedule NN . SENT MySQL NP 5 CD . SENT 0 CD is VBZ currently RB in IN its PP$ beta JJ phase NN , , with IN the DT gamma NN release NN candidate NN following NN . SENT Your PP$ assistance NN with IN the DT MySQL NP 5 CD . SENT 0 CD QA NP Quality NP Assurance NP process NN is VBZ most RBS appreciated VVN , , see VV http NN . SENT dev NP . SENT mysql NN . SENT com NN tech NN resources NNS articles NNS evaluating VVG mysql NP 5 CD . SENT 0 CD . SENT html NN for IN details NNS . SENT Thank VV you PP for IN helping VVG us PP make VV this DT new JJ release NN top JJ quality NN . SENT GEN NN 2 CD . SENT Can MD MySQL NP 5 CD . SENT 0 CD do VVP subqueries NNS . SENT Yes UH . SENT MySQL NP supports VVZ subqueries NNS since IN version NN 4 CD . SENT 1 CD See NP http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN subqueries NNS . SENT html NN GEN NN 3 CD . SENT Can MD MySQL NP 5 CD . SENT 0 CD do NP multi NNS table NN inserts NNS and CC updates NNS . SENT Yes UH . SENT Multi NNS table NN UPDATE NN and CC DELETE VV were VBD actually RB implemented VVN in IN MySQL NP 4 CD . SENT 0 CD , , with IN enhancements NNS added VVN in IN MySQL NP 4 CD . SENT 1 LS . SENT See VV http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN UPDATE NN . SENT html NN and CC http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN DELETE VV . SENT html NN GEN NN 4 CD . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD have VHP a DT Query NP Cache NP . SENT Does VVZ it PP work VV on IN Server NP , , Instance NN or CC Database NN . SENT Yes UH . SENT The DT Query NP Cache NP was VBD introduced VVN in IN MySQL NP 4 CD . SENT 0 CD , , and CC operates VVZ on IN the DT server NN level NN . SENT It PP caches NNS complete JJ result NN sets NNS , , matched VVN with IN the DT original JJ query NN string NN . SENT If IN an DT exactly RB identical JJ query NN is VBZ made VVN which WDT often RB happens VVZ , , particularly RB in IN web NN applications NNS , , no RB parsing VVG or CC execution NN is VBZ necessary JJ , , the DT result NN is VBZ sent VVN directly RB from IN the DT cache NN . SENT Various JJ tuning VVG options NNS are VBP available JJ . SENT See VV http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN query NN cache NN . SENT html NN GEN NN 5 CD . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD have VHP Sequences NNS . SENT No UH . SENT However RB , , MySQL NP has VHZ an DT AUTO NN INCREMENT NN system NN , , which WDT in IN MySQL NP 5 CD . SENT 0 CD can MD also RB handle VV inserts NNS in IN a DT multi NNS master NN replication NN setup NN . SENT With IN the DT auto NN increment NN increment NN and CC auto NN increment NN offset VVN startup NN options NNS , , you PP can MD set VV each DT server NN to TO generate VV auto NN increment NN values NNS that IN don't JJ conflict NN with IN other JJ servers NNS . SENT The DT auto NN increment NN increment NN should MD be VB the DT number NN of IN servers NNS , , and CC each DT server NN should MD have VH a DT unique JJ offset VVN . SENT GEN NN 6 CD . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD have VHP a DT NOW RB with IN fractions NNS of IN seconds NNS . SENT No UH . SENT This DT is VBZ on IN the DT MySQL NP roadmap NN as IN a DT rolling JJ feature NN . SENT This DT means VVZ that IN it PP is VBZ not RB a DT flagship JJ feature NN , , but CC will MD be VB implemented VVN , , development NN time NN permitting VVG . SENT Specific JJ customer NN demand NN may MD change VV this DT scheduling NN . SENT MySQL NP will MD however RB parse VV time NN strings NNS with IN a DT fractional JJ component NN . SENT See VV http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN time NN . SENT html NN GEN NN 7 CD . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD work NN with IN Dual JJ Core NP Opterons NP . SENT Yes UH . SENT MySQL NP is VBZ fully RB multi NNS threaded VVD , , and CC will MD make VV use NN of IN multiple JJ CPUs NP provided VVD the DT operating NN system NN supports VVZ it PP . SENT GEN NN 8 CD . SENT Is VBZ there RB a DT MyISAM NP Hot NP Backup NN like IN the DT InnoDB NP Hot NP Backup NN . SENT This DT is VBZ currently RB under IN development NN , , and CC scheduled VVN for IN MySQL NP 5 CD . SENT 1 CD . SENT GEN NN 9 CD . SENT Is VBZ there RB any DT improvement NN in IN error NN reporting NN when WRB Foreign NP Key NP fails VVZ i NP . SENT e SYM . SENT currently RB does VVZ not RB report VV which WDT column NN and CC reference NN failed VVD . SENT The DT foreign JJ key JJ support NN in IN InnoDB NP has VHZ seen VVN improvements NNS in IN each DT major JJ version NN of IN MySQL NP . SENT However RB , , global JJ foreign JJ key JJ support NN i NP . SENT e SYM . SENT , , generically RB for IN all DT storage NN engines NNS is VBZ scheduled VVN for IN MySQL NP 5 CD . SENT 2 CD and CC should MD resolve VV any DT inadequacies NNS in IN the DT current JJ storage NN engine NN specific JJ implementation NN . SENT GEN NN 10 CD . SENT Can MD MySQL NP 5 CD . SENT 0 CD do VVP ACID JJ Transactions NNS . SENT Yes UH . SENT MySQL NP has VHZ supported VVN transactions NNS for IN years NNS now RB , , since IN 3 CD . SENT 23 CD Max NP and CC all DT versions NNS 4 CD . SENT 0 CD and CC above RB . SENT The DT InnoDB NP storage NN engine NN offers VVZ full JJ ACID JJ transactions NNS with IN row NN level NN locking VVG , , multi NNS versioning NN , , non JJ locking VVG repeatable JJ reads VVZ , , and CC all DT four CD SQL NP standard JJ isolation NN levels NNS . SENT Storage NN Engines NNS ST NP 1 CD . SENT What WP are VBP the DT new JJ Storage NN Engines NNS in IN MySQL NP 5 CD . SENT 0 CD . SENT The DT FEDERATED VVN storage NN engine NN , , new JJ in IN MySQL NP 5 CD . SENT 0 CD , , allows VVZ the DT server NN to TO access VV tables NNS in IN other JJ remote JJ servers NNS . SENT See VV http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN federated VVN storage NN engine NN . SENT html NN MySQL NP 4 CD . SENT 1 CD already RB added VVD other JJ new JJ storage NN engines NNS , , such JJ as IN ARCHIVE NP , , CSV NP and CC NDB NP Cluster NP . SENT ST NP 2 CD . SENT What WP are VBP the DT unique JJ benefits NNS of IN the DT ARCHIVE NP Storage NP Engine NP . SENT The DT ARCHIVE NP Storage NP Engine NP , , added VVD in IN MySQL NP 4 CD . SENT 1 CD , , is VBZ ideally RB suited VVN for IN storing VVG large JJ amounts NNS of IN data NNS without IN indexes NNS in IN a DT very RB small JJ footprint NN , , and CC selects VVZ using VVG table NN scans NNS . SENT See VV http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN archive NP storage NN engine NN . SENT html NN for IN details NNS . SENT ST NP 3 CD . SENT Do VV the DT new JJ features NNS in IN MySQL NP 5 CD . SENT 0 CD apply VVP to TO all PDT the DT Storage NP Engines NNS . SENT The DT general JJ new JJ features NNS such JJ as IN views NNS , , stored VVD procedures NNS , , triggers VVZ , , INFORMATION NN SCHEMA NN , , precision NN math NN DECIMAL JJ column NN type NN , , and CC the DT BIT NN column NN type NN , , apply VV to TO all DT storage NN engines NNS . SENT There EX are VBP also RB additions NNS and CC changes NNS for IN specific JJ storage NN engines NNS . SENT Server NP SQL NP Mode NP MODE NN 1 CD . SENT What WP is VBZ Server NP SQL NP Mode NP . SENT The DT MySQL NP server NN can MD operate VV in IN different JJ SQL NP modes NNS , , and CC as RB of IN MySQL NP 4 CD . SENT 1 CD can MD apply VV these DT modes NNS separately RB for IN different JJ clients NNS . SENT Modes NNS define VV what WP SQL NP syntax NN MySQL NP should MD support VV and CC what WP kind NN of IN data NN validation NN checks NNS it PP should MD perform VV . SENT This DT makes VVZ it PP easier JJR to TO use VV MySQL NP in IN different JJ environments NNS and CC to TO use VV MySQL NP together RB with IN other JJ database NN servers NNS . SENT For IN more JJR information NN , , see VV http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN server NN sql NN mode NN . SENT html NN MODE NN 2 CD . SENT How WRB many JJ modes NNS are VBP there RB in IN Server NP SQL NP Mode NP . SENT Quite PDT a DT few JJ , , as IN each DT mode NN can MD be VB individually RB switched VVN on RP and CC off RP . SENT See VV http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN server NN sql NN mode NN . SENT html NN for IN a DT full JJ current JJ list NN . SENT MODE NN 3 CD . SENT How WRB do VVP you PP configure VV Server NP SQL NP Mode NP . SENT You PP can MD set VV the DT default NN SQL NP mode NN for IN mysqld NN startup NN in IN the DT MySQL NP configuration NN with IN the DT sql NN mode NN option NN . SENT With IN SET VVN SESSION NN GLOBAL JJ sql NN mode NN modes NNS you PP can MD change VV the DT settings NNS from IN within IN a DT connection NN . SENT either CC local JJ to TO the DT connection NN , , or CC to TO take VV effect NN globally RB . SENT You PP can MD retrieve VV the DT current JJ mode NN by IN issuing VVG a DT SELECT JJ sql NN mode NN statement NN . SENT MODE NN 4 CD . SENT Is VBZ the DT mode NN dependent JJ on IN the DT Database NN or CC the DT Connection NN . SENT A DT mode NN is VBZ not RB linked VVN to TO a DT particular JJ database NN . SENT Modes NNS can MD be VB set VVN locally RB to TO the DT session NN connection NN , , or CC globally RB for IN the DT server NN With IN SET VVN SESSION NN GLOBAL JJ sql NN mode NN modes NNS you PP can MD change VV the DT settings NNS . SENT MODE NN 5 CD . SENT Can NN Strict JJ Mode NP rules NNS be VB extended VVN . SENT When WRB we PP refer VVP to TO strict JJ mode NN , , we PP mean VVP a DT mode NN where WRB at IN least JJS one CD of IN TRADITIONAL JJ , , STRICT JJ TRANS NP TABLES NNS , , or CC STRICT JJ ALL DT TABLES NNS is VBZ enabled VVN . SENT See VV also RB http JJ . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN server NN sql NN mode NN . SENT html NN Options NNS can MD be VB combined VVN , , so RB you PP can MD indeed RB add VV additional JJ restrictions NNS to TO a DT mode NN . SENT MODE NN 6 CD . SENT Does VVZ Strict JJ Mode NP impact NN performance NN . SENT Of IN course NN , , a DT setting VVG such JJ as IN the DT requirement NN for IN detailed JJ validation NN of IN input NN data NNS requires VVZ some DT additional JJ time NN . SENT While IN the DT performance NN impact NN is VBZ not RB that DT great JJ , , if IN you PP do VVP not RB require VV such JJ validation NN perhaps RB your PP$ application NN already RB handles VVZ all DT of IN this DT , , MySQL NP gives VVZ you PP the DT option NN of IN leaving VVG Strict JJ Mode NP disabled JJ . SENT But CC if IN you PP do VVP require VV it PP , , Strict JJ Mode NP delivers VVZ the DT validation NN you PP need VVP . SENT MODE NN 7 CD . SENT What WP is VBZ the DT default NN mode NN when WRB MySQL NP 5 CD . SENT 0 CD is VBZ installed VVN . SENT By IN default NN no DT special JJ modes NNS are VBP enabled VVN . SENT See VV http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN server NN sql NN mode NN . SENT html NN for IN information NN about IN all DT available JJ modes NNS and CC the DT default NN behaviour NN in IN 5 CD . SENT 0 CD . SENT Stored VVN Procedures NNS SP NP 1 CD . SENT Where WRB can MD I PP find VV documentation NN for IN MySQL NP Stored VVD Procedures NNS . SENT In IN the DT MySQL NP Reference NN Manual NP . SENT http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN stored VVN procedures NNS . SENT html NN SP NP 2 CD . SENT Where WRB is VBZ the DT discussion NN forum NN for IN MySQL NP Stored VVD Procedures NNS . SENT http NN . SENT forums NNS . SENT mysql NN . SENT com NN list NN . SENT php NN . SENT 98 CD SP NP 3 CD . SENT Where WRB can MD I PP find VV the DT ANSI NP SQL NP 2003 CD specification NN for IN Stored VVN Procedures NNS . SENT Unfortunately RB , , the DT official JJ specifications NNS are VBP not RB freely RB available JJ , , ANSI NP makes VVZ them PP available JJ for IN purchase NN . SENT However RB , , there EX are VBP books NNS available JJ , , such JJ as IN SQL NP 99 CD Complete JJ , , Really RB by IN Peter NP Gulutzan NP and CC Trudy NP Pelzer NP , , which WDT give VVP a DT comprehensive JJ overview NN of IN the DT standard JJ including VVG stored VVN procedures NNS . SENT SP NP 4 CD . SENT How WRB do VVP you PP manage VV Stored VVN Procedures NNS . SENT It PP is VBZ always RB good JJ practice NN to TO use VV a DT clear JJ naming NN scheme NN for IN your PP$ stored VVN procedures NNS . SENT You PP can MD manage VV stored VVN procedures NNS with IN CREATE VV FUNCTION NN PROCEDURE NN , , ALTER VV FUNCTION NN PROCEDURE NN , , DROP NN FUNCTION NN PROCEDURE NN , , and CC SHOW VV CREATE VV FUNCTION NN PROCEDURE NN , , INFORMATION NN SCHEMA NN see VVP http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN routines NNS table NN . SENT html NN . SENT SP NP 5 CD . SENT Is VBZ there RB a DT way NN to TO view VV all DT Stored VVN Procedures NNS in IN a DT database NN . SENT Yes UH , , using VVG the DT INFORMATION NN SCHEMA NN . SENT ROUTINES NNS table NN . SENT SELECT JJ ROUTINE JJ TYPE NN , , ROUTINE JJ NAME NN FROM IN INFORMATION NN SCHEMA NN . SENT ROUTINES NNS WHERE WRB ROUTINE JJ SCHEMA NN dbname NN . SENT See VV also RB http JJ . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN routines NNS table NN . SENT html NN The DT body NN of IN individual JJ stored VVN procedures NNS can MD be VB seen VVN through IN SHOW NN CREATE VVP FUNCTION NN PROCEDURE NN procname NN . SENT See VV also RB http JJ . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN show NN create VVP procedure NN . SENT html NN SP NP 6 CD . SENT Where WRB are VBP Stored VVN Procedures NNS stored VVD . SENT In IN the DT proc NN table NN in IN the DT mysql NN system NN database NN . SENT However RB , , you PP should MD not RB access VV the DT tables NNS in IN the DT system NN database NN directly RB . SENT Instead RB , , use VV SHOW NN CREATE VV FUNCTION NN PROCEDURE NN see VVP http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN show NN create VVP procedure NN . SENT html NN or CC INFORMATION NN SCHEMA NN see VVP http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN routines NNS table NN . SENT html NN SP NP 7 CD . SENT Is VBZ it PP possible JJ to TO group NN SPs NP into IN a DT package NN e NN . SENT g NN . SENT like IN Oracle NP . SENT No RB , , not RB at IN present NN . SENT SP NP 8 CD . SENT Can MD a DT SP NP call VVP another DT SP NP . SENT Yes UH . SENT SP NP 9 CD . SENT Can MD a DT SP NP call VVP a DT Trigger NN . SENT A DT stored VVN procedure NN could MD execute VV an DT SQL NP statement NN such JJ as IN an DT UPDATE NN that WDT causes VVZ a DT trigger NN to TO fire NN . SENT SP NP 10 NP . SENT Can MD SPs NP access NN a DT single JJ Table NN . SENT Multiple JJ Tables NP . SENT Yes NP and CC Yes NP . SENT SP NP 11 CD . SENT Do VV SPs NP have VH a DT raise NN statement NN to TO raise VV application NN errors NNS . SENT Sorry RB , , not RB at IN present NN . SENT The DT SQL NP standard NN SIGNAL NN and CC RESIGNAL JJ statements NNS are VBP on IN the DT TODO NP . SENT SP NP 12 CD . SENT Do VV SPs NP have VH Exception NN Handling NN . SENT MySQL NP implements VVZ HANDLER NN definitions NNS according VVG to TO the DT SQL NP standard NN . SENT See VV http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN declare VV handlers NNS . SENT html NN for IN details NNS . SENT SP NP 13 NP . SENT Can MD SPs NP return NN result NN sets VVZ as RB do VV MS NN SQL NP and CC Sybase NP . SENT Yes UH . SENT If IN you PP do VVP an DT ordinary JJ SELECT JJ inside IN a DT stored VVN procedure NN or CC function NN , , the DT result NN set NN is VBZ returned VVN directly RB to TO the DT client NN . SENT You PP will MD need VV to TO use VV the DT MySQL NP 4 CD . SENT 1 CD client NN server NN protocol NN for IN this DT to TO work VV . SENT This DT means VVZ that IN , , for IN instance NN in IN PHP NP , , you PP need VVP to TO use VV the DT mysqli NN extension NN rather RB than IN the DT old JJ mysql NN extension NN . SENT SP NP 14 NP . SENT Can MD I PP do VV a DT WITH IN RECOMPILE NP for IN SPs NP . SENT Not RB at IN present NN . SENT SP NP 15 CD . SENT Oracle NP uses VVZ mod JJ plsql NN as IN a DT gateway NN on IN Apache NP to TO talk VV directly RB to TO a DT SP NP in IN the DT database NN . SENT What WP is VBZ the DT MySQL NP equivalent NN . SENT There EX is VBZ no DT equivalent NN at IN present NN . SENT Implementation NN of IN this DT should MD not RB be VB too RB difficult JJ . SENT Perhaps RB an DT active JJ community NN user NN will MD step VV up RP to TO the DT challenge NN . SENT SP NP 16 NP . SENT Can MD I PP pass VV an DT array NN as IN input NN to TO a DT SP NP . SENT No UH . SENT SP NP 17 NP . SENT Can MD I PP pass VV a DT cursor NN as IN an DT IN IN parameter NN to TO a DT SP NP . SENT No UH . SENT Currently RB , , cursors NNS are VBP only RB available JJ inside IN stored VVN procedures NNS . SENT SP NP 18 NP . SENT Can MD I PP return VV a DT cursor NN as IN an DT OUT JJ parameter NN from IN a DT SP NP . SENT No UH . SENT Currently RB , , cursors NNS are VBP only RB available JJ inside IN stored VVN procedures NNS . SENT However RB , , you PP can MD return VV a DT result NN set VVN from IN a DT SELECT JJ by IN not RB opening VVG a DT cursor NN on IN it PP it PP will MD be VB sent VVN directly RB to TO the DT client NN , , or CC by IN selecting VVG into IN variables NNS . SENT SP NP 19 NP . SENT Can MD I PP print VV out RP a DT variable JJ value NN in IN a DT SP NP for IN debugging VVG . SENT Yes UH , , if IN you PP do VVP an DT ordinary JJ SELECT JJ inside IN a DT stored VVN procedure NN or CC function NN , , the DT result NN set NN is VBZ returned VVN directly RB to TO the DT client NN . SENT You PP will MD need VV to TO use VV the DT MySQL NP 4 CD . SENT 1 CD client NN server NN protocol NN for IN this DT to TO work VV . SENT This DT means VVZ that IN , , for IN instance NN in IN PHP NP , , you PP need VVP to TO use VV the DT mysqli NN extension NN rather RB than IN the DT old JJ mysql NN extension NN . SENT SP NP 20 NP . SENT Can MD I PP do VV a DT Transaction NN inside IN a DT SP NP i NP . SENT e SYM . SENT committing VVG or CC rolling VVG back RB a DT set NN of IN SQL NP statements NNS in IN a DT batch NN . SENT No UH . SENT Triggers VVZ TRG NP 1 CD . SENT Where WRB can MD I PP find VV documentation NN for IN MySQL NP Triggers VVZ . SENT In IN the DT MySQL NP Reference NN Manual NP . SENT http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN show NN create VVP procedure NN . SENT html NN TRG NP 2 CD . SENT Where WRB is VBZ the DT discussion NN forum NN for IN MySQL NP Triggers VVZ . SENT http NN . SENT forums NNS . SENT mysql NN . SENT com NN list NN . SENT php NN . SENT 99 CD TRG NP 3 CD . SENT Do VV you PP have VHP Statement NN level NN Triggers VVZ or CC Row NN level NN Triggers VVZ . SENT All DT triggers NNS are VBP FOR IN EACH DT ROW NN , , that WDT is VBZ , , the DT trigger NN is VBZ activated VVN for IN each DT row NN that WDT is VBZ inserted VVN updated VVD deleted VVN . SENT We PP currently RB don't VVD allow VV FOR IN EACH DT STATEMENT NN triggers VVZ . SENT TRG NP 4 CD . SENT Are VBP there RB any DT default NN Triggers VVZ . SENT Not RB explicitly RB . SENT MySQL NP does VVZ have VH specific JJ special JJ behavior NN for IN some DT TIMESTAMP NP columns NNS , , and CC columns NNS defined VVN as IN AUTO NN INCREMENT NN . SENT TRG NP 5 CD . SENT How WRB do VVP you PP manage VVP Triggers VVZ . SENT A DT trigger NN can MD be VB created VVN with IN a DT CREATE VVP TRIGGER NN statement NN . SENT See VV http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN triggers VVZ . SENT html NN for IN details NNS . SENT Management NN features NNS through IN , , for IN instance NN , , INFORMATION NN SCHEMA NN are VBP currently RB being VBG implemented VVN . SENT TRG NP 6 CD . SENT Is VBZ there RB a DT way NN to TO view VV all DT Triggers VVZ in IN a DT Database NN . SENT Yes UH , , using VVG the DT INFORMATION NN SCHEMA NN . SENT TRIGGERS VVZ table NN . SENT SELECT JJ TRIGGER NN NAME NN , , EVENT NN MANIPULATION NN , , EVENT NN OBJECT NN TABLE NN , , ACTION NN STATEMENT NN FROM IN INFORMATION NN SCHEMA NN . SENT TRIGGERS VVZ WHERE WRB TRIGGER NN SCHEMA NN dbname NN . SENT See VV also RB http JJ . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN triggers VVZ table NN . SENT html NN You PP can MD also RB use VV the DT MySQL NP specific JJ SHOW NN TRIGGERS VVZ statement NN . SENT See VV also RB http JJ . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN show NN create VVP triggers VVZ . SENT html NN TRG NP 7 CD . SENT Where WRB are VBP Triggers NNS stored VVD . SENT Currently RB , , Triggers NNS are VBP stored VVN individually RB for IN each DT table NN in IN a DT . SENT TRG NP file NN , , next JJ to TO the DT normal JJ . SENT FRM JJ file NN with IN the DT CREATE VVP TABLE NN information NN . SENT In IN the DT near JJ future NN , , the DT trigger NN information NN will MD be VB included VVN in IN the DT . SENT FRM NN structure NN . SENT In IN a DT nutshell NN , , triggers VVZ belong VV with IN a DT table NN . SENT Work NN is VBZ currently RB being VBG done VVN to TO make VV triggers VVZ database NN level NN objects NNS as RB opposed VVN to TO table NN level NN as IN they PP are VBP now RB and CC mentioned VVN above IN as RB prescribed VVN by IN the DT SQL NP standard NN . SENT TRG NP 8 CD . SENT Can MD a DT Trigger NN call VVP a DT Stored VVN Procedure NN . SENT Yes UH . SENT TRG NP 9 CD . SENT Can NN Triggers VVZ access NN a DT single JJ Table NN . SENT Multiple JJ Tables NP . SENT A DT trigger NN can MD access VV information NN in IN its PP$ own JJ table NN , , both CC the DT old JJ and CC the DT new JJ data NNS . SENT Through IN a DT stored VVN procedure NN , , or CC a DT multi NNS table NN update NN or CC delete VV statement NN , , a DT trigger NN can MD also RB affect VV multiple JJ other JJ tables NNS . SENT TRG NP 10 CD . SENT Can NN Triggers VVZ call VV an DT external JJ application NN through IN a DT UDF NP . SENT No RB , , not RB at IN present NN . SENT TRG NP 11 NP . SENT Is VBZ there RB an DT example NN of IN a DT Trigger NN updating VVG Tables NP on IN remote JJ servers NNS . SENT Yes UH , , a DT table NN on IN a DT remote JJ server NN could MD be VB updated VVN through IN the DT FEDERATED VVN storage NN engine NN see VVP http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN federated VVN storage NN engine NN . SENT html NN . SENT Views NNS VW NP 1 CD . SENT Where WRB can MD I PP find VV documentation NN for IN MySQL NP Views NNS . SENT In IN the DT MySQL NP Reference NN Manual NP . SENT http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN views NNS . SENT html NN VW NP 2 CD . SENT Where WRB is VBZ the DT discussion NN forum NN for IN MySQL NP Views NNS . SENT http NN . SENT forums NNS . SENT mysql NN . SENT com NN list NN . SENT php NN . SENT 100 CD VW NP 3 CD . SENT What WP happens VVZ if IN an DT underlying JJ Table NN is VBZ dropped VVN , , renamed VVD , , etc FW . SENT After IN a DT view NN has VHZ been VBN created VVN , , it PP is VBZ possible JJ to TO drop VV or CC alter VV a DT table NN or CC view NN to TO which WDT the DT definition NN refers VVZ . SENT To TO check VV a DT view NN definition NN for IN problems NNS of IN this DT kind NN , , use VVP the DT CHECK NN TABLE NN statement NN . SENT VW NP 4 CD . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD have VHP Table NN Snapshots NNS . SENT No UH . SENT VW NP 5 CD . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD have VHP Materialized VVN Views NNS . SENT No UH . SENT VW NP 6 CD . SENT Can MD you PP insert VV into IN Views NNS based VVN on IN Joins NNS . SENT It PP is VBZ possible JJ , , provided VVN that IN your PP$ INSERT NN statement NN has VHZ a DT column NN list NN that WDT makes VVZ it PP clear VV there's RB only RB one CD table NN involved VVN . SENT You PP cannot NN insert NN into IN multiple JJ tables NNS with IN a DT single JJ statement NN . SENT VW NP 7 CD . SENT Can MD updating VVG a DT View NP affect VV multiple JJ tables NNS or CC single JJ table NN . SENT Only RB a DT single JJ table NN . SENT INFORMATION NN SCHEMA NN IS VBZ 1 CD . SENT Where WRB can MD I PP find VV documentation NN for IN MySQL NP INFORMATION NN SCHEMA NN . SENT In IN the DT MySQL NP Reference NN Manual NP . SENT http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN information NN schema NN tables NNS . SENT html NN IS VBZ 2 CD . SENT Where WRB is VBZ the DT discussion NN forum NN for IN MySQL NP INFORMATION NN SCHEMA NN . SENT http NN . SENT forums NNS . SENT mysql NN . SENT com NN list NN . SENT php NN . SENT 101 CD IS VBZ 3 CD . SENT Where WRB can MD I PP find VV the DT ANSI NP SQL NP 2003 CD specification NN for IN INFORMATION NN SCHEMA NN . SENT Unfortunately RB , , the DT official JJ specifications NNS are VBP not RB freely RB available JJ , , ANSI NP makes VVZ them PP available JJ for IN purchase NN . SENT However RB , , there EX are VBP books NNS available JJ , , such JJ as IN SQL NP 99 CD Complete JJ , , Really RB by IN Peter NP Gulutzan NP and CC Trudy NP Pelzer NP , , which WDT give VVP a DT comprehensive JJ overview NN of IN the DT standard JJ including VVG INFORMATION NN SCHEMA NN . SENT IS VBZ 4 CD . SENT What WP is VBZ the DT difference NN between IN the DT Oracle NP Data NP Dictionary NP and CC MySQL NP INFORMATION NN SCHEMA NN . SENT At IN the DT overview NN level NN . SENT no DT difference NN , , both CC Oracle NP and CC MySQL NP provide VVP metadata NN information NN in IN tables NNS . SENT At IN the DT detail NN level NN . SENT many JJ differences NNS , , because IN Oracle NP and CC MySQL NP use VVP different JJ table NN names NNS and CC column NN names NNS for IN that DT metadata NN information NN . SENT There EX is VBZ more JJR similarity NN with IN DB NP 2 CD and CC SQL NP Server NP , , which WDT also RB has VHZ an DT INFORMATION NN SCHEMA NN as IN in IN the DT SQL NP standard NN . SENT IS VBZ 5 CD . SENT Can MD I PP organize VV groups NNS of IN Tables NP in IN MySQL NP e NN . SENT g NN . SENT PostgreSQL NP does VVZ this DT with IN SCHEMA NN . SENT Groups NNS of IN tables NNS are VBP organized VVN in IN a DT database NN . SENT In IN most JJS cases NNS with IN MySQL NP , , you PP can MD regard VV a DT database NN as IN equivalent NN to TO a DT schema NN . SENT IS VBZ 6 CD . SENT Can MD I PP add VV or CC modify VV the DT Tables NP in IN the DT INFORMATION NN SCHEMA NN . SENT No UH . SENT Applications NNS may MD rely VV on IN a DT certain JJ standard JJ structure NN , , this DT should MD not RB be VB modified VVN . SENT Connectors NNS CON NN 1 CD . SENT Does NP MySQL NP Connector NN J NP work NN with IN the DT new JJ features NNS in IN MySQL NP 5 CD . SENT 0 CD . SENT Partially RB . SENT Although IN version NN 3 CD . SENT 51 CD does VVZ not RB support VV stored VVN procedure NN calls NNS using VVG escape NN syntax NN i NP . SENT e SYM . SENT , , call VV . SENT . SENT . SENT , , or CC the DT server NN side NN stored VVD procedures NNS , , version NN 3 CD . SENT 53 CD , , currently RB in IN development NN , , will MD . SENT The DT JDBC NP forum NN is VBZ at IN http NN . SENT forums NNS . SENT mysql NN . SENT com NN list NN . SENT php NN . SENT 39 CD . SENT CON NN 2 CD . SENT Does NP MySQL NP Connector NN NET JJ work NN with IN the DT new JJ features NNS in IN MySQL NP 5 CD . SENT 0 CD . SENT Yes UH . SENT The DT . SENT Net JJ forum NN is VBZ at IN http NN . SENT forums NNS . SENT mysql NN . SENT com NN list NN . SENT php NN . SENT 38 CD . SENT CON NN 3 CD . SENT Does NP MySQL NP Connector NN ODBC NP work NN with IN the DT new JJ features NNS in IN MySQL NP 5 CD . SENT 0 CD . SENT Yes UH . SENT The DT ODBC NP forum NN is VBZ at IN http NN . SENT forums NNS . SENT mysql NN . SENT com NN list NN . SENT php NN . SENT 37 CD . SENT CON NN 4 CD . SENT Does NP DBD NP . SENT . SENT MySQL NP the DT Perl NP MySQL NP driver NN work NN with IN the DT new JJ features NNS in IN MySQL NP 5 CD . SENT 0 CD . SENT Yes UH . SENT The DT Perl NP forum NN is VBZ at IN http NN . SENT forums NNS . SENT mysql NN . SENT com NN list NN . SENT php NN . SENT 51 CD . SENT CON NN 5 CD . SENT Do VV the DT mysql NN and CC mysqli NN extensions NNS the DT PHP NP MySQL NP APIs NP work NN with IN the DT new JJ features NNS in IN MySQL NP 5 CD . SENT 0 CD . SENT The DT old JJ mysql NN extension NN can MD work VV with IN MySQL NP 5 CD . SENT 0 CD , , but CC does VVZ not RB support VV the DT new JJ authentication NN protocol NN MySQL NP 4 CD . SENT 1 CD , , prepared VVN statements NNS MySQL NP 4 CD . SENT 1 CD , , cursors NNS , , or CC multiple JJ result NN sets NNS . SENT Only RB the DT new JJ mysqli NN extension NN PHP NP 5 CD . SENT 0 CD and CC up RB covers VVZ and CC supports VVZ all DT features NNS of IN MySQL NP 4 CD . SENT 1 CD and CC 5 CD . SENT 0 CD . SENT The DT PHP NP forum NN is VBZ at IN http NN . SENT forums NNS . SENT mysql NN . SENT com NN list NN . SENT php NN . SENT 52 CD . SENT Tools NNS TOOL NN 1 CD . SENT Can NN Instance NN Manager NN enable VV management NN of IN remote JJ MySQL NP servers NNS . SENT Yes UH . SENT See VV http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN instance NN manager NN . SENT html NN for IN more JJR information NN about IN the DT MySQL NP Instance NN Manager NN . SENT TOOL NN 2 CD . SENT Can MD you PP run VV Instance NN Manager NN on IN a DT Windows NNS machine NN to TO manage VV MySQL NP on IN remote JJ Linux NP machines NNS . SENT MySQL NP Instance NN Manager NN is VBZ currently RB only RB available JJ for IN Unix NP like IN operating VVG systems NNS . SENT This DT precludes VVZ Windows NNS . SENT A DT Windows NNS version NN is VBZ under IN active JJ development NN though RB , , and CC should MD be VB available JJ shortly RB . SENT TOOL NN 3 CD . SENT Are VBP GUI NP Graphical JJ User NP Interface NP Tools NP available JJ on IN Linux NP . SENT The DT following VVG MySQL NP GUI NP Tools NP are VBP available JJ for IN download NN . SENT MySQL NP Administrator NP for IN DBA NP tasks NNS , , MySQL NP Query NP Browser NN for IN developers NNS . SENT See VV http NN . SENT www JJ . SENT mysql NN . SENT com NN products NNS administrator NN and CC http NN . SENT www JJ . SENT mysql NN . SENT com NN products NNS query NN browser NN for IN details NNS on IN each DT of IN these DT tools NNS . SENT More JJR MySQL NP GUI NP Tools NP are VBP under IN development NN , , as RB well RB as IN continued JJ enhancements NNS to TO the DT existing JJ tools NNS . SENT The DT MySQL NP Administrator NP forum NN is VBZ at IN http NN . SENT forums NNS . SENT mysql NN . SENT com NN list NN . SENT php NN . SENT 34 CD . SENT The DT MySQL NP Query NP browser NN forum NN is VBZ at IN http NN . SENT forums NNS . SENT mysql NN . SENT com NN list NN . SENT php NN . SENT 108 CD . SENT TOOL NN 4 CD . SENT Can MD MySQL NP Administrator NP work NN with IN the DT new JJ features NNS in IN MySQL NP 5 CD . SENT 0 CD . SENT Yes UH . SENT TOOL NN 5 CD . SENT Can MD MySQL NP Query NP Browser NN work NN with IN the DT new JJ features NNS in IN MySQL NP 5 CD . SENT 0 CD . SENT Yes UH . SENT TOOL NN 6 CD . SENT Can MD you PP use VV MySQL NP GUI NP Tools NP to TO build VV Stored VVN Procedures NNS and CC Views NNS . SENT Additional JJ GUI NP Tool NP features VVZ to TO ease VV development NN and CC debugging VVG of IN Stored VVN Procedures NNS , , etc NN are VBP under IN development NN . SENT The DT GUI NP Tools NP have VHP a DT higher JJR release NN frequency NN and CC versions NNS with IN new JJ features NNS and CC fixes NNS are VBP released VVN frequently RB . SENT TOOL NN 7 CD . SENT When WRB will MD Backup JJ Restore NP and CC mysqldump NN work NN with IN SPs NP . SENT This DT is VBZ scheduled VVN for IN completion NN before IN the DT production NN GA NP version NN of IN MySQL NP 5 CD . SENT 0 CD is VBZ released VVN . SENT TOOL NN 8 CD . SENT When WRB will MD mysqldump VV actually RB dump VV the DT definitions NNS of IN SPs NP , , Triggers VVZ , , and CC Functions NNS . SENT This DT is VBZ scheduled VVN for IN completion NN before IN the DT production NN GA NP version NN of IN MySQL NP 5 CD . SENT 0 CD is VBZ released VVN . SENT Cluster NP CL NP 1 CD . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD work NN with IN MySQL NP Cluster NP . SENT Yes UH . SENT CL NP 2 CD . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD provide VVP any DT new JJ features NNS capabilities NNS for IN MySQL NP Cluster NP . SENT MySQL NP Cluster NP in IN 5 CD . SENT 0 CD introduces VVZ various JJ speed NN optimizations NNS , , as RB well RB as IN decreased VVN memory NN usage NN . SENT See VV http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN mysql NN 5 CD 0 CD cluster NN changes NNS . SENT html NN for IN more JJR details NNS . SENT CL NP 3 CD . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD include VVP a DT disk NN based VVN MySQL NP Cluster NP . SENT Not RB yet RB essential JJ infrastructure NN for IN this DT feature NN is VBZ currently RB under IN development NN , , but CC the DT full JJ feature NN is VBZ scheduled VVN on IN the DT MySQL NP roadmap NN as IN a DT rolling JJ feature NN . SENT This DT means VVZ that IN it PP is VBZ not RB a DT flagship JJ feature NN , , but CC will MD be VB implemented VVN , , development NN time NN permitting VVG . SENT Specific JJ customer NN demand NN may MD change VV this DT scheduling NN . SENT See VV also RB http JJ . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN mysql NN 5 CD 1 CD cluster NN roadmap NN . SENT html NN Migration NN MIG NP 1 CD . SENT How WRB do VVP you PP migrate VV from IN MySQL NP 4 CD . SENT x SYM to TO 5 CD . SENT 0 CD . SENT Detailed JJ upgrade JJ information NN for IN each DT version NN can MD be VB found VVN at IN http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN upgrade NN . SENT html NN . SENT We PP recommend VVP that IN you PP do VVP not RB skip VV a DT major JJ version NN when WRB upgrading VVG , , but CC rather RB upgrade VV in IN steps NNS for IN instance NN , , if IN you PP are VBP still RB using VVG MySQL NP 4 CD . SENT 0 CD but CC wish VVP to TO upgrade VV to TO 5 CD . SENT 0 CD , , upgrade VV your PP$ test NN system NN to TO 4 CD . SENT 1 CD first JJ , , and CC verify VV that DT everything NN is VBZ as IN it PP should MD be VB . SENT Then RB proceed VV with IN the DT 4 CD . SENT 1 CD to TO 5 CD . SENT 0 CD upgrade JJ step NN . SENT This DT may MD seem VV more RBR complicated JJ , , but CC it PP will MD probably RB save VV you PP time NN and CC hassle NN if IN you PP find VVP any DT problems NNS along IN the DT way NN , , their PP$ origin NN will MD be VB easier JJR to TO identify VV either RB by IN you PP or CC MySQL NP support NN , , if IN you PP have VHP a DT MySQL NP Network NP subscription NN . SENT MIG NP 2 CD . SENT Have VHP the DT Table NN Types NNS changed VVN from IN MySQL NP 4 CD . SENT x SYM to TO 5 CD . SENT 0 CD . SENT Support NN for IN the DT old JJ ISAM NP tables NNS used VVN until IN MySQL NP 3 CD . SENT 22 CD was VBD removed VVN in IN MySQL NP 5 CD . SENT 0 CD . SENT To TO convert VV a DT table NN from IN ISAM NP to TO MyISAM NP , , simply RB issue VV a DT statement NN like IN ALTER VV TABLE NN tblname NN ENGINE NN MYISAM NP . SENT The DT internal JJ RAID NN support NN in IN MyISAM NP tables NNS was VBD also RB removed VVN . SENT This DT was VBD an DT old JJ feature NN used VVN to TO allow VV large JJ tables NNS with IN file NN systems NNS that WDT did VVD not RB support VV large JJ 2 CD GB NN files NNS . SENT All DT modern JJ file NN systems NNS allow VVP for IN larger JJR tables NNS , , and CC there EX are VBP also RB other JJ solutions NNS such JJ as IN MERGE VV tables NNS and CC VIEWs NNS . SENT The DT VARCHAR NP column NN type NN now RB retains VVZ any DT trailing VVG spaces NNS all DT storage NN engines NNS . SENT MEMORY NN tables NNS called VVD HEAP NN , , prior RB to TO MySQL NP version NN 4 CD . SENT 1 CD can MD now RB also RB contain VV VARCHAR NP columns NNS . SENT Security NP SEC NP 1 CD . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD have VHP native JJ support NN for IN SSL NP . SENT Yes UH , , most RBS 5 CD . SENT 0 CD binaries NNS have VHP support NN for IN SSL NP secured VVN and CC or CC authenticated VVN connections NNS between IN the DT client NN and CC server NN . SENT We PP can't VVD yet RB build VV with IN the DT new JJ YaSSL NP library NN everywhere RB , , as IN it's NNS still RB quite RB new JJ and CC does VVZ not RB compile VV on IN all DT platforms NNS yet RB . SENT See VV http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN secure JJ connections NNS . SENT html NN You PP could MD also RB tunnel VV the DT connection NN via IN SSH NP , , for IN instance NN if IN the DT client NN application NN doesn't NN support NN SSL NP connections NNS . SENT For IN an DT example NN of IN this DT , , see VV http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN windows NNS and CC ssh NN . SENT html NN SEC NP 2 CD . SENT Will MD the DT SSL NP Support NN be VB built VVN into IN the DT MySQL NP Binaries NNS or CC will MD it PP require VV a DT recompile NN . SENT All DT 5 CD . SENT 0 CD binaries NNS have VHP support NN for IN SSL NP secured VVN and CC or CC authenticated VVN connections NNS between IN the DT client NN and CC server NN . SENT See VV http NN . SENT dev NP . SENT mysql NN . SENT com NN doc NN mysql NN en IN secure JJ connections NNS . SENT html NN SEC NP 3 CD . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD have VHP built VVN in IN Authentication NN against IN LDAP NP directories NNS . SENT No UH . SENT Support NN for IN external JJ authentication NN methods NNS is VBZ on IN the DT MySQL NP roadmap NN as IN a DT rolling JJ feature NN . SENT This DT means VVZ that IN it PP is VBZ not RB a DT flagship JJ feature NN , , but CC will MD be VB implemented VVN , , development NN time NN permitting VVG . SENT Specific JJ customer NN demand NN may MD change VV this DT scheduling NN . SENT SEC NP 4 CD . SENT Does VVZ MySQL NP 5 CD . SENT 0 CD have VHP built VVN in IN Roles NP Based VVN Access NP Control NP RBAC NP . SENT No UH . SENT Roles NNS are VBP on IN the DT MySQL NP roadmap NN as IN a DT rolling JJ feature NN . SENT This DT means VVZ that IN it PP is VBZ not RB a DT flagship JJ feature NN , , but CC will MD be VB implemented VVN , , development NN time NN permitting VVG . SENT Specific JJ customer NN demand NN may MD change VV this DT scheduling NN . SENT Back RB to TO Top JJ Of IN the DT five CD databases NNS we PP tested VVD , , only RB Oracle NP 9 CD i NP and CC MySQL NP were VBD able JJ to TO run VV our PP$ Nile NP application NN as IN originally RB written VVN for IN 8 CD hours NNS without IN problems NNS . SENT eWeek NN , , Server NP Databases NNS Clash NN Read VV more RBR about IN the DT benchmark NN . SENT . SENT . SENT . SENT Learn VV about IN new JJ MySQL NP releases NNS , , technical JJ articles NNS , , events NNS and CC more JJR . SENT Subscribe VV to TO the DT monthly JJ MySQL NP Newsletter NN . SENT 1995 CD 2005 CD MySQL NP AB NP . SENT All DT rights NNS reserved VVD . SENT About IN MySQL NP Careers NNS Site NN Map NN Contact NP Us NP Legal NP Privacy NN Policy NN Trademark NN Info NP