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

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

RE: what does show status 'questions' refer to?

. 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

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

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

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

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

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

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

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