List:Internals« Previous MessageNext Message »
From:Girish Maskeri Rama Date:June 21 2006 11:38am
Subject:Mysql architecture
View as plain text  
Hi,

            We are trying to analyse the architecture of mysql with
respect to layering. As Petr suggested we reorganized the mapping of
modules to layers as follows:



Layer 3 (Application/top level) : client, libmysql, libmysqld,
libmysql_r, tests, mysql-test

Layer 2 (QueryProcessing) : sql

Layer 1 (StorageManagement) : heap, innobase, myisam, ndb, isam,
bdatabase, myisammrg, merge

Layer 0 (library/utilities) :
mysys,cmd-line-utils,extra,netware,os2,pstack,regex,zlib,vio,strings,SSL
,support-files,tools,include,dbug



The rationale for this layering is that the layer above would use the
services provided by layers below.



We have a couple of questions:

1.	There are 3 versions of sql_string.h : client/sql_string.h,
libmysqld/sql_string.h and sql/sql_string.h.  Do we need 3 versions? 
2.	libmysqld has a copy of many files that exist in other
directories (eg. Sql_cache.cc exists in both libmysqld and sql)  So if
one of the files change would you not have to make changes in both the
places?
3.	There are function calls from sql (in layer 2) to libmysqld (in
layer 3) . For example function "query_cache_end_of_result" in file
sql/sql_cache.cc calls the function "emb_count_querycache_size"  in file
libmysqld/emb_qcache.cc.   Is this intended?



Thanks in advance

Girish





**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use
of the addressee(s). If you are not the intended recipient, please notify the sender by
e-mail and delete the original message. Further, you are not to copy, disclose, or
distribute this e-mail or its contents to any other person and any such actions are
unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution
to minimize this risk, but is not liable for any damage you may sustain as a result of
any virus in this e-mail. You should carry out your own virus checks before opening the
e-mail or attachment. Infosys reserves the right to monitor and review the content of all
messages sent to or from this e-mail address. Messages sent to or from this e-mail address
may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
Thread
Mysql architectureGirish Maskeri Rama21 Jun
  • Re: Mysql architectureStewart Smith21 Jun
RE: Mysql architectureGirish Maskeri Rama21 Jun
  • Re: Mysql architectureJim Winstead21 Jun