Re: help with a sql statement

tech user wrote: Add an alias for the subquery select * from ( select ) my_alias where dd >= 3; Better, use a having clause and eliminate the subquery. Odds are it will be more efficient in MySQL. How to replace the original one with a having statement? Thanks again. sele

Two databases, two disks

Hi All, I have two MySQL databases and I would like to place each one of them on a separated disk, and backup each one of them separately. I understand I need to use the "One file per table" option, right? It will effect all the databases. How do I place each database on a different volume

Re: help with a sql statement

> > Add an alias for the subquery > > select * from ( select ) my_alias where dd >= 3; > > Better, use a having clause and eliminate the subquery. Odds are it > will be more efficient in MySQL. > How to replace the original one with a having statement? Thanks again. Get the n

Re: help with a sql statement

tech user wrote: hello, I try to execute this sql in mysql shell,but got error as: mysql> select * from (select uin,count(*) as dd from active_users where date >= date_add(curdate(),interval -30 day) group by uin) where dd >=3; ERROR 1248 (42000): Every derived table must have its own alias

help with a sql statement

hello, I try to execute this sql in mysql shell,but got error as: mysql> select * from (select uin,count(*) as dd from active_users where date >= date_add(curdate(),interval -30 day) group by uin) where dd >=3; ERROR 1248 (42000): Every derived table must have its own alias But I can execute

Re: R: R: Multiple instances howto

Nanni, To make things even creepier, I tried to access the 2 "alleged" instances from a different WinXP PC by starting 2 instances of MySQL Administrator, using different port number 33061 and 33062 at the same time. And it worked! I went further to create a database on each instances of MySQL

StartupItem not installing on Mac OS X 10.5

Hello, About 3 months ago I purchased two Mac Mini systems to use as MySQL EDB servers (I might point out that I've been doing this for years with OS X 10.4/Tiger and it works really good). The newest Macs came with OS X 10.5 Leopard. I was not able to downgrade the OS to 10.4. At the time, t

Re: Connections on Database

Oops. I was wrong on that one. max_user_connections is different from global max_connections and max_connections per user. 2008/3/31 Eric Bergen <[EMAIL PROTECTED]>: > You probably only want max_connections and not max_user_connections. > Max_user_connections is the number of times a user can con

Re: Connections on Database

You probably only want max_connections and not max_user_connections. Max_user_connections is the number of times a user can connect per hour.. -Eric 2008/3/31 Vidal Garza <[EMAIL PROTECTED]>: > Velen escribió: > > > > Hi, > > > > How can i limit connections to my database? > > > > Regards, >

Re: Connections on Database

Velen escribió: Hi, How can i limit connections to my database? Regards, Velen max_user_connections = 50 max_connections = 50 -- Ing. Vidal Garza Tirado Depto. Sistemas Aduanet S.A. de C.V. Tel. (867)711-5850 ext. 4346, Fax (867)711-58

Re: R: R: Multiple instances howto

Nanni, You know, it's really strange. On 2 different terminals, I ran [EMAIL PROTECTED] etc]mysql -S /var/lib/mysql/mysql.sock -u root -p AND [EMAIL PROTECTED] etc]mysql -S /var/lib/mysql/mysql2.sock -u root -p I was able to log in. Then I run "show variables", I could actually see them liste

Re: How can I export compressed databases in MySQL?

On Monday 31 March 2008 16:24:59 Marcos Vinícius Vieira dos Santos wrote: > I have to export my databases and I get large files for my dump. > > How can I export compressed databases in MySQL? > > I use: #mysqldump --default-character-set=latin1 -u'name_user' -p'pass' > 'database_name' > $path/f

Re: Connections on Database

On Sun, Mar 30, 2008 at 9:59 AM, Velen <[EMAIL PROTECTED]> wrote: > > Hi, > > How can i limit connections to my database? RTFM: http://dev.mysql.com/doc/refman/5.0/en/user-resources.html -- Forensic Services, Senior Unix Engineer 1+ (570-) 362-0283 -- MySQL General Mailing List For list

How can I export compressed databases in MySQL?

Hello everyone, I have to export my databases and I get large files for my dump. How can I export compressed databases in MySQL? I use: #mysqldump --default-character-set=latin1 -u'name_user' -p'pass' 'database_name' > $path/file_name.sql; Thanks, Marcos Santos Abra sua conta no

R: Connections on Database

Hi Velen, you have to put this parameter in the [mysqld] section of .my.cnf file: max_connections = n # n is the number of connections desired don't forget to restart mysql! Aloha! Claudio Nanni -Messaggio originale- Da: Velen [mailto:[EMAIL PROTECTED] Inviato: domenica 30 mar

Re: mysql replication

On Mon, Mar 31, 2008 at 9:39 AM, Kaushal Shriyan <[EMAIL PROTECTED]> wrote: > Hi > > Is there a documentation on replication of MySQL Database on Gentoo From the manual: http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html -- Forensic Services, Senior Unix Engineer 1+ (570

Re: strange files in database directory

Hello, Marten, in my experience, these are most often temporary files leftover from an incomplete operation. They might be from a long-running query that was canceled, or from a table repair operation that errored out or was interrupted. In my experience it is safe to delete them, provided

Re: mysql replication

http://gentoo-wiki.com/HOWTO_MySQL_Replication On 3/31/08, Kaushal Shriyan <[EMAIL PROTECTED]> wrote: > > Hi > > Is there a documentation on replication of MySQL Database on Gentoo > > Thanks and Regards > > Kaushal > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/my

Re: strange files in database directory

Marten, in my experience, these are most often temporary files leftover from an incomplete operation. They might be from a long-running query that was canceled, or from a table repair operation that errored out or was interrupted. In my experience it is safe to delete them, provided you take care

mysql replication

Hi Is there a documentation on replication of MySQL Database on Gentoo Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

parameters to be set for myisam engine

Hi All, We are setting up a new db with myisam storage engine. Its runing on debain, with 8 CPU, 8 GB RAM. Can you please let me know what all parameters i need to setup for only myisam storage engine and also their values for better performance. regards anandkl

R: R: Multiple instances howto

Jing, First: you can have only ONE mysql instance running for each installation, but you can have as many installations as you want on each server. So to answer your statement only the first command started mysql, while the second command should have given you an error(there is already an instanc