You havent mentioned which version of mysql your are on. If on an older
version i would recommend the option --opt. Also if you are running a dump
using single-transaction option on a loaded system with writes, things might
slow down significantly due to different versions of rows which the serve
On 7/6/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
How does the cpu power influence the speed of a query?
Sort is a cpu intensive process.
*Check if you are suffering from locks on the tables you look up.*
Also, was the table in the system where the queries are running faster
rebuilt r
On 7/6/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
-- CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.03',
MASTER_LOG_POS=311;
As see in the mysqldump is saying to start recovery from bin-log file "'
mysql-bin.03'" and position="MASTER_LOG_POS=311",
You need to use the positions specif
On 7/6/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
How does the cpu power influence the speed of a query?
Sort is a cpu intensive process.
*Check if you are suffering from locks on the tables you look up.*
Also, was the table in the system where the queries are running faster
rebuilt r
David T. Ashley wrote:
I'm sending this again, because the server seems to have been down for
several hours, and I'm not sure if it went out.
Yes, I've been getting messages from yesterday, too. But I did get both
of your messages. I don't know what's up.
I'd like to do full text search on
Good Evening David-
Have you considered using Lucene ?
http://lucene.apache.org/java/docs/
M--
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed. If you have received this email message i
At 10:09 PM +0200 7/7/07, Ian Collins wrote:
Hi,
I am seeing a large lock contention on a production database (A
large table_locks_waited against table_locks_immediate).
I want to set low priority updates, but I don't want to shut the
database down to do it.
Is,
set global LOW_PRIORITY_UPDATE
Miguel, it's possible, but it's not normal procedure in most systems I've
worked with. Separate databases are generally used for separate "systems".
Reasons include more work/steps to grant privileges to users, more
difficulty establishing a test system (you need a whole separate MySQL
instance i
Hi,
I am building a new system for the place i work and i was thinking
about organizing my tables in several databases, like "management",
"financial", "production_line" to make things more tidy. I will have
tons of tables, so is it a usual procedure in organizing tables?
The othe
I'm sending this again, because the server seems to have been down for
several hours, and I'm not sure if it went out.
-
I'd like to do full text search on some fields of some tables, but I'm a bit
confused by the documentation. Questions:
a)How do I set that up (i.e. do I need to use
mysqlhotcopy is a perl script that came with your disto of mysql. If you have
mysql installed on another machine then you probably already have it (I've
never installed it without it being there).
-Chris
From: Michael Higgins [mailto:[EMAIL PROTECTED]
Sent: Fr
Hi,
I am seeing a large lock contention on a production database (A large
table_locks_waited against table_locks_immediate).
I want to set low priority updates, but I don't want to shut the
database down to do it.
Is,
set global LOW_PRIORITY_UPDATES=1;
the same as starting mysql with --low_pr
There are just spam messages.
The spam robots probably found some messages from the list somewhere and our
addresses, and it put all the addresses in its database.
Then, as usually, it sends spam messages to all addresses, using another
address from the same message as the source address. This
Same here, although they have been a little less frequent
lately.
From: "B. Keith Murphy" <[EMAIL PROTECTED]>
Sent: Friday, July 06, 2007 3:50 PM
To: Michael Dykman <[EMAIL PROTECTED]>
Subject: Re: off-topi
In python
-
import re
file = open("path/to/file","r")
for line in file:
line = line.replace("\n","")# this is not always needed
columns = re.split("\s+",line)
print columns#is now a list
print columns[0]
sql = "insert into ..."
-
Check out your signature after posting.
It has the unsubscribe link added.
cheers,
boro
Ananda Kumar schreef:
Me too, every once in two days i keep getting this "UNSUBSRIBE" emails.
regards
anandkl
On 7/7/07, B. Keith Murphy <[EMAIL PROTECTED]> wrote:
I have been having the same problems
Me too, every once in two days i keep getting this "UNSUBSRIBE" emails.
regards
anandkl
On 7/7/07, B. Keith Murphy <[EMAIL PROTECTED]> wrote:
I have been having the same problems. Have no idea what is up.
- Original Message -
From: "Michael Dykman" <[EMAIL PROTECTED]>
To: "MySQL Gen
Hello, list --
Quick (and simple?) question:
I've been backing my databases up with a perl tool mysqlhotcopy. It seems
to leave me a bunch of files in a folder I specified.
What is the best way to move this database function to a different machine?
There are no constraints. I can take it a
I'd like to do full text search on some fields of some tables, but I'm a bit
confused by the documentation. Questions:
a)How do I set that up?
b)What storage engines are required?
c)Are there any restrictions on "mixing and matching" tables?
d)Do table locking and transactions work the same?
19 matches
Mail list logo