Hi,
is there a way or a function like NOW() except it returns the client time
and not the server time?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 08:18 AM 5/12/2008, you wrote:
Hi All,
We have a table which is around 100 Million rows. Its a myisam table, but
the db default is innodb.
CREATE TABLE `dc_data` (
`id` decimal(22,0) NOT NULL,
`words` varchar(255) NOT NULL,
`lf_id` decimal(22,0) NOT NULL,
`occurence` bigint(20) NOT NUL
Hi,
Alter table works on the whole table and it apply on whole table,
irrespective of partition. It will block all other queries ( select,
insert, update) until alter gets completed.
On Mon, May 12, 2008 at 8:45 PM, Mariella Petrini <[EMAIL PROTECTED]>
wrote:
>
>
> One more question, plz
>
> (h
myisam_max_sort_file_size=10GB
You have alloted 10GB memory to myisam_max_sort_file_size, The system has
8GB of memory.
send show global status;
On Mon, May 12, 2008 at 6:48 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Hi All,
> We have a table which is around 100 Million rows. Its a myisam ta
On Mon, May 12, 2008 at 8:31 AM, Velen <[EMAIL PROTECTED]> wrote:
> Hi Arthur,
>
> Could you please tell this guy that it was not a virus and you tested it
> without any problem?
>
One guy that is brave/crazy/stupid enough to run a binary on his machine
that didn't have anything bad happen to him
I tested the program before running it and it is virus-clean. I ran it
through AVG first and it's clean. I ran it in Windows. I don't know whether
there is a Linux version.
Arthur
On Mon, May 12, 2008 at 11:31 AM, Velen <[EMAIL PROTECTED]> wrote:
> Hi Arthur,
>
> Could you please tell this guy
Your best bet would be to use a UUID:
SELECT UUID();
+--+
| uuid() |
+--+
| c712dc72-718d-102b-b3c8-97395a1766b9 |
+--+
There are equivalents in various progra
I would do something along these lines:
SELECT file_id, owner_id, (owner_id = ) as 'mine'
FROM whiles
WHERE blah blah
ORDER BY mine, file_id
Jake Conk wrote:
Hello,
I have a table with 2 columns, file_id and owner_id. I want to select
all the files and order by file_id but I want the ones t
On Mon, May 12, 2008 at 11:36 AM, Jake Conk <[EMAIL PROTECTED]> wrote:
>
> SELECT * FROM whiles WHERE owner_id= first THEN SELECT * FROM
> files ORDER by file_id
>
Would this work?
SELECT *
FROM whiles
WHERE owner_id =
ORDER BY owner_id = DESC, file_id
It looks like you can use multiple order by's...
SELECT * FROM files ORDER BY owner_id, file_id
or something like that... The documentation is really good :)
On May 12, 2008, at 2:36 PM, Jake Conk wrote:
Hello,
I have a table with 2 columns, file_id and owner_id. I want to select
all the fi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jake Conk wrote:
| Hello,
|
| I have a table with 2 columns, file_id and owner_id. I want to select
| all the files and order by file_id but I want the ones that belong to
| me to show up first then everyone elses. Is this possible and how?
|
| This i
Hello,
I have a table with 2 columns, file_id and owner_id. I want to select
all the files and order by file_id but I want the ones that belong to
me to show up first then everyone elses. Is this possible and how?
This is what I'm trying to accomplish:
SELECT * FROM whiles WHERE owner_id= first
On May 11, 2008, at 11:39 AM, Kaushal Shriyan wrote:
Hi
I am referring to
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
whats the exact syntax to purge this MySQL Binary Logs
It's as indicated on the page that you reference. For example,
to purge all logs before .000698, use
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
GRANT SELECT ON X.* TO 'Xread'@'172.28.1.%' IDENTIFIED BY 'X';
I need to change that slightly so that I add a more specific 'deny'
REVOKE SELECT ON X.Y TO 'Xread'@'172.28.1.%' IDENTIFIED BY 'X'
obviously this doesn't work as there is no grant defin
On Mon, 12 May 2008 at 11:58 -0400, [EMAIL PROTECTED] confabulated:
You could also do:
SET GLOBAL expire_log_days=n;
You forgot the 's' in log:
SET GLOBAL expire_logs_days=n;
BTW - this same hint is on the the very same manual page you mentioned
at the beginning of this thread.
--
August
On May 9, 2008, at 6:58 AM, Chris Pirazzi wrote:
Hello,
I _thought_ I knew how InnoDB worked, but due to a recent mysql doc
change, I am no longer sure--the change made the dox significantly
less clear, and potentially code-breaking.
Please can someone tell me the real behavior of InnoDB in t
Sorry, you can't prove uniqueness by running it against a hundred
thousand, million, or even a billion computers. (The billionth-and-first
computer could be the one with the non-unique ID.) You need a
mathematical proof to prove uniqueness.
-Original Message-
From: Velen [mailto:[EMAIL PR
You could also do:
SET GLOBAL expire_log_days=n;
BTW - this same hint is on the the very same manual page you mentioned
at the beginning of this thread.
--
Augusto Bott
On Mon, May 12, 2008 at 11:11 AM, Rick James <[EMAIL PROTECTED]> wrote:
> RESET is not a good idea -- PURGE to some point is
Hi Arthur,
Could you please tell this guy that it was not a virus and you tested it
without any problem?
Thanks.
Velen
On Sat, 2008-05-10 at 20:59 +0400, Velen wrote:
> Hi,
>
> I'm testing a program and I need you assistance.
>
> Please unzip the file at http://www.biz-mu.com/PCID.zip an
One more question, plz
(http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations.html)
Table locks.
The process executing a partitioning operation on a
table takes a write lock on the table. Reads from such
tables are relatively unaffected; pending INSERT and
UPDATE operations are perf
RESET is not a good idea -- PURGE to some point is better.
> -Original Message-
> From: Dennis Yu [mailto:[EMAIL PROTECTED]
> Sent: Sunday, May 11, 2008 6:10 PM
> To: Kaushal Shriyan
> Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]
> Subject: Re: MySQL purge logs
>
> login MySQL with "r
Are you using mysqli, PDO, or mysql? There are differences in the way the
character set is determined, as I discovered after much the same experience
as yours.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860
Hello!
I'm wondering about MySQL LVM2 preformance, but cant found any
comparisions. I know that there is some speed decrease with LVM,
something about 30%. But how this decrease impacts overal MySQL performance?
Now we are backuping replication slave server with mysqldump w full
table locks, this t
Hi ALL,
I have been using 5.1.24-rc and partitioning by range.
I have noticed that while doing a set of SELECT
statements on one of the partitions (e.g. p1) and at
the same time doing an ALTER TABLE with drop or add a
different partition (e.g. ALTER TABLE DROP or ADD
PARTITION p10) all the sele
Hi All,
We have a table which is around 100 Million rows. Its a myisam table, but
the db default is innodb.
CREATE TABLE `dc_data` (
`id` decimal(22,0) NOT NULL,
`words` varchar(255) NOT NULL,
`lf_id` decimal(22,0) NOT NULL,
`occurence` bigint(20) NOT NULL,
`date_modified` timestamp NULL
Waynn Lue wrote:
I'm trying to figure out if the fact that the charset
is set to latin1 is the reason why.
It shouldn't be. The registered trademark symbol is code point 0xAE in
ISO 8859-1 according to the 'pedia:
http://en.wikipedia.org/wiki/ISO_8859-1
So, it would seem that your
> Thanks for your reply very much.
> I know this way.
:-)
> Could you know how to get this just by sql?
Mmmhh, no idea right now. I think unless you logged the CREATE DATABASE
I don't think the creation date is stored anywhere.
Anybody could check that?
Iñigo
> On Mon, May 12, 2008 at 2
Thanks for your reply very much.
I know this way.
Could you know how to get this just by sql?
On Mon, May 12, 2008 at 2:57 PM, Iñigo Medina García <
[EMAIL PROTECTED]> wrote:
> Hi Moon's Father, :-)
>
> what about through filesystem? $ ls -la /path-mysql-databases or
> something like that.
>
>
Hi Moon's Father, :-)
what about through filesystem? $ ls -la /path-mysql-databases or
something like that.
Iñigo
>> I want to know the create time of a database,but I can not find a way
>> till now.
>> Any reply is appreciated.
--
Iñigo Medina García
Librer
29 matches
Mail list logo
