URL: https://linuxfr.org/forums/programmation-shell/posts/mesurer-temps-d-execution-mysql
Title: mesurer temps d'exécution mysql
Authors: gotcha5832
Date: 2016年10月14日T17:36:42+02:00
License: CC By-SA
Tags: 
Score: 0
Bonjour
Je cherche à tester des opti de requete mysql et pour ca je me suis fait un petit script mais les résulat renvoyé ne semble pas cohérent?
Une idée?
```bash
 #!/bin/bash
 fichier=results.csv
 passroot***
 db=***
 nbloops=100
 if [ -f $fichier ]
 then
 rm -f $fichier
 fi
 echo ""
 echo ""
 echo "╔═══════════════════════════════════════════════════╗"
 echo "║ ║"
 echo "║ Script de comparaison de deux requetes mysql ║"
 echo "╠═══════════════════════════════════════════════════╣"
 echo "║ * @author: Gotcha5832 <gotcha5832 @ hotmail.fr> ║"
 echo "╠═══════════════════════════════════════════════════╣"
 echo "║ HOWTO : ./script \"requete1\" \"requete2\" \"...\" ║"
 echo "╚═══════════════════════════════════════════════════╝"
 echo ""
 echo ""
 for p in "$@";
 do
 deb=`date +%s%N`
 echo "$p"
 echo " --> Demarrage : $deb";
 		i=1
 		echo -e "______________________\n$p">>$fichier
 		while ((i<=$nbloops)) do mysql -u root --password="$passroot" "$db" -e "$p" -s> /dev/null 2>&1
 		 i=$(expr 1 + $i)
 		 echo "$i">>$fichier
 		done
 
 		fin=`date +%s%N`
 		echo " --> fin : $fin"
 		duree=$(($(( $fin - $deb ))/$((1000000*$nbloops))))
 		echo "-----------------------"
 		echo "Durée moyenne = $duree"
 		echo "_____________________________________________________________________________ "
 		 echo -e "$i\t$deb\t$fin\t-->$duree">>$fichier
 done
```
P.S: requête e effectué en SQL_NO_CACHE
</div><div class="naked_ctrl">
<form action="/index.cgi/contrast" method="get" name="gate">
<p><a href="http://altstyle.alfasado.net">AltStyle</a> によって変換されたページ <a href="httpS://linuxfr.org/forums/programmation-shell/posts/mesurer-temps-d-execution-mysql.md">(-&gt;オリジナル)</a>
/ <label>アドレス: <input type="text" name="naked_post_url" value="httpS://linuxfr.org/forums/programmation-shell/posts/mesurer-temps-d-execution-mysql.md" size="22" /></label> <label>モード: <select name="naked_post_mode">
<option value="default">デフォルト</option>
<option value="speech">音声ブラウザ</option>
<option value="ruby">ルビ付き</option>
<option value="contrast" selected="selected">配色反転</option>
<option value="larger-text">文字拡大</option>
<option value="mobile">モバイル</option>
</select>
<input type="submit" value="表示" />
</p>
</form>
</div>