I have been looking high and low but am having trouble finding good
info. I need to try to lock down mysql with strong passwords
password expiry yadda yadda. I've looked at securich and am not sure
I want to use it.
All I really want is to prevent users from be able to change their
pa
"Jesse F. Hughes" writes:
> r...@pw:/var/lib/mysql/mythconverg# myisamchk -o recorded.MYI
> Warning: option 'key_buffer_size': unsigned value 18446744073709551615
> adjusted to 4294963200
> Warning: option 'read_buffer_size': unsigned value 18446744073709551615
> adjusted to 4294967295
> Warnin
(I emailed this to Martin and Jaime rather than to the discussion
group, so I'm re-sending it.)
Martin Gainty writes:
> Jesse ..please keep us apprised on your progress..we would like to
> know how fubar the db can be before it becomes 'unrecoverable'
Well, I'm not having much luck so far.
I h
Brian Dunning wrote:
Hey all -
I have a table with 12,000,000 records spread over about 6 years. I'm trying to
delete all but the last 2 years, but no matter how small of a group I try to
delete at a time, it keeps hanging up the server and I eventually have to
restart MySQL. The table looks
I can't help but wonder how this is in any way relevant to the
original question.
On Fri, Jun 4, 2010 at 6:12 PM, Martin Gainty wrote:
>
> Hi Brian-
>
>
>
> i think the best way to ensure your dates are using -MM-DD format is for
> your dml to reference dates with DATE_FORMAT('-MM-DD','%
Hi Brian-
i think the best way to ensure your dates are using -MM-DD format is for
your dml to reference dates with DATE_FORMAT('-MM-DD','%Y-%m-%d') e.g.
mysql> select DEIT_EVENT_SEQUENCE_ID,DEIT_EVENT_STATUS_CODE,DEIT_EVENT_DATE
from DEIT;
++-
Are there any publicly available data on how the size of some (or better
yet, many) particular "real" database(s) changed over time (for a longish
period of time)? How about data on how the throughput (in any interesting
terms) varied over time?
Thanks,
Mike Spreitzer
Hi Brian,
I would suggest you to use mk-archiver (Maatkit Tools) for this activity.
http://www.percona.com/files/presentations/Make_Life_Easier_Maatkit_v2.pdf
Regards,
Krishna
On Fri, Jun 4, 2010 at 8:40 PM, Brian Dunning wrote:
> Hey all -
>
> I have a table with 12,000,000 records spread ove
dont use a single delete statment.
Use a stored proc, loop through and delete record by record and commit for
every 10k. In this way, your mysql will not hang and if you replication
setup, slave also will not lag behind.
regards
anandkl
On Fri, Jun 4, 2010 at 8:40 PM, Brian Dunning wrote:
> Hey
Hey all -
I have a table with 12,000,000 records spread over about 6 years. I'm trying to
delete all but the last 2 years, but no matter how small of a group I try to
delete at a time, it keeps hanging up the server and I eventually have to
restart MySQL. The table looks like this:
`creation
2010/6/4 Jesse F. Hughes :
> Is it possible to build a .MYI file "from scratch"?
>
> I have found a file that I believe is recorded.MYD. I have the .frm
> file as well, but I don't think that recorded.MYI survived the
> file system event.
Yes, the mysql utility "myisamchk" and the REPAIR command
Is it possible to build a .MYI file "from scratch"?
I have found a file that I believe is recorded.MYD. I have the .frm
file as well, but I don't think that recorded.MYI survived the
file system event.
--
"No feeling sympathy for mathematicians who start marching with signs
like 'Will work fo
On Thu, Jun 3, 2010 at 8:44 PM, Michael Dykman wrote:
> address, there are privacy regulations which prohibit the practice.
>
I fully agree with you, but as a matter of pedantry I would like to point
out that the privacy regulations you speak of are not applicable outside of
your part of the wor
hello, i have a mysql database that stores URL's in a table now i
would like to change the schema so that the URL's are unique so my
question is: is it appropriate to use URL's as a unique IDs if not
what are the alternatives?
any advise much appreciated
norman
--
˙uʍop ǝpısdn p,uɹnʇ pןɹoʍ ǝɥʇ
14 matches
Mail list logo