[Résolu] Mysql server slow Windows 7

[Akimania]

This text was translated on google

Hello,

Here I use xampp for my sites on a PC with windows 7 x 3.33 ghz processor 6 and 12 gigabytes of memory and hard disk turn 10000.
And I use another script or mysqldumper all test, inject large file. Sql in my DB.
When I do the injection is ultra slow, while on a single host or shared with xampp on windows XP is 100 times faster.
How to speed up the mysql server (mysqli)

Thank you in advance


// français
Bonjour,

Voila j’utilise xampp pour mes sites sur un PC avec windows 7 processeur 6 x 3.33 ghz et 12 giga de mémoire et disque dur 10000 tour.
Et j’utilise mysqldumper ou un autre script tous tester, pour injecter des gros ficher .sql dans ma DB.
Quand je fais l’injection c’est ultra lent, alors que sur un hébergeur simple avec mutualisé ou sur xampp avec windows XP c’est 100 fois plus rapide.
Comment augmenter la vitesse du serveur mysql (mysqli)

Merci d’avance

[hackattack142]

You should investigate the settings in the other included example my.ini files. The default configuration is based off of my-small.ini in the "/xampp/mysql" folder. There are others in addition to that one which include my-medium.ini, my-large.ini, and my-huge.ini. These have adjusted settings for systems with better hardware.

[Akimania]

Not the same problem

I try to point the mydomaine3.com -> (pc2) on another computer, in the pc1 OK it works, but in another pc error 404
Do you have an idea

logs/mydomaine3.com-error.log
File does not exist: //192.168.0.10

Code: Select all

<VirtualHost  *:80>
    DocumentRoot //192.168.0.10
    ServerName mydomaine3.com
    ServerAlias www.mydomaine3.com
    ErrorLog "i:/home/mydomaine3.com/logs/mydomaine3.com-error.log"
    CustomLog "i:/home/mydomaine3.com/logs/mydomaine3.com-access.log" combined
</VirtualHost>

Code: Select all

<Directory //192.168.0.10>
    Options FollowSymLinks
    AllowOverride None
    Order deny,allow
    Allow from all
</Directory>

[Akimania]

Problème résolut, j'ai trouver deux solutions

RewriteRule ^/(.*) \http://192.168.0.10/$1 [P]

OR tous simplement

Code: Select all

<VirtualHost  *:80>
ProxyPreserveHost On
ServerName mydomaine3.com
ServerAlias www.mydomaine3.com
ErrorLog "i:/home/mydomaine3.com/logs/mydomaine3.com-error.log"
CustomLog "i:/home/mydomaine3.com/logs/mydomaine3.com-access.log" combined

   <Proxy *>
     AddDefaultCharset Off
     Order deny,allow
     Allow from all
   </Proxy>

ProxyPass / http://192.168.0.10/
ProxyPassReverse / http://192.168.0.10/
</VirtualHost>


Merci tous pour votre participation
Akimania,