你出现的太频繁了,兄弟
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
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
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,
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
: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
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?
>
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
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
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
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
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
> 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
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
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
> 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
--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
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
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,
>
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
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.
>
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
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
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
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?
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
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
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:/
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
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
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
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
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
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"
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
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
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
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 +
#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
"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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
[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
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
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
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.
>
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
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.
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
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
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
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
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
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;
+++--
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
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
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
mysql> describe art;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-++
| id | int(11) | | PRI | NULL| auto_increment |
| parent
; 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
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
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
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
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
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
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
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
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
>
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
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
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
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
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
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
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
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
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
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,
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
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
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
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 ---
* 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
--> 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
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,
[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
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
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
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 - 100 of 170 matches
Mail list logo