"Saied Taghavi" <s.taghavi@stripped> wrote on 07/02/2005 07:58:10 AM:
> > "Saied Taghavi" <s.taghavi@stripped> wrote on 07/01/2005 11:34:06
AM:
> >
> >> hi every body
> >> we are working on source code of mysql for our file structure course
> >> project and during studying we found that mysql performs its work
with
> >> file
> >> system with storage engines . now my question :
> >> is thare another mechanism except storage engines for accessing file
> > system ?
> >>
> >> thanks a lot
> >>
> >
> > If I understand your question correctly, you would like to know if
there
> > are any commands or functions available to a USER of the server that
will
> > allow for direct manipulation of disk files. The only commands that
comes
> > close to doing what you ask are "LOAD DATA LOCAL INFILE ... "
> > (http://dev.mysql.com/doc/mysql/en/load-data.html) and "SELECT ...
INTO
> > OUTFILE" (http://dev.mysql.com/doc/mysql/en/select.html)
> >
> > Other than those two commands I can think of no other commands
(recognized
> > by a MySQL server) where the user can even specify a file name and
either
> > read from or write to that file. All other file-level access is hidden
> > below and managed within the abstractions provided by the storage
engine
> > interface.
> >
> > No user (or any other process, for that matter) should be allowed to
> > directly modify any file created or managed by any of the storage
engines
> > for a database server. To allow those kinds of changes invites
disaster.
> > "To Preserve Data Integrity" is the most important reason why there
are no
> > other file system access commands in MySQL.
> >
> > Shawn Green
> > Database Administrator
> > Unimin Corporation - Spruce Pine
> >
> >
>
> no my question is not how can users access to file systems with some
> commands . i know that MySQL implements working with file system with
> storage engines . is there another implementation except storage engine
?
>
I don't think you are asking your question correctly (it's a language
issue, no problem). We will work at this until we get it right, OK? MySQL
must use the file system for many things, most of it is related to storing
and retrieving actual data (data tables, indexes, etc). MySQL also needs
to read the file system to get its settings (my.ini/my.cnf) and for other
general purposes.
Are you trying to find out if MySQL accesses the file system through any
library/class/modules/... other than what is represented by the concept of
"storage engine"? I would say YES. For a complete picture of how MySQL
interacts with the file system, you could download the source and check it
yourself.... Is there a specific activity you are concerned about? Is
there something you noticed and you want to know if MySQL did it?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
