On Fri, 2006-10-20 at 09:06 -0700, William R. Mussatto wrote:
> On Thu, October 19, 2006 18:24, Ow Mun Heng said:
> > Just curious to know,
> >
> > I tried to update a table with ~1.7 million rows (~1G in size) and the
> > update took close to 15-20 minutes before it says it's done.
> > Is this kin
before all thank you for your answer,
next
while waiting for an answ3er I backup the db then tried to convert tables
in Inno db format
everything run fine now, the same query execute ok
but i prefer myIsam format i use it as default,
then I'd like to understand what is the problem,
here are al
Yves, my recollection is that I ran into this exact same error msg on
a recent 4.1 - 5.0 upgrade, and the bottom line is you don't need to
worry about it. The 'File_priv' column exists as it should for 5.0.
Dan
On 10/21/06, Yves Goergen <[EMAIL PROTECTED]> wrote:
Hello,
I've just upgraded my
Another thought I had just after hitting "send" -
if you're concerned about adding to the time it takes to load a page
due to logging, you should consider using an "INSERT DELAYED" syntax
if you can. That causes the database to immediately return a success
message to the client (probably your web
It does speed things up to have no indices, sure. How much, I do not
know exactly. It takes CPU time to update the index, time to write it
to disk, etc.
I have always used indices heavily, since I have tended to work with
data that needs to be sliced & diced lots of different ways.
I personall
Adriano -
MySQL names temp tables like that (starting with # sign), in paticular
while storing a result set to be sorted. I would guess that your
query is returning a result set large enough to hit a filesystem limit
on your box. How big are you expecting the results to be? Perhaps
you are mis
Does not having a Primary Key and No indexes really speed up inserts
significantly?
We have a log table. it has the fields, cart_id, referer, remote_ip,
server_name, user_agent, company, action, type, and value that we are
tracking vistor log information for our ecommerce site. Every page
is
Hy thank you all, I'm getting the following err msg
-> The table '#sql_2c52_0' is full
running a complex query (and only running that query) with three outer join
it is a simple db that stores mail msgs
my query is about mail msg->recipients->sender
the biggest table mail_archive has 90467
Hello,
I've just upgraded my MySQL server to version 5.0.26 and ran the
mysql_upgrade script with basedir, datadir, password and socket
arguments. The first time, I ran it, it listed a bunch of tables
(database.tablename) with an "OK" after them. In the end, it said:
ERROR 1060 (42S21) at lin
Dear all,
I am running the official mysql rpms on a sles 9 box, and I am running
multiple versions of mysql servers on different ports. The problem I
am facing is that when i run
mysqld_multi start
it starts the servers up fine but when i do the reverse :
mysqld_multi stop ,
it doesn't stop
Hi everyone
is it possible in Mysql 5.0.1 to set the timezone for a user ?
PS: I don't have root access to mysql, so I'm looking for away to do
it as a normal user.
---
Ahmad
http://www.v-tadawul.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
11 matches
Mail list logo
