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

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

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

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

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

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

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

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,

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

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 mysqluse sample mysqlcreate 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

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

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

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

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

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

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

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 database name or myisamchk -d -v table_name .Thank you sir for your reply.