what happen if exceed max connection in innodb

test it? 3. what will happen if the connection exceed 100 connection? (does mysql crash or display database unavailable error message or it just queued the connection requests) 4. how should i measure the cache and ram needed for the value of connections? thanx -- Chenri J Taman Palem L

Previous date problem

-- Forwarded message -- From: Chenri <[EMAIL PROTECTED]> Date: Mon, 24 Jan 2005 08:22:01 +0700 Subject: To: mysql@lists.mysql.com i have a price table no date price limit 01 1/1/05 5000 100 02 1/2/05 5010 100 03 1/3/05 5020 60 in order to input a record the price m

Re: problem starting mysqld-max

i've restart the machine and it run ok thanx On Mon, 24 Jan 2005 07:42:41 +0700, Chenri <[EMAIL PROTECTED]> wrote: > i'm having problem starting mysqld-max, > when i use command line it just didn't start with > no error message. > > I've shutdown t

problem starting mysqld-max

n like this thanks -- Chenri J Taman Palem Lestari B18 - 19A (021) 926 68651 - Esia jadi bisa SMS -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

get field name

0906; can someone help me? -- Chenri J Taman Palem Lestari B18 - 19A (021) 926 68651 - Esia jadi bisa SMS -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Update log

one more question, how about when i'm using 'BEGIN' and doesn't end it with 'COMMIT' neither 'ROLLBACK' what will happen. I've tried before and nothing happen but does anyone have an opinion? --- Chenri J <[EMAIL PROTECTED]> wrote: > i&#

Update log

i'm still using 3.23 can anyone show me how to activate update log by modifying the my.cnf/ my.ini And a question about update log, does it only record update and delete (mysql documentation), how about insert? do the log recorded those too? thanks _

how to get Previous date

I have a price table entered more than once every day, In the report for spesific day, I must show also the last entered price for the day before The problem is that the day before sometimes varies not fixed (if it is fixed I could just round down the required date substract the date with 86400

verbose

can anyone tell me about what verbose mode mean? is it Uppercase or Lower case matter or something with backtick? By the way what do backslash for in mysql query? Thanx guys __ Do you Yahoo!? Yahoo! Mail - You care about security. So

binary column type

What is 'binary' in column type stand for? is it describe how the data is stored (in biner value)? what do we want use it for? - encryption ? - space efficiency ? - fast index ? - or ? I've searched the mysql manual but didn't find any clue about it thanks for your help before.