Re: Documenting and visualizing a database

2005-10-02 Thread Ligaya Turmelle
+1 - it is wonderful. olinux wrote: You will love this. http://www.fabforce.net/dbdesigner4/ Josh --- Jeffrey Goldberg <[EMAIL PROTECTED]> wrote: This is probably a FAQ, but I haven't been able to find the answer. Briefly, I am looking for tools that will help me document a database.

Re: Documenting and visualizing a database

2005-10-02 Thread olinux
You will love this. http://www.fabforce.net/dbdesigner4/ Josh --- Jeffrey Goldberg <[EMAIL PROTECTED]> wrote: > This is probably a FAQ, but I haven't been able to > find the answer. > > Briefly, I am looking for tools that will help me > document a database. Visualization would be nice > to

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

2005-10-02 Thread s. keeling
Incoming from Paul DuBois: > At 18:50 -0600 10/2/05, s. keeling wrote: > > > >Groan. More stuff to learn, configure, maintain, and memorize. I'm > >trying to replicate Unix's "root vs. mere user" security paradigm in > > I think your analogy is flawed. If you really want the root vs mere > user

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

2005-10-02 Thread Paul DuBois
At 18:50 -0600 10/2/05, s. keeling wrote: Incoming from Paul DuBois: At 16:39 -0600 10/2/05, s. keeling wrote: > >The admin account, with no password, doesn't function at all. perl >programs appear to ignore ~/.my.cnf forcing me to open() them and >slurp username and password that way. >

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

2005-10-02 Thread s. keeling
Incoming from Paul DuBois: > > At 16:39 -0600 10/2/05, s. keeling wrote: > > > >The admin account, with no password, doesn't function at all. perl > >programs appear to ignore ~/.my.cnf forcing me to open() them and > >slurp username and password that way. > > > >How is this supposed to work? Su

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

2005-10-02 Thread Paul DuBois
I think I'd probably set up aliases that invoke mysql or mysqladmin with a --defaults-extra-file option that contains the username/password for the appropriate account. At 16:39 -0600 10/2/05, s. keeling wrote: I've checked everywhere I can find (Paul DuBois' MySQL, ML archives, dev.mysql.com,

~/.my.cnf syntax for multiple MySQL user accounts per login account?

2005-10-02 Thread s. keeling
I've checked everywhere I can find (Paul DuBois' MySQL, ML archives, dev.mysql.com, my local User Group) for this, but everything I find either describes a simplistic or far more complex case. This is all on my local box, no networking required, and I'm the only one accessing the data. I've four

Re: daemon crash when shutting down large databases

2005-10-02 Thread Heikki Tuuri
David, man pthread_mutex_destroy says: " ... pthread_mutex_destroy destroys a mutex object, freeing the resources it might hold. The mutex must be unlocked on entrance. In the LinuxThreads implementation, no resources areassociated with mutex objects,

Re: Does MySQL open the .frm file when opening a table?

2005-10-02 Thread Gleb Paharenko
Hello. > For InnoDB I'm not sure, so I don't make guessings. I'm continuing the previous message. Here is what I've found out: InnoDB has its own open file statistics, but currently they are not printed even by SHOW INNODB STATUS. By default, InnoDB keeps at most 300 files open.

Re: Distribution of Software

2005-10-02 Thread Ady Wicaksono
Yes, that's the lack of on web based applicatiion. Thx Vinayak Mahadevan wrote: Hi I have developed a software wherein the frontend is in visual basic and the backend is mysql 4.1. Now when I am installing the software in various machines do i have to install the odbc connector for mysql in

Re: daemon crash when shutting down large databases

2005-10-02 Thread Gleb Paharenko
Hello. Sorry for a delayed answer. Could you provide a whole error message with a resolved stack trace? Check if the problem remains when you switch to the official binaries. David Sparks wrote: > Gleb Paharenko wrote: > >> Hello. >> >> > = 77591546 K >> >> >> Really - somet

Re: MySQL upgrade from 3.x to 4.1 for Chinese databases

2005-10-02 Thread Gleb Paharenko
Hello. Try to follow the manual. At first you should perfrom an upgrade to 4.0. If everything is Ok - then move to 4.1. See: http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html > Yes. I tried. The result is all Chines

Re: How to benchmark performans

2005-10-02 Thread Gleb Paharenko
Hello. See: http://dev.mysql.com/doc/mysql/en/mysql-benchmarks.html OKAN ARI wrote: > How can I test the performans benchmark of my MYSQL? > For instance how can I learn query per second information? And any other > informatioin? > > Thanks > > -- For technical support cont

Re: Does MySQL open the .frm file when opening a table?

2005-10-02 Thread Gleb Paharenko
Hello. > In other words: does opening a MyISAM table take three file handles, Maybe you can find an answer here: http://dev.mysql.com/doc/mysql/en/table-cache.html " You also have to take into account that the MyISAM storage engine needs two file descriptors for each unique open tab