script of mysql

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 Pratiksha

Re: script of mysql

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 appreciate your help in advance You can find tons of

Re: CentOS 4.8 no-install of MySQL 5.1.4X???

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? Thanks for responding :-) Nunzio

Re: CentOS 4.8 no-install of MySQL 5.1.4X???

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 packages are not specific to the Linux distribution, they

Re: CentOS 4.8 no-install of MySQL 5.1.4X???

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 provide (own builds or mirrored ones from the MySQL

Re: Variable Expansion Using MySQL Client and .sql Files

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 accounts ###--- USE puppet; ###--- ### Remove

Re: CentOS 4.8 no-install of MySQL 5.1.4X???

Awesome, thanks for helping that's just what I needed :-) Nunzio From: Joerg Bruehe joerg.bru...@oracle.com To: Nunzio Daveri nunziodav...@yahoo.com Cc: MySQL General List mysql@lists.mysql.com Sent: Fri, July 30, 2010 10:49:14 AM Subject: Re: CentOS 4.8

Re: Indexes larger than RAM (was: Do you know who can answer this question I posted yesterday please?)

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 innodb database is 190Gb in size BUT the worrying issue

Re: Indexes larger than RAM (was: Do you know who can answer this question I posted yesterday please?)

Thanks again :-) Nunzio From: Joerg Bruehe joerg.bru...@oracle.com To: Nunzio Daveri nunziodav...@yahoo.com; mysQL General List mysql@lists.mysql.com Sent: Fri, July 30, 2010 1:31:54 PM Subject: Re: Indexes larger than RAM (was: Do you know who can answer

Re: Indexes larger than RAM (was: Do you know who can answer this question I posted yesterday please?)

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 some of the slow queries (see Slow Query Log)

RE: script of mysql

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: pratikshadjayswa...@gmail.com To: mysql@lists.mysql.com Hi

Re: query results group/summed by interval

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: Aveek Misra ave...@yahoo-inc.com To: Ghulam Mustafa