date:20070717

[Care2002-developers] mysql tuning !

2007-07-17 Thread K2O2


Dear all,

MySQL 4.0 becomes slowing down on 20 of records on patient visit.
Especially when browsing, data of wards and its waiting list patients. I am
trying to tune the mysql Server increasing file size and also buffer.

Is there any one who solved the problem to make it faster Mysql server.

Please suggest me how to improve the speed on Mysql. As I am on urgent,
please reply me ASAP.


Regards,
kko!@
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/___
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers

Re: [Care2002-developers] mysql tuning !

2007-07-17 Thread Jonathon Coombes

On 17/07/2007, at 8:33 PM, K2O2 wrote:

> Dear all,
>
> MySQL 4.0 becomes slowing down on 20 of records on patient  
> visit. Especially when browsing, data of wards and its waiting list  
> patients. I am trying to tune the mysql Server increasing file size  
> and also buffer.
>
> Is there any one who solved the problem to make it faster Mysql  
> server.
>
> Please suggest me how to improve the speed on Mysql. As I am on  
> urgent, please reply me ASAP.

A slow query on 20 records is most likely nothing to do with your  
buffers, but is more likely to do with a missing or misconfigured  
index. Check what indexes are available and being used and see what  
can be adjusted there to get the most benefit.

Regards
Jonathon

Jonathon Coombes - Cybersite Consulting
MySQL Consulting + Training Partner
Authorised MySQL Training Centre
http://www.cybersite.com.au

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers

Re: [Care2002-developers] mysql tuning !

2007-07-17 Thread Robert Meggle

Hello all,

> > MySQL 4.0 becomes slowing down on 20 of records on patient
> > visit. Especially when browsing, data of wards and its waiting list
> > patients. I am trying to tune the mysql Server increasing file size
> > and also buffer.
> >
> > Is there any one who solved the problem to make it faster Mysql
> > server.
> >
> > Please suggest me how to improve the speed on Mysql. As I am on
> > urgent, please reply me ASAP.
> 
> A slow query on 20 records is most likely nothing to do with your
> buffers, but is more likely to do with a missing or misconfigured
> index. Check what indexes are available and being used and see what
> can be adjusted there to get the most benefit.
> 
> Regards
> Jonathon

Yes and no, but that's true indeed ;-) 
200.000 records make really no headache for mysql. Fist you should check the
suggestion of Jonathon of index. If that is okay, there is also a way of
digging deeper on your mysql-server:
http://dev.mysql.com/doc/refman/5.0/en/optimizing-the-server.html

I have here running also mysql on other projects with billions of records
and it's working extremely fast. So mysql does normally not know a frontier
when it's staring of getting slower (if the tables are indexed). 

Maybe you could tell little bit more about your server perimeters (CPU,
RAM...)

Robert



-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers

Re: [Care2002-developers] mysql tuning !

2007-07-17 Thread Jonathon Coombes


On 17/07/2007, at 9:19 PM, K2O2 wrote:

> Well,
>
> Here is my server spec. HP proliant dl 380 G5 Intel Xeon 3.0GHz.  
> 2GB RAM. Running CentOS 4. Hoping that server is quite ok. Please  
> check that variables.
> mysql> SHOW VARIABLES;

Hi K2O2,

You could increase your key_buffer and join_buffer sizes, but more  
importantly at this stage is probably to do a SHOW STATUS and send  
that through.

Regards
Jonathon


> +- 
> ++
> | Variable_name   |  
> Value  |
> +- 
> ++
> | back_log|  
> 50 |
> | basedir | / 
> usr/  |
> | bdb_cache_size  |  
> 8388600|
> | bdb_home| /var/lib/ 
> mysql/|
> | bdb_log_buffer_size |  
> 32768  |
> | bdb_logdir   
> ||
> | bdb_max_lock|  
> 1  |
> | bdb_shared_data |  
> OFF|
> | bdb_tmpdir  | / 
> tmp/  |
> | binlog_cache_size   |  
> 32768  |
> | bulk_insert_buffer_size |  
> 8388608|
> | character_set_client|  
> latin1 |
> | character_set_connection|  
> latin1 |
> | character_set_database  |  
> latin1 |
> | character_set_results   |  
> latin1 |
> | character_set_server|  
> latin1 |
> | character_set_system|  
> utf8   |
> | character_sets_dir  | /usr/share/mysql/ 
> charsets/ |
> | collation_connection|  
> latin1_swedish_ci  |
> | collation_database  |  
> latin1_swedish_ci  |
> | collation_server|  
> latin1_swedish_ci  |
> | concurrent_insert   |  
> ON |
> | connect_timeout |  
> 5  |
> | datadir | /var/lib/ 
> mysql/|
> | date_format | %Y-%m-% 
> d   |
> | datetime_format | %Y-%m-%d %H:%i:% 
> s  |
> | default_week_format |  
> 0  |
> | delay_key_write |  
> ON |
> | delayed_insert_limit|  
> 100|
> | delayed_insert_timeout  |  
> 300|
> | delayed_queue_size  |  
> 1000   |
> | expire_logs_days|  
> 0  |
> | flush   |  
> OFF|
> | flush_time  |  
> 0  |
> | ft_boolean_syntax   | + -><() 
> ~*:""&| |
> | ft_max_word_len |  
> 84 |
> | ft_min_word_len |  
> 4  |
> | ft_query_expansion_limit|  
> 20 |
> | ft_stopword_file| (built- 
> in) |
> | group_concat_max_len|  
> 1024   |
> | have_archive|  
> NO |
> | have_bdb|  
> YES|
> | have_blackhole_engine   |  
> NO |
> | have_compress

