Encerrado

Need Windows mySQL 5.1 (InnoDB) expert to fix the error ''Sort aborted''

I need a mySQL 5.1 (InnoDB) expert to fix the error "*Sort aborted*" that I am getting every other second. Here is the [url removed, login to view] file.

1. MySQL [url removed, login to view]

2. Its a Quadcore 8GB Intel machine on Windows 2003.

3. The space left in C drive is 120 GB and in D drive is 75GB

4. The problem started on its own in last few days

5. Database has not changed in last 6 months

I would like to hire the same for making sure that I have MySQL configured the best possible way and also running at optimal performance. So a MySQL DBA is most preferred.

# MySQL Server Instance Configuration File

#

[client]

port=3306

[mysql]

default-character-set=latin1

[mysqld]

port=3306

basedir="C:/Program Files/MySQL/MySQL Server 5.1/"

datadir="D:/MySQL/Data/"

default-character-set=latin1

default-storage-engine=INNODB

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

max_connections=500

query_cache_size=0

table_cache=1520

tmp_table_size=67M

thread_cache_size=38

#*** MyISAM Specific options

myisam_max_sort_file_size=100G

myisam_sort_buffer_size=67M

key_buffer_size=55M

read_buffer_size=64K

read_rnd_buffer_size=256K

sort_buffer_size=30M

#*** INNODB Specific options ***

innodb_data_home_dir="D:/MySQL/InnoDBHome/"

innodb_additional_mem_pool_size=23M

innodb_flush_log_at_trx_commit=0

innodb_log_buffer_size=11M

innodb_buffer_pool_size=5G

innodb_log_file_size=214M

innodb_thread_concurrency=500

long_query_time=5

log-queries-not-using-indexes

expire_logs_days=2

innodb_data_file_path=ibdata1:10M:autoextend

skip-slave-start

Habilidades: MySQL

Ver mais: sort sort sort, sort sort, intel 2003, hire the best, hire mysql dba, hire a mysql expert, windows mysql sort aborted, mysql data files, mysql 5.1, the space, sql expert for hire, sql dba, mysql dba, i need a character, mysql sort, expert machine, windows server port, last days sql, file sort, running error, mysql ibdata1, error database problem, character problem, mysql server performance, mysql database engine

Acerca do Empregador:
( 106 comentários ) Bangalore, India

ID do Projeto: #3397282

3 freelancers estão ofertando em média $62 para este trabalho

kobor

See private message.

$38.25 USD in 7 dias
(22 Comentários)
4.2
dmavwvw

See private message.

$63.75 USD in 7 dias
(11 Comentários)
3.6
alienwebsoft

See private message.

$84.15 USD in 7 dias
(0 Comentários)
0.0