At 02:40 PM 10/10/2007, Baron Schwartz wrote:
mos wrote:
At 01:24 PM 10/10/2007, Baron Schwartz wrote:
Hi,
Tiago Cruz wrote:
Hello guys,
I have one monster database running on MySQL 4.0.17, using InnoDB:
270GB Oct 10 14:35 ibdata1
I've deleted a lot of register of then, and I've expected tha
Hi,
I'm looking for a "best practices" way of creating tables to store both
one time and regularly repeating events. These are classes, so for the
most part the have a regularly recurring time, but we do have some one
off events. For example, let's say the following:
Class-A Mon,Wed,Fri 8-9 fro
Eric Frazier wrote:
Andrew Carlson wrote:
If you do what Baron suggests, you may want to set Innodb to create a
file-per-table - that way, in the future, you could save space when
tables
are dropped, or you could recreate innodb tables individually to save
space,
not have to dump all your inn
mos wrote:
At 01:24 PM 10/10/2007, Baron Schwartz wrote:
Hi,
Tiago Cruz wrote:
Hello guys,
I have one monster database running on MySQL 4.0.17, using InnoDB:
270GB Oct 10 14:35 ibdata1
I've deleted a lot of register of then, and I've expected that the size
can be decreased if 50% (135 GB) but
Andrew Carlson wrote:
If you do what Baron suggests, you may want to set Innodb to create a
file-per-table - that way, in the future, you could save space when tables
are dropped, or you could recreate innodb tables individually to save space,
not have to dump all your innodb tables at one time.
So, just to clarify: optimize table just defragments the index?
Apologies, I misinterpreted the documentation then.
Thanks,
Dan
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 10, 2007 3:05 PM
To: Tiago Cruz
Cc: Eric Frazier; Dan Rogart; mysql
At 01:24 PM 10/10/2007, Baron Schwartz wrote:
Hi,
Tiago Cruz wrote:
Hello guys,
I have one monster database running on MySQL 4.0.17, using InnoDB:
270GB Oct 10 14:35 ibdata1
I've deleted a lot of register of then, and I've expected that the size
can be decreased if 50% (135 GB) but the ibdata
Hi Tiago,
Tiago Cruz wrote:
Thank you guys!!
I have a lot of MyISAM and a lot of InnoDB on this database.
I did one little "for" to run one "OPTIMIZE TABLE" in each table that I
have, on my database.
If this step don't save enough disk space, I'll do the Baron suggestion.
It will not shrink
Thank you guys!!
I have a lot of MyISAM and a lot of InnoDB on this database.
I did one little "for" to run one "OPTIMIZE TABLE" in each table that I
have, on my database.
If this step don't save enough disk space, I'll do the Baron suggestion.
Thank you all!
- Tiago Cruz
On Wed, 2007-10-10
Dan Rogart wrote:
OPTIMIZE TABLE should reclaim that space, but be aware that it could
take a while to run (locking your table all the while) since it just
maps to an ALTER TABLE statement which creates a new copy of the table.
Depends on how big your tables are.
Doc: http://dev.mysql.com/doc/r
He's using 4.0, it's not an option in that version :-(
Andrew Carlson wrote:
If you do what Baron suggests, you may want to set Innodb to create a
file-per-table - that way, in the future, you could save space when tables
are dropped, or you could recreate innodb tables individually to save spac
If you do what Baron suggests, you may want to set Innodb to create a
file-per-table - that way, in the future, you could save space when tables
are dropped, or you could recreate innodb tables individually to save space,
not have to dump all your innodb tables at one time.
On 10/10/07, Baron Schw
OPTIMIZE TABLE should reclaim that space, but be aware that it could
take a while to run (locking your table all the while) since it just
maps to an ALTER TABLE statement which creates a new copy of the table.
Depends on how big your tables are.
Doc: http://dev.mysql.com/doc/refman/4.1/en/optimiz
Hi,
Tiago Cruz wrote:
Hello guys,
I have one monster database running on MySQL 4.0.17, using InnoDB:
270GB Oct 10 14:35 ibdata1
I've deleted a lot of register of then, and I've expected that the size
can be decreased if 50% (135 GB) but the ibdata was the same value than
before "clean"...
H
Hello guys,
I have one monster database running on MySQL 4.0.17, using InnoDB:
270GB Oct 10 14:35 ibdata1
I've deleted a lot of register of then, and I've expected that the size
can be decreased if 50% (135 GB) but the ibdata was the same value than
before "clean"...
How can I force to save th
Hi,
Ratheesh K J wrote:
@all,
Currently we run all our complex reporting queries on a different
server. We are not using replication though. What we are doing is to
restore the backup of the live data every night onto the reporting
server. So we are running reports on data that is not real time
> Sorry about double post, I am having problems with my ISP.
>
> I have the following query:
>
> SELECT *
> FROM Sight_Hearing_Help
> WHERE 'type_help' = "Eye Exam & Glasses"
> AND 'board_action_date' BETWEEN "07-01-2007" AND "12-31-2007"
> LIMIT 0 , 60;
>
> Returns empty row every time. The boar
russbucket wrote:
Sorry about double post, I am having problems with my ISP.
I have the following query:
SELECT *
FROM Sight_Hearing_Help
WHERE 'type_help' = "Eye Exam & Glasses"
AND 'board_action_date' BETWEEN "07-01-2007" AND "12-31-2007"
LIMIT 0 , 60;
Returns empty row every time. The boa
Have you tried testing the two parts of your WHERE clause separately?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
> -Original
Oh boy.. having the date stored as a varchar in that particular format will be
profoundly problematic. You might want to store it -MM-DD or the SQL
BETWEEN will mangle the expected return results.
Does it work (return a non-empty result-set) when you omit the LIMIT clause?
Does it work (re
Sorry about double post, I am having problems with my ISP.
I have the following query:
SELECT *
FROM Sight_Hearing_Help
WHERE 'type_help' = "Eye Exam & Glasses"
AND 'board_action_date' BETWEEN "07-01-2007" AND "12-31-2007"
LIMIT 0 , 60;
Returns empty row every time. The board_action_date is a v
[snip]
SELECT *
FROM Sight_Hearing_Help
WHERE 'type_help' = "Eye Exam & Glasses"
AND 'board_action_date' BETWEEN "07-01-2007" AND "12-31-2007"
LIMIT 0 , 60;
[/snip]
Try WHERE type_help LIKE '%Eye Exam & Glasses%' and look at your dates
in the database themselves even if they are varchars, they ar
cancel by original author
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
russbucket wrote:
> I have the following query:
>
> SELECT *
> FROM Sight_Hearing_Help
> WHERE 'type_help' = "Eye Exam & Glasses"
> AND 'board_action_date' BETWEEN "07-01-2007" AND "12-31-2007"
> LIMIT 0 , 60;
>
> Returns empty row every time. The board_action_date is a varchar field.
> Not a da
I have the following query:
SELECT *
FROM Sight_Hearing_Help
WHERE 'type_help' = "Eye Exam & Glasses"
AND 'board_action_date' BETWEEN "07-01-2007" AND "12-31-2007"
LIMIT 0 , 60;
Returns empty row every time. The board_action_date is a varchar field. Not
a date field. I have also tried using form
@all,
Currently we run all our complex reporting queries on a different server. We
are not using replication though.
What we are doing is to restore the backup of the live data every night onto
the reporting server. So we are running reports on data that is not real time.
And we are OK with tha
I tried something different:
This Server was acting as a slave before, so I removed all the Slave
stuff from it. Also mydns DNS Server was running, but i relocated it to
a different server.
Unfortunately I still get the same behavior:
# grep ' mysqld' /var/log/syslog
Oct 10 07:06:29 h1314631 m
I would have a look here:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
Secondly, if I'm not mistaking, the some_host should be localhost if you
want the script only to be able to connect from the local computer and % if
you want the connection to be possible from any possible host.
At le
28 matches
Mail list logo
