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
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 n
it starts the servers up fine but when i do the reverse :
mysqld_multi stop n,
it doesn't
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 line
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
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
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
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
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
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
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
10 matches
Mail list logo