tables_priv and TABLES_PRIVILEGE

I have run across a problem with differences in the mysql.tables_priv table and the INFORMATION_SCHEMA.TABLE_PRIVILEGES tables. My application is currently written to query the information schema for privileges before allowing users to insert or update. The problem is that for some users and some t

Re: too many connections

One thing a lot of people miss is that web server KeepAliveTimeout setting has an effect on pconnect. Apache will keep the thread handling that client open for the KeepAliveTimeout duration, which will keep the database connection open for reuse. You can lower your KeepAliveTimeout or not use pconn

Re: too many connections

You have to use mysql 64bits on S.O. 64bits --Mensaje original-- De: Martin Gainty Para: Kinney, Gail Para: 'mysql@lists.mysql.com' Enviado: 19 Sep 2008 10:51 Asunto: RE: too many connections in my.cnf configuration file try upping the number of connections max_connections=3072 to max_c

mysqlimport failed to import

I created a csv file entitled 'disposed.csv' and placed it in computer_inventory data folder with the following inside: 1087 1046 1086 1161 1049 1178 1029 1030 1224 1044 1106 Now I created the table 'disposed' as following: Create disposed ( Mot_id INT(4) UNIQUE NOT NULL ); Then I issued the c

Re: too many connections

PHP provides both msql_connect and mysql_pconnect. The former does indeed create a new connection to process each request and closes it auto-magically upon completion. The latter creates a rather half-assed connection pool; once a connection is allocated by PHP, it is held open and reused for sub

Re: too many connections

Then killing the server process should be safe. Except that server startup may take a while. On Fri, Sep 19, 2008 at 7:25 PM, Kinney, Gail <[EMAIL PROTECTED]>wrote: > We are using the default storage engine - INNODB > > > > *From:* Olexandr Melnyk [mailto:[EMAIL PROTECTED] > *Sent:* Friday, Sep

Re: too many connections

In case you're using PHP, in theory all database connections should be closed when script stops execution. I'm not sure if it's always like that in practice. Persistent connections can be a quick fix to your problem, but as was mentioned in the previous mail, it's better to find out why there's so

RE: too many connections

Gail, I know the list has already recommended allowing more connections but the bigger question is what is sucking them all up. Even with 1000 connections things like apache can only use the number of connections that there are processes (* the number of connections used within each process)

Re: too many connections

On 9/19/08, Kinney, Gail <[EMAIL PROTECTED]> wrote: > > Hello, We have MySQL 4.0.14 and have just gotten an error: > Please help. > Answer the door, 2004 is calling. -- -jp I hope that someday we will be able to put away our fears and prejudices and just laugh at people. deepthoughtsbyjackh

RE: too many connections

in my.cnf configuration file try upping the number of connections max_connections=3072 to max_connections=6144 Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. Th

Re: too many connections

On Fri, Sep 19, 2008 at 9:07 PM, Olexandr Melnyk <[EMAIL PROTECTED]> wrote: > Restart MySQL server > > On 9/19/08, Kinney, Gail <[EMAIL PROTECTED]> wrote: > > > > Hello, We have MySQL 4.0.14 and have just gotten an error: too many > > connections. we can't connect to our site using MySQL admin.

Re: too many connections

Restart MySQL server On 9/19/08, Kinney, Gail <[EMAIL PROTECTED]> wrote: > > Hello, We have MySQL 4.0.14 and have just gotten an error: too many > connections. we can't connect to our site using MySQL admin. Please help. > > Gail Kinney > Webmaster UC Denver > > [EMAIL PROTECTED]

too many connections

Hello, We have MySQL 4.0.14 and have just gotten an error: too many connections. we can't connect to our site using MySQL admin. Please help. Gail Kinney Webmaster UC Denver [EMAIL PROTECTED]

ANN: MicroOLAP Database Designer for MySQL 1.9.7 released

Greetings! We are glad to announce MicroOLAP Database Designer for MySQL 1.9.7 (September 16, 2008) release. This release introduces ability to create partitioned tables for MySQL 5.1+. There are a lot of minor improvements and bugfixes. Changes history: [!] MySQL 5.1+ table partitioning suppo

Re: Fwd: Why dont my query use the index keys?

Hi joerg, that was a excellent explanation. Regards, Pradeep Chandru. Joerg Bruehe wrote: Hi ! Parikh, Dilip Kumar schrieb: Hi , So you are trying to say that 1) when the Table has Low Cardinality, Mysql wont use Index? Is this the logic behind your words? Extreme example: If