Hello this is more of an administrator question,
I also run my own webserver (for testing) but I'm wondering on my server lets say the mysql db size for a table is 19.3 MiB but here its only 16.6 MiB, what mysql function/addon is doing this maybe an admin could post the the my.cnf for this server cause I'm curious whats causing it (it must be some compression module).
my mysql was compiled with these options any ideas what i can do to improve performance?
--prefix=/usr \
--with-mysqld-user=mysql \
--with-unix-socket-path=/var/run/mysql/mysql.sock \
--localstatedir=/var/lib/mysql \
--enable-assembler \
--with-raid \
--without-debug \
--enable-thread-safe-client \
--without-bench \
--with-extra-charsets=complex \
--with-vio \
--with-openssl \
--program-prefix="" \
--program-suffix="" \
my my.cnf is like this
[mysqld]
port = 3306
socket = /var/run/mysql/mysql.sock
skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 8M
sort_buffer_size = 8M
[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M
[mysqlhotcopy]
interactive-timeout
please let me know if you have any ideas. sorry if this was the wrong forum to ask this question i just say others posting about php and mysql questions.
I also run my own webserver (for testing) but I'm wondering on my server lets say the mysql db size for a table is 19.3 MiB but here its only 16.6 MiB, what mysql function/addon is doing this maybe an admin could post the the my.cnf for this server cause I'm curious whats causing it (it must be some compression module).
my mysql was compiled with these options any ideas what i can do to improve performance?
--prefix=/usr \
--with-mysqld-user=mysql \
--with-unix-socket-path=/var/run/mysql/mysql.sock \
--localstatedir=/var/lib/mysql \
--enable-assembler \
--with-raid \
--without-debug \
--enable-thread-safe-client \
--without-bench \
--with-extra-charsets=complex \
--with-vio \
--with-openssl \
--program-prefix="" \
--program-suffix="" \
my my.cnf is like this
[mysqld]
port = 3306
socket = /var/run/mysql/mysql.sock
skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 8M
sort_buffer_size = 8M
[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M
[mysqlhotcopy]
interactive-timeout
please let me know if you have any ideas. sorry if this was the wrong forum to ask this question i just say others posting about php and mysql questions.