Re: Are there any difference between max_connection and max_user_connection?

Yes it won't allow except 1 connection for root user. We have to monitor the MySQLD server and the queries runnning at that time. As of now, increase the key_buffer_size to 64 or 128 mb according to your indexes created and physical memory available. and query_cache_size is purely depends on the qu

Re: Are there any difference between max_connection and max_user_connection?

hi Suresh thanks. max_connection=100(default). so, it won't allow user more than 100? and one more clarification. i am facing performance issue in mysqld. some time mysqld consuming 100% cpu. so what i have to do now? and the below parameters are in default values. if i increase the value. it w

Re: Are there any difference between max_connection and max_user_connection?

Hi Faizal, Max_connections are the connections for the overall MySQLD server. Max_user_connections are the connections for the particular user ( i.e for an account ) of the MySQLD server. Suresh Kuna MySQL DBA On Thu, Jan 7, 2010 at 11:00 AM, F.A.I.Z.A.L wrote: > Dear all > > I can see max_conn

Are there any difference between max_connection and max_user_connection?

Dear all I can see max_connection and max_user_connection set to default value. but daily i can see 40 to 70 users connection to the database. how? when max_user_connections=0. what is the different between these two parameters.. max_connection=100 max_user_connections=0 thanks in advance. Chee

Re: mysql Create table in system database

Hi Manasi, Do you mean the copy paste of one database and rename it to another ? If so, it is not possible as the data is shared between the data nodes by partitioning. For innodb, if you are using file_per_table option, We can do so and give the "flush tables" command to read the same but the data

Re: mysql Create table in system database

Hi Johan,Is it possible to do such manipulation in NDB, the way innodb works. Thanks in advance.--Regards, Manasi Save Quoting Johan De Meersman :File permissions ? SE Linux ? AppArmor ?On Mon, Nov 16, 2009 at 7:48 AM, Manasi Save wrote: Thanks Shawn for the qui

Re: Possible new MySQL 0day

On Wed, Jan 6, 2010 at 5:47 PM, Daevid Vincent wrote: >   Intevydis has published a flash video showing what > appears to be a new 0day exploit against MySQL 5.x. Gah. Is there a text description available that doesn't require sitting through some #%#$ video? -- Hassan S

Possible new MySQL 0day

http://isc.sans.org/diary.html?storyid=7900 Possible new MySQL 0day Published: 2010-01-06, Last Updated: 2010-01-06 21:46:51 UTC by Toby Kohlenberg (Version: 1) Intevydis has published a flash video showing what appears to

Re: Another Inserting Multiple Values with Set Problem

mysql> create table t (sizes set('Extra-small','Small','Medium','Large','XLarge','XXLarge','XXXLarge'), colorsShadesNumbersShort set('blue:99','gray:465945','purple:50404D','navy-blue:CC7722','fuchsia:FF77FF','aqua:7FFFD4','maroon:B03060','black:FF','yellow:9ACD32'));

Re: table export in cron

As Oracle has SQL*Loader and MySQL has LOAD FROM INFILE/SELECT INTO OUTFILE, your proposed approach is %100 sound. Mysqldump will just move you further from your particular objective. The 'simple' alternate, if you would rather not have the file generated on the server is to do something like ec

RE: Binary Logging

Binary logs are pretty important for backups as well. Most often people take a full backup using mysqldump or filesystem snapshots, and then back up their binlogs. With the full backup + all the binlogs since then, you can recover to any point in time you choose. If you're not currently runni

Re: Binary Logging

Yes, your settings will be fine. If you were already supporting slaves which might remain dis-connected for extended periods of time, you would have to take that into account when setting the purge interval. You don't need current binary logs for future slaves. You new slave will start with a sn

RE: Binary Logging

Silly me sees that there is an 'expire_log_days' in the my.cnf But again, if i was to purge everything but the last day or 2... running this command i found: PURGE BINARY LOGS BEFORE DATE_SUB(NOW(), INTERVAL 2 DAY); >From the MySQL command line, will this be ok? Steve. -Original Message--

Binary Logging

Good afternoon. I am having a weird problem with the Binary Logging of my MySQL. For some reason, we have it on (still not sure why) but when i look in the /var/log/mysql/ folder, the oldest file is from the 2009-12-27. The MySQL service has not been restarted since the server came back up 150

Re: Another Inserting Multiple Values with Set Problem

On Wed, Jan 6, 2010 at 2:40 PM, Michael Dykman wrote: > How about you show us the schema for the table so we know what is > defined as what? > Done in last email. > > Also, as the update does succeed, it would be interesting to see what > value actually got stored. After you have accounted for

Re: Another Inserting Multiple Values with Set Problem

