How to tweek the max connections

Hi all! I would like know if there are any calculatios for specifying the maximum number of the 'max_connections' value. I understand that max_connections should be decided by the remaining RAM size of the system. But exactly how should it be actually calculated? I am currently using RHEL 5.3 3

Re: How to change max simultaneous connection parameter in mysql.

esday, April 02, 2013 8:29 AM >> To: mysql@lists.mysql.com >> Subject: Re: How to change max simultaneous connection parameter in >> mysql. >> >> >> >> Am 02.04.2013 16:09, schrieb spameden: >>> 2013/3/24 Reindl Harald >> <mailto

Re: How to change max simultaneous connection parameter in mysql.

> > Sent: Tuesday, April 02, 2013 2:00 PM > > To: mysql@lists.mysql.com > > Subject: Re: How to change max simultaneous connection parameter in > > mysql. > > > > > > > > Am 02.04.2013 22:56, schrieb Rick James: > > > I hear that nginx is very fa

RE: How to change max simultaneous connection parameter in mysql.

e- > From: spameden [mailto:spame...@gmail.com] > Sent: Tuesday, April 02, 2013 7:10 AM > To: Reindl Harald > Cc: mysql@lists.mysql.com > Subject: Re: How to change max simultaneous connection parameter in > mysql. > > 2013/3/24 Reindl Harald > > > > > > &

RE: How to change max simultaneous connection parameter in mysql.

ld [mailto:h.rei...@thelounge.net] > Sent: Tuesday, April 02, 2013 2:00 PM > To: mysql@lists.mysql.com > Subject: Re: How to change max simultaneous connection parameter in > mysql. > > > > Am 02.04.2013 22:56, schrieb Rick James: > > I hear that nginx is very fas

Re: How to change max simultaneous connection parameter in mysql.

tell me something new >> -Original Message- >> From: Reindl Harald [mailto:h.rei...@thelounge.net] >> Sent: Tuesday, April 02, 2013 2:00 PM >> To: mysql@lists.mysql.com >> Subject: Re: How to change max simultaneous connection parameter in >> mysql. >

RE: How to change max simultaneous connection parameter in mysql.

ei...@thelounge.net] > Sent: Tuesday, April 02, 2013 8:29 AM > To: mysql@lists.mysql.com > Subject: Re: How to change max simultaneous connection parameter in > mysql. > > > > Am 02.04.2013 16:09, schrieb spameden: > > 2013/3/24 Reindl Harald > <mailto:h

Re: How to change max simultaneous connection parameter in mysql.

il.com] >> Sent: Tuesday, April 02, 2013 7:10 AM >> To: Reindl Harald >> Cc: mysql@lists.mysql.com >> Subject: Re: How to change max simultaneous connection parameter in >> mysql. >> >> 2013/3/24 Reindl Harald >> >>> >>> >>>

Re: How to change max simultaneous connection parameter in mysql.

Am 02.04.2013 16:09, schrieb spameden: > 2013/3/24 Reindl Harald > > > Am 24.03.2013 05:20, schrieb spameden: > > 2013/3/19 Rick James >: > >>> you never have hosted a large site > >> Check my email address before sayin

Re: How to change max simultaneous connection parameter in mysql.

2013/3/24 Reindl Harald > > > Am 24.03.2013 05:20, schrieb spameden: > > 2013/3/19 Rick James : > >>> you never have hosted a large site > >> Check my email address before saying that. > > > > :D > > as said, big company does not have only geniusses > I do not judge only on 1 parameter, Rick has

Re: How to change max simultaneous connection parameter in mysql.

2013/3/24 Reindl Harald > > > Am 24.03.2013 05:20, schrieb spameden: > > 2013/3/19 Rick James : > >>> you never have hosted a large site > >> Check my email address before saying that. > > > > :D > > as said, big company does not have only geniusses > > >> 20 may be low, but 100 is rather high. >

