 | | | MySQL General | | 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 whichHe '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 coIf 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 indiviOPTIMIZE 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 tHi
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 exHello 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 iHi
Ratheesh K J wrote
> @(protected)
>
> 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 t
> 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_datrussbucket 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 "
> ANHave 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 /Oh boy.. having the date stored as a varchar in that particular format will be profoundly problematic. You might want to store it YYYY-MM-DD or the SQL BETWEEN will mangle the expected return resultsSorry 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-[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 Exacancel by original author
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysql
To unsubscribe http //lists.mysql.com/mysql?unsub mysql@(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 "
> LII 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 e@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 rI 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.
UnfortunI 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 frRecover your files first and then you can see where you can go. I
suppose you now have backup plans in place now?
Keith
David Winslow wrote
> Hey
>
>
>
> Environment
>
> Windows 2003 server
>Hi
We have php 4.3.4 and mysql 5
My test script produces this
Client does not support authentication protocol requested by server
http //www.jewishgen.org/cemetery/connect-test.php
Research sugSign up for dyndns.com or some other similiar service. Create
permissions to the domain and run a script that updates you IP with
dyndns whenever it changes. (such scripts already exist).
As far asQUESTION What are the most secure permissions settings for administrator
access to connect to my server without using a static IP address?
MY ISP changes my DSL ip address almost daily so when IHi all
I 'm looking to get an unbiased opinion of two possible methods for
controlling access to database servers.
Here are the specs
* 6 database servers all firewalled off to the outside world-----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Hi
MySQL Connector/J 5.0.8 a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
This is a bug fix release for the current prHey
Environment
Windows 2003 server
Mysql 5.0 server
Problem
Our server crashed and the c drive was formatted. Unfortunately we did not
have a backup of the mysql databases which we were-----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Hi
MySQL Connector/J 5.1.5 the first production release of the 5.1 branch
has been released. Connector/J is the Type-IV pure-Java JDBC driver for
MySQSid Lane wrote
> stupid non-technical ?
>
> does anyone know what the registration fee is going to be for the 2008
> conference? my mgr needs a # today to put in next yr 's budget & I couldn 't
> fiFrank-
I 've had the exact same issue crop up in our prod servers - it was very
frustrating as it was intermittent and would affect some of our slaves
but not all.
We had a lot of back and forth wiBaron
Thanks for the quick response. I do have the binlogs still on the
master so I should be able to do that - however I saw a post somewhere
(lost the link at this time) saying that resetting t |
|
|
