questions mean what?
does the questions counter equate to the number of queries ran against the database? or then number of questions a query may have to ask the database for one query? if I do a select * from table1; and table one has 100 records does that equate to 100 questions or one question? Dean-O EMAIL CONFIDENTIALITY NOTICE This Email message, and any attachments, may contain confidential patient health information that is legally protected. This information is intended only for the use of the individual or entity named above. The authorized recipient of this information is prohibited from disclosing this information to any other party unless required to do so by law or regulation and is required to destroy the information after its stated need has been fulfilled. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or action taken in reliance on the contents of this message is strictly prohibited. If you have received this information in error, please notify the sender immediately by replying to this message and delete the message from your system. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
what does show status 'questions' refer to?
in the show status there is a line that says Questions and it shows a number The manual says this is the number of questions asked the mysql database. what I want to know does one query equal one question or if I did the select * and it brought back 100 rows... does that equate to 100 questions? Trying to get number of hits to the database. Maybe there is a better way to get that. Dean-O EMAIL CONFIDENTIALITY NOTICE This Email message, and any attachments, may contain confidential patient health information that is legally protected. This information is intended only for the use of the individual or entity named above. The authorized recipient of this information is prohibited from disclosing this information to any other party unless required to do so by law or regulation and is required to destroy the information after its stated need has been fulfilled. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or action taken in reliance on the contents of this message is strictly prohibited. If you have received this information in error, please notify the sender immediately by replying to this message and delete the message from your system. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: what does show status 'questions' refer to?
Thanks guys... I think questions does it. I just want to know how many queries hit the database. I am getting ready to unleash our company phonebook, with 10,000 plus listings and just want to make sure that it can handle it. I have a jndi connection pool established and have the max used connections set to 200. We are in testing mode and we set around 24 max used connections all the time. Is the the current number of users on the database when I did a show status or is that the top number of users on the database at any given time? Like a max indicator since the database was up. What value should I change the default 28800 wait timeout to for connections? Do these two values relate? Max Used Connections and Wait Timeout? Dean-O -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 10, 2004 1:27 PM To: Rhino; Rochester, Dean; MySQL (E-mail) (E-mail) Subject: Re: what does show status 'questions' refer to? At 13:15 -0500 3/10/04, Rhino wrote: - Original Message - From: Rochester, Dean [EMAIL PROTECTED] To: MySQL (E-mail) (E-mail) [EMAIL PROTECTED] Sent: Wednesday, March 10, 2004 12:35 PM Subject: what does show status 'questions' refer to? in the show status there is a line that says Questions and it shows a number The manual says this is the number of questions asked the mysql database. what I want to know does one query equal one question or if I did the select * and it brought back 100 rows... does that equate to 100 questions? I see Paul DuBois has already answered that; he's on the Documentation Team at MySQL so he's a pretty authoritative source. Trying to get number of hits to the database. Maybe there is a better way to get that. I've never seen a database that automatically tracks the number of hits to the database. That doesn't mean that MySQL doesn't do it - maybe someone here can answer that with 100% certainty - but I'd be a little surprised if it did. I'm wondering what hits means in the original question. If it refers to statements executed, the Questions value may be sufficient. If it refers to rows returned by statements, I don't believe there is a way to get that value. You can count the results from your own statements, of course, but if you connect a bunch of times all at once, each connection can count only its own statement results. And you cannot count the results from queries issued by clients that connect using other accounts. If you're interested in statements executed, broken down by statement type, try this: SHOW STATUS LIKE 'Com%'; However, the Com_select value reflects only SELECT statements actually executed by the server. If the query cache is on, some SELECT statements may be served directly out of the query cache without the server having to execute them. You can get the number of such queries like this: SHOW STATUS LIKE 'Qcache_hits'; -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ EMAIL CONFIDENTIALITY NOTICE This Email message, and any attachments, may contain confidential patient health information that is legally protected. This information is intended only for the use of the individual or entity named above. The authorized recipient of this information is prohibited from disclosing this information to any other party unless required to do so by law or regulation and is required to destroy the information after its stated need has been fulfilled. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or action taken in reliance on the contents of this message is strictly prohibited. If you have received this information in error, please notify the sender immediately by replying to this message and delete the message from your system. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
max used connections question
Does this number indicate the current number of connections or the max number of connections during the current uptime? We have this number max set to 200 from the default 100 how does this number go down during uptime? It hovers around 30 - 40 but sometimes goes to 90 But it does not seem to go back down without restarting the mysql service Dean-O EMAIL CONFIDENTIALITY NOTICE This Email message, and any attachments, may contain confidential patient health information that is legally protected. This information is intended only for the use of the individual or entity named above. The authorized recipient of this information is prohibited from disclosing this information to any other party unless required to do so by law or regulation and is required to destroy the information after its stated need has been fulfilled. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or action taken in reliance on the contents of this message is strictly prohibited. If you have received this information in error, please notify the sender immediately by replying to this message and delete the message from your system. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Why so many mysqld lines in process list on Linux box
We had an issue the other day where we could not access the myslq database we have on our redhat linux 7.2 box. when I did a ps -ef |grep mysql I got the following. root 645 1 0 2002 ?00:00:00 [safe_mysqld] root 688 645 0 2002 ?00:01:31 /usr/local/mysql/bin/mysqld --ba root 699 688 0 2002 ?00:00:33 /usr/local/mysql/bin/mysqld --ba root 700 699 0 2002 ?00:00:43 /usr/local/mysql/bin/mysqld --ba root 13208 699 99 Jan31 ?18:36:55 /usr/local/mysql/bin/mysqld --ba root 13308 699 0 Jan31 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13317 699 0 00:18 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13322 699 0 00:33 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13657 699 0 10:04 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13658 699 0 10:05 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13659 699 0 10:06 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13660 699 0 10:07 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13680 699 0 11:25 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13681 699 0 11:27 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13684 699 0 11:30 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13730 699 0 11:39 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13732 699 0 11:39 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13737 699 0 11:41 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13751 699 0 11:47 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13756 699 0 11:49 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13764 699 0 11:54 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13832 13813 0 12:05 pts/000:00:00 grep mysql Why so many? Is this a problem? Thanks in advance Dean-O - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Table says it is read only but it is not from file system level
I am running an sql insert against a mysql table version 3.23.52 When from the file system level the table has the following permissions. rw-rw-r-- table.frm rw-rw-r-- table.MYD rw-rw-r-- table.MYI When the sql runs it says the table is read only. I am connecting to the table as root and I have set the password too. I am using java to do this sql operation. I can select items from the table, but can not insert them. Thanks in advance Dean-O - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How can I set a char(2) column to always stay 2 chars?
-Original Message- From: [EMAIL PROTECTED] To: Rochester, Dean Sent: 4/3/02 4:26 PM Subject: Re: How can I set a char(2) column to always stay 2 chars? Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I have a table with a char(2) and when I send it '02' I want it to stay 02, but instead it stores 2 How do I make this store as '02'? Dean-O - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How do you set the char format for a column in Mysql table
I have a Mysql table with a char(2) column, name is Dependents. I want the value that I insert to always be to places. I have tried Insert into Table1 Dependents values '02'; but it inserts 2 in the Dependents column How do I make it insert 02? Thanks Dean-O - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How does one put images into a MySql database
Greeting all Is there a way to put images like jpgs, tifs, gifs, bmp files into a mysql database? I have done this with OLE objects using MS Access... can this be done using the blob data type some how? Thanks in advance Dean-O - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to read blob field data as picture and display on browser?
How about with Java and straight sql call to put the blob in a datastream or what object type? -Original Message- From: Kittiphum Worachat [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 1:08 AM To: ST Ooi; [EMAIL PROTECTED] Subject: Re: How to read blob field data as picture and display on browser? Hi If you use PHP it very simple to do by retrive data from BLOB field and then echo or print such as $sql=select fld_blob from tble_xxx; $result=mysql_db_query($db,$sql); $row=mysql_fetch_array($result); //suppose your data is JPEG Header(Content-type: Image/JPEG); echo $row['fld_blob']; Kittiphum Worachat,MT. www.hatyailab.com Thailand. OK, I know how to insert the data into a database, now how can i retrieve it and display it in client's browser? Thanks ST Ooi Malaysia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php