Lampstack vs Lampp (index more slow)

hi:

I test 2 table in Lampstack and Lampp
Lampstack :bitnami-lampstack-5.3.6-0-linux-x64-installer
Lampstack :lampp-linux-1.7.4(32 bit)

same server , same platform(suse linux 11 sp1) , same config of my.cnf

[mysqld]
key_buffer_size = 2048M
max_allowed_packet =16M
table_open_cache = 1024
sort_buffer_size = 8M
read_buffer_size = 8M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 256M
thread_cache_size = 16
query_cache_size= 64M

1. Try number of CPU’s*2 for thread_concurrency
   thread_concurrency = 16

#innodb_data_home_dir = /usr/local/mysql/data
innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /usr/local/mysql/data

1. You can set .._buffer_pool_size up to 50 – 80 %
2. of RAM but beware of setting memory usage too high
   innodb_buffer_pool_size = 512M
   innodb_additional_mem_pool_size = 200M
3. Set ..log_file_size to 25 % of buffer pool size
   #innodb_log_file_size = 64M
   #innodb_log_buffer_size = 8M
   #innodb_flush_log_at_trx_commit = 1
   #innodb_lock_waittimeout = 50
   *************************************

table1 : 30480 records , 30.7 MB with 5 index
table2 : 58230 records , 59.7 MB with 7 index

Lampstack: 500 seconds
Lampp: 60 seconds

Why Lampstack more slow than lampp ?

Hi,

Thanks for posting your results. Could you send us the SQL files so we can test on our own? How you are running the commands to load data in the database (from command line, from PHP or other language)? Is the amount of time just for SQL or does it include other stuff, like PHP being used to load the database?

Regards.

hi Beltrán Rueda :
Sorry feedback for a long time.

Yes , index Very slow in SQLRDD+xHarbour .

I try index phpadmin platform no Problem.

SQLRDD+xHarbour Index work in Lampstack or Wampstack was more slow than Lampp or xampp .

I don’t know why ?