List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 6 2003 11:05pm
Subject:Re: Data file size
View as plain text  
At 15:59 -0700 6/6/03, Titu Kim wrote:
>Hi I am new to Mysql. I have the following newbie
>questions.
>
>1. How can i find/set the file size of for my .MYI and
>.MYD file?

You can find the sizes using ls on Unix or dir on Windows.
You don't set the sizes.  Let the server manage the files.

>2. How can i add another file to a table if the .MYD
>file grows too large?

Once the file size reaches its maximum, that's as far as you can go.

>
>3. How to configure mysql client to access two mysql
>database on two machines with each database using
>different port number?

Not sure what you mean?  Do you mean at the same time?
If so, you cannot do that.  If you mean at different
times, use appropriate --host and --port options
to specify the hostname and port number.


-- 
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Are you MySQL certified?  http://www.mysql.com/certification/

Thread
Data file sizeTitu Kim7 Jun
  • Re: Data file sizePaul DuBois7 Jun
    • Re: Data file sizePaul DuBois7 Jun
      • Re: Data file sizeTitu Kim7 Jun
      • Re: Data file sizeTitu Kim7 Jun
        • Re: Data file sizeWare Adams7 Jun