用php和bootstrap的Mysql查询进度条

Question

A basic Bootstrap progress bar looks like this:

<div class="progress">
   <div class="progress-bar" role="progressbar" aria-valuenow="70"
   aria-valuemin="0" aria-valuemax="100" style="width:70%">
     70%
   </div>
</div>

How could I update in real time the percentage values, based upon the progress of a Mysql SELECT query that takes from a few seconds up to a minute to finish.

I´m using php for the application.

Thanks!

Answer 1

UPDATE: Looks like this is possible with MariaDB 5.3+ now. anyway, I wouldn't suggest doing this because you'll use vendor-specific extensions.

Referring to MySQL Long Query Progress Monitoring, it isn't possible to monitor a MySQL query. The only thing you could do is to split queries and then check how many queries ran through already.