Re: How to change max simultaneous connection parameter in mysql.

Am 24.03.2013 05:20, schrieb spameden: > 2013/3/19 Rick James : >>> you never have hosted a large site >> Check my email address before saying that. > > :D as said, big company does not have only geniusses >> 20 may be low, but 100 is rather high. > Never use apache2 it has so many problems un

Re: How to change max simultaneous connection parameter in mysql.

e if well tuned. > >> -Original Message- >> From: Reindl Harald [mailto:h.rei...@thelounge.net] >> Sent: Monday, March 18, 2013 1:36 PM >> To: mysql@lists.mysql.com >> Subject: Re: How to change max simultaneous connection parameter in >> mysql. >>

Re: How to change max simultaneous connection parameter in mysql.

mory and CPU so please get rid of your i386 and stop to explain me the world >> -Original Message- >> From: Reindl Harald [mailto:h.rei...@thelounge.net] >> Sent: Monday, March 18, 2013 1:36 PM >> To: mysql@lists.mysql.com >> Subject: Re: How to change max sim

RE: How to change max simultaneous connection parameter in mysql.

ubject: Re: How to change max simultaneous connection parameter in > mysql. > > > > Am 18.03.2013 21:01, schrieb Rick James: > > 20 is plenty if your pages run fast enough > > it is not > you never have hosted a large site > > > Excess clients after MaxClients

RE: How to change max simultaneous connection parameter in mysql.

6, 2013 1:45 AM > To: mysql@lists.mysql.com > Subject: Re: How to change max simultaneous connection parameter in > mysql. > > Hi Kevin, > In your MySQL client pls execute: > SET GLOBAL max_connections = 200; > To Make the change permanent you can edit /etc/my.cnf or whatev

Re: How to change max simultaneous connection parameter in mysql.

On Mon, 2013-03-18 at 21:35 +0100, Reindl Harald wrote: > > Am 18.03.2013 21:01, schrieb Rick James: > > 20 is plenty if your pages run fast enough > > if your server can not serve more than 20 simultaionous > requests you are not doing any serious things > or he's using a 286 signatu

Re: How to change max simultaneous connection parameter in mysql.

o:h.rei...@thelounge.net] >> Sent: Monday, March 18, 2013 12:15 PM >> To: mysql@lists.mysql.com >> Subject: Re: How to change max simultaneous connection parameter in >> mysql. >> >> >> >> Am 18.03.2013 19:26, schrieb Rick James: >>> If you are r

RE: How to change max simultaneous connection parameter in mysql.

error. > -Original Message- > From: Reindl Harald [mailto:h.rei...@thelounge.net] > Sent: Monday, March 18, 2013 12:15 PM > To: mysql@lists.mysql.com > Subject: Re: How to change max simultaneous connection parameter in > mysql. > > > > Am 18.03.2013 19:26,

Re: How to change max simultaneous connection parameter in mysql.

Am 18.03.2013 19:26, schrieb Rick James: > If you are running Apache with MaxClients set too high, that can cause the > problem. "too high" is relative > That Apache setting should be something like 20. (Other web servers have > similar settings.) 20 is a laughable value as long you are n

Re: How to change max simultaneous connection parameter in mysql.

Hi Kevin, In your MySQL client pls execute: SET GLOBAL max_connections = 200; To Make the change permanent you can edit /etc/my.cnf or whatever MySQL config file you you've got in your system Look for this line max_connections under [mysqld] secction, add it if it's not in the config. make sure

Re: How to change max simultaneous connection parameter in mysql.

2013/3/16 Kevin Peterson > I am using PHP along with mysql. Mysql default configuration allows to > have 100 simultaneous connection which I want to chane to 200. Please help. > If you're reaching too many connections quite often, this change can imply memory problems in your server. If you are

Re: Retrieve the values from the table of its max date

