Wow! thanks for the responses!
Here is what I think you are mostly asking for... I have run "mysqladmin
variables" to get this.
Regards,
Greg.
+---------------------------------+-----------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
--------+
| Variable_name | Value
|
+---------------------------------+-----------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
--------+
| back_log | 50
|
| basedir | /
|
| binlog_cache_size | 32768
|
| character_set | latin1
|
| character_sets | latin1 big5 czech euc_kr gb2312 gbk sjis
tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish
hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat
cp1257 latin5 |
| concurrent_insert | ON
|
| connect_timeout | 5
|
| datadir | /var/lib/mysql/
|
| delay_key_write | ON
|
| delayed_insert_limit | 100
|
| delayed_insert_timeout | 300
|
| delayed_queue_size | 1000
|
| flush | OFF
|
| flush_time | 0
|
| have_bdb | NO
|
| have_gemini | NO
|
| have_innodb | NO
|
| have_isam | YES
|
| have_raid | NO
|
| have_openssl | NO
|
| init_file |
|
| interactive_timeout | 28800
|
| join_buffer_size | 131072
|
| key_buffer_size | 8388600
|
| language | /usr/share/mysql/english/
|
| large_files_support | ON
|
| locked_in_memory | OFF
|
| log | OFF
|
| log_update | OFF
|
| log_bin | OFF
|
| log_slave_updates | OFF
|
| log_long_queries | OFF
|
| long_query_time | 10
|
| low_priority_updates | OFF
|
| lower_case_table_names | 0
|
| max_allowed_packet | 1048576
|
| max_binlog_cache_size | 4294967295
|
| max_binlog_size | 1073741824
|
| max_connections | 100
|
| max_connect_errors | 10
|
| max_delayed_threads | 20
|
| max_heap_table_size | 16777216
|
| max_join_size | 4294967295
|
| max_sort_length | 1024
|
| max_user_connections | 0
|
| max_tmp_tables | 32
|
| max_write_lock_count | 4294967295
|
| myisam_max_extra_sort_file_size | 256
|
| myisam_max_sort_file_size | 2047
|
| myisam_recover_options | 0
|
| myisam_sort_buffer_size | 8388608
|
| net_buffer_length | 16384
|
| net_read_timeout | 30
|
| net_retry_count | 10
|
| net_write_timeout | 60
|
| open_files_limit | 0
|
| pid_file | /var/lib/mysql/host.domain.com.pid
|
| port | 3306
|
| protocol_version | 10
|
| record_buffer | 131072
|
| record_rnd_buffer | 131072
|
| query_buffer_size | 0
|
| safe_show_database | OFF
|
| server_id | 0
|
| slave_net_timeout | 3600
|
| skip_locking | ON
|
| skip_networking | OFF
|
| skip_show_database | OFF
|
| slow_launch_time | 2
|
| socket | /var/lib/mysql/mysql.sock
|
| sort_buffer | 2097144
|
| sql_mode | 0
|
| table_cache | 64
|
| table_type | MYISAM
|
| thread_cache_size | 0
|
| thread_stack | 65536
|
| transaction_isolation | READ-COMMITTED
|
| timezone | GMT
|
| tmp_table_size | 33554432
|
| tmpdir | /tmp/
|
| version | 3.23.47
|
| wait_timeout | 28800
|
+---------------------------------+-----------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
--------+
> -----Original Message-----
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: 31 January 2002 00:17
> To: Greg Conway
> Cc: [EMAIL PROTECTED]
> Subject: Re: mysql lost it's ability to perform transactions?
>
>
> On Thu, Jan 31, 2002 at 12:06:52AM -0000, Greg Conway wrote:
> >
> > I've just upgraded from a tarball MySQL (3.23.33) to an RPM (MySQL
> > 3.23.47-1).
> >
> > Along the way, somewhere, MySQL seems to have lost it's ability
> > operate as a transaction server!
> >
> > I know this as I use Zope to connect to MySQL, and it's now giving
> > me the following error:
> >
> > Error Type: NotSupportedError
> > Error Value: transactions not supported by this server
> >
> > If I change my connection string from +server.com to
> -server.com, it then
> > kicks into life... but without transaction support!
> >
> > I've located my new mysql_config, and checked it against the
> old one, but I
> > don't appear to be missing any options.
> >
> > Anybody got any ideas on what I'm doing wrong?
>
> Can you give us the SHOW VARIABLES output?
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
>
> MySQL 3.23.41-max: up 28 days, processed 622,041,808 queries
> (256/sec. avg)
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
