different max_connections based on users/host

ources per hour" features, but they don't fit my need, since I need a "instant" control, not a "per hour" control. Any hint? Bye, Alberto. -- http://stain.giovani.it (italian blog) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ERROR: bogus data when reading binary log

ad the master, so I have no service during the snapshot operation. Does anybody have a workaround or a solution for this? Bye, Alberto. -- "Imagination is more important than knowledge" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Server optimization issue

Misao wrote: I have 4 MySQL 4.0.16 servers, all with Dual 3ghz Xeons and 4GB of RAM. They use InnoDB for all tables, and the ibdata file is 70GB. The DBs seem to be a little slow, and the darn thing is always using a huge chunk of swap. I've tried increasing and decreasing what it's allowed to use,

Re: Maximum number of simulatneous connections

venkata ramana wrote: Hi, What is the maximum number of simulataneous connections that can exist for MySQL. Can we change this limit? If yes please tell me how to do this. I am using MySQL4.1 in Linux. Thanks, ramana. look at max_connections in my.cnf bye a -- "Imagination is more impo

explain strange result using keys

why it doesn't use "ast" key (articolo,status,thread) which has been created since where condiction uses these three fields. In other tables I get such key working fine... Can anyone explain me this? Thanks in advance. Bye, Alberto. -- "Imagination is more important th

MySQL Replication scheme - DMZ - LAN

kind of replication schema that keep security of the LAN segment ? Thanks to all, Alberto Fabbro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Fw: [SQL] foreign key from a table to the *same* table

Hi to all...i've a problem...would anyone help me? I've a table called COURSES, where there are some universitary courses. I've a table called DIDACTIC_UNITS, where there are some subjects with some info like the professor, the course year, etc. The problem is that some didactic units can be lend

Bad field type translation

I found the following error with mysql server version 3.23.52. mysql> select snb,id_servicio from Abonados_Servicios where snb="1144293549"; 9 rows in set (0.01 sec) mysql> select snb,id_servicio from Abonados_Servicios where snb=1144293549; 9 rows in set (45.61 sec) mysql> describe Abonados_Serv

Mysql - How to use more than 32 index in a table ?

Hi, How to use more than 32 index in a table ? I need to use 68 index in one same table (Mysql v 3.23.44. How to make ? Thank you, Alberto J. Alvares - Before posting, please check: http://www.mysql.com/manual.php (the

SQL - MYSQL: More than 32 index in a table

Hi, How to use more than 32 index in a table ? I need to use 68 index in one same table (my sql v 3.23.44. How to make ? Thank you, Alberto J. Alvares - Before posting, please check: http://www.mysql.com/manual.php

Efficiency Query

MySql efficiency? If not, maybe you can just tell me your own experience. Thank you in advance! Alberto Ruiz Spain - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Delay in SELECT with innodb

Hi, We have a problem : We are working with MySql ver 3.23.51 in Windows NT 4.0 Service Pack 6. We use Acctualy MyIsam. It works fine, SELECT works fast with any indexes ( primary and others ) But when try to use InnoDB, only the primary key works like MyIsam

mysql Tcl/tk and Win me

Hello I am working in a project on Tcl/tk and Mysql, I use Win98, Just change my computer to a Sony Vaio PIII It comes whit Win me. We can not make it work, has any body do it? it so could you send me the .dll files or I just go back to win98. Alberto Romero [EMAIL PROTECTED] Mazatlan

To insert images in a table -> BLOB

Hello List: I am new in this list and in MySQL, I have the following problem: I need to insert files of images in a table, which has a field of type BLOB, I have understood that to do this I can use the function LOAD_FILE(file.bmp), but that this file must be in the server. It is not possible t

Requirement of INFO

Is there any performance difference between running a query on a compressed MyIsam Table rather than a normal MyIsam Table ? Thanks in advance Bye