perhaps you are looking for something like select entry,timestamp from table A where A.timestamp=(select max(B.timestamp) from table B where a.entry=b.entry); also this oage may be helpful: http://www.artfulsoftware.com/infotree/queries.php re, wh Am 30.11.2012 02:39, schrieb h...@tbbs.net

RE: Retrieve the values from the table of its max date

and answered many times on forums.mysql.com > -Original Message- > From: h...@tbbs.net [mailto:h...@tbbs.net] > Sent: Thursday, November 29, 2012 5:40 PM > To: mysql@lists.mysql.com > Subject: Re: Retrieve the values from the table of its max date > > >&g

Re: Retrieve the values from the table of its max date

2012/11/29 11:46 +0530, Trimurthy i have a table which contains the columns date,sname,age,item,quantity,units.my question is i want to retrieve all the values from the table where date=maxdate group by sname how can i get those values. A question, I suspect, found in all SQL

RE: Default Values for Max User and Max Connections.

After installing, do SHOW VARIABLES LIKE 'max%'; If you don't like the values, then ad a line to my.cnf (my.ini) and restart. For max_user_connections, I think "0" means "unlimited". > -Original Message- > From: Wayne Leutwyler [mailto

Default Values for Max User and Max Connections.

Hello All, Question. In mysql 5.5 what are the defaults for these values: max_connections = ? (is this set to 151 in 5,5) max_user_connections = ?(is this set to unlimited unless you provide the exact number)? Thank you so much. Wayne Leutwyler, RHCT Open Source + Open M

Best way to tune substr,min,max query

