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
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
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]
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
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/mysql
To
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
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
--
/Daniel P. Brown
Forensic Services, Senior Unix
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
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
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
--
/Daniel P. Brown
Forensic Services, Senior Unix Engineer
1+ (570-) 362-0283
--
MySQL General Mailing
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'
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
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
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,
Velen
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
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,
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
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
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
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 name you
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?
21 matches
Mail list logo