[FUG-BR] Diferença absurda do mysql no Linux para o do FreeBSD

[Marcelo Gondim]

Em 11/07/2012 17:45, Edson Brandi escreveu:
> Bom,
>
> Peguei 2 VMs aqui idênticas em termos de hardware virtual (rs),
> rodando sobre VMWare ESXi 5.0, configuradas com 4 Gb de RAM...
>
> Uma rodando:
>
> FreeBSD keyserver.fug.com.br 9.0-RELEASE-p3 FreeBSD 9.0-RELEASE-p3 #0:
> Tue Jun 12 01:47:53 UTC 2012
> root em i386-builder.daemonology.net:/usr/obj/usr/src/sys/GENERIC  i386
>
> e na outra:
>
> Linux server01.ebrandi.eti.br 2.6.32-220.23.1.el6.x86_64 #1 SMP Mon
> Jun 18 18:58:52 BST 2012 x86_64 x86_64 x86_64 GNU/Linux
>
> Não tinha uma VM com o FreeBSD 64 Bits aqui para testar... A
> configuração e a versão do mysql é a mesma nas 2 VMs.
>
> Os cálculos do consumo teórico de memoria em cada uma delas informado
> MySQL Tuning Primer está abaixo, os numeros são bem parecidos, e vai
> de encontro com aquela impressão que eu tinha de que o calculo do
> Tuning Primer não olha nada do sistema operacional.
>
> O proximo passo vai ser fazer um teste real de carga...
>
> ### FreeBSD ###
>
> * max_connections=1
>
> MEMORY USAGE
> Max Memory Ever Allocated : 154 M
> Configured Max Per-thread Buffers : 2 M
> Configured Max Global Buffers : 152 M
> Configured Max Memory Limit : 154 M
> Physical Memory : 3.74 G
> Max memory limit seem to be within acceptable norms
>
> * max_connections=10
> MEMORY USAGE
> Max Memory Ever Allocated : 154 M
> Configured Max Per-thread Buffers : 26 M
> Configured Max Global Buffers : 152 M
> Configured Max Memory Limit : 178 M
> Physical Memory : 3.74 G
> Max memory limit seem to be within acceptable norms
>
> * max_connections=100
> MEMORY USAGE
> Max Memory Ever Allocated : 154 M
> Configured Max Per-thread Buffers : 268 M
> Configured Max Global Buffers : 152 M
> Configured Max Memory Limit : 420 M
> Physical Memory : 3.74 G
> Max memory limit seem to be within acceptable norms
>
> * max_connections=1000
> MEMORY USAGE
> Max Memory Ever Allocated : 154 M
> Configured Max Per-thread Buffers : 2.62 G
> Configured Max Global Buffers : 152 M
> Configured Max Memory Limit : 2.77 G
> Physical Memory : 3.74 G
> Max memory limit seem to be within acceptable norms
>
> * max_connections=4000
> MEMORY USAGE
> Max Memory Ever Allocated : 154 M
> Configured Max Per-thread Buffers : 10.49 G
> Configured Max Global Buffers : 152 M
> Configured Max Memory Limit : 10.64 G
> Physical Memory : 1.00 G
>
> Max memory limit exceeds 90% of physical memory
>
> #### Linux ####
>
> * max_connections=1
>
> MEMORY USAGE
> Max Memory Ever Allocated : 154 M
> Configured Max Per-thread Buffers : 2 M
> Configured Max Global Buffers : 152 M
> Configured Max Memory Limit : 154 M
> Physical Memory : 3.74 G
> Max memory limit seem to be within acceptable norms
>
> * max_connections=10
>
> MEMORY USAGE
> Max Memory Ever Allocated : 154 M
> Configured Max Per-thread Buffers : 27 M
> Configured Max Global Buffers : 152 M
> Configured Max Memory Limit : 179 M
> Physical Memory : 3.74 G
> Max memory limit seem to be within acceptable norms
>
> * max_connections=100
>
> MEMORY USAGE
> Max Memory Ever Allocated : 154 M
> Configured Max Per-thread Buffers : 275 M
> Configured Max Global Buffers : 152 M
> Configured Max Memory Limit : 427 M
> Physical Memory : 3.74 G
> Max memory limit seem to be within acceptable norms
>
> * max_connections=1000
> MEMORY USAGE
> Max Memory Ever Allocated : 154 M
> Configured Max Per-thread Buffers : 2.68 G
> Configured Max Global Buffers : 152 M
> Configured Max Memory Limit : 2.83 G
> Physical Memory : 3.74 G
> Max memory limit seem to be within acceptable norms
>
> * max_connections=4000
> MEMORY USAGE
> Max Memory Ever Allocated : 157 M
> Configured Max Per-thread Buffers : 10.74 G
> Configured Max Global Buffers : 152 M
> Configured Max Memory Limit : 10.89 G
> Physical Memory : 3.74 G
>
> Max memory limit exceeds 90% of physical memory
>
> ####
> -------------------------
> Histórico: http://www.fug.com.br/historico/html/freebsd/
> Sair da lista: https://www.fug.com.br/mailman/listinfo/freebsd
>
Opa Edson,

Me manda o seu my.cnf de teste pra eu jogar na VM que fiz aqui de 64 
bits. Pra eu ver que bicho vai dar.  :)  Vai que o problema é por ser 64 
bits.
Bem temos que testar tudo e 32 bits tem que endereçar menos mesmo. :)