Mysql query progress bar with php and bootstrap

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!

I don't think this is possible. A work around that comes to mind is to query parts of data set (table) in a loop and on each iteration send a response. — B-and-P
– B-and-P, Commented Mar 11, 2015 at 17:30
Not sure, depends on several things. Wait for some mysql experts to respond. Interesting idea though, I would use something like this myself for some projects. — B-and-P
– B-and-P, Commented Mar 11, 2015 at 17:40
Show us what is going on on php side? what query are you trying to get? is it really slow? is there data transformation part? — Alex
– Alex, Commented Mar 11, 2015 at 18:20

TheAlexLichter · Accepted Answer · 2017-11-18 16:14:18Z

3

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.

edited Nov 18, 2017 at 16:14

answered Mar 11, 2015 at 17:46

TheAlexLichter

7,3338 gold badges50 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

TheAlexLichter Over a year ago

@caCtus, now it should fit

Code4R7 Over a year ago

It's possible with MariaDB now: mariadb.com/kb/en/library/progress-reporting

Collectives™ on Stack Overflow

Mysql query progress bar with php and bootstrap

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related