select substr(rsyslog.SystemEvents.FromHost,1,if((locate(_latin1'.',rsyslog.SystemEvents.FromHost) > 0),(locate(_latin1'.',rsyslog.SystemEvents.FromHost) - 1),length(rsyslog.SystemEvents.FromHost))) AS hostname, max(rsyslog.SystemEvents.DeviceReportedTime) AS first_syslog_entry, min(rsysl

Re: max allowed packets on Mac

Dec 17, 2010 at 12:16 PM, g...@noiseunit.com >> wrote: >> > Hi, >> > >> > I found this page on the wiki regarding max allowed packets. >> > http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html >> > >> > >> > Howeve

Re: max allowed packets on Mac

d give your admin password when asked. You should now be root and > can expect permissions to behave as you would expect. > > - michael dykman > > On Fri, Dec 17, 2010 at 12:16 PM, g...@noiseunit.com > wrote: > > Hi, > > > > I found this page on the wiki regard

Re: max allowed packets on Mac

16 PM, g...@noiseunit.com wrote: > Hi, > > I found this page on the wiki regarding max allowed packets. > http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html > > > However, on my Mac OSX when I try to run the following from terminal window > I get "Pe

max allowed packets on Mac

Hi, I found this page on the wiki regarding max allowed packets. http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html However, on my Mac OSX when I try to run the following from terminal window I get "Permission Denied" shell> mysqld --max_allowed_packet=16M And if I

Re: Get max ID of each item in a list

SELECT tid,max(id) FROM mytable GROUP BY tid Le 10 sept. 2010 à 19:12, Bryan Cantwell a écrit : > I have a simple table > > mytable > id int > time_stamp tiemstamp > value int > tid int > > I want to find the max id for each individual tid in my table. > > i

Get max ID of each item in a list

I have a simple table mytable id int time_stamp tiemstamp value int tid int I want to find the max id for each individual tid in my table. if I did it one by one it would be: select max(id) from mytable where tid = 12345; but how can I do something more like: select concat(tid,':'

Re: MySQL 5.0.44 with Innodb Max memory problem :-(

On 7/21/2010 12:16 PM, Nunzio Daveri wrote: database is around 150GB with over 5,000 tables. To make things worse, if I shutdown MySQL, top-c still says all the memory is still used? Is this a bug, why would it say all the memory is used when I turn off MySQL. The weird thing is that when I rebo

MySQL 5.0.44 with Innodb Max memory problem :-(

Hello Gurus, I just inhereted a Sun 2 U Server with 2 Intel Quad Core CPU's and 16 GB of ram. Here is the problem. The machine is constantly at 99% Memory utilization and we get random row locking, we are only using InnoDB. The database is around 150GB with over 5,000 tables. To make things wors

Re: How to compute the min and max of two numbers?

I want to select all the rows where the minimum of column1 and column2 are bigger than the maximum of col3 and col4 ... WHERE Least(col1,col2) > Greatest(col3, col4) ... PB http://www.artfulsoftware.com - Peng Yu wrote: I don't see there is a function to compute min or ma

Re: How to compute the min and max of two numbers?

On Tue, 27 Apr 2010 09:08:29 Peng Yu wrote: > I don't see there is a function to compute min or max of two numbers > in a row. Essentially I want to select all the rows where the minimum > of column1 and column2 are bigger than the maximum of col3 and col4 > (The following cod

How to compute the min and max of two numbers?

I don't see there is a function to compute min or max of two numbers in a row. Essentially I want to select all the rows where the minimum of column1 and column2 are bigger than the maximum of col3 and col4 (The following code won't work as I expected, if I am correct). select * fr

Finding the max integer using MySQL.

Hi there, I would like to find out the maximum (signed or unsigned) integer from MySQL. SELECT CAST( POW(2,100) as UNSIGNED) as max_int; # max_int | 9223372036854775808 This seems to be a MAX_BIGINT from the lookup table at http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html Is there a wa

Re: max() can't work

Why in the world would you think "select * from table_name group by movid having max(movid)" would work? It seems to compile without errors but doesn't give you what you seem to want. This would work: select * from table_name group by movid having movid = (select max(movid)

Re: max() can't work

hi It is not working, select * from table_name group by movid having max(movid) but it is working fine select * from table_name order by movid desc limit 1 From: Roland Kaber To: armando Cc: tech list ; mysql@lists.mysql.com Sent: Sat, 6 February, 2010 8

Re: max() can't work

Yes - you must use the subselect. Or, you can set a variable like: select @max := max(movid) from table_name; select * from table_name where movid = @max; On Sat, Feb 6, 2010 at 8:34 AM, tech list wrote: > select * from table_name where movid = max(movid); > > why the sql above c

Re: max() can't work

The max() function is an aggregate function which can be used in conjunction with GROUP BY in the SELECT or HAVING clause: http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html . This code should work: select * from table_name group by movid having max(movid). However, there is a

Re: max() can't work

the field "movid" is type integer or varchar ? 2010/2/6 tech list > select * from table_name where movid = max(movid); > > why the sql above can't work? > Shall I use a sub-select instead? > > select * from table_name where movid = (select max(movid) fro

max() can't work

select * from table_name where movid = max(movid); why the sql above can't work? Shall I use a sub-select instead? select * from table_name where movid = (select max(movid) from table_name) ? Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: Distinct max() and separate unique value

- Original Message - From: "Eric Anderson" To: Sent: Tuesday, October 20, 2009 4:05 PM Subject: Re: Distinct max() and separate unique value I'm trying to formulate a query on a Wordpress database that will give me the highest 'object_id' with the

Re: Distinct max() and separate unique value

On Tue, 20 Oct 2009, DaWiz wrote: I would try: select max(object_id), term_taxonomy_id group by term_taxonomy_id order by term_taxonomy_id; max(column) returns a single value so distinct is not needed. The group by and order by should only have columns thaqt are displayed and that are not

Re: Distinct max() and separate unique value

I would try: select max(object_id), term_taxonomy_id group by term_taxonomy_id order by term_taxonomy_id; max(column) returns a single value so distinct is not needed. The group by and order by should only have columns thaqt are displayed and that are not aggregate columns. - Original

Distinct max() and separate unique value

I'm trying to formulate a query on a Wordpress database that will give me the highest 'object_id' with the highest 'term_taxonomy_id', something like: +-----+--+ | max(distinct obje

Re: the max length of one SQL statement

hi, According to the transfer limit, ... 16M? 2009/3/20 raid fifa : > Hi guys, > > Anybody knows that how many bytes the max length of on SQL statement can be > in MySQL database? > I know it's 64KB i

the max length of one SQL statement

Hi guys,   Anybody knows that how many bytes the max length of on SQL statement can be in MySQL database? I know it's 64KB in Oracle.   Thanks. *^_^* ___ 好玩贺卡等你发，邮箱贺卡全新上线！ http://card.mail.cn.yahoo.com/

Re: UPDATE ... where max(datecolumn)

Is there ever more than one order per day? I also think you might mean "most current order per product", but you didn't say that. On Tue, Jan 27, 2009 at 8:38 AM, Adria Stembridge wrote: > I have a table like this: > > ID PRODUCT DATEORDERED > 152005-02-18 > 22

Re: INNODB and Max Processors

Gary, I need to know a lot about your workload to say whether it will work well on InnoDB with 4+ processors. You can check http://www.mysqlperformanceblog.com/ for a lot of benchmarks in this area. But in general, my opinion is that for most workloads, 4 total processors (cores included) is rea

INNODB and Max Processors

A few weeks back I was reading an article that said that INNODB doesn't take adantage of servers using more than 4 processors. I think I also recieved this as a reply some time ago as to the same thing. I was wondering if this is indeed true. We are using 5.1.30 and wanted to pickup a new du

UPDATE ... where max(datecolumn)

I have a table like this: ID PRODUCT DATEORDERED 152005-02-18 222008-03-13 322008-11-21 462009-01-21 A field has been added for current order to this table: ID PRODUCT DATEORDERED FLAGCURRENT I need to update

Re: how to optimize: max(timetstamp) where a.foo=b.foo ?

Peter Brawley wrote: >> to get the latest value for each id i have queries like: > >> select * from tab A where timestamp = (select max(timestamp) from tab >> B where B.id=A.id) group by id ; > > See "Within-group aggregates" at > http://www.artfulso

Re: how to optimize: max(timetstamp) where a.foo=b.foo ?

to get the latest value for each id i have queries like: select * from tab A where timestamp = (select max(timestamp) from tab B where B.id=A.id) group by id ; See "Within-group aggregates" at http://www.artfulsoftware.com/infotree/queries.php. PB walter harms wrote: hi li

Re: how to optimize: max(timetstamp) where a.foo=b.foo ?

On Thu, 2008-07-24 at 14:49 +0200, walter harms wrote: > hi list, > i have tables that look like this( <10.000 entries) : > > id, > timestamp, > value > > > to get the latest value for each id i have queries like: > > select * from tab A where timestamp

how to optimize: max(timetstamp) where a.foo=b.foo ?

hi list, i have tables that look like this( <10.000 entries) : id, timestamp, value to get the latest value for each id i have queries like: select * from tab A where timestamp = (select max(timestamp) from tab B where B.id=A.id) group by id ; on a fast system it takes round 4 sec to comp

Re: Error with max and group by

gives you random results for all but the grouped column. The example I pointed to will give you the values from the row with the MAX date for each person. Actually, this example is more complete for you, since it gets all the rows rather than one: http://dev.mysql.com/doc/refman/5.0/en/example-maxim

Re: Error with max and group by

Your query is just grabbing the max date within the group, but you are not specifying which record you should be pulling for the location, so it's using an arbitrary one within the group. In your query, there is not relation between max date and location. What you need to do is fin

Re: Error with max and group by

Thanks, but this is not the result I want. The SQL for the correct result is at http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group.html and I'm apparently using the correct SQL. The problem is that the columns are not coming out correctly - the rows considered for th

Re: Error with max and group by

On Fri, Jun 20, 2008 at 10:50 PM, Joe Pearl <[EMAIL PROTECTED]> wrote: > I want to get back only the most recent entry for each person and I don't > care about the order. I want the result to show Jim with the acq_date of > "2008-01-03", Mary and Sally with the location and date for all of them.

Error with max and group by

e most recent entry for each person and I don't care about the order. I want the result to show Jim with the acq_date of "2008-01-03", Mary and Sally with the location and date for all of them. However, when I run what I think should be the sql, I get: mysql> select name,

Fw: mysql query, min, max with where conditions

Well, if your particular problem has a well defined maximum minimum and minimum maximum (Ie the max(q) < 4294967296, because q is a 32 bit unsigned int, and min(q)> -1) then you can do it without any extra joins or sub selects. select a, b, min(IF(date <100, q, 4294967296)) as m

Re: mysql query, min, max with where conditions

CRISTEA, Adrian schrieb: Hello there, What is the corect syntax for selecting something like: select a, b, (min(q) where date<100), (max(q) where date>100) from a left join b left join c group by a.p i need min() max() values each of them with other WHERE clause. How can I do that?

mysql query, min, max with where conditions

Hello there, What is the corect syntax for selecting something like: select a, b, (min(q) where date<100), (max(q) where date>100) from a left join b left join c group by a.p i need min() max() values each of them with other WHERE clause. How can I do that? Adrian. -- MySQL General M

Re: Weird result on max compared to order by

[EMAIL PROTECTED] schrieb: Hi, I did a select on a primary key.. Select max(account_id) from mytable; -- it gave me a value X I did a select with order by Select account_id from mytable order by account_id desc limit 3 -- it gave me a value of Y ( Y is the

Weird result on max compared to order by

Hi, I did a select on a primary key.. Select max(account_id) from mytable; -- it gave me a value X I did a select with order by Select account_id from mytable order by account_id desc limit 3 -- it gave me a value of Y ( Y is the right value ) I was

Re: MySQL 5.1.23-rc compiled and max open files

Hi ALL, I have compiled MySLQ 5.1.23-rc for Linux 64bit ./configure CC=gcc CFLAGS="-DBIG_JOINS=1 -O3" CXX=g++ CXXFLAGS="-DBIG_JOINS=1 -felide-constructors -fno-exceptions -fno-rtti -O3" --prefix=/app/mysql-5.1.23-rc --localstatedir=/app/mysql-5.1.23-rc/data --libexecdir=/app/mysql-5.1.23-rc/bin -

Re: Hi,I want to know how big to configurate the max-connections parameter in my.cnf?

On Dec 22, 2007 10:55 AM, Moon's Father <[EMAIL PROTECTED]> wrote: > how big your mysql connections's users. How big users? don't know what you said. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to know the number of rows used in a SELECT MAX() query? FOUND_ROWS() not working.

Hi, Daevid Vincent wrote: Is there a way to know how many rows were used in a computation? I tried this 'trick' but I still get 1, when I know that there are 3 rows used... SELECT SQL_CALC_FOUND_ROWS MAX(DATE_ADD('2007-10-18 18:04:45', INTERVAL user_access_hours HOUR)),

How to know the number of rows used in a SELECT MAX() query? FOUND_ROWS() not working.

Is there a way to know how many rows were used in a computation? I tried this 'trick' but I still get 1, when I know that there are 3 rows used... SELECT SQL_CALC_FOUND_ROWS MAX(DATE_ADD('2007-10-18 18:04:45', INTERVAL user_access_hours HOUR)), MAX

Re: Using MAX function to fetch primary id

You can do it as long as there is only a single record with the max value. If there is more than 1 record with the same max value, there isn't a single record to pull. To do it, you would need to join on the results of the max query, and part of the join condition would be the max

RE: Using MAX function to fetch primary id

> -Original Message- > I need to select a max value for a group of records and I > also need the > primary key for that record. > > I am wondering if this can be done with a single query? e.g > > Table_x > > id count cat_id > 110

Using MAX function to fetch primary id

Hi, I need to select a max value for a group of records and I also need the primary key for that record. I am wondering if this can be done with a single query? e.g Table_x id count cat_id 110 1 220 2 335 2 415 1 with SELECT id, cat_id

why the max value of innodb_buffer_pool_size is always 4G

I install MySQL on Linux 2.6.9-52bs #2 x86_64 x86_64 x86_64 GNU/Linux, 16G memory with followiing step: 1. ./configure --prefix=/home/mysql/mysql2. make3. make install I set innodb_pool_buffer_size = 8G in my.cnf, but when I use "show variables like 'innodb_buffer_pool_size';" the result is : +

mysqld-max: segfault at and auto restart mysql

: mysqld-max[24953]: segfault at 416c7fe8 rip 003d45d68900 rsp 416c8018 error 6 Jun 20 16:03:34 PrivateData1 kernel: mysqld-max[3171]: segfault at 41541fe8 rip 003d45d68900 rsp 41542018 error 6 Jun 20 16:08:50 PrivateData1 kernel: mysqld-max[22925]: segfault

Re: How can I do something like this "SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3);" ?

2007/6/13, Ricardas S <[EMAIL PROTECTED]>: ops again you probably needed just select greatest(col1,col2,col3) from t order by 1 Thanks, it's work very well. best regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EM

Re: How can I do something like this "SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3);" ?

ops again you probably needed just select greatest(col1,col2,col3) from t order by 1 - Original Message - From: "Ricardas S" <[EMAIL PROTECTED]> To: "KLEIN Stéphane" <[EMAIL PROTECTED]> Cc: Sent: Wednesday, June 13, 2007 11:02 Subject: Re: How can I do

Re: How can I do something like this "SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3);" ?

select greatest(col1,col2,col3) from (select max(col1) as col1 from t) a, (select max(col2) as col2 from t) b, (select max(col3) as col3 from t) c - Original Message - From: "KLEIN Stéphane" <[EMAIL PROTECTED]> To: "Ricardas S" <[EMAIL PROTECTED]> Cc: S

Re: How can I do something like this "SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3);" ?

2007/6/13, Ricardas S <[EMAIL PROTECTED]>: Ops, small mistake, shoud be MAX((col1*(MAX_VALUE_OF_COL2+1)+col2)*(MAX_VALUE_OF_COL3+1)+col3) Sorry, my question is ashamed. Example, I've this row : Col1 | Col2 | Col3 1 | 5 | 8 6 | 2 | 4 12| 13 | 6 Aft

Re: How can I do something like this "SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3);" ?

Ops, small mistake, shoud be MAX((col1*(MAX_VALUE_OF_COL2+1)+col2)*(MAX_VALUE_OF_COL3+1)+col3) - Original Message - From: "Ricardas S" <[EMAIL PROTECTED]> To: Sent: Wednesday, June 13, 2007 09:36 Subject: Re: How can I do something like this "SELECT MAX(c

Re: How can I do something like this "SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3);" ?

Have you tried MAX((col1*(MAX_VALUE_OF_COL1+1)+col2)*(MAX_VALUE_OF_COL2+1)+col3) - Original Message - From: "KLEIN Stéphane" <[EMAIL PROTECTED]> To: Sent: Wednesday, June 13, 2007 09:30 Subject: How can I do something like this "SELECT MAX(col1, col2, col3) FROM

How can I do something like this "SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3);" ?

Hi, I would like do something like : SELECT MAX(col1, col2, col3) FROM mytable ORDER BY MAX(col1, col2, col3); I know this syntax is wrong but I would like get a solution to this stuff. Thanks for your help. Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Max columns in a tabel in MyISAM storage engine

ecause it's really fast and i can define each column properly but i currently see no option to go this way but with that way there will alway be a limit to the max. amount of answers in the system. If you're doing that, why not just make a flat-file database of the answers? That

RE: Max columns in a tabel in MyISAM storage engine

rtz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: Martijn Tonies [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 17, 2007 10:13 AM > To: mysql@lists.mysql.com > Subject: Re: Max columns in

RE: Max columns in a tabel in MyISAM storage engine

07 10:09 AM > To: 'Jerry Schwartz' > Cc: 'mysql@lists.mysql.com' > Subject: RE: Max columns in a tabel in MyISAM storage engine > > >> The "right" way to do this would be your second way, where > there would be > >> one row per answer

Re: Max columns in a tabel in MyISAM storage engine

> The "right" way to do this would be your second way, where there would be > one row per answer. I can't really grasp how the questions and answers > relate to anything else, so I'm making a lot of assumptions. > > If you are concerned that this technique is too slow, because it involves > lin

RE: Max columns in a tabel in MyISAM storage engine

ble at all). Fabian -- Fabian Köhler http://www.fabiankoehler.de > -Original Message- > From: Jerry Schwartz [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 17, 2007 3:50 PM > To: 'Fabian Köhler'; mysql@lists.mysql.com > Subject: RE: Max columns in a tabe

RE: Max columns in a tabel in MyISAM storage engine

Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: Fabian Köhler [mailto:[EMAIL PROTECTED] > Sent: Monday, April 16, 2007 7:04 PM > To: 'mysql@lists.mysql.com' &

Re: Max columns in a tabel in MyISAM storage engine

> Not necessarily. I do precisely this for a data base whose structure I do > not control. I stuff > > |code1|code2|code3| ... > > Into an unused text field. The users can query on LIKE "%|code2|%. The key > is to have a delimiter at the start and end of the entire list, so that the > string matc

RE: Max columns in a tabel in MyISAM storage engine

--Original Message- > From: Martijn Tonies [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 17, 2007 9:53 AM > To: mysql@lists.mysql.com > Subject: Re: Max columns in a tabel in MyISAM storage engine > > > > > > The "right" way to do this would be your second w

Re: Max columns in a tabel in MyISAM storage engine

s like oracle better on doing joins on such large tables? > >So i really like the idea of having one large table with many columns >because it's really fast and i can define each column properly but i >currently see no option to go this way but with that way there will >alway be

Re: Max columns in a tabel in MyISAM storage engine

There is another question coming to my mind: is it possible to define a view which has more columns then or does the same limits for a normal table apply to a view? regards, Fabian On Mon, 16 Apr 2007 23:39:40 -0700, "Micah Stevens" <[EMAIL PROTECTED]> said: > Fabian Köhler wrote: > > Hello, >

Re: Max columns in a tabel in MyISAM storage engine

I also thought about creating a "materialized view" with mysql by doing: create table vanswers (select ... query to get the table in the format..) or a stored procedure which generates a table like the one below, but all solutions seem to be slow like hell due to the high large joins which are nece

Re: Max columns in a tabel in MyISAM storage engine

arge amounts of data? Are other dbs like oracle better on doing joins on such large tables? So i really like the idea of having one large table with many columns because it's really fast and i can define each column properly but i currently see no option to go this way but with that way th

Re: Max columns in a tabel in MyISAM storage engine

Fabian Köhler wrote: Hello, i have table with answers to questions. Every answer is a column in the table. i.e. id|q1|q2|q3 1|answer1|answer2|answer5 2|answer3|answer4|asnwer6 another option to save it would be sth like this: id|field|value 1|q1|answer1 1|q2|answer2 1|q3|answer5 2|q1|answer3

Re: Max columns in a tabel in MyISAM storage engine

Fabian Köhler wrote: Hello, i have table with answers to questions. Every answer is a column in the table. i.e. id|q1|q2|q3 1|answer1|answer2|answer5 2|answer3|answer4|asnwer6 another option to save it would be sth like this: id|field|value 1|q1|answer1 1|q2|answer2 1|q3|answer5 2|q1|answer3

  1   2   3   4   5   6   7   8   9   10   >