I mean database,not table.
thank you all the same.
On Mon, May 12, 2008 at 1:55 PM, Krishna Chandra Prajapati
[EMAIL PROTECTED] wrote:
show table status;
On Mon, May 12, 2008 at 11:19 AM, Moon's Father [EMAIL PROTECTED]
wrote:
I want to know the create time of a database,but I can not
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ía
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.
Iñigo
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:57
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
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
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
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
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:
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 root and
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
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 and
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
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
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
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.
--
-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
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,
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=my_id
-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
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
On Mon, May 12, 2008 at 11:36 AM, Jake Conk [EMAIL PROTECTED] wrote:
SELECT * FROM whiles WHERE owner_id=my_id first THEN SELECT * FROM
files ORDER by file_id
Would this work?
SELECT *
FROM whiles
WHERE owner_id = my_id
ORDER BY owner_id = my_id DESC, file_id
I would do something along these lines:
SELECT file_id, owner_id, (owner_id = my_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
Your best bet would be to use a UUID:
SELECT UUID();
+--+
| uuid() |
+--+
| c712dc72-718d-102b-b3c8-97395a1766b9 |
+--+
There are equivalents in various
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 that
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 does
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
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
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
29 matches
Mail list logo
