Re: max allowed packets on Mac

2010-12-21 Thread Sharl
你出现的太频繁了,兄弟 You post too frequently in the list. 杨涛涛 编写: >I agree with michael dykman. >杨涛 >我博客1:http://yueliangdao0608.cublog.cn >My 我博客2:http://yueliangdao0608.blog.51cto.com > > >2010/12/18 Michael Dykman > >> I'm not nuts about deploying MySQL on macs, but I think you need to >> assume roo

Re: max allowed packets on Mac

2010-12-21 Thread 杨涛涛
I agree with michael dykman. 杨涛 我博客1:http://yueliangdao0608.cublog.cn My 我博客2:http://yueliangdao0608.blog.51cto.com 2010/12/18 Michael Dykman > I'm not nuts about deploying MySQL on macs, but I think you need to > assume root. As your mac admin user, try > $ sudo su - > and give your admin pas

Re: max allowed packets on Mac

2010-12-17 Thread Michael Dykman
I'm not nuts about deploying MySQL on macs, but I think you need to assume root. As your mac admin user, try $ sudo su - and 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,

Re: max() can't work

2010-02-06 Thread Jim Lyons
t * 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:28:06 PM > Subject: Re: max() can't work > > The max() function

Re: max() can't work

2010-02-06 Thread Vikram A
:28:06 PM Subject: 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

Re: max() can't work

2010-02-06 Thread Jim Lyons
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 can't work? >

Re: max() can't work

2010-02-06 Thread Roland Kaber
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 simp

Re: max() can't work

2010-02-06 Thread armando
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) from table_name) > ? > > > Thanks in advance

Re: Max columns in a tabel in MyISAM storage engine

2007-04-17 Thread Micah Stevens
On 04/17/2007 04:18 AM, Fabian Köhler wrote: Thanks for all the input. The problem i have with this idea: Really? Wow, my opinion is that you're trying to do in one table what you should do in two. Have a questions table, and an answers table. The answers table would have a column specifyin

RE: Max columns in a tabel in MyISAM storage engine

2007-04-17 Thread Jerry Schwartz
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

2007-04-17 Thread Jerry Schwartz
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

2007-04-17 Thread Martijn Tonies
> 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

2007-04-17 Thread Fabian Köhler
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

2007-04-17 Thread Jerry Schwartz
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 linking two tables

Re: Max columns in a tabel in MyISAM storage engine

2007-04-17 Thread Martijn Tonies
> 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

2007-04-17 Thread Jerry Schwartz
--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

2007-04-17 Thread Martijn Tonies
Hi, >> Really? Wow, my opinion is that you're trying to do in one table what >> you should do in two. Have a questions table, and an answers table. The >> answers table would have a column specifying which question they belong >> to. i.e. >> >> QUESTIONS >> int autoincrement questionID >> question

Re: Max columns in a tabel in MyISAM storage engine

2007-04-17 Thread Fabian Köhler
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

2007-04-17 Thread Fabian Köhler
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

2007-04-17 Thread Fabian Köhler
Thanks for all the input. The problem i have with this idea: > Really? Wow, my opinion is that you're trying to do in one table what > you should do in two. Have a questions table, and an answers table. The > answers table would have a column specifying which question they belong > to. i.e. >

Re: Max columns in a tabel in MyISAM storage engine

2007-04-16 Thread Stijn Verholen
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

2007-04-16 Thread Micah Stevens
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

