Re: logging slow queries with time

es but is there a way to see when the > >> slow queries take place also?  I'd like to know what queries are being > >> processed during this window of poor response time, usually around > >> noon local time. > > > > If you want more than just the slow querie

Re: How to put table definition into another table using SQL?

create table TableDef like TableX ? -- Nuno Tavares DRI, Consultoria Informática Telef: +351 936 184 086 mos escreveu: > I'd like to get the field names and data types of a table, say TableX, > and put it into TableDef using nothing but SQL. I know I can list the > table de

RE: query results group/summed by interval

> i would really appreciate your help. > > > > Best Regards. > > > > -- > > Ghulam Mustafa > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql?unsub=ave...@yahoo-inc.com > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/mysql?unsub=cuong.m...@vienthongso.com > > > > > > -- > > Best Regards, > > Cuongmc. > > > > -- > > Nguyen Manh Cuong > > Phong Ky Thuat - Cong ty Vien Thong So - VTC > > Dien thoai: 0912051542 > > Gmail : philipscu...@gmail.com > > YahooMail : philipscu...@yahoo.com > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com > > > -- Nuno Tavares +351 93 618 40 86 dri Consultoria Informatica -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: how to generate a data set then join with in on fly?

cords-are-ocurring-during-that-interval/ -- Nuno Tavares DRI, Consultoria Informática Telef: +351 936 184 086 Shawn Green (MySQL) escreveu: > On 1/10/2011 18:51, Ryan Liu wrote: >> Hi, >> >> In MySQL, is that possible to generate a data set join with it on fly >> (with

Re: Join based upon LIKE

Dear Jerry, I've been silently following this discussion because I've missed the original question. But from your last explanation, now it really looks you have a "data quality" kind of issue, which is by far related with MySQL. Indeed, in Data Quality, there is *never* a ready solution, because

Re: How to find values which do not return any tuple in "IN" clause

create table dim (value varchar(10), primary key(value)); insert into dim values ('aaa'),('bbb'),('ccc'),('ddd'); SELECT tablename.fieldname FROM dim LEFT JOIN tablename ON tablename.fieldname = dim WHERE tablename.fieldname IS NULL; If this is not what intended, I'd suggest you to spend a littl

Re: How to find values which do not return any tuple in "IN" clause

Fahim, I was not quite sure I understood you question, but looking at what you're trying to achieve in this example, give a try to my suggestion. You have to bear in mind that you can only GROUP BY values that indeed show up in the results. That means that if ('','y') never show up, they

Re: very large import

The following page has some nice interesting stuff, assuming you have a reasonable configuration in place (innodb_buffer_pool, etc[1]) http://download.oracle.com/docs/cd/E17952_01/refman-5.5-en/optimizing-innodb-bulk-data-loading.html [1] http://gpshumano.blogs.dri.pt/2009/09/28/importing-wikim

Re: MySQL Indexes

Neil, whenever you see multiple fields you'd like to index, you should consider, at least: * The frequency of each query; * The occurrences of the same field in multiple queries; * The cardinality of each field; There is a tool "Index Analyzer" that may give you some hints, and I think it's maatk

Re: Script need for dropping databases

Hi , Have a look at database information_schema.TABLES: SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA=''; As long as your MySQL version is >= 5.1, you don't need a cron script, you can use the MySQL scheduler, create a stored procedure that will run each month. You'll need to use pr

Re: One inst has 39 columns- the other 40

Charles, You should run "SELECT @@version" on both nodes. It looks like you have different version' schemas. -NT Em 22-03-2012 04:41, Brown, Charles escreveu: Look man, there has to be someone out there that can tell me why one user table has 5 extra columns. Is it version related or my sy

Re: big character constant

Halász, not sure if I understood correcly, but you "mysql" console/client may have different charsets. This means you should set it accordingly. Check this out: mysql> show global variables like '%character_set%'; +--++ | Variable_name

Re: mySQL Query and Report Builder

Hi Don, Have a look at Jasper Reports: http://jasperforge.org/ -NT Em 30-04-2012 17:53, Don Wieland escreveu: Hello, I have a client who needs the ability to do statistical reporting on their mySQL db data. Is there an app that provides an easy UI that will allow my client to build a line ite

Re: need list of country ISO code to demonyms

I don't have it, sorry. But it took me 10 seconds to copy & paste it to an Excel, so I could save it as CSV and import it directly to MySQL. Further on, it'd be as simples as JOIN by name with a table with ISO-to-country-names, which you can fetch in hundreds of places, such as Wikipedia. -N

Re: need list of country ISO code to demonyms

ht a table like that, and paste it into Excel. That darn Microsoft -- they think of everything! :) Thanks for the tip. -Original Message----- From: Nuno Tavares [mailto:nuno.tava...@dri.pt] Sent: Wednesday, October 03, 2012 3:10 PM To: mysql@lists.mysql.com Subject: Re: need list of country I