mysql cpu usage
hi everybody, PLATFORM: MySQL 4.1.8 version,OS:windowsXP We are working on a project that requires MySQL database monitoring. As part of it we monitor the network traffic to and from MySQL,harddisk space used by Mysql ,primary memory used by it and so on.As part of it we need to find the 'amount of cpu used' by MySQL . So if any one has information regarding it, please help us.It helps extremely in completing our project.We need to do JAVA programming with the information you provide.So give information,so that we could use it in our java programming. Thanks in advance. Yahoo! India Matrimony: Find your life partneronline.
Re: max key file length
Ingo Strüwing <[EMAIL PROTECTED]> wrote: Hi Sirisha, Am Donnerstag, den 27.01.2005, 08:41 + schrieb sirisha gnvg: > hai, > I tried the command "myisamchk -d -v ".It gives the output containing data > file length,key file length,max key file length of a myisam table.I supposed > to use the value of "MAX KEY FILE LENGTH" in my java program.For that I > search the souce code of mysql 4.1.8.It is used in the statement > "llstr(share->base.max_key_file_length,llbuff2)" in > ../myisam/myisamchk.c.(where share is a structure variable for MYISAM_SHARE& > base is a structure variable for MI_BASE_INFO).But I could not get how it is > computed.Can any one suggest me in detail > 1.HOW THE "MAX KEY FILE LENGTH " IS COMPUTED? myisam/mi_info.c mi_info(): max_key_file_length= mi_safe_mul(MI_MIN_KEY_BLOCK_LENGTH, ((ulonglong) 1 << (share->base.key_reflength*8))-1); > 2.WHAT ARE THE VARIABLES USED IN COMPUTING THAT PARAMETER? key_reflength is read from the key file by my_n_base_info_read() in mi_open(). > 3.HOW CAN I USE THOSE VARIABLES IN MY JAVA PROGRAM IN COMPUTING "MAX KEY FILE > LENGTH"? You can read the key file, following the file layout as given by the above mentioned functions. In that case, max_key_file_length is itself part of the key file. You just need to figure out, at which offset it is. Regards, Ingo -- Ingo Strüwing, Senior Software Developer MySQL AB, www.mysql.com Office: +49 30 43672407 Are you MySQL certified? www.mysql.com/certification Respected sir, Thank you for your reply.You suggested me that both key_reflength and max_key_file_length can be read from "key file".We just need to find the offset at which they are stored in "key file".But I have searched all files containing "key" as part of their name in "MySQL 4.1.9" folder for "max_key_file_length" and all those files all c or c++ program files. Then what do you mean by finding offset?Please once again explain in detail what "key file" is and what it contains. Thanking you, sirisha. Yahoo! India Matrimony: Find your life partneronline.
ms sql server to mysql migration
hello, The platform we are working is Mysql 4.1.8 version and Windows XP os. In ms sql server the space used and free space available for each database is obtained through 'sp_spaceused'procedure( built in ). Primary memory used by ms sql server and related services like query browser is obtained by "sysprocesses" table.It gives primary memory used in terms of pages in cache. The cpu used by ms sql server is obtained through "spt_monitor" table. similarly my friends who are working on oracle obtained all the above values from system tables for oracle. so both of them that is those working on ms sql server and oracle could use them directly in java programs. Are there any system tables in mysql that give info. about the above issues.If so please suggest them. If not please suggest us a way to get info. about above issues so that we can use them in our java programs. Thanks in advance. Yahoo! India Matrimony: Find your life partner online Go to: http://yahoo.shaadi.com/india-matrimony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql cpu and primary memory usages
hello, version:mysql 4.1.8 os:windows XP How can we measure the primary memory used and cpu used by MySQL database and related services like query browser etc.We don't want the info.obtained from windows task manager .Can we get it from any SQL commands.Are they stored in any variables. Thanks in advance. Yahoo! India Matrimony: Find your life partneronline.
mysql cpu and primary memory usages
hello, version:mysql 4.1.8 os:windows XP How can we measure the primary memory used and cpu used by MySQL database and related services like query browser etc.We don't want the info.obtained from windows task manager .Can we get it from any SQL commands.Are they stored in any variables. Yahoo! India Matrimony: Find your life partneronline.
mysql 4.1.8 client installation problem
We want only mysql 4.1.8 client version .How to get only client installed without server being installed? Thanking you, yours sincerely, sirisha. Yahoo! India Matrimony: Find your life partneronline.
show table status
hello everybody, Mysql version:4.1.8 OS:windows XP data_file_path:ibdata1:10M in my.ini file /* which is default value*/ As every one knew the data and index files of all innodb tables are stored in ibdata1(in this case). We created some user defined tables(innodb type).The number of user defined tables does not exceed 10.The size of each table also does not exceed 10 rows. We executed 'show table status' command and it gave innodb freespace:4092 KB. What does that mean?How come system tables and user defined tables(which are not more than 10) occupy 6MB?Does mysql does 10MB ibdata1 into partitions of 6MB and 4MB?If any one knew anything regarding this issue please answer immediately. Thanking you, your's sincerely, sirisha. Yahoo! India Matrimony: Find your life partneronline.
innodb tablespaces
We are working with mysql 4.1.8 version and windows XP os. In that version the default amount of tablespace for data files and index files is given as data_file_path=ibdata1:10M .we then executed 'show table status' command and got innodb freespace:4092 KB (in comment column) We then created another tablespace as data_file_path=ibdata1:10M;ibdata2:5M . Then we executed the following statements use sample/* user defined database*/ show table status /*we want free space in tablespace and we saw in manual that comment column of of show table status gives that.*/ We got in comment column innodb free space=9212 KB (nearly 9 MB) Then we removed ibdata2 manually from 'data' directory and also deleted the ibdata2:5M from my.ini file and again created ibdata2 with 7MB size as follows data_file_path=ibdata1:10M;ibdata2=7M Again we saw show table status output. It gave innodb freespace:16380KB (nearly 16MB) We have done it many times i.e removing ibdata2 and again adding it. But the comment column gave always the aggregate value as u can see from above output where the freespace is given as 16MB when it should be 11MB(4MB+7MB). Why did this occur?Should we not remove the ibdata2 file once it is created?If at all if we want to remove it,what are the places from where we have to remove it? Does show table status always give correct values? Thanking you, yours sincerely, sirisha. Yahoo! India Matrimony: Find your life partneronline.
create view not working on mysql 4.1.8
we are working on mysql 4.1.8 and windows XP platform. This version supports views.We created a view like this mysql>use sample mysql>create view v1 as select * from sam2; sam2 is a table We got an error errror 1024(42000):you have an error in your sql syntax; we checked the manual but the syntax is as written above.we also saw error 1024 in error notepad but we could not get any further details. please explain the fault in above statement Yahoo! India Matrimony: Find your life partneronline.
error 1114 appearing for some tables and not for other tables
hello everybody, We are working on mysql 4.1.8 version and windows XP platform. As every one knew the default table type here is innodb.All innodb data files and index files are stored in ibdata1 tablespace. We started creating user defined tables called sam1 consisting of 750 rows and 10 columns.All columns type is int.Then we did not get any problem.Next we created table sam2 with 10 columns of 'decimal' type and by the time we inserted 88 rows we got error 1114(HY000):the table 'sam2' is full. Why was that so,in one table we could insert 750 rows(The table size is shown as 98304 by show table status) while other one with decimal type values was filled for just 88 inserts(Table size is given as 16384 by 'show table status' command).Does mysql put max limit on table size?We searched all types of mysql variables but we could not find the answer. Please give the details of error 1114. Yahoo! India Matrimony: Find your life partneronline.
mysql tablespace monitoring
First of all, thanks for the mailing list for giving details about myisamchk.we used them but we got some errors which I have reported in 'myisamchk errors' mail to mysql. At present we are working in mysql 3.23.32 ,windows xp os. Are there any system tables that store mysql related info.(like memory related issues etc). Are there any other ways to find memory used and free memory available by data tables,log files,temporary tables.We want the information so that we can use it in programs.Information available through commands could not be used in programming(For ex:myisamchk works with single table.we need to monitor entire datadirectory so we need to write programs.) Thanking you, yours sincerely, sirisha. PS:FIRST OF ALL ARE THERE ANY SYSTEM TABLES THOSE STORE THE ABOVE RELATED INFORMATION.IF NOT PLEASE MENTION IT. Yahoo! India Matrimony: Find your life partneronline.
please advise on mysql memory,users monitoring
First of all, thanks for the mailing list for giving details about myisamchk.we used them but we got some errors which I have reported in 'myisamchk errors' mail to mysql. At present we are working in mysql 3.23.32 ,windows xp os. Are there any system tables that store mysql related info.(like memory related issues etc). Are there any other ways to find memory used and free memory available by data tables,log files,temporary tables.We want the information so that we can use it in programs.Information available through commands could not be used in programming(For ex:myisamchk works with single table.we need to monitor entire datadirectory so we need write programs.) Thanking you, yours sincerely, sirisha. Yahoo! India Matrimony: Find your life partneronline.
mysql memory,users monitoring
First of all, thanks for the mailing list for giving details about myisamchk.we used them but we got some errors which I have reported in 'myisamchk errors' mail to mysql. At present we are working in mysql 3.23.32 ,windows xp os. Are there any system tables that store mysql related info.(like memory related issues etc). Are there any other ways to find memory used and free memory available by data tables,log files,temporary tables.We want the information so that we can use it in programs.Information available through commands could not be used in programming(For ex: myisamchk works with single table.we need to monitor entire datadirectory so we need write programs.) Thanking you, yours sincerely, sirisha. Yahoo! India Matrimony: Find your life partneronline.
mysql memory,users monitoring
First of all, thanks for the mailing list for giving details about myisamchk. At present we are working in mysql 3.23.32 ,windows xp os. Are there any system tables that store mysql related info.(like memory related issues etc). Are there any other ways to find memory used and free memory available by data tables,log files,temporary tables.We want the information so that we can use it in programs.Information available through commands could not be used in programming(For ex: myisamchk works with single table.we need to monitor entire datadirectory so we need write programs.) Thanking you, yours sincerely, sirisha. Yahoo! India Matrimony: Find your life partneronline.
myisamchk errors
hello everybody, I used myisamchk /path/to/datadir/mysql/*.* to find memory already in use and free memory available for all tables in 'mysql' database.where mysql in above path refers to mysql database. I got two types of errors for all tables in that directory. They are myisamchk:error: -1 when opening myisam_table 'abcd.MYD' myisamchk1 error:'abcd.frm' doen't have a correct index definition.You need to create it before u can do a repair.I am using Red hat linux mysql version. Please give more information about these errors and the ways to rectify them. Thank you, yours, sirisha. Yahoo! India Matrimony: Find your life partneronline.
if you know the answer,please answer immediately contd
I am a student and we are doing project in mysql database monitoring.Yesterday I posted my doubts regarding that project to this forum. I got reply from Mr.Harish, his suggestion is to use show table status or myisamchk -d -v .Thank you sir for your reply. Actually i haven't made the queations clearer. This is what we have to do in our project,we have to monitor mysql database and continously calculate memory already used by and free memory available for each database(or table),each log file,each temporary table(mysql temporary tables).If free memory is less than a certain percentage we have to send an alert box to the user asking him to backup those tables and logfiles. So we need information about both used space and free space not just the size of those tables or log files. I asked to give details about the tables myisamchk works on.By that question I mean that because Myisamchk is giving details about memory used by tables those details should have been stored in some system tables or files.We need the names of those system tables or files. So if you have information regarding any of the above issues please answer immediately. yours sincerely, sirisha. Yahoo! India Matrimony: Find your life partneronline.
if you know please answer immediately
>I am a student and we are doing a project in mysql database monitoring. > 1 . we found that the memory used and free memory available for tables in > individual database is given by myisamchk -d -v command.But we don't have any > information about the tables or files myisamchk works on.so please give information if available. > 2 . we are required to find memory used and free memory available for all > types of tables,log files of mysql,temporary tables used by mysql database.We > don't get help from any of our professors since they don't have working > experience in mysql. >please give details to any one of the above questions if not all the questions. Yahoo! India Matrimony: Find your life partneronline.