Hi all,
Is there a problem with the mysql web page (http://lists.mysql.com/) where
you can query mailing list archives ? I can't seem to get more than 20
results to any query.
Thanks,
Yong.
Yong Lee
Developer
[EMAIL PROTECTED]
http://www.eqo.com/
direct: +1.604.273.8173 x113
mobile:
John Roddy wrote:
I know that successful, data changing queries get logged in the binary log. But
is there any
way to see the actual queries that fail (i.e. timeouts, deadlocks)?
I'm hoping there's a
way other than using the general query log, which takes up too much
space just to catch
I know that successful, data changing queries get logged in the binary log. But
is there any way to see the actual queries that fail (i.e. timeouts,
deadlocks)? I'm hoping there's a way other than using the general query log,
which takes up too much space just to catch that occasional failed
simpler queries and
then merge the results, or create some temporary tables containing the filtered
data to let the main query execute without too many iterations...
I was wondering if there was anybody here, to suggest the best approach to this
kind of performance issues.
Thanks,
Stefano.
p.s
the
recordset. I was looking for some (right) way to optimize the search.
there were some solutions proposed around, like split in n simpler queries
and then merge the results, or create some temporary tables containing the
filtered data to let the main query execute without too many iterations...
I
proposed around, like split in n simpler queries and
then merge the results, or create some temporary tables containing the filtered
data to let the main query execute without too many iterations...
I was wondering if there was anybody here, to suggest the best approach to this
kind of performance
Hi.
I've been finding some queries by using 'mytop' which takes +200
seconds to be executed. It wastes tons of CPU resources on my server
and would like to detect them automatically and kill them.
Does anybody have experience with this issue? Thank you very much,
--Thomas
--
MySQL General
At 06:40 AM 12/11/2007, you wrote:
Hi.
I've been finding some queries by using 'mytop' which takes +200
seconds to be executed. It wastes tons of CPU resources on my server
and would like to detect them automatically and kill them.
Does anybody have experience with this issue? Thank you very
I started using MySQL 5 a couple of months ago and I was able to handle
most of the issues OK. However there is this particular problem that is
causing untold misery for my self and particularly my users.
At unexpected times, a roque query is executed or triggered all on its
accord and starts
for your client connection as well.
http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html
-RG
Ovidiu Farauanu wrote:
Hello.
I have a problem with queries on a utf8 table. For example when I send
select SQL_CALC_FOUND_ROWS * from city where country_code = 'pl' and
language_code
Hello.
I have a problem with queries on a utf8 table. For example when I send
select SQL_CALC_FOUND_ROWS * from city where country_code = 'pl' and
language_code = 'en' and ( city_name like 'A%' or city_name like 'A%
) order by city_name
to MySQL, it returns to me not only cities that begin
queries.
if yes, then how ?.
You could do it in the application logic, i.e. create a separate
connection to the slave server that you use for reading, or perhaps this
would be a good use of the MySQL Proxy URL:
http://forge.mysql.com/wiki/MySQL_Proxy .
This doesn't look like it will work
queries.
if yes, then how ?.
You could do it in the application logic, i.e. create a separate
connection to the slave server that you use for reading, or perhaps this
would be a good use of the MySQL Proxy URL:
http://forge.mysql.com/wiki/MySQL_Proxy .
In any case, you should be aware
+0200, Ashok Chauhan [EMAIL PROTECTED]
wrote:
Hi All,
I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and
8GB
of RAM.
Master Slave servers have same hardware configration.
Now i want to know, should i use slave server for fetching read only
queries.
if yes
Ashok Chauhan wrote:
Hi All,
I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and 8GB
of RAM.
Master Slave servers have same hardware configration.
Now i want to know, should i use slave server for fetching read only
queries.
if yes, then how ?.
Thanks
Ashok
The simple
Hi All,
I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and 8GB
of RAM.
Master Slave servers have same hardware configration.
Now i want to know, should i use slave server for fetching read only
queries.
if yes, then how ?.
Thanks
Ashok
--
MySQL General Mailing List
Hi all,
i have to optimize complex join queries. i am not able to understand how the
complex queries gets executed. Whether it follow top-down or bottom-up
approach. There is millions of data.
The queries is:
select ucp.user_id as RESULTANT_ID from user_course_payment
ucp,crm_sales_contact sc
Hi Krishna,
Its the bottom-up approach in all db's which follow SQL standards.
Can u please show us the explain plan of the below query.
regards
anandkl
On 8/14/07, krishna chandra prajapati [EMAIL PROTECTED] wrote:
Hi all,
i have to optimize complex join queries. i am not able
db's which follow SQL standards.
Can u please show us the explain plan of the below query.
regards
anandkl
On 8/14/07, krishna chandra prajapati [EMAIL PROTECTED] wrote:
Hi all,
i have to optimize complex join queries. i am not able to understand how
the complex queries gets executed
://mysqltoolkit.sourceforge.net/). This query
isn't too hard to read, but more complex queries are tough to understand.
Baron
krishna chandra prajapati wrote:
Hi,
The details are as follows
mysql explain select ucp.user_id as RESULTANT_ID from user_course_payment
ucp,crm_sales_contact sc
not sure about this -- maybe someone else could answer it for
sure.
If you're unfamiliar with reading EXPLAIN output, try
mysql-visual-explain (http://mysqltoolkit.sourceforge.net/). This query
isn't too hard to read, but more complex queries are tough to understand.
Baron
krishna chandra
wrote a script to
log the output from show full processlist when the number of connections
passes 100 and ~90% of them are selects against one particular table in
the statistics state.
What would cause a large number of queries to linger in this state?
My guess is this is simply a concurrency
full processlist when the number of connections
passes 100 and ~90% of them are selects against one particular table in
the statistics state.
What would cause a large number of queries to linger in this state?
In case it's relevant I should say that the database in question is
being replicated
I want to execute three sql statements in single query which will perform
following task...
1. select a particular row
2. insert that row to another table
3. delete that row from 1st table
in short, i want to move one row from table 1 to table 2 with single query..
thanks in advance for any
if you are using MySQL 5 you could use a stored procedure
On 7/27/07, Samrat Kar [EMAIL PROTECTED] wrote:
I want to execute three sql statements in single query which will perform
following task...
1. select a particular row
2. insert that row to another table
3. delete that row from 1st
Hi all,
I have to create a view. For this, a table needs to transformed like this:
So the original table is
1 a b
2 c d
I want
1 a
1 b
2 c
2 d
I can do two queries giving me this, but how do I combine them in a view? If a
new table would need to be created, I could do a select
;
- Original Message -
From: Stefan Kuhn [EMAIL PROTECTED]
To: MySQL mysql@lists.mysql.com
Sent: Monday, July 16, 2007 8:58:58 AM (GMT-0500) America/New_York
Subject: Putting two queries in one
Hi all,
I have to create a view. For this, a table needs to transformed like this:
So
: Rolando Edwards [EMAIL PROTECTED]
To: Stefan Kuhn [EMAIL PROTECTED]
Cc: MySQL mysql@lists.mysql.com
Sent: Monday, July 16, 2007 9:44:48 AM (GMT-0500) America/New_York
Subject: Re: Putting two queries in one
drop table if exists test.flipdata;
create table test.flipdata (f1 int,f2 char(1),f3 char(1
/New_York
Subject: Re: Putting two queries in one
drop table if exists test.flipdata;
create table test.flipdata (f1 int,f2 char(1),f3 char(1));
insert into test.flipdata values (1,'a','b'),(2,'c','d');
create view test.RotatedData as select f1,f2 from test.flipdata union
select f1,f3 from
Hi,
Steffan A. Cline wrote:
I am trying to set up a forum where there are main posts with replies and
replies to replies. Rather than using nested queries in my middleware I am
thinking there has to be some kind of recursive query where I can output the
results in a format like so:
MAIN
On 7/8/07, Steffan A. Cline [EMAIL PROTECTED] wrote:
I am trying to set up a forum where there are main posts with replies and
replies to replies. Rather than using nested queries in my middleware I am
thinking there has to be some kind of recursive query where I can output
the
results
I am trying to set up a forum where there are main posts with replies and
replies to replies. Rather than using nested queries in my middleware I am
thinking there has to be some kind of recursive query where I can output the
results in a format like so:
MAIN
Reply to main
reply
We are having a problem with out mysql database (4.2) and think we may
have indexes missing. What we are trying to do is find out the most
popular queries that run. We know there are not may and that they are
relatively simple.
Does anyone know of a tool that allows us to see what queries (i.e
Ben, there's a slow query log feature that may be just what you're looking
for:
http://dev.mysql.com/doc/refman/4.1/en/slow-query-log.html
There's an analysis script that will show you the most popular slow queries,
too, '*mysqldumpslow'.
You can take those queries and use the EXPLAIN feature
the file, to see what queries are most popular.
The sleep defines how often the picture of activities in DB is taking
Regards,
Mikhail Berman
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 20, 2007 10:34 AM
To: Ben Edwards
Cc: mysql@lists.mysql.com
Ben Edwards wrote:
We are having a problem with out mysql database (4.2) and think we may
have indexes missing. What we are trying to do is find out the most
popular queries that run. We know there are not may and that they are
relatively simple.
Does anyone know of a tool that allows us
I hadn't even thought that you might want to monitor the process list. If this is what
you want to do, I suggest innotop: http://innotop.sourceforge.net/ Not only can you
see what queries are running, you can easily run EXPLAIN on them with a single
keystroke (press the 'Q' key to watch
Hello,
To get started, have you tried enabling the slow query log?
http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
The slow query log can be used to find queries that take a long time to
execute and are therefore candidates for optimization.
Jimmy Guerrero
Sr Product Manager
Hi, I need to write a small middleware program that can capture, inspect
and redirect all queries to an old instance of mysql to a new instance.
Any help or pointers to get started would be greatly appreciated.
thanks,
Chike.
--
MySQL General Mailing List
For list archives: http
Hi,
Chibuike Muoh wrote:
Hi, I need to write a small middleware program that can capture, inspect
and redirect all queries to an old instance of mysql to a new instance.
Any help or pointers to get started would be greatly appreciated.
Perhaps this will help: http://jan.kneschke.de/projects
I have a Windows program that will execute simple 1 table queries that use
an index and sort, and with a limit of 20 rows.
When I start the program for the first time, the queries run quite fast at
around 1200 queries/second. Then within a couple of seconds it drops
immediately down to 20-40
Hi List,
Using printf( System status: %s\n, mysqli_stat($link));
in a PHP script, says: Queries per second avg: 0.051.
This means that a query takes about 20 seconds ?
But the query result is given immediately.
How should I interpret Queries per second avg ?
I'm using version 5.0.15 NT.
Regards
C.R.Vegelin wrote:
...
How should I interpret Queries per second avg ?
How about as 'queries per second on average' :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
: question about Queries per second avg
C.R.Vegelin wrote:
...
How should I interpret Queries per second avg ?
How about as 'queries per second on average' :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
I have to admit, Google doesn't provide much information.
Let's take a closer look and see if we can't figure out ourselves what
that value means.
Here is the output of `mysqladmin status` on my development box:
Uptime: 7510 Threads: 3 Questions: 4123 Slow queries: 0 Opens:
713 Flush
Ofcourse, the number of queries is just the value of Questions.
Christophe Gregoir wrote:
I have to admit, Google doesn't provide much information.
Let's take a closer look and see if we can't figure out ourselves what
that value means.
Here is the output of `mysqladmin status` on my
It's just telling you how many queries per second on average the server
is receiving. This says nothing about how long it takes to execute a
particular query.
-Micah
On 04/06/2007 01:22 AM, C.R.Vegelin wrote:
Hi List,
Using printf( System status: %s\n, mysqli_stat($link));
in a PHP script
My idea of this is :
(Questions+Slow queries)/Uptime = Queries per second avg
(118794 + 16) / 84751) = 1,4018713643496831895788840249673
Uptime: 84751 Threads: 2 Questions: 118794 Slow queries: 16
Opens: 478 Flush tables: 1 Open tables: 29
Queries per second avg: 1.402
--
Later
It says nothing about how long it takes to process a query (service time);
it tells you on average how often queries come in (arrival rate). If the
service time is such that an arriving query is finished before the next one
arrives, you aren't in terrible shape as far as the queue of waiting
. The only
queries in the file are simple INSERT statements -- there are no statements
that would force a commit (as per 13.4.3 of the manual).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
result. I even tried including the rollback in
the
.sql file as well, but the changes are still committed afterwards. The
only
queries in the file are simple INSERT statements -- there are no
statements
that would force a commit (as per 13.4.3 of the manual).
--
MySQL General Mailing
Greetings all, I am trying to track down the cause of some issues I'm
having. I am doing this from the mysql prompt:
start transaction;
source c:/queries.sql;
rollback;
When I examine the db though, it appears that the changes from the sourced
queries have been committed.
--
MySQL General
database would be better suited to
the large size of some tables, and would therefore return queries more quickly.
It is now populated with the data from the old Access tables.
So far, the MySQL speed has been very slow. I'm talking about 30 seconds to
return the 2 records found by
SELECT * FROM
in the hope that the MySQL database would be better suited to
the large size of some tables, and would therefore return queries more quickly.
It is now populated with the data from the old Access tables.
So far, the MySQL speed has been very slow. I'm talking about 30 seconds to
return the 2 records
a MySQL database in the hope that the MySQL
database would be better suited to the large size of some tables, and
would therefore return queries more quickly. It is now populated with the
data from the old Access tables.
So far, the MySQL speed has been very slow. I'm talking about 30 seconds
I need to run a query that will take the data from item_number field,
add -1.jpg to the end of it, and store it in image_location
I have tried update inventory_items set image_location = item_number + -1.jpg;
but that just places the item number into the field, without the text
in quotes.
How do
Try using CONCAT() ;
mysql update inventory_items set
image_location=concat(item_number,'-1.jpg');
Thanks
ViSolve DB Team.
- Original Message -
From: Jerry Jones [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, February 03, 2007 12:00 PM
Subject: Update queries
I need
I have a list of subjects, such as Linux, Open Source, and the
World Wide Web. The subjects are stored in MySQL and being retrieved
via php. I currently organize them alphabetically with MySQL's ORDER
BY ASC argument, however, if there is a preceding the or a then
that is considered as part of
On 2006-11-06 Dotan Cohen wrote:
I have a list of subjects, such as Linux, Open Source, and the
World Wide Web. The subjects are stored in MySQL and being retrieved
via php. I currently organize them alphabetically with MySQL's ORDER
BY ASC argument, however, if there is a preceding the or
On 06/11/06, Christian Hammers [EMAIL PROTECTED] wrote:
On 2006-11-06 Dotan Cohen wrote:
I have a list of subjects, such as Linux, Open Source, and the
World Wide Web. The subjects are stored in MySQL and being retrieved
via php. I currently organize them alphabetically with MySQL's ORDER
BY
On 2006-11-06 Dotan Cohen wrote:
Make a second column that only contains
ALTER TABLE table ADD cooked_subject;
UPDATE table SET cooked_subject = ereg_replace('^(a|the) ', '', subject);
(I don't know how the regular expression function was called exactly but
you get the idea)
Hi,
Is the the right group to post for questions with SQL Queries ?
thx.
yashesh bhatia
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Yes, ask away :)
Hi,
Is the the right group to post for questions with SQL Queries ?
thx.
yashesh bhatia
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
hey thx for the reply..
here's my query..
http://forums.mysql.com/read.php?20,119150,119150#msg-119150
thx.
yashesh bhatia.
On 10/4/06, Rob Desbois [EMAIL PROTECTED] wrote:
Yes, ask away :)
Hi,
Is the the right group to post for questions with SQL Queries ?
thx.
yashesh bhatia
Hi,
I'm including your post to the forum as well.
The problem I think is the fact that you need to
do LEFT JOIN in two directions which quite often
don't turn out what you want.
So what you can do is to do two queries, UNION
them together and form a derived table that you
then do your final
I hope this is a simple question.
I'm trying to run a select like the one below, but limiting the results to 2 Sub
Categories per Category.
I can't find a way to do this in the SQL reference
mysql select sub_categories.id, categories.name 'Category', sub_categories.name
'Sub Category' from
(these are
not human language words and phrases but rather random bytes where
some are human readable).
Now, I'm trying to find out how many times has word 1..n been
searched for and how many times has phrases containing 1..n been
searched for?
These queries take a really long time to execute
by phrase_words (these are
not human language words and phrases but rather random bytes where
some are human readable).
Now, I'm trying to find out how many times has word 1..n been
searched for and how many times has phrases containing 1..n been
searched for?
These queries take a really long
containing 1..n been
searched for?
These queries take a really long time to execute, first I select for the
words:
explain sELECT w.word as word, w.word_id as word_id, sum(ws.amount) as
amount FROM words w, word_searches ws WHERE
ws.word_id=w.word_id AND w.word IN (p, xyz, zzz, abc
Unfortunately didn't that help, it leads to:
++-+---+---+---
| id | select_type | table | type | possible_keys
| key | key_len | ref | rows| Extra
|
++-+---+---+---
| 1
On 8/17/06, Chris [EMAIL PROTECTED] wrote:
Unfortunately didn't that help, it leads to:
++-+---+---+---
| id | select_type | table | type | possible_keys
| key | key_len | ref | rows| Extra
|
DELETE from cart
WHERE product_id NOT IN( SELECT id FROM products where status = 'enabled')
AND user_id = '90'
The above is what I would like it to do, though I can not test it as I do
not have access to a mysql that supports it.
Aside from two queries, can someone perhaps show me how to run
DELETE from cart
WHERE product_id NOT IN( SELECT id FROM products where status = 'enabled')
AND user_id = '90'
The above is what I would like it to do, though I can not test it as I do
not have access to a mysql that supports it.
Aside from two queries, can someone perhaps show me how
Thanks, Philip.
On 8/2/06, Philip Hallstrom [EMAIL PROTECTED] wrote:
..
http://hackmysql.com/mysqlsla
.
That's definitely of immense help.
--
Thanks a zillion,
Asif
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
1) What parameters I need to set in my.cnf to
log slow queries so that they stick out conspicuously and get noticed,
and
2) How I can find out from the log that MySQL
creates as a result of 1) as to
which queries are running slow
advice that I need right now.
I just need to know
1) What parameters I need to set in my.cnf to
log slow queries so that they stick out conspicuously and get noticed,
and
http://dev.mysql.com/doc/mysql/search.php?version=4.1q=slow+query+loglang=en
1) What parameters I need to set in my.cnf to
log slow queries so that they stick out conspicuously and get noticed,
and
2) How I can find out from the log that MySQL
creates as a result of 1) as to
which queries are running slow.
mysqlsla
Helo all,
I need explanation on EXPLAIN here.
I am trying to JOIN 2 tables TBL1 and TBL2 on TBL1.fld_id = TBL2.fld_id . And
finally I filter out the results that i need in the where clause using
where TBL1.fld_col = 100;
Running an EXPLAIN shows that it is an impossible where condition. This
Hi,
I am trying to JOIN 2 tables TBL1 and TBL2 on TBL1.fld_id
= TBL2.fld_id . And finally I filter out the results that
i need in the where clause using
where TBL1.fld_col = 100;
Running an EXPLAIN shows that it is an impossible where
condition. This may be because there may be no rows
A
are replicated to slave A, and inserts on master B are replicated to slave
B). However, queries that are run on master A, do *not* make it all the
way to slave B. The queries execute on master B but I have verified that
they are not being written to master B's binary log. Hence, slave B is not
seeing
Hi all if u have doubts pls feel free to send mails to [EMAIL PROTECTED]
www.venadsolutions.com
its
not spam
-Rao
On Tuesday 27 June 2006 13:43, Veerabhadra rao Narra wrote:
Hi all if u have doubts pls feel free to send mails to [EMAIL PROTECTED]
www.venadsolutions.com
its
not spam
-Rao
I consider this as spam. I would suggest that this person is removed from the
list.
--
Jørn Dahl-Stamnes
homepage:
and save results where queries have been
processing for X amount of time
With this information you can profile your queries and use 'EXPLAIN
query' to optimize where needed, aka adding indexes, etc.
I simply haven't found it worth it to replicate live setups in order to
look for bottlenecks. It's
processlist periodically and save results where queries have been
processing for X amount of time
With this information you can profile your queries and use 'EXPLAIN
query' to optimize where needed, aka adding indexes, etc.
I simply haven't found it worth it to replicate live setups in order to
look
nigel wood wrote:
Dan Trainor wrote:
Dan Trainor wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server.
Hi -
So I
On 5/24/06, Dan Trainor [EMAIL PROTECTED] wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server. I think that by doing something
Jake Peavy wrote:
On 5/24/06, *Dan Trainor* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
On Tue, 2006-06-13 at 19:04, Dan Trainor wrote:
Jake Peavy wrote:
On 5/24/06, *Dan Trainor* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server. I think that by doing something like
this, I would be able to fine-tune
Dan Trainor wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server. I think that by doing something like
this, I would be able
Dan Trainor wrote:
Dan Trainor wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server.
Hi -
So I was thinking about
nigel wood wrote:
Dan Trainor wrote:
Dan Trainor wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server.
Hi -
So I
Hi,
yes, it is happening when ever some duplicates are loading replication is
not moving further.
I mean in my experirnce, i stoped my slave from replication for a while, and
i forget the exact location where i stoped it. I resetted my binarylog to
appropriate file, and position to 0, and
As an addendum to this -- this was solved. The master and slave were
out of sync.
-Sheeri
On 5/19/06, Jeremy Cole [EMAIL PROTECTED] wrote:
Hi Sheeri,
So I've seen replication break a few times due to duplicate queries.
A few times it was around a server crashing, but I thought perhaps
So I've seen replication break a few times due to duplicate queries.
A few times it was around a server crashing, but I thought perhaps it
was because of the crash. (ie, master sends a query, crashes, and
then tries to send the query again when it comes back up).
But in the past 16 hours, it's
On 5/19/06, sheeri kritzer [EMAIL PROTECTED] wrote:
So I've seen replication break a few times due to duplicate queries.
A few times it was around a server crashing, but I thought perhaps it
was because of the crash. (ie, master sends a query, crashes, and
then tries to send the query again
Hi Sheeri,
So I've seen replication break a few times due to duplicate queries.
A few times it was around a server crashing, but I thought perhaps it
was because of the crash. (ie, master sends a query, crashes, and
then tries to send the query again when it comes back up).
But in the past 16
indexes, which I am looking
into. Alternatively, I could optimise queries by creating multiple
slices of the data set accross one axis then use a key on the other
axis. MySQL 5.1 partitioning scheme may help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
optimise queries by creating multiple slices of the
data set accross one axis then use a key on the other axis. MySQL 5.1
partitioning scheme may help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
made many empirical tests and have concluded:
1) I can improve performance by a factor of 2-2.5 by changing the double
lat/lon to an integer then selecting on an integer.
2) I have concluded that for each 10 fold increase in the number of
records, select queries take twice as long. For each
201 - 300 of 1256 matches
Mail list logo