How about you show us the schema for the table so we know what is defined as what? Also, as the update does succeed, it would be interesting to see what value actually got stored. After you have accounted for each bit in the stored value, we might have a clue about what is being truncated. One t

Re: Another Inserting Multiple Values with Set Problem

On Wed, Jan 6, 2010 at 2:34 PM, Hassan Schroeder wrote: > On Wed, Jan 6, 2010 at 1:25 PM, Victor Subervi > wrote: > > > mysql> update products set SKU="prodSKU2", Category="prodCat1", > > Name="name2", Title="title2", Description="descr", Price="22.55", > > SortFactor="500", Availability="1", Ou

Re: Another Inserting Multiple Values with Set Problem

On Wed, Jan 6, 2010 at 2:18 PM, Hassan Schroeder wrote: > On Wed, Jan 6, 2010 at 11:39 AM, Victor Subervi > wrote: > > > Here's my example again. Syntactically correct. From my original post: > > > > update products set SKU="prodSKU2", Category="prodCat1", Name="name2", > > Title="title2", Descr

Re: Another Inserting Multiple Values with Set Problem

On Wed, Jan 6, 2010 at 12:14 PM, Michael Dykman wrote: > so you dropped the quotes around the unneccessarily bracketed > expression? It's hard to diagnose when your example isn't even what > you think is syntactically correct. > Here's my example again. Syntactically correct. From my original p

Re: Another Inserting Multiple Values with Set Problem

so you dropped the quotes around the unneccessarily bracketed expression? It's hard to diagnose when your example isn't even what you think is syntactically correct. I can't find a reference, but i recall there is some limit on the length of SET member identifiers.. some of yours look longish, m

Re: Another Inserting Multiple Values with Set Problem

On Wed, Jan 6, 2010 at 10:56 AM, Michael Dykman wrote: > I don't really use sets when I can avoid them (too much special > wierdness) but from the manual I see this: > > mysql> INSERT INTO myset (col) VALUES > -> ('a,d'), ('d,a'), ('a,d,a'), ('a,d,d'), ('d,a,d'); > Query OK, 5 rows affected (0.01

Re: table export in cron

Hi, You can use an external replication tool like Golden gate for replication between MySQL and Oracle. Thanks Suresh Kuna MySQL DBA Sent from BlackBerry® on Airtel -Original Message- From: Mikhail Berman Date: Wed, 06 Jan 2010 10:42:14 To: machiel.richards Cc: Subject: Re: table expor

Re: table export in cron

Hi Machiel, As an alternative, you might consider use of mysqdump command, http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html, in a KSH/BASH script running from cron The script might look like this: = !#/bin/ksh mysqldump --password=yourpassword [more switches needed here] your_da

Re: table export in cron

machiel.richards wrote: How can we do this when running in a cron script? mysql -e "select * from into outfile '/path/to/output/file' fields terminated by '|'" ? Gary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

table export in cron

Hi all I have a question regarding exporting of tables to a file from mysql. We need to export tables from mysql to a delimeted file which will then be imported into another database (oracle). We can do this manually from within mysql usin

Another Inserting Multiple Values with Set Problem

Hi; The following doesn't work with or without enclosing the sets in quotes: update products set SKU="prodSKU2", Category="prodCat1", Name="name2", Title="title2", Description="descr", Price="22.55", SortFactor="500", Availability="1", OutOfStock="0", Weight="5.5", ShipFlatFee="10.0", ShipPercentP

Re: Join with OR-condition and Indexes

Tobias, all, Tobias Schultze wrote: > Thanks for your answers. > > I found out, that MySQL behaves very strange in this situation. > I think this is a bug or important missing feature. I disagree. > > I would like to see how other DBMS behave in this situation, which I would > think is a comm

ANN: Advanced Data Generator 2.5.1 released

on - MySQL Edition More info and a 30-day trial version on www.upscene.com Pricing information available on: http://www.upscene.com/purchase.php#adg More information available here: http://www.upscene.com/go/?go=news&id=20100106 With regards, Martijn Tonies Upscene Productions - Data

Re: Help for mysql@lists.mysql.com

Hi list, i am trying to add mysql support to my project using autoconf. Following flags are are generated: LIBS=-lmysqlclient -lssl -lpthread -lresolv -lm -L/usr/lib -lcrypto - lssl -lstdc++ -L/Developer/SDKs/MacOSX10.4u.sdk/usr/lib -L/Developer/ SDKs/MacOSX10.4u.sdk/usr/lib/system -L/usr/loca

Re: Join with OR-condition and Indexes

Thanks for your answers. I found out, that MySQL behaves very strange in this situation. I think this is a bug or important missing feature. I would like to see how other DBMS behave in this situation, which I would think is a common problem - whenever you want to join one column of a table with