2007-04-16 Thread ViSolve DB Team
Hi, Might be column indexing have restriction over number of columns to be indexed, but for number of columns, hope you can overrider with the variables "avg_row_length" and "max_rows" during create/alter table. The length/size of the table depends on the file system(maximum file size defin

Re: max mysql under windows

2007-02-08 Thread Eric Bergen
Hi Charles, The manual has a few options for running multiple mysql instances on windows. See: http://dev.mysql.com/doc/refman/5.0/en/multiple-windows-servers.html On 2/5/07, Brown, Charles <[EMAIL PROTECTED]> wrote: Hello All. Is it possible to setup two instances of MySQL under windows?

Re: Max number of 64 indices per table?

2007-01-26 Thread Francesco Riosa
Horst Jäger ha scritto: Hi everyone, the number of incices per table seems to be restricted to 64. Any way to change that? recompile with "configure --with-max-indexes=128" I'm using MySQL 5.0.27 . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: Max size and row numbers

2006-12-29 Thread Philip Mather
Olaf, That's a very broad question depending upon your exact requirements to be honest. So long as you've considered file size limitations and you've opted for a decent RAID system there's not too much more to worry about, try and buy the fastest disks possible obviously i.e. 15,000 RPM one

Re: Max size and row numbers

2006-12-29 Thread Philip Mather
Olaf, Thanks for the detailed answer. So basically the limitations come from the OS and the file system used. What is the best file system to use for mysql (not considering the filesize limitations)? Thanks Olaf The "best" is probably ZFS if you really are intent on make things huge, http:/

Re: Max size and row numbers

2006-12-29 Thread Olaf Stein
Thanks for the detailed answer. So basically the limitations come from the OS and the file system used. What is the best file system to use for mysql (not considering the filesize limitations)? Thanks Olaf On 12/29/06 2:25 AM, "ViSolve DB Team" <[EMAIL PROTECTED]> wrote: > Hi, > > The maxim

Re: Max size and row numbers

2006-12-28 Thread ViSolve DB Team
Hi, The maximum effective table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. If you need a MyISAM table that is larger than 4GB in size (and your operating system supports large files), the CREATE TABLE statement all

RE: Max date in recordset

2006-11-14 Thread Jerry Schwartz
z Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: João Cândido de Souza Neto [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 14, 2006 12:00 PM > To: mysql@lists.mysql.com > Subject: Re

RE: Max date in recordset

2006-11-14 Thread Jerry Schwartz
Assuming that insertdate is a DATE column, SELECT * FROM t WHERE t.insertdate = (SELECT MAX(t.insertdate) FROM t)); would do it. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > F

Re: Max date in recordset

2006-11-14 Thread Dan Buettner
If you're looking for the records from the last full day contained in the data, not the past 24 hours according to the clock, then this ought to work: select * from table where InsertDate >= date_sub( (select max(InsertDate from table),interval 1 day) order by InserDate desc Dan On 11/14/06, V

Re: Max date in recordset

2006-11-14 Thread Jo�o C�ndido de Souza Neto
select * from table where InsertDate = date_sub(now,interval 1 day) limit 3; Not tested, but i think it will work fine. ""Vittorio Zuccalà"" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > Hello, > i've a table with a lot of field and in particular: > "InsertDate","Box","Prt"

Re: MAX() and GROUP BY question

2006-11-12 Thread Jochem van Dieten
On 11/10/06, [EMAIL PROTECTED] wrote: Hello everybody Can you explain me please how to get the entire row where ID is maximum per given status_id Mysql 4.0.xx Have you checked the manual? There is an entire page specifically about the group-wise maximum. Jochem -- MySQL General Mailing List

Re: MAX() and GROUP BY question

2006-11-11 Thread [EMAIL PROTECTED]
f there is more optimised solution Thanks a lot - Original Message From: Tim Lucia <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Saturday, November 11, 2006 3:56:49 PM Subject: RE: MAX() and GROUP BY question How about select ID, X, Y, Z from USERS order by ID desc limit 1

RE: MAX() and GROUP BY question

2006-11-11 Thread Tim Lucia
How about select ID, X, Y, Z from USERS order by ID desc limit 1 Tim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, November 10, 2006 5:47 PM To: mysql@lists.mysql.com Subject: MAX() and GROUP BY question Hello everybody Can you explain me please ho

Re: MAX + SUM in one query

2006-11-06 Thread Arjan Hulshoff
and id same for both the tables. Is it so? Thanks ViSolve DB Team. - Original Message - From: "Ahmad Al-Twaijiry" <[EMAIL PROTECTED]> To: "Visolve DB Team" <[EMAIL PROTECTED]> Cc: "MySQL List" Sent: Monday, November 06, 2006 2:33 PM Subject: Re: MAX +

Re: MAX + SUM in one query

2006-11-06 Thread Ahmad Al-Twaijiry
#x27;offer' and id same for both the tables. Is it so? Thanks ViSolve DB Team. - Original Message - From: "Ahmad Al-Twaijiry" <[EMAIL PROTECTED]> To: "Visolve DB Team" <[EMAIL PROTECTED]> Cc: "MySQL List" Sent: Monday, November 06, 2006

Re: MAX + SUM in one query

2006-11-06 Thread Visolve DB Team
"Ahmad Al-Twaijiry" <[EMAIL PROTECTED]> To: "Visolve DB Team" <[EMAIL PROTECTED]> Cc: "MySQL List" Sent: Monday, November 06, 2006 2:33 PM Subject: Re: MAX + SUM in one query but what if I want also to include another table for example, can I do this : SE

Re: MAX + SUM in one query

2006-11-06 Thread Ahmad Al-Twaijiry
test where >> RequestType='offer' group by StockID; Pls have a look into the table and the output for the query. Thanks ViSolve DB Team. - Original Message - From: "Ahmad Al-Twaijiry" <[EMAIL PROTECTED]> To: "Visolve DB Team" <[EMAIL PROTECTE

Re: MAX + SUM in one query

2006-11-05 Thread Visolve DB Team
and the output for the query. Thanks ViSolve DB Team. - Original Message - From: "Ahmad Al-Twaijiry" <[EMAIL PROTECTED]> To: "Visolve DB Team" <[EMAIL PROTECTED]> Cc: "MySQL List" Sent: Monday, November 06, 2006 12:10 PM Subject: Re: MAX + SUM in

Re: MAX + SUM in one query

2006-11-05 Thread Ahmad Al-Twaijiry
Hi no R.RequestENDDate>=Date(now()) will work fine (I use it in other sql queries) also as you can see in my sql, I want to group using Stock_StockID , so your solution will not work with me On 11/5/06, Visolve DB Team <[EMAIL PROTECTED]> wrote: Hi, The query what you tried will return empty

Re: MAX + SUM in one query

2006-11-05 Thread Visolve DB Team
Hi, The query what you tried will return empty set only, since you have compared the RequestENDDate with now(), which always returns false[due to seconds]. Try extracting the date part alone from RequestENDDate for the Where cond. otherwise the query do well: select RequestID, sum(RequestTota

Re: RE: Max of Count

2006-11-01 Thread Dan Buettner
y Schwartz > Cc: mysql@lists.mysql.com > Subject: Re: Max of Count > > This might work for you, Jerry - you're on the right track, > pretty close. > > SELECT prod.prod_id, COUNT(*) > FROM prod, prod_rel > WHERE prod.prod_id = prod_rel.prod_id > GROUP BY prod.prod_i

RE: Max of Count

2006-11-01 Thread Jerry Schwartz
armington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: Dan Buettner [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 31, 2006 5:49 PM > To: Jerry Schwartz > Cc: mysql@lists.mysql.com > Subject: Re: Max of Count > > Thi

Re: Max of Count

2006-10-31 Thread Dan Buettner
This might work for you, Jerry - you're on the right track, pretty close. SELECT prod.prod_id, COUNT(*) FROM prod, prod_rel WHERE prod.prod_id = prod_rel.prod_id GROUP BY prod.prod_id ORDER BY 2 DESC LIMIT 1 Be aware that using the LIMIT 1 may be misleading in that if you have multiple entries w

RE: max size of TEXT columns

2006-05-29 Thread Robert DiFalco
FWIW, IMO LOB handling is really where MySQL lags behind all other enterprise database solutions. Firebird, DB2, Oracle, et al all are able to stream LOB data to and from disk so that it does not all need to be loaded in memory (multiple times for a single LOB). I would call this a bug but others w

Re: max size of TEXT columns

2006-05-29 Thread Paul DuBois
At 17:06 +0200 5/29/06, schlubediwup wrote: 2. problem according do the mysql docu TEXT/BLOB fields depend solely on the db environment and can grow to any length: 11.4.3. The |BLOB| and |TEXT| Types The maximum size of a |BLOB| or |TEXT| object is determined by its type, but "d

Re: max packet size question

2005-10-22 Thread Michael Stassen
Jasper Bryant-Greene wrote: On Fri, 2005-10-21 at 21:40 -0700, Logg, Connie A. wrote: The max packet size depends on the MTU your network and interface settings allow. The common packet size is 1500, however, if you can use 9000, you will get much better performace. I believe Rob is talkin

RE: max packet size question

2005-10-21 Thread Jasper Bryant-Greene
On Fri, 2005-10-21 at 21:40 -0700, Logg, Connie A. wrote: > The max packet size depends on the MTU your network and interface settings > allow. > The common packet size is 1500, however, if you can use 9000, you will get > much better performace. I believe Rob is talking about MySQL packet sizes

RE: max packet size question

2005-10-21 Thread Logg, Connie A.
I forgot to mention that the buffer sizes, block sizes and window sizes you use can also make a big difference. You need to calibrate those for your systems and you need to understand the characteristics of your source and destination nodes. If you are desparate for performance, you may need to

RE: max packet size question

2005-10-21 Thread Logg, Connie A.
The max packet size depends on the MTU your network and interface settings allow. The common packet size is 1500, however, if you can use 9000, you will get much better performace. Connie Logg Network Analyst Stanford Linear Accelerator Center -Original Message- From: Rob Brooks [mailt

Re: max Mysql database size

2005-09-14 Thread 2wsxdr5
Andrew stolarz wrote: Hello Everyone, Hopefully easy question, What is the Max size of a MySQL server database? The answer to that question depends more on your OS than mysql. A quick search of the contents page of the documentation clearly list the limitations of this kind. -- Chris W

Re: max Mysql database size

2005-09-14 Thread Chenzhou Cui
I have a database, which is more than 120GB with about 500 million records. MySQL works well. Andrew stolarz wrote: Hello Everyone, Hopefully easy question, What is the Max size of a MySQL server database? -- Chenzhou Cui (Chi

RE: MAX BLOB can Hold UP?

2005-08-01 Thread Jay Blanchard
[snip] ORACLE, BLOB (Binary Large Object) can hold up to 4 GB of data. How about Mysql? [/snip] Have a look here, the short answer is yes. http://dev.mysql.com/doc/mysql/en/blob.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mys

Re: MAX select problem

2005-07-29 Thread Philippe Poelvoorde
Lee Denny wrote: Hello, I'm trying to get the date and amount of the most visits to my site over a given time period using : SELECT max(visits) as maximum FROM visit WHERE (((visit_date >= '$sdatestring') and (visit_date < '$edatestring')) and (site_id=$site_id)) This gives me the right figure

Re: MAX select problem

2005-07-29 Thread Jigal van Hemert
Lee Denny wrote: Hello, I'm trying to get the date and amount of the most visits to my site over a given time period using : SELECT max(visits) as maximum FROM visit WHERE (((visit_date >= '$sdatestring') and (visit_date < '$edatestring')) and (site_id=$site_id)) This gives me the right figure

Re: MAX on UNSIGNED INT Column

2005-07-06 Thread Jacob S. Barrett
On Wednesday 06 July 2005 11:42 am, Keith Ivey <[EMAIL PROTECTED]> wrote: > Jacob S. Barrett wrote: > > I have a column of type UNSIGNED INT which holds a 32bit counter. When > > the value of the field exceeds 2147483647 (signed max) the value of MAX > > on the column returns a negative number. >

Re: MAX on UNSIGNED INT Column

2005-07-06 Thread Keith Ivey
Jacob S. Barrett wrote: I have a column of type UNSIGNED INT which holds a 32bit counter. When the value of the field exceeds 2147483647 (signed max) the value of MAX on the column returns a negative number. Possibly this bug, fixed in 4.1.12? http://bugs.mysql.com/bug.php?id=9298 -- Keith

Re: MAX on UNSIGNED INT Column

2005-07-05 Thread Paul DuBois
At 12:17 -0700 7/5/05, Jacob S. Barrett wrote: I have a column of type UNSIGNED INT which holds a 32bit counter. When the value of the field exceeds 2147483647 (signed max) the value of MAX on the column returns a negative number. If I convert the column to BIGINT the correct MAX is returned.

Re: Max Connections of MySQL on Linux

2005-06-27 Thread Gleb Paharenko
Hello. Check your results with official binaries. Set max_connections variable to big enough value. Combinations of different versions of compilers and glibc sometimes could give unpredictable results. "huang leo" <[EMAIL PROTECTED]> wrote: > Hi, everyone: >I had done a test on Lin

Re: max key file length

2005-02-08 Thread Ingo Strüwing
Hello, Am Montag, den 07.02.2005, 17:16 + schrieb sirisha gnvg: ... > Thank you for your reply.You suggested me that both > key_reflength and max_key_file_length can be read from "key > file".We just need to find the offset at which they are stored > in "key fil

Re: max key file length

2005-02-07 Thread sirisha gnvg
Ingo Strüwing <[EMAIL PROTECTED]> wrote: Hi Sirisha, Am Donnerstag, den 27.01.2005, 08:41 + schrieb sirisha gnvg: > hai, > I tried the command "myisamchk -d -v ".It gives the output containing data > file length,key file length,max key file length of a myisam table.I supposed > to use the

Re: Max connections being used every 10-12 day.

2005-01-05 Thread Fredrik Carlsson
Hi, My original query was a UNION query :) and that one is really fast. The problem i had was that every 8-12 day mysql sad that all of my max_connections was in use. I think i will stick with my UNION query it seems faster. // Fredrik. Bill Easton wrote: Fredrik, I haven't read all of th

Re: Max connections being used every 10-12 day.

2005-01-05 Thread Bill Easton
ED]> To: Donny Simonton <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: Max connections being used every 10-12 day. I really appreciate your help :) I did some cleanup of my indexes(there are a c

Re: Max connections being used every 10-12 day.

2005-01-03 Thread Fredrik Carlsson
I really appreciate your help :) I did some cleanup of my indexes(there are a couple of them left to clean out but it takes so long time): mysql> show index from art; +++--

RE: Max connections being used every 10-12 day.

2005-01-03 Thread Tom Crimmins
x. This is covered by 1st_2 or 1st_3. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: Tom Crimmins Sent: Monday, January 03, 2005 2:49 PM To: Donny Simonton; 'Fredrik Carlsson' Cc: mysql@lists.mysql.com Subject: RE: Max connections being

RE: Max connections being used every 10-12 day.

2005-01-03 Thread Tom Crimmins
onday, January 03, 2005 1:12 PM To: 'Fredrik Carlsson' Cc: mysql@lists.mysql.com Subject: RE: Max connections being used every 10-12 day. Frederik, I may be losing my mind, but I don't think I am according to your show index, you have multiple indexes on the same fields which is abso

RE: Max connections being used every 10-12 day.

2005-01-03 Thread Donny Simonton
g (id) where A.id=60 or B.parent=60 order by A.date Donny > -Original Message- > From: Fredrik Carlsson [mailto:[EMAIL PROTECTED] > Sent: Monday, January 03, 2005 11:08 AM > To: Donny Simonton > Cc: mysql@lists.mysql.com > Subject: Re: Max connections being used every 10-12 da

Re: Max connections being used every 10-12 day.

2005-01-03 Thread Fredrik Carlsson
mysql> describe art; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(11) | | PRI | NULL| auto_increment | | parent

RE: Max connections being used every 10-12 day.

2005-01-02 Thread Donny Simonton
; From: Fredrik Carlsson [mailto:[EMAIL PROTECTED] > Sent: Sunday, January 02, 2005 4:45 PM > To: mysql@lists.mysql.com > Subject: Re: Max connections being used every 10-12 day. > > The inner join statement returned the same stuff but it was not as fast > as the union is and the inne

Re: Max connections being used every 10-12 day.

2005-01-02 Thread Fredrik Carlsson
The inner join statement returned the same stuff but it was not as fast as the union is and the inner join seems to use more cpu resources. Could these union queries really be the problem behind my occasional lock ups and that 200 connections being used? i mean the server is not that loaded and

RE: Max connections being used every 10-12 day.

2005-01-02 Thread Donny Simonton
rom: Fredrik Carlsson [mailto:[EMAIL PROTECTED] > Sent: Sunday, January 02, 2005 5:18 AM > To: Donny Simonton > Cc: mysql@lists.mysql.com > Subject: Re: Max connections being used every 10-12 day. > > It is a single PIII 500MHz, so i just changed thread_concurrency to 2 > :), than

Re: Max connections being used every 10-12 day.

2005-01-02 Thread Benoit St-Jean
Fredrik Carlsson wrote: It is a single PIII 500MHz, so i just changed thread_concurrency to 2 :), thanks The slow query log don't show that many slow queries, but they did show alot of queries that was'nt using any index, can these queries cause some kind of occasional lock up? Is there a fas

Re: Max connections being used every 10-12 day.

2005-01-02 Thread Fredrik Carlsson
It is a single PIII 500MHz, so i just changed thread_concurrency to 2 :), thanks The slow query log don't show that many slow queries, but they did show alot of queries that was'nt using any index, can these queries cause some kind of occasional lock up? Is there a faster way to perform this

RE: Max connections being used every 10-12 day.

2005-01-01 Thread Donny Simonton
What kind of box is this? According to you're my.cnf it looks like it's a either a dual with hyperthreading or a quad box. I don't see that you have your slow query log turned on, this should be the first thing you should do in my opinion. This is what mine looks like. ### Slow Query Informat

Re: Max connections being used every 10-12 day.

2005-01-01 Thread Fredrik Carlsson
mysql has about 50GB of temp space to work with so thats not the problem. Its strange because the server is not that loaded and around 12-04 at night no cronjobs that affects mysql or general server performance are being run. Is is possible to se how many queued up questions mysql has at the mom

RE: Max connections being used every 10-12 day.

2005-01-01 Thread Peter Lovatt
Hi there a are a couple of things that I have found cause occasional lock ups. running out of temp space - MySql builds temp files on bigger queries and if it runs out of temp disk space it grinds to a halt, which causes all the following queries to queue up until max_connections is exceeded. th

RE: max allowed packet error

2004-11-02 Thread Anil Doppalapudi
cket Anil DBA -Original Message- From: Philippe Poelvoorde [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 8:13 PM To: Ferino Mardo; [EMAIL PROTECTED] Subject: Re: max allowed packet error HI, > I have copied the mysql-medium.cnf to /etc/my.cnf and have noticed that >

Re: max allowed packet error

2004-11-02 Thread Philippe Poelvoorde
HI, I have copied the mysql-medium.cnf to /etc/my.cnf and have noticed that the "max-allowed-packet" is 1M. no matter what I set it to 8M, 10M, 16M I still get the error. did you try this in your my.cnf in the [mysqld] section ? set-variable= max_allowed_packet=8M -- Philippe Poelvoorde COS Tr

RE: max allowed packet error

2004-11-01 Thread Ferino Mardo
yes that I did (installed binaries) and it's working now. *sigh* wish I could use the source. > -Original Message- > From: Gleb Paharenko [mailto:[EMAIL PROTECTED] > Sent: Monday, November 01, 2004 06:56 PM > To: [EMAIL PROTECTED] > Subject: Re: max allowed pac

Re: max allowed packet error

2004-11-01 Thread Gleb Paharenko
Hi. Please download and install official binaries, as this looks like a compilation bug which is likely to occur when compilation is done "by hands" on Linux. :) >folks I have successfully compiled and install mysql-4.1.7 from source >in my Debian (3.0, lots of free space in hd, 64MB RAM) w

Re: max db size for individual users

2004-05-20 Thread Egor Egorov
Jay Fitzgerald <[EMAIL PROTECTED]> wrote: > Does anyone know how or where to set the maximum size limit on a per > user basis for their db? This is not for a table, but for their entire db. > > example: >GRANT ALL ON usera.* TO [EMAIL PROTECTED] IDENTIFIED BY "password" > WITH max_db_size=5M

Re: Max

2004-05-13 Thread Mikhail Entaltsev
Thank you for correction. You are absolutly right! Best regards, Mikhail. - Original Message - From: "Brian Mansell" <[EMAIL PROTECTED]> To: "Mikhail Entaltsev" <[EMAIL PROTECTED]> Cc: "A Z" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> S

Re: Max

2004-05-12 Thread Brian Mansell
Just a minor correction... select YourField from YourTable order by YourField DESC limit 1; ('DESC' in order to return the greatest value first) On Tue, 11 May 2004 17:28:05 +0200, Mikhail Entaltsev <[EMAIL PROTECTED]> wrote: > > Hi, > > select YourField from YourTable order by YourField limit

Re: Max

2004-05-11 Thread Mikhail Entaltsev
Hi, select YourField from YourTable order by YourField limit 1; Best regards, Mikhail. - Original Message - From: "A Z" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 11, 2004 3:01 PM Subject: Max > > Hi, > > A field of type VarChar() with following syntax: > ABA1. > H

Re: Max Open Tables

2004-03-23 Thread Jim Richardson
On Tue, Mar 23, 2004 at 11:34:13AM -0800, Jim Richardson wrote: I am trying to push the performance of a Mysql database a little more, it's pretty busy, but I hope to squeeze a tad more out of it. I am a newbie/pretty clueless wrt MySQL in general, so ... I run the status command, and see the fo

Re: max key length 500 in myisam index

2004-02-05 Thread Mikhail Entaltsev
Adam, > I've got to create a table that has the following: > > CREATE TABLE access ( >query VARCHAR(255) NOT NULL, >INDEX (query) > ); > > and mysql is telling that the max bytes allowed is 500 for key length. > The docs say I can change this by recompiling, which I would like to > avo

Re: max key length 500 in myisam index

2004-02-03 Thread Victoria Reznichenko
Adam Hardy <[EMAIL PROTECTED]> wrote: > I've got to create a table that has the following: > > CREATE TABLE access ( > query VARCHAR(255) NOT NULL, > INDEX (query) > ); > > and mysql is telling that the max bytes allowed is 500 for key length. > The docs say I can change this by recompiling,

Re: max length of primary key

2004-01-07 Thread Martijn Tonies
Hi, > I have a problem when creating a table: > > > CREATE TABLE test ( > test_key varchar(255) NOT NULL default '', > test_value text NOT NULL, > PRIMARY KEY (test_key) ) TYPE=MYISAM; > > It then report error: > > mySQL Error: Specified key was too long. Max key length is 500 > > Why

RE: Max Packet for MySQL?

2003-11-03 Thread Mike At Spy
Dand, sorry, I forgot to cut and paste the error in there. :\ It was something to the point of 'exceeded max_allowed_packet', though. I can't find any sort of file in my system called 'my.cnf'. Is there another name or place this would be on a linux box? I have a Cobalt RAQ4 if you or anyone

RE: Max Packet for MySQL?

2003-10-31 Thread Mark Pittam
Could you include the error you receive? You can check the current value of your max_allowed_packet using the following command, mysql> show variables like 'max_allowed_packet'; max_allowed_packet determines the maximum packet length that the server can send and receive. You can set this value

Re: MAX in a SubSelect

2003-09-04 Thread Leonardo Rodrigues Magalhães
MySQL 4.0 (the current stable brench) does not support subqueries. This feature is present in the beta brench of MySQL, v4.1. http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#ANSI_diff_Subqueries Sincerily, Leonardo Rodrigues - Original Message ---

Re: Max number of databases

2003-09-03 Thread Roger Baklund
* Keith Schuster > Is there a max number of databases that will run under mysql This is AFAIK limited only by the OS: how many directories can exist inside one directory. Most file systems will perform slower with a high number of entries in a single directory, how high this number is depends on

Re: Max number of databases

2003-09-03 Thread Thomas Spahni
--> might be equal to the max number of directories you file system supports. Thomas Spahni On Tue, 2 Sep 2003, Keith Schuster wrote: > Is there a max number of databases that will run under mysql > --- > Keith Schuster > Schuster & Company LLC > ph:704-799-2438 > fx

Re: Max number of databases

2003-09-03 Thread Paul DuBois
At 23:14 -0400 9/2/03, Keith Schuster wrote: Is there a max number of databases that will run under mysql Not unless your operating system limits the number of directories that a given directory can contain. (MySQL represents each database by a directory under the data directory.) -- Paul DuBois,

Re: Max size

2003-08-19 Thread Miguel Perez
[EMAIL PROTECTED] Subject: Re: Max size Date: Mon, 18 Aug 2003 23:43:19 -0700 On Mon, Aug 18, 2003 at 02:33:04PM -0500, Miguel Perez wrote: > > I have an ibdata file that its size is 4.5GB, and it will increase > every day the max size of the hard disk is about 330GB, the question > is shoul

Re: Max size

2003-08-18 Thread Jeremy Zawodny
On Mon, Aug 18, 2003 at 02:33:04PM -0500, Miguel Perez wrote: > > I have an ibdata file that its size is 4.5GB, and it will increase > every day the max size of the hard disk is about 330GB, the question > is should I split this ibdata file in several files in a way that I > can reach this size? D

RE: max clients

2003-08-01 Thread Brian Austin
that helps. Brian -Original Message- From: NEWMEDIAPLAN [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 1:46 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: max clients Hi Jeremy I'm planning to use a dual xeon 2.8Ghz and 6/8 gb ram on the database server. Redh

RE: max clients

2003-07-31 Thread NEWMEDIAPLAN
ginal Message- |From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] |Sent: Thursday, July 31, 2003 11:36 PM |To: NEWMEDIAPLAN |Cc: [EMAIL PROTECTED] |Subject: Re: max clients | | |On Thu, Jul 31, 2003 at 08:36:02PM +0200, NEWMEDIAPLAN wrote: |> Can mysql handle 5000 concurrent webusers sending querie

  1   2   >