Problem in parser too long quries

[amik...@gmail.com]

Dear All,

Hi iam using jbioparser afetr succesfully dumping few tables when i used swissprot data base i was facing problem "myisam_sort_buffer_size is too small"

I need advice what would be the my.inf (mysql configuration)

system configuration 8 GB 2 tb

my.inf file configuration

[mysqld]

datadir=/diskb/var_mysql/mysql

socket=/diskb/var_mysql/mysql/mysql.sock

user=mysql

tmpdir=/diskb/new/tmp

#table_cache=768

#query_cache_size = 12582912

#query_cache_limit=80000

#thread_cache_size = 4

#join_buffer_size = 128K

#max_tmp_tables=99

long_query_time                         = 30

big-tables

safe-show-database

connect_timeout                         = 10

wait_timeout                            = 1800

max_connections                         = 256

max_user_connections                    = 256

max_connect_errors                      = 2000

max_allowed_packet                      = 16M

bulk_insert_buffer_size                 = 512M

join_buffer                             = 1G

sort_buffer_size                        = 512M

read_buffer_size                        = 512M

read_rnd_buffer_size                    = 512M

table_cache                             = 1024

thread_cache_size                       = 256

tmp_table_size                          = 512M

max_heap_table_size                     = 512M

query_cache_size                        = 64M

query_cache_limit                       = 64M

thread_concurrency                      = 4

key_buffer_size                         = 8G    #24G    # increase for MyISAM only !

myisam_sort_buffer_size                 = 8G    # increase for MyISAM only !

myisam_repair_threads                   = 8

myisam_max_sort_file_size               = 8G

myisam-recover                          = BACKUP,FORCE

[myisamchk]

#myisam_sort_buffer_size                = 8G

sort_buffer_size                        = 8G

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

Regards,

Amit

[Roberto Vera Alvarez]

Hi Amit,

I don't understand very well your question or comment. However, I would like
to show you my config.

My desktop computer has:

OpenSuSE 13.0
Linux version 3.11.6-4-desktop (gcc version 4.8.1) Wed Oct 30 18:04:56 UTC
2013
Two Processors: Intel(R) Core(TM)2 Extreme CPU Q6850 @ 3.00GHz
RAM: 8 GB

I am using the default my.cnf and the JBioWH parsers and database runs fine.

The production server has:

OpenSuSE 12.3
Linux version 3.7.10-1.16-default (gcc version 4.7.2) Fri May 31 20:21:23 UTC
2013
Two processors: Intel(R) Xeon(R) CPU E31220 @ 3.10GHz
RAM: 4GB

In this computer the my.cnf has:

[myisamchk]
sort_buffer_size = 1024M
read_buffer = 512M
write_buffer = 512M
key_buffer_size = 1024M
read_buffer_size = 16M
read_rnd_buffer_size = 1024M
bulk_insert_buffer_size = 1024M
myisam_sort_buffer_size = 1024M
myisam_max_sort_file_size = 10240M

Let me know if you need something else.

Regards,
Roberto