Re: [Care2002-developers] mysql tuning !

2007-07-17 Thread Jonathon Coombes


On 17/07/2007, at 9:44 PM, K2O2 wrote:

> Here again,

OK. There is no table locks showing up here, so that should be okay,  
so I am suggesting it is coming back to the indexing or the query  
structure.
Is the query being logged at all?

Regards
Jonathon

>
> mysql> SHOW STATUS;
> ++-+
> | Variable_name  | Value   |
> ++-+
> | Aborted_clients| 10  |
> | Aborted_connects   | 1   |
> | Binlog_cache_disk_use  | 0   |
> | Binlog_cache_use   | 0   |
> | Bytes_received | 209061  |
> | Bytes_sent | 7734641 |
> | Com_admin_commands | 59  |
> | Com_alter_db   | 0   |
> | Com_alter_table| 0   |
> | Com_analyze| 0   |
> | Com_backup_table   | 0   |
> | Com_begin  | 0   |
> | Com_change_db  | 127 |
> | Com_change_master  | 0   |
> | Com_check  | 0   |
> | Com_checksum   | 0   |
> | Com_commit | 0   |
> | Com_create_db  | 0   |
> | Com_create_function| 0   |
> | Com_create_index   | 0   |
> | Com_create_table   | 0   |
> | Com_dealloc_sql| 0   |
> | Com_delete | 0   |
> | Com_delete_multi   | 0   |
> | Com_do | 0   |
> | Com_drop_db| 0   |
> | Com_drop_function  | 0   |
> | Com_drop_index | 0   |
> | Com_drop_table | 0   |
> | Com_drop_user  | 0   |
> | Com_execute_sql| 0   |
> | Com_flush  | 1   |
> | Com_grant  | 0   |
> | Com_ha_close   | 0   |
> | Com_ha_open| 0   |
> | Com_ha_read| 0   |
> | Com_help   | 0   |
> | Com_insert | 13  |
> | Com_insert_select  | 0   |
> | Com_kill   | 0   |
> | Com_load   | 0   |
> | Com_load_master_data   | 0   |
> | Com_load_master_table  | 0   |
> | Com_lock_tables| 0   |
> | Com_optimize   | 0   |
> | Com_preload_keys   | 0   |
> | Com_prepare_sql| 0   |
> | Com_purge  | 0   |
> | Com_purge_before_date  | 0   |
> | Com_rename_table   | 0   |
> | Com_repair | 0   |
> | Com_replace| 0   |
> | Com_replace_select | 0   |
> | Com_reset  | 0   |
> | Com_restore_table  | 0   |
> | Com_revoke | 0   |
> | Com_revoke_all | 0   |
> | Com_rollback   | 0   |
> | Com_savepoint  | 0   |
> | Com_select | 654 |
> | Com_set_option | 0   |
> | Com_show_binlog_events | 0   |
> | Com_show_binlogs   | 0   |
> | Com_show_charsets  | 2   |
> | Com_show_collations| 2   |
> | Com_show_column_types  | 0   |
> | Com_show_create_db | 0   |
> | Com_show_create_table  | 0   |
> | Com_show_databases | 1   |
> | Com_show_errors| 0   |
> | Com_show_fields| 15  |
> | Com_show_grants| 0   |
> | Com_show_innodb_status | 0   |
> | Com_show_keys  | 0   |
> | Com_show_logs  | 0   |
> | Com_show_master_status | 0   |
> | Com_show_new_master| 0   |
> | Com_show_open_tables   | 0   |
> | Com_show_privileges| 0   |
> | Com_show_processlist   | 0   |
> | Com_show_slave_hosts   | 0   |
> | Com_show_slave_status  | 0   |
> | Com_show_status| 12  |
> | Com_show_storage_engines   | 0   |
> | Com_show_tables| 2   |
> | Com_show_variables | 6   |
> | Com_show_warnings  | 0   |
> | Com_slave_start| 0   |
> | Com_slave_stop | 0   |
> | Com_truncate   | 0   |
> | Com_unlock_tables  | 0   |
> | Com_update | 71  |
> | Com_update_multi   | 0   |
> | Connections| 84  |
> | Created_tmp_disk_tables| 0   |
> | Created_tmp_files  | 3   |
> | Created_tmp_tables | 32  |
> | Delayed_erro

Re: [Care2002-developers] mysql tuning !

2007-07-17 Thread steve

