get read/write percent to a table

Hello, Our mysql is using Innodb engines. How can I get the read/write percent to each table? for example, for the table_99, the read percent is 77%, write percent is 23%. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Percent of match in condition

say how many percent match are available. select * from my_table where sex_id = 1 or country_id = 120 or education_id I mean if in my table there are some records with sex_id = 1 or country_id = 120 then I got 2 (2 match) then I can say 66% percent match. Thank you, ali -- MySQL

Re: Percent of match in condition

On 10/21/2010 9:57 AM, Ali A.F.N wrote: Hi All, I have a table with different fileds and almost the type of all them are smallint. I want to search on some fields with OR condition. I want to know is there possibility to know how many fileds matched exactly? then I can say how many percent

RE: Percent of match in condition

my_table where sex_id = @sex or country_id = @country or education_id = @education order by num_matches desc; -Travis -Original Message- From: Ali A.F.N [mailto:alio...@yahoo.com] Sent: Thursday, October 21, 2010 7:58 AM To: mysql@lists.mysql.com Subject: Percent of match in condition

Percent of match in condition

Hi All, I have a table with different fileds and almost the type of all them are smallint. I want to search on some fields with OR condition. I want to know is there possibility to know how many fileds matched exactly? then I can say how many percent match are available. select * from

Re: crosstab with percent change between years

Hi Baron, Thanks for your message. After endless nights trying I could not get it to work, so I finally created a temporary table and run a second query to get the percentages. It works fine for now, but I wonder if it will take too long once there are thousands of records. Is there an

Re: crosstab with percent change between years

with the percent change respect the previous year. (lastYear-previousYear)*100/previousYear . It should look like this: Year 1 % 2% 200527 36 200638 40.7% 47 30.5% 200775 97.4% 54 14.8% 200878

crosstab with percent change between years

59 80 71 82 75 84 6 0 726 200878 87 90 74 76 74 65 70 78 85 32 0 809 What I have been unsuccesfully trying to accomplish is to have a column next to each month with the percent change

mysql process 99.9 percent

hi do you have any idea why the mysql process is 99.9 percent? when i click one hyperlink it takes more than 1 minute to load the page. thank you very much. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.6/111 - Release Date: 9/23

Re: mysql process 99.9 percent

Joeffrey Betita wrote: do you have any idea why the mysql process is 99.9 percent? No. when i click one hyperlink it takes more than 1 minute to load the page. thank you very much. Maybe if you provided some details then someone would be able to help you. We're not psychic. What

Re: mysql process 99.9 percent

-on logging, rerun selected queries with and without the explain syntax, look at the MySQL administrator process list to see which query is the problem whilst the CPU is 99.9 %. Good news is : 'it is solvable'. Mark Joeffrey Betita wrote: hi do you have any idea why the mysql process is 99.9 percent

Re: mysql process 99.9 percent

Joeffrey Betita wrote: hi Jasper the linux distribution is redhat 9, mysql-4.0.15a-log, apache-2.0.47, php-4.3.3 etc. just clicking one hyperlink and searching for any item. OK, would you mind providing the SQL query that's being executed when you click that hyperlink? You see, MySQL

Re: mysql process 99.9 percent

On Monday, 26 September 2005 at 9:29:32 +0200, mark carson wrote: Joeffrey Betita wrote: hi do you have any idea why the mysql process is 99.9 percent? when i click one hyperlink it takes more than 1 minute to load the page. thank you very much. Most readers in this list expect OS

Percent?

I can't find this in the manual (maybe I'm looking in the wrong place). How do I show a value as a percent? For example. SELECT data1, data2, data3 FROM table; Assuming data1 is 0.25, how do I show it as 25%? SELECT PERC(data1), data2, data3 FROM table;? Thanks. John Halladay

Re: Percent?

this in the manual (maybe I'm looking in the wrong place). How do I show a value as a percent? For example. SELECT data1, data2, data3 FROM table; Assuming data1 is 0.25, how do I show it as 25%? SELECT PERC(data1), data2, data3 FROM table;? Thanks. John Halladay

Re: Percent?

SELECT CONCAT(data1*100,'%') as percdata1, data2, data3 FROM table; John Halladay [EMAIL PROTECTED] wrote: I can't find this in the manual (maybe I'm looking in the wrong place). How do I show a value as a percent? For example. SELECT data1, data2, data3 FROM table; Assuming data1 is 0.25

RE: Percent?

]] Sent: Thursday, February 15, 2001 11:27 AM To: John Halladay Cc: MySQL List (E-mail) Subject: Re: Percent? couldn't you just do: SELECT data1 * 100 FROM table; which if data1 is 0.25, you'd get a result of 25, and depending on what you're using for the frontend, it would be really easy to add

RE: Percent?

: Thursday, February 15, 2001 1:36 PM To: John Halladay Cc: MySQL List (E-mail) Subject: Re: Percent? SELECT CONCAT(data1*100,'%') as percdata1, data2, data3 FROM table; John Halladay [EMAIL PROTECTED] wrote: I can't find this in the manual (maybe I'm looking in the wrong place). How do I show