Re: How to set max_connections ?

what do you mean it doesn't do anything? you should be able to set it on the command line as: --set-variable=max_connections=200 or you could edit the my.cnf file that mysql is using when it starts-up. if you can't find the my.cnf, then you should create one. here is a link to the manpage a

query

alright, not sure if i can even do this or not, but i figured the list would know. here is the query i have: SELECT count(ID),sum(pnt1)+sum(pnt2)+sum(pnt3)+sum(pnt4) FROM wiseQuiz_questions WHERE test='$test' here is the table structure i have: CREATE TABLE `wiseQuiz_questions` ( `ID` int(1

query optimization

trying to make a query faster. the list helped out a lot last time, so i figured i would bring back and get more assistance. any thoughts? katen EXPLAIN SYNTAX: +-+---+-+---+-+---+--+---+ | table | type | possible_keys | key |

Re: ENUM Default values on NULL

/documentation/mysql/full/manual_toc.html#ENUM katen At 01:07 PM 4/12/2002 -0400, Ruben I Safir wrote: >When I send a NULL it's rejected as bad data, which sort of makes sense > > >On 2002.04.12 12:33 Steve Katen wrote: > > Ruben, > > > > If you leave it as NOT NU

Re: ENUM Default values on NULL

Ruben, If you leave it as NOT NULL it should default to NO. "If an ENUM is declared NOT NULL, the default value is the first element of the list of allowed values." SIDE QUESTION: Are you doing something like: select * from table where enum_colum="NO" If you are running that type of query it

Re: ENUM Default values on NULL

ENUM can handle your needs. you should be able to just change your syntax to: FIELD ENUM('NO','YES') NULL under that syntax your default value will be NULL. this is from the documentation directly: "If an ENUM is declared NULL, NULL is also a legal value for the column, and the default value

Re: select query optimization

lesort" and the query run a lot faster again. > >Bye, > > Benjamin. > > >PS: And to answer the other question, yes INDEX and KEY are synonyms >in MySQL (see http://www.mysql.com/doc/C/R/CREATE_TABLE.html). > > >[...] > > -Original

RE: select query optimization

08:35 AM 4/10/2002 -0700, Lopez David E-r9374c wrote: >Katen > >Try using a compound index with STATE and POOL > > INDEX ipoolstate( POOL, STATE ) > >Use EXPLAIN SELECT to see what mysql thinks. > >David > >PS anybody know if KEY is the same as INDEX? > >

select query optimization

i have been working on getting this query as fast as possible and figured it was time to come to the mailing list. the below table currently holds about 43 thousand records with potential to grow to around 1,000,000 records. CREATE TABLE `RADPOOL` ( `id` int(11) NOT NULL auto_increment,

select query optimization

i am running a basic install of mysql version 3.23.49-log and i have a pretty simple query that is not fast enough for my needs. any thoughts on optimization would help. the table description is below: mysql> desc RADPOOL; ++--+--+-+-++ | Fie