Make sure the query has an "order by". I swear I found not having an "order by" changed a query of 400,000 customers in a mysql system from 2 minutes to 10 seconds once. Never looked into it thoroughly as I very seldom have that concern. For certain, there are always more and less efficient ways to construct queries and which to use can sometimes be influenced by the number of records. Sometimes a single more complicated query is less efficient or unusable while extracting part of the query and using it in a separate query works great.

Steve 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jonathon Coombes
Sent: Tuesday, July 17, 2007 6:45 AM
To: care2002-developers@lists.sourceforge.net
Subject: Re: [Care2002-developers] mysql tuning !

On 17/07/2007, at 8:33 PM, K2O2 wrote:
> Dear all,
>
> MySQL 4.0 becomes slowing down on 20 of records on patient 
> visit. Especially when browsing, data of wards and its waiting list 
> patients. I am trying to tune the mysql Server increasing file size 
> and also buffer.
>
> Is there any one who solved the problem to make it faster Mysql 
> server.
>
> Please suggest me how to improve the speed on Mysql. As I am on 
> urgent, please reply me ASAP.
A slow query on 20 records is most likely nothing to do with your 
buffers, but is more likely to do with a missing or misconfigured 
index. Check what indexes are available and being used and see what 
can be adjusted there to get the most benefit.
Regards
Jonathon

Jonathon Coombes - Cybersite Consulting
MySQL Consulting + Training Partner
Authorised MySQL Training Centre
http://www.cybersite.com.au
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers
No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.10.8/904 - Release Date: 7/16/2007 5:42 PM

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.10.8/904 - Release Date: 7/16/2007 5:42 PM

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/___
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers

Re: [Care2002-developers] mysql tuning !

2007-07-17 Thread K2O2

Ok. I will try and I will let you know. Yeh, I better try right now. !

regards,
kko!@

==

On 7/17/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:

Make sure the query has an "order by". I swear I found not having an
"order by" changed a query of 400,000 customers in a mysql system from 2
minutes to 10 seconds once. Never looked into it thoroughly as I very seldom
have that concern. For certain, there are always more and less efficient
ways to construct queries and which to use can sometimes be influenced by
the number of records. Sometimes a single more complicated query is less
efficient or unusable while extracting part of the query and using it in a
separate query works great.

Steve

-Original Message-
From: [EMAIL PROTECTED] [
*mailto:[EMAIL PROTECTED]<[EMAIL PROTECTED]>]
On Behalf Of Jonathon Coombes
Sent: Tuesday, July 17, 2007 6:45 AM
To: care2002-developers@lists.sourceforge.net
Subject: Re: [Care2002-developers] mysql tuning !

On 17/07/2007, at 8:33 PM, K2O2 wrote:
> Dear all,
>
> MySQL 4.0 becomes slowing down on 20 of records on patient
> visit. Especially when browsing, data of wards and its waiting list
> patients. I am trying to tune the mysql Server increasing file size
> and also buffer.
>
> Is there any one who solved the problem to make it faster Mysql
> server.
>
> Please suggest me how to improve the speed on Mysql. As I am on
> urgent, please reply me ASAP.
A slow query on 20 records is most likely nothing to do with your
buffers, but is more likely to do with a missing or misconfigured
index. Check what indexes are available and being used and see what
can be adjusted there to get the most benefit.
Regards
Jonathon

Jonathon Coombes - Cybersite Consulting
MySQL Consulting + Training Partner
Authorised MySQL Training Centre
*http://www.cybersite.com.au* 
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
*http://sourceforge.net/powerbar/db2/*
___
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
*https://lists.sourceforge.net/lists/listinfo/care2002-developers*
 No
virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.8/904 - Release Date: 7/16/2007
5:42 PM
 No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.8/904 - Release Date: 7/16/2007
5:42 PM

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers

-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/___
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers

[Care2002-developers] Branches

2007-07-17 Thread Claudio Giulio Torbinio

Hi Carers
Due to the inutilizzation of the db_abstraction/ and php5_compatibility/ rep 
SVN (over 5 mounth) they will be deleted.
New branches added: 3th_generation/ with seagull framework, for test 
purpose.
All developer are invited to test the tool.
Regards
Claudio
--
CGT // mind in progress.
http://cgt.altervista.org (Claudio Torbinio)
email: [EMAIL PROTECTED]
tel. +393339925580 


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers

[Care2002-developers] Starter Kit Files

2007-07-17 Thread Absar Ali


Hi All,

I am developing insurance system for care2x, please give me a simple page 
which has some template file, using template variables, some language file, 
and a php file to execute.

This will help every one who wants to understand the structure of the 
care2x, although there is very good documentaion available but still for 
quick start this will really help.

Quick response will be highly appreaciated.

Regards,

Absar Ali.

_
http://liveearth.msn.com


-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers

[Care2002-developers] mysql tuning !

Re: [Care2002-developers] mysql tuning !

Re: [Care2002-developers] mysql tuning !

Re: [Care2002-developers] mysql tuning !

Re: [Care2002-developers] mysql tuning !

Re: [Care2002-developers] mysql tuning !

Re: [Care2002-developers] mysql tuning !

[Care2002-developers] Branches

[Care2002-developers] Starter Kit Files

9 matches

Site Navigation

Mail list logo

Footer information