» Home » queries » Page 1
MYSQL slow queries in “slow queries log” - but same queries runs very fast manually
by Edwin Goei in Databases

as title states, in my database various queries appear in the slow queries log, but when I run them manually they run 10x faster.


for example a relatively simple select query with several order by params takes often up to 100 seconds in log(yes table is very big)... but when I run it myself on the same DB it takes 2 seconds or so.


I've examined the server's performance


how to resolve General error: 2014 Cannot execute queries while other unbuffered queries are active. using PDO connection
by Steve O. in Databases

While i am executing second Stored procedure with same connection statement(Using PDO), getting the below error.


=================================================


SQLSTATE[HY000]:
General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll().
Alternatively, if your code is only ever going to run


FirePHP not returning ajax request queries, yet returns normal page load queries
by asp.net in Web Design

I am using firePHP(Zend profiler) on on FF 3.6.3(firephp addon installed) and it returns queries, when I do a normal page load. Ajax requests, however, are not returning the proper queries. I am using Prototype 1.6.0.2 for ajax requests. Is there something I am missing? Most of the write-ups seem to imply that this should work by default.


mytop ( a mysql monitoring tool) thread view dosen't consider queries commited by other users in Queries
by Mahesh in Databases

I ran a program which commits 2000 inserts into a table. but in mytop thread veiw the item "Queries" which keeps track of number of queries is increased just by 2 each time mytop view is refreshed and that is the number of queries mytop commits itself to get info from mysql. I don't know why the number of insert queries is not added... .


another matter is that my command view has ju


Good tool for converting mssql queries to mysql queries
by IHateMyJob2004 in Databases

I found alot of question on stack about converting mysql to mssql, but i would like to convert it otherwise.


From mssql server to mysql.


is there a (free) tool for this to do that without connecting to the databases?
i have an sql query dump and i want to convert that by putting that code in an tool.


Thanks.


Join queries taking more execution time than their corresponding nested queries
by nishar7 in Coding

I have 2 tables namely Person_Organization and Person_Organization_other and nested query is :-


SELECT Person_Organization_id FROM Person_Organization_other
WHERE company_name IN
(
SELECT company_name from Person_Organization_other
WHERE Person_Organization_id IN
(
SELECT Person_Organization_Id FROM Person_Organization

How to avoid this PDO exception: Cannot execute queries while other unbuffered queries are active
by Matt in Programming Languages

I'd like to print a simple table in my page with 3 columns, building name, tags and architecture style. If I try to retrieve the list of building names and arch. styles there is no problem:


SELECT buildings.name, arch_styles.style_name
FROM buildings
INNER JOIN buildings_arch_styles
ON buildings.id =

I get 2014 Cannot execute queries while other unbuffered queries are active when doing exec with PDO
by Marti in Programming Languages

I am doing a PDO::exec command on multiple updates:


$MyPdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY,true);
$MyPdo->exec("update t1 set f1=1;update t2 set f1=2");

I am doing it inside a transaction, and I keep getting:


SQLSTATE[HY000]: General error: 2014
Cannot execute queries while other
unbuffered queries are a


Is it true that writing LINQ queries is not easy for complex queries?
by skriefal in Programming Languages

Is it true that writing LINQ queries is not easy for complex queries?


select a.sNavID,
a.sNavText,
a.sNavText as EName,
' '+a.sNavText as NameDisplay
from ContentPageNav as a
where a.navID=0
union
select b.sNavID,
a.sNavText + ' >> ' + b.sNavText as Name,
b.sNavText as EName,
' '

How come queries aren't being added to Django's db.connection.queries in tests?
by 02ranger in Databases

I'm trying to capture the queries which my code submits to the database by examining the contents of django.db.connection.queries. For some reason though, after all the automatically produced setup queries are logged, no further queries are logged from my own code. The following test case demonstrates the behavior.


from django.test import TestCase
from django.

Next
Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2017 © bighow.org All Rights Reserved .