http://www.listsearch.com/MySQL/index.lasso MySQL Talk is an email discussion forum for discussion of the MySQL database from MySQL, AB. en-us Sat, 31 Jul 2010 17:15:43 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378777 Corey to MySQL Talk on 2010-07-31 17:15:43 - On Saturday 31 July 2010 5:11:33 Claudio Nanni wrote: > login as root and remove 'empty' user ,issue: > > delete from mysql.user where user ''; > flush privileges; > > mysql authentication system is logging you on as 'empty' user. > > you will ... Sat, 31 Jul 2010 17:11:33 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378776 Claudio Nanni to MySQL Talk on 2010-07-31 17:11:33 - login as root and remove 'empty' user ,issue: delete from mysql.user where user ''; flush privileges; mysql authentication system is logging you on as 'empty' user. you will be ok after that ;) Claudio On 8/1/2010 2:02 AM, Corey wrote: > ... Sat, 31 Jul 2010 17:02:49 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378775 Corey to MySQL Talk on 2010-07-31 17:02:49 - On Saturday 31 July 2010 4:58:36 Claudio Nanni wrote: > after login to mysql issue: > > select user(); > and > select current user(); > and post output > you will see they dont match. > /usr/local/mysql/bin/mysql -h localhost -u scripts -p ... Sat, 31 Jul 2010 16:58:36 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378774 Claudio Nanni to MySQL Talk on 2010-07-31 16:58:36 - after login to mysql issue: select user(); and select current user(); and post output you will see they dont match. Claudio On 8/1/2010 1:47 AM, Corey wrote: > On Saturday 31 July 2010 4:40:14 chaim rieger wrote: > >> Another thing I j... Sat, 31 Jul 2010 16:47:56 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378773 Corey to MySQL Talk on 2010-07-31 16:47:56 - On Saturday 31 July 2010 4:40:14 chaim rieger wrote: > Another thing I just noticed > > In your first example you are using localhost, which probably means you are > connecting via network > > The second option you don't define a host, which means... Sat, 31 Jul 2010 16:40:14 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378772 chaim rieger to MySQL Talk on 2010-07-31 16:40:14 - Another thing I just noticed In your first example you are using localhost, which probably means you are connecting via network The second option you don't define a host, which means you're prolly using socket connection -- MySQL General Ma... Sat, 31 Jul 2010 16:32:25 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378771 Corey to MySQL Talk on 2010-07-31 16:32:25 - On Saturday 31 July 2010 4:30:00 chaim rieger wrote: > Just a stab but what's the max connect set to ? > Thanks a ton for the quick response - I'm at wits end, been working on this for hours! max connections is set to 0. (but it is also set to... Sat, 31 Jul 2010 16:30:00 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378770 chaim rieger to MySQL Talk on 2010-07-31 16:30:00 - Just a stab but what's the max connect set to ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub archiver@lists.blueworld.com... Sat, 31 Jul 2010 16:27:29 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378769 Corey to MySQL Talk on 2010-07-31 16:27:29 - Hello - I'm only moderately familiar with mysql; the following issue has me stumped. I just noticed that some scripts on one of my client's servers suddenly started failing due to being no longer able to log into the mysql db. I have not touched ... Sat, 31 Jul 2010 05:43:56 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378768 Martin Gainty to MySQL Talk on 2010-07-31 05:43:56 - no that would give you the count for each second interval instead of using the interval variable 5 Aveeks floor: FLOOR(X) Returns the largest integer value not greater than X. 1st (seconds/5) interval example 5/5 1 floor(5/5) 1 supplied va... Sat, 31 Jul 2010 05:43:33 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378767 Martin Gainty to MySQL Talk on 2010-07-31 05:43:33 - no that would give you the count for each second interval instead of using the interval variable 5 Aveeks floor: FLOOR(X) Returns the largest integer value not greater than X. 1st (seconds/5) interval example 5/5 1 floor(5/5) 1 supplied va... Fri, 30 Jul 2010 20:31:43 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378766 Nguyen Manh Cuong to MySQL Talk on 2010-07-30 20:31:43 - Hi Aveek, I think Ghulam just want to count calls for each intervals so the query should looks like this: select count(*) as total calls, queue seconds from calls group by queue seconds order by total calls; ----- Original Message ----- From... Fri, 30 Jul 2010 19:29:54 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378765 Travis Ard to MySQL Talk on 2010-07-30 19:29:54 - Something like this mysql-summary script might be useful: http://code.google.com/p/aspersa/wiki/mysql summary -Travis ---------------------------------------- > Date: Fri, 30 Jul 2010 12:19:07 +0100 > Subject: script of mysql > From: pratikshadja... Fri, 30 Jul 2010 12:05:43 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378764 mos to MySQL Talk on 2010-07-30 12:05:43 - Nunzio Daveri, Joerg Bruehe gave you a lot of good tips to try and speed things up. A few hundred queries per second seem to be a relatively small number to cause the server to crawl. I don't have the rest of your thread, but can you publish ... Fri, 30 Jul 2010 11:55:10 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378763 Nunzio Daveri to MySQL Talk on 2010-07-30 11:55:10 - Thanks again :-) Nunzio From: Joerg Bruehe <joerg.bruehe@oracle.com> To: Nunzio Daveri <nunziodaveri@yahoo.com>; mysQL General List <mysql@lists.mysql.com> Sent: Fri, July 30, 2010 1:31:54 PM Subject: Re: Indexes lar... Fri, 30 Jul 2010 11:31:54 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378762 Joerg Bruehe to MySQL Talk on 2010-07-30 11:31:54 - Hi! I am no InnoDB and tuning expert, so I had intended to stay away from this question. Ok, I'll give some general remarks: Nunzio Daveri schrieb: > [[...]] > > All, I was running slamdb against one of our QA boxes and noticed that the >... Fri, 30 Jul 2010 09:08:42 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378761 Nunzio Daveri to MySQL Talk on 2010-07-30 09:08:42 - Awesome, thanks for helping that's just what I needed :-) Nunzio From: Joerg Bruehe <joerg.bruehe@oracle.com> To: Nunzio Daveri <nunziodaveri@yahoo.com> Cc: MySQL General List <mysql@lists.mysql.com> Sent: Fri, July 3... Fri, 30 Jul 2010 09:00:57 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378760 Todd E Thomas to MySQL Talk on 2010-07-30 09:00:57 - Simple - brilliant. I've modified to cat a temporary script... 1) cat the file as suggested: cat > ~/payload/scripts/create mysqldb.sql << EOF ###--- ### Display the current user ###--- create database puppet; ###--- ### Display all default ... Fri, 30 Jul 2010 08:49:14 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378759 Joerg Bruehe to MySQL Talk on 2010-07-30 08:49:14 - Hi Nunzio, all (cc' to the list)! Nunzio Daveri schrieb: > Hello Joerg, thanks for replying. I am at: > > http://mysql.llarian.net/Downloads/MySQL-5.1/ I cannot comment on that server, do neither know it nor the origin of the packages they p... Fri, 30 Jul 2010 07:19:29 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378758 Joerg Bruehe to MySQL Talk on 2010-07-30 07:19:29 - Nunzio, all, Nunzio Daveri schrieb: > Thanks Claudio but I do that all the time. The question is where is the file? > You said to go to the download area, there are hundreads of files and not one > tar file says rhel or cent os. "tar.gz" pack... Fri, 30 Jul 2010 06:53:31 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378757 Nunzio Daveri to MySQL Talk on 2010-07-30 06:53:31 - Thanks Claudio but I do that all the time. The question is where is the file? You said to go to the download area, there are hundreads of files and not one tar file says rhel or cent os. What is the URL / file name to download and untar please? Than... Fri, 30 Jul 2010 05:26:48 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378756 walter harms to MySQL Talk on 2010-07-30 05:26:48 - PRATIKSHA JAISWAL schrieb: > Hi List, > > Can somebody please help me if they have a script using which we can get an > idea for installed mysql server, backup, created databases, indexes, tables, > engines, replication etc... > > I will apprecia... Fri, 30 Jul 2010 04:19:07 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378755 PRATIKSHA JAISWAL to MySQL Talk on 2010-07-30 04:19:07 - Hi List, Can somebody please help me if they have a script using which we can get an idea for installed mysql server, backup, created databases, indexes, tables, engines, replication etc... I will appreciate your help in advance.... Thanks P... Thu, 29 Jul 2010 20:11:34 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378754 Norman Khine to MySQL Talk on 2010-07-29 20:11:34 - thank you, this makes sense. On Thu, Jul 29, 2010 at 11:29 PM, Dan Nelson <dnelson@allantgroup.com> wrote: > In the last episode (Jul 29), Norman Khine said: >> I don't know what I am missing, but I have this: >> >> mysql> SELECT url FROM product W... Thu, 29 Jul 2010 14:29:12 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378753 Dan Nelson to MySQL Talk on 2010-07-29 14:29:12 - In the last episode (Jul 29), Norman Khine said: > I don't know what I am missing, but I have this: > > mysql> SELECT url FROM product WHERE url IS NULL; > Empty set (0.05 sec) > > mysql> SELECT url FROM product WHERE product Id 67; > +------+ ... Thu, 29 Jul 2010 14:13:13 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378752 Andy Wallace to MySQL Talk on 2010-07-29 14:13:13 - blank is not null... I'll bet if you did SELECT url FROM product WHERE url ''; you'll get a row or three. If the field was NULL, your product id select would look like: +------+ | url | +------+ |NULL | +------+ andy Norm... Thu, 29 Jul 2010 13:58:38 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378751 Norman Khine to MySQL Talk on 2010-07-29 13:58:38 - Hello, I don't know what I am missing, but I have this: mysql> SELECT url FROM product WHERE url IS NULL; Empty set (0.05 sec) mysql> SELECT url FROM product WHERE product Id 67; +------+ | url | +------+ | | +------+ 1 row in set (0... Thu, 29 Jul 2010 13:40:39 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378750 Claudio Nanni to MySQL Talk on 2010-07-29 13:40:39 - Yes, I do it all the time. download TAR archive at the bottom of the download list. untar in a custom dir. use dedicated user watch the my.cnf location, its kind of css style, if you have side effects its cause your mysql installation is pickin... Thu, 29 Jul 2010 13:19:17 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378749 Travis Ard to MySQL Talk on 2010-07-29 13:19:17 - You could try it inside a "here" document: mysql <<EOF GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON concrete5.db TO 'admin'@'localhost' IDENTIFIED BY '$PASSWD PRIV ROOT'; EOF ---------------------------------------- > Date: Thu, 2... Thu, 29 Jul 2010 12:30:37 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378748 Nunzio Daveri to MySQL Talk on 2010-07-29 12:30:37 - Hello Gurus, I am trying to see if there is a no install version of MySQL 5..1.4X for Cent OS 4.8? We got a copy for Solaris x86 and it works AWESOME, I cant seem to find one for Cent OS? We wanted to install several flavors and test a 200 MB query s... Thu, 29 Jul 2010 12:29:55 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378747 Todd E Thomas to MySQL Talk on 2010-07-29 12:29:55 - Hey all, I've found many packages that sit on top of MySQL for various clients. For the purposes of consistency I'd like to automate these installs. I've been directed towards using .sql files and they work great. The trouble I'm having now is t... Thu, 29 Jul 2010 11:29:28 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378746 Nunzio Daveri to MySQL Talk on 2010-07-29 11:29:28 - Hi All, I was running slamdb against one of our QA boxes and noticed that the innodb database is 190Gb in size BUT the worrying issue is that the indexes are 30GB in size!!! When I hit this server hard, it tanks on memory but still performs, slower of... Thu, 29 Jul 2010 11:01:08 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378745 Travis Ard to MySQL Talk on 2010-07-29 11:01:08 - With some databases such as MySQL, subqueries have to be explicitly named.. For example select * from (select * from (select * from table) sub1) sub2; If not, you will see an error like: "ERROR 1248 (42000): Every derived table must have its own al... Thu, 29 Jul 2010 08:45:42 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378744 Todd E Thomas to MySQL Talk on 2010-07-29 08:45:42 - To answer both emails... My first install is Puppet :) 1) I have many clients (schools with Macs/Linux) that could use this package. This is in the works - good call. For the sake of DRP (Disaster Recovery Planning) I automate all of my insta... Wed, 28 Jul 2010 09:10:32 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378743 Peng Yu to MySQL Talk on 2010-07-28 09:10:32 - mysql -ugenome -hgenome-mysql.cse.ucsc.edu mm9 -A I start mysql with the above command. Then I want to select the rows from the result of the following query, provided that for any rows that have the same symbol, chrom and strand should be the same ... Wed, 28 Jul 2010 06:59:43 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378742 Mike Spreitzer to MySQL Talk on 2010-07-28 06:59:43 - I installed iostat and used it. It showed that my MySQL data is striped over four devices. During my "idle" query each of those four devices has about 25% utilization, which is consistent with the hypothesis that this I/O is the bottleneck. It lo... Wed, 28 Jul 2010 02:23:31 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378741 Robert P. J. Day to MySQL Talk on 2010-07-28 02:23:31 - i asked about this once upon a time, and might need a little more help here. a friend's mysql hosting provider lost an entire DB, but has managed to recover and hand over the "ibdata1" file (or at least some portion of it). when my friend popped ... Tue, 27 Jul 2010 23:49:06 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378740 Rob Wultsch to MySQL Talk on 2010-07-27 23:49:06 - On Tue, Jul 27, 2010 at 1:56 PM, Todd E Thomas <todd dsm@ssiresults.com> wrote: > I'm looking for automation direction... > > I've found many packages that sit on top of MySQL. For the purposes of > consistency I'd like to automate these installs. > ... Tue, 27 Jul 2010 13:56:30 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378739 Todd E Thomas to MySQL Talk on 2010-07-27 13:56:30 - I'm looking for automation direction... I've found many packages that sit on top of MySQL. For the purposes of consistency I'd like to automate these installs. I've been able to automate the install and configuration of everything except the mys... Tue, 27 Jul 2010 07:25:26 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378738 Dan Nelson to MySQL Talk on 2010-07-27 07:25:26 - In the last episode (Jul 27), Dan Nelson said: > In the last episode (Jul 27), Mike Spreitzer said: > > If I want to try to actually hold a 2GB table in RAM, is there anything I > > need to set in my.cnf to enable that? > > Just make sure your key ... Tue, 27 Jul 2010 07:20:54 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378737 Dan Nelson to MySQL Talk on 2010-07-27 07:20:54 - In the last episode (Jul 27), Mike Spreitzer said: > Does `iostat` consider GPFS mounts at all? If so, how can I tell which > line of `iostat` output is about the GPFS mounted at /dev/gpfscf ? I do > not see such a thing mentioned in the iostat out... Tue, 27 Jul 2010 06:24:45 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378736 Jerry Schwartz to MySQL Talk on 2010-07-27 06:24:45 - >-----Original Message----- >From: Dan Nelson [mailto:dnelson@allantgroup.com] >Sent: Monday, July 26, 2010 11:31 PM >To: Mike Spreitzer >Cc: MySql >Subject: Re: idle query >iostat -x output would be helpful here, too, so we can see whether your... Tue, 27 Jul 2010 05:01:26 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378735 Julia Samarska to MySQL Talk on 2010-07-27 05:01:26 - Devart Email: info@devart.com Web: http://www.devart.com FOR IMMEDIATE RELEASE CONTACT INFORMATION: Julia Samarska julias@devart.com 27-Jul-2010 More Tools to Work with MySQL Databases in Visual Studio Provided by... Tue, 27 Jul 2010 05:05:21 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378734 Mike Spreitzer to MySQL Talk on 2010-07-27 05:05:21 - Does `iostat` consider GPFS mounts at all? If so, how can I tell which line of `iostat` output is about the GPFS mounted at /dev/gpfscf ? I do not see such a thing mentioned in the iostat output. In `vmstat` output, I thought "bi" is in terms of ... Tue, 27 Jul 2010 03:54:13 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378733 Aveek Misra to MySQL Talk on 2010-07-27 03:54:13 - try this ... select 5 * floor(seconds/5) as start, 5 * floor(seconds/5) + 5 as end, sum(calls) from calls group by 5 * floor(seconds/5); This should give you an output of the type +-------+------+------------+ | start | end | sum(calls) | +--... Tue, 27 Jul 2010 03:23:20 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378732 Ghulam Mustafa to MySQL Talk on 2010-07-27 03:23:20 - Hi everyone, i have two columns (seconds, number of calls), i need to produce a report which will show total number of calls in intervals (let'say 10 seconds interval), i know i can do this programmability in my script but i was wondering if it's po... Mon, 26 Jul 2010 23:18:01 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378731 Dan Nelson to MySQL Talk on 2010-07-26 23:18:01 - In the last episode (Jul 27), Mike Spreitzer said: > Sure, `wc` is different from mysql --- but different enough to account for > a 16000:75 ratio? Most definitely. wc is reading sequentially, and the OS is probably coalescing those reads and prefe... Mon, 26 Jul 2010 22:52:28 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378730 Mike Spreitzer to MySQL Talk on 2010-07-26 22:52:28 - Sure, `wc` is different from mysql --- but different enough to account for a 16000:75 ratio? Will iostat give a good utilization metric for GPFS? If I want to try to actually hold a 2GB table in RAM, is there anything I need to set in my.cnf to ... Mon, 26 Jul 2010 21:44:50 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378729 jayabharath to MySQL Talk on 2010-07-26 21:44:50 - Hi Carlos, >From your trailing mail I noticed the below GRANT. This will just give 'cmennens'@'ideweb1.iamorlando.com' access to mysql but not any databases. *Access to mysql:* | GRANT USAGE ON *.* TO 'cmennens'@'ideweb1.iamorlando.com' IDENTIFI... Mon, 26 Jul 2010 21:22:03 -0700 http://www.listsearch.com/MySQL/Message/index.lasso?378728 Dan Nelson to MySQL Talk on 2010-07-26 21:22:03 - In the last episode (Jul 27), Mike Spreitzer said: > Thanks for the clues. In this case the storage is not on a SATA disk, > rather is it on a GPFS ( > http://en.wikipedia.org/wiki/IBM General Parallel File System) mount. This > thing is capable of...