[Résolu] Mysql server slow Windows 7

Problems with the Windows version of XAMPP, questions, comments, and anything related.

[Résolu] Mysql server slow Windows 7

Postby Akimania » 15. February 2012 16:43

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
Last edited by Akimania on 18. February 2012 14:46, edited 1 time in total.
Akimania
 
Posts: 4
Joined: 15. February 2012 16:38
Operating System: Windows 7 processor 6x3.33

Re: Mysql server slow Windows 7

Postby hackattack142 » 18. February 2012 00:37

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.
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 703
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: Mysql server slow Windows 7

Postby Akimania » 18. February 2012 04:43

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
 
Posts: 4
Joined: 15. February 2012 16:38
Operating System: Windows 7 processor 6x3.33

Re: Mysql server slow Windows 7

Postby Akimania » 18. February 2012 14:45

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,
Akimania
 
Posts: 4
Joined: 15. February 2012 16:38
Operating System: Windows 7 processor 6x3.33


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 41 guests