26 Oct
2005
26 Oct
'05
7:03 p.m.
Nguyen Manh Toan wrote:
Dear Mr. Stephane,
I'm working with xwiki and I have a problem with my Vietnamese content.
I've configured as the intruction at url:
http://www.xwiki.org/xwiki/bin/view/Dev/CharactersSets.
After configured, Xwiki did well for the first time but when I clear all
cache and restart Tomcat server some vietnamese character changed to
??????. I checked in mysql database and it store characters ???? too.
Could you help me to configure Xwiki work with vietnamese content?
Best regards,
Toan
Dear Toan,
I'm copying your request to xwiki-users mailing-list. Can you let us
know about the XWiki version and the MySQL version you're using? Can you
check whether MySQL is correctly set up for storing content in UTF-8
(by issuing the command "show variables")?
Greetings,
Stéphane
--
Stéphane Laurière
slauriere(a)mandriva.com
http://club.mandriva.com
27 Oct
27 Oct
4:33 a.m.
New subject: [xwiki-users] xWiki in multi languages
Dear Stephane,
I used xwiki version 0.9.840 and mysql database server version 4.1.12. I
used command: create database xwiki character set utf8; to create xwiki
database. And this is my mysql database variables:
+---------------------------------+----------------------------------------+
| Variable_name | Value |
+---------------------------------+----------------------------------------+
| back_log | 50 |
| basedir | D:\tools\mysql\ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | D:\tools\mysql\share\charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | utf8_general_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 5 |
| datadir | D:\tools\mysql\data\ |
| 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 | 1800 |
| 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 | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | NO |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | .\ |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | D:\tools\mysql\share\english\ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| log | OFF |
| log_bin | OFF |
| log_error | .\nguyenmanhtoan.err |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 1 |
| max_allowed_packet | 1048576 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 100 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 8388608 |
| named_pipe | OFF |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 510 |
| pid_file | D:\tools\mysql\data\nguyenmanhtoan.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 0 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 131072 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| shared_memory | OFF |
| shared_memory_base_name | MYSQL |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| sort_buffer_size | 2097144 |
| sql_mode | |
| storage_engine | MyISAM |
| sql_notes | ON |
| sql_warnings | ON |
| sync_binlog | 0 |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| sync_frm | ON |
| system_time_zone | SE Asia Standard Time |
| table_cache | 64 |
| table_type | MyISAM |
| thread_cache_size | 0 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 33554432 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.12a-nt |
| version_comment | Official MySQL binary |
| version_compile_machine | ia32 |
| version_compile_os | Win32 |
| wait_timeout | 28800 |
+---------------------------------+----------------------------------------+
185 rows in set (0.00 sec)
I think the problem is not in database. When building the source code, I
insert a command to print out the request's parameters after encoding in
file: com.xpn.xwiki.web.SetCharacterEncodingFilter.java and It print ????
for vietnamese characters.
Best regards,
Toan, Nguyen Manh
----- Original Message -----
From: "Stéphane Laurière" <slauriere(a)mandriva.com>
To: "Nguyen Manh Toan" <toan(a)netnam.vn>vn>;
<xwiki-users(a)objectweb.org>
Sent: Thursday, October 27, 2005 12:03 AM
Subject: Re: [xwiki-users] xWiki in multi languages
Nguyen Manh Toan wrote:
Dear Mr. Stephane,
I'm working with xwiki and I have a problem with my Vietnamese content.
I've configured as the intruction at url:
http://www.xwiki.org/xwiki/bin/view/Dev/CharactersSets.
After configured, Xwiki did well for the first time but when I clear all
cache and restart Tomcat server some vietnamese character changed to
??????. I checked in mysql database and it store characters ???? too.
Could you help me to configure Xwiki work with vietnamese content?
Best regards,
Toan
Dear Toan,
I'm copying your request to xwiki-users mailing-list. Can you let us
know about the XWiki version and the MySQL version you're using? Can you
check whether MySQL is correctly set up for storing content in UTF-8
(by issuing the command "show variables")?
Greetings,
Stéphane
--
Stéphane Laurière
slauriere(a)mandriva.com
http://club.mandriva.com
----------------------------------------------------------------------------
----
--
You receive this message as a subscriber of the xwiki-users(a)objectweb.org
mailing
list.
To unsubscribe:
mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
10:31 a.m.
New subject: [xwiki-users] xWiki in multi languages
Hi
In my mysql configuration I get the following variables :
character_set_client | utf8
character_set_connection | utf8
character_set_database | utf8
character_set_results | utf8
character_set_server | utf8
character_set_system | utf8
character_sets_dir | /usr/share/mysql/charsets/
collation_connection | utf8_general_ci
collation_database | utf8_general_ci
collation_server | utf8_general_ci
And I can manage well UTF-8 characters.
To to that in my my.cnf file (under /etc with Linux systems), I've added the
following configuration lines :
[client]
default_character_set=utf8
[mysqld]
default_character_set=utf8
hope it helps.
Regards
Xavier
Le Jeudi 27 Octobre 2005 04:33, Toan, Nguyen Manh a écrit :
Dear Stephane,
I used xwiki version 0.9.840 and mysql database server version 4.1.12. I
used command: create database xwiki character set utf8; to create xwiki
database. And this is my mysql database variables:
2:13 p.m.
New subject: [xwiki-users] xWiki in multi languages
Make sure you have modified the web.xml file to change the content type
for SetCharacterEncodingFilter
Ludovic
Toan, Nguyen Manh a écrit :
Dear Stephane,
I used xwiki version 0.9.840 and mysql database server version 4.1.12. I
used command: create database xwiki character set utf8; to create xwiki
database. And this is my mysql database variables:
+---------------------------------+----------------------------------------+
| Variable_name | Value |
+---------------------------------+----------------------------------------+
| back_log | 50 |
| basedir | D:\tools\mysql\ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | D:\tools\mysql\share\charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | utf8_general_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 5 |
| datadir | D:\tools\mysql\data\ |
| 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 | 1800 |
| 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 | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | NO |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | .\ |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | D:\tools\mysql\share\english\ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| log | OFF |
| log_bin | OFF |
| log_error | .\nguyenmanhtoan.err |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 1 |
| max_allowed_packet | 1048576 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 100 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 8388608 |
| named_pipe | OFF |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 510 |
| pid_file | D:\tools\mysql\data\nguyenmanhtoan.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 0 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 131072 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| shared_memory | OFF |
| shared_memory_base_name | MYSQL |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| sort_buffer_size | 2097144 |
| sql_mode | |
| storage_engine | MyISAM |
| sql_notes | ON |
| sql_warnings | ON |
| sync_binlog | 0 |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| sync_frm | ON |
| system_time_zone | SE Asia Standard Time |
| table_cache | 64 |
| table_type | MyISAM |
| thread_cache_size | 0 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 33554432 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.12a-nt |
| version_comment | Official MySQL binary |
| version_compile_machine | ia32 |
| version_compile_os | Win32 |
| wait_timeout | 28800 |
+---------------------------------+----------------------------------------+
185 rows in set (0.00 sec)
I think the problem is not in database. When building the source code, I
insert a command to print out the request's parameters after encoding in
file: com.xpn.xwiki.web.SetCharacterEncodingFilter.java and It print ????
for vietnamese characters.
Best regards,
Toan, Nguyen Manh
----- Original Message -----
From: "Stéphane Laurière" <slauriere(a)mandriva.com>
To: "Nguyen Manh Toan" <toan(a)netnam.vn>vn>;
<xwiki-users(a)objectweb.org>
Sent: Thursday, October 27, 2005 12:03 AM
Subject: Re: [xwiki-users] xWiki in multi languages
Nguyen Manh Toan wrote:
--
Ludovic Dubost
XPertNet: http://www.xpertnet.fr/
Blog: http://www.ludovic.org/blog/
XWiki: http://www.xwiki.com
Skype: ldubost AIM: nvludo Yahoo: ludovic
Dear Mr. Stephane,
I'm working with xwiki and I have a problem with my Vietnamese content.
I've configured as the intruction at url:
http://www.xwiki.org/xwiki/bin/view/Dev/CharactersSets.
After configured, Xwiki did well for the first time but when I clear all
cache and restart Tomcat server some vietnamese character changed to
??????. I checked in mysql database and it store characters ???? too.
Could you help me to configure Xwiki work with vietnamese content?
Best regards,
Toan
Dear Toan,
I'm copying your request to xwiki-users mailing-list. Can you let us
know about the XWiki version and the MySQL version you're using? Can you
check whether MySQL is correctly set up for storing content in UTF-8
(by issuing the command "show variables")?
Greetings,
Stéphane
--
Stéphane Laurière
slauriere(a)mandriva.com
http://club.mandriva.com
----------------------------------------------------------------------------
----
--
You receive this message as a subscriber of the xwiki-users(a)objectweb.org
mailing list.
To unsubscribe:
mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
------------------------------------------------------------------------
--
You receive this message as a subscriber of the xwiki-users(a)objectweb.org mailing list.
To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
2:19 p.m.
New subject: [xwiki-users] xWiki in multi languages
Dear Ludovic,
Yes, I've changed it to utf-8 encode.
----- Original Message -----
From: "Ludovic Dubost" <ludovic(a)xwiki.com
To: <xwiki-users(a)objectweb.org
Cc: <slauriere(a)mandriva.com
Sent: Thursday, October 27, 2005 7:13 PM
Subject: Re: [xwiki-users] xWiki in multi languages
Make sure you have modified the web.xml file to change the content type
for SetCharacterEncodingFilter
Ludovic
Toan, Nguyen Manh a écrit :
+---------------------------------+----------------------------------------+
+---------------------------------+----------------------------------------+
> 185 rows in set (0.00 sec)
> I think the problem is not in database.
When building the source code, I
> insert a command to print out the request's parameters after encoding in
> file: com.xpn.xwiki.web.SetCharacterEncodingFilter.java and It print ????
> for vietnamese characters.
> Best regards,
> Toan, Nguyen Manh
> ----- Original Message -----
> From: "Stéphane Laurière" <slauriere(a)mandriva.com > To: "Nguyen Manh Toan"
<toan(a)netnam.vn>vn>; <xwiki-users(a)objectweb.org
> Sent: Thursday, October 27, 2005 12:03 AM
> Subject: Re: [xwiki-users] xWiki in multi languages
> Nguyen Manh Toan wrote:
>> Dear Mr. Stephane,
> >> I'm working with xwiki and I have a
problem with my Vietnamese content.
>> I've configured as the intruction at url:
>> http://www.xwiki.org/xwiki/bin/view/Dev/CharactersSets.
>> After configured, Xwiki did well for the first time but when I clear all
>> cache and restart Tomcat server some vietnamese character changed to
>> ??????. I checked in mysql database and it store characters ???? too.
> >> Could you help me to configure Xwiki
work with vietnamese content?
> >> Best regards,
>> Toan
>
> Dear Toan,
> I'm copying your request to xwiki-users
mailing-list. Can you let us
> know about the XWiki version and the MySQL version you're using? Can you
> check whether MySQL is correctly set up for storing content in UTF-8
> (by issuing the command "show variables")?
> Greetings,
> Stéphane
> --
> Stéphane Laurière
> slauriere(a)mandriva.com
> http://club.mandriva.com
> --------------------------------------------------------------------------
--
> ----
>> --
>> You receive this message as a subscriber of the xwiki-users(a)objectweb.org
> > mailing list.
>> To unsubscribe:
mailto:xwiki-users-unsubscribe@objectweb.org
>> For general help: mailto:sympa@objectweb.org?subject=help
>> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
> >
>
------------------------------------------------------------------------
> --
> You receive this message as a subscriber of the xwiki-users(a)objectweb.org
mailing list.
> To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
> For general help: mailto:sympa@objectweb.org?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
--
Ludovic Dubost
XPertNet: http://www.xpertnet.fr/
Blog: http://www.ludovic.org/blog/
XWiki: http://www.xwiki.com
Skype: ldubost AIM: nvludo Yahoo: ludovic
----------------------------------------------------------------------------
----
> --
> You receive this message as a subscriber of the xwiki-users(a)objectweb.org
mailing list.
> To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
> For general help: mailto:sympa@objectweb.org?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Dear Stephane,
I used xwiki version 0.9.840 and mysql database server version 4.1.12. I
used command: create database xwiki character set utf8; to create xwiki
database. And this is my mysql database variables:
+---------------------------------+----------------------------------------+
| Variable_name | Value
|
| back_log | 50
|
| basedir | D:\tools\mysql\
|
| binlog_cache_size | 32768
|
| bulk_insert_buffer_size | 8388608
|
| character_set_client | latin1
|
| character_set_connection | latin1
|
| character_set_database | utf8
|
| character_set_results | latin1
|
| character_set_server | latin1
|
| character_set_system | utf8
|
| character_sets_dir |
D:\tools\mysql\share\charsets/
|
| collation_connection | latin1_swedish_ci
|
| collation_database | utf8_general_ci
|
| collation_server | latin1_swedish_ci
|
| concurrent_insert | ON
|
| connect_timeout | 5
|
| datadir |
D:\tools\mysql\data\
|
| 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 | 1800
|
| 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 | NO
|
| have_blackhole_engine | NO
|
| have_compress | YES
|
| have_crypt | NO
|
| have_csv | NO
|
| have_example_engine | NO
|
| have_geometry | YES
|
| have_innodb | YES
|
| have_isam | NO
|
| have_ndbcluster | NO
|
| have_openssl | NO
|
| have_query_cache | YES
|
| have_raid | NO
|
| have_rtree_keys | YES
|
| have_symlink | YES
|
| init_connect |
|
| init_file |
|
| init_slave |
|
| innodb_additional_mem_pool_size | 1048576
|
| innodb_autoextend_increment | 8
|
| innodb_buffer_pool_awe_mem_mb | 0
|
| innodb_buffer_pool_size | 8388608
|
| innodb_data_file_path |
ibdata1:10M:autoextend
|
| innodb_data_home_dir |
|
| innodb_fast_shutdown | ON
|
| innodb_file_io_threads | 4
|
| innodb_file_per_table | OFF
|
| innodb_flush_log_at_trx_commit | 1
|
| innodb_flush_method |
|
| innodb_force_recovery | 0
|
| innodb_lock_wait_timeout | 50
|
| innodb_locks_unsafe_for_binlog | OFF
|
| innodb_log_arch_dir |
|
| innodb_log_archive | OFF
|
| innodb_log_buffer_size | 1048576
|
| innodb_log_file_size | 5242880
|
| innodb_log_files_in_group | 2
|
| innodb_log_group_home_dir | .\
|
| innodb_max_dirty_pages_pct | 90
|
| innodb_max_purge_lag | 0
|
| innodb_mirrored_log_groups | 1
|
| innodb_open_files | 300
|
| innodb_table_locks | ON
|
| innodb_thread_concurrency | 8
|
| interactive_timeout | 28800
|
| join_buffer_size | 131072
|
| key_buffer_size | 8388600
|
| key_cache_age_threshold | 300
|
| key_cache_block_size | 1024
|
| key_cache_division_limit | 100
|
| language |
D:\tools\mysql\share\english\
|
| large_files_support | ON
|
| license | GPL
|
| local_infile | ON
|
| log | OFF
|
| log_bin | OFF
|
| log_error |
.\nguyenmanhtoan.err
|
| log_slave_updates | OFF
|
| log_slow_queries | OFF
|
| log_update | OFF
|
| log_warnings | 1
|
| long_query_time | 10
|
| low_priority_updates | OFF
|
| lower_case_file_system | OFF
|
| lower_case_table_names | 1
|
| max_allowed_packet | 1048576
|
| max_binlog_cache_size | 4294967295
|
| max_binlog_size | 1073741824
|
| max_connect_errors | 10
|
| max_connections | 100
|
| max_delayed_threads | 20
|
| max_error_count | 64
|
| max_heap_table_size | 16777216
|
| max_insert_delayed_threads | 20
|
| max_join_size | 4294967295
|
| max_length_for_sort_data | 1024
|
| max_relay_log_size | 0
|
| max_seeks_for_key | 4294967295
|
| max_sort_length | 1024
|
| max_tmp_tables | 32
|
| max_user_connections | 0
|
| max_write_lock_count | 4294967295
|
| myisam_data_pointer_size | 4
|
| myisam_max_extra_sort_file_size | 2147483648
|
| myisam_max_sort_file_size | 2147483647
|
| myisam_recover_options | OFF
|
| myisam_repair_threads | 1
|
| myisam_sort_buffer_size | 8388608
|
| named_pipe | OFF
|
| net_buffer_length | 16384
|
| net_read_timeout | 30
|
| net_retry_count | 10
|
| net_write_timeout | 60
|
| new | OFF
|
| old_passwords | OFF
|
| open_files_limit | 510
|
| pid_file |
D:\tools\mysql\data\nguyenmanhtoan.pid
|
| port | 3306
|
| preload_buffer_size | 32768
|
| protocol_version | 10
|
| query_alloc_block_size | 8192
|
| query_cache_limit | 1048576
|
| query_cache_min_res_unit | 4096
|
| query_cache_size | 0
|
| query_cache_type | ON
|
| query_cache_wlock_invalidate | OFF
|
| query_prealloc_size | 8192
|
| range_alloc_block_size | 2048
|
| read_buffer_size | 131072
|
| read_only | OFF
|
| read_rnd_buffer_size | 262144
|
| relay_log_purge | ON
|
| relay_log_space_limit | 0
|
| rpl_recovery_rank | 0
|
| secure_auth | OFF
|
| shared_memory | OFF
|
| shared_memory_base_name | MYSQL
|
| server_id | 0
|
| skip_external_locking | ON
|
| skip_networking | OFF
|
| skip_show_database | OFF
|
| slave_net_timeout | 3600
|
| slave_transaction_retries | 0
|
| slow_launch_time | 2
|
| sort_buffer_size | 2097144
|
| sql_mode |
|
| storage_engine | MyISAM
|
| sql_notes | ON
|
| sql_warnings | ON
|
| sync_binlog | 0
|
| sync_replication | 0
|
| sync_replication_slave_id | 0
|
| sync_replication_timeout | 0
|
| sync_frm | ON
|
| system_time_zone | SE Asia Standard
Time
|
| table_cache | 64
|
| table_type | MyISAM
|
| thread_cache_size | 0
|
| thread_stack | 196608
|
| time_format | %H:%i:%s
|
| time_zone | SYSTEM
|
| tmp_table_size | 33554432
|
| tmpdir |
|
| transaction_alloc_block_size | 8192
|
| transaction_prealloc_size | 4096
|
| tx_isolation | REPEATABLE-READ
|
| version | 4.1.12a-nt
|
| version_comment | Official MySQL
binary
|
| version_compile_machine | ia32
|
| version_compile_os | Win32
|
| wait_timeout | 28800
|
6996
days inactive
6997
days old
4 comments
5 participants
participants (5)
-
Ludovic Dubost -
Nguyen Manh Toan -
Stéphane Laurière -
Toan, Nguyen Manh -
Xavier MOGHRABI