On 1/27/06, Imran Chaudhry <[EMAIL PROTECTED]> wrote:
> > Hi;
> > My query.log is full of 'show innodb status' queries.
> > How do I get this ascii log file not to log these. OR some help with a
> > grep script to copy the file without these lines.
>
> I noticed the same in the logs of a 4.1 test s
[Sorry] I didn't realize that hitting Reply (using Gmail) sent a
private message. Usually on lists the message ends up on the list.
Will need to observe the header in the future.
tx;
-nat
On 1/27/06, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
> Please, next time always CC your messages t
I recently changed all my ibd files to MYISAM. Can I safely remove the
ibdata file and restart mysql?
Thanks;
-nat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Aye. -v. thanks!
-nat
On 1/26/06, Pooly <[EMAIL PROTECTED]> wrote:
> 2006/1/25, Nathan Gross <[EMAIL PROTECTED]>:
> > Hi;
> > My query.log is full of 'show innodb status' queries.
> > How do I get this ascii log file not to log these. OR some help with
Hi;
My query.log is full of 'show innodb status' queries.
How do I get this ascii log file not to log these. OR some help with a
grep script to copy the file without these lines.
Thanks
-nat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
Yesterday I installed the XAMPP (used to be called LAMP) stack, which
includes mysql 5.0.18, on a Fedora Core 4 system. This seems like the
quickest way of getting version 5 running WITHOUT clashing at all with
my current install.
Everything went 100% smooth, and I was able to copy my 4.x myisam
ba
On 12/21/05, Mark Matthews <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Nathan Gross wrote:
> > On 12/21/05, Hassan Schroeder <[EMAIL PROTECTED]> wrote:
> >> Nathan Gross wrote:
> >>
> >>>> /* hint
On 12/21/05, Hassan Schroeder <[EMAIL PROTECTED]> wrote:
> Nathan Gross wrote:
>
> > Woa! Let me verify. If I pass a qry string:
> > "SELECT Anyfield from Anytable where Anyfield = 'The man was 100% correct'
> > "
> > to a Connecto
On 12/21/05, Hassan Schroeder <[EMAIL PROTECTED]> wrote:
> Nathan Gross wrote:
>
> >>/* hint: java.sql.PreparedStatement */
> >
> > I thought we are talking about a mysql specific function, which would
> > not be in the vanilla j2se/j2ee pkg's. Actua
On 12/21/05, Hassan Schroeder <[EMAIL PROTECTED]> wrote:
> Nathan Gross wrote:
>
> >>Nearly every mysql client library has some kind of function to perform this
> >>escaping for you. Please refer to the manual of the client library you are
> >>using to see
On 12/21/05, JamesDR <[EMAIL PROTECTED]> wrote:
> Nathan Gross wrote:
>
>
>
> >
> > I get two lists from different sources which I merge into the database
> > via a Java program. Since these two lists themselves sometimes get
> > their data from the same
On 12/21/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> Nathan Gross <[EMAIL PROTECTED]> wrote on 12/21/2005 11:20:50 AM:
>
>
> > On 12/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > > Nathan Gross <[EMAIL PROTECTED]>
On 12/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Nathan Gross <[EMAIL PROTECTED]> wrote on 12/20/2005 05:34:58 PM:
>
> > Hi;
> > [Mysql 4x] In a table where I get data from another program, I have
> > many records (about 1000) that have ille
Hi;
[Mysql 4x] In a table where I get data from another program, I have
many records (about 1000) that have illegal chars in a [unique]
indexed varchar field. I would like to clean the illegal characters
out and leave the rest of the data intact.
1. Is there a utility to do this?
1b) Or an UPDATE c
On 12/20/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
>
>
> Please, next time answer to the list as well.
Sorry. I didn't realize Gmail's 'reply' didn't go to the list. First
time I noticed the 'reply to all' option in Gmail. Thanks.
> As far as I know, you can't specify the location
Hi;
Mysql 4x on Linux Fc4.
In /var/lib/mysql there is an ibdata1 file. Also in this directory I
also have various database folders, with *.ibd data files. I would
like to locate the ibdata1 somewhere else, say, /usr/extraData/mysql.
I am confused as how to set *innodb_data_file_path* as well as
*in
Hi;
Is there a formula I can go by in order to estimate how long it would
take to change over from innodb to myisam. Say for a 100meg file, a 5
gig table, etc.
Thank you;
-nat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
Hi;
A while ago, I changed most of my myisam based tables over to innodb. Fine.
A while later, I noticed and implemented the option to keep the files separate.
Now, weeks later, I still have a huge, 7 gig ibdata1, plus many *.ibd files.
Can I delete ibdata1? What worries me is that when I have new
On a 1.6ghz, 1gb ram, Linux machine running Mysql 4.1x.
I have an Innodb table with over 20 million records and index size
about 3.7 gig, data size 2.2gig (yes, many indexes, more space then
the data itself). Last night I tried an Optimize from the Admin gui
console (logged in as root at the host
Hi;
I have been running this server, 4.1.14 on Linux FC 4 for while, no problems.
Yesterday I fiddled with my.cnf via the Administrator console to,
tried some graphs, and also turned on binary logs.
Later in the day, (don't think it was immediate after the server
process restart, but maybe), the JB
Hi;
On FC3, for some silly reason, Yum deleted my mysql 4.1x production server!
I do have my data. Now that I am in this hole, maybe I should go to mysql 5.
Can I install mysql 5, and it will migrate/work with my existing data?
Thanks,
-nat
Hi;
I have run into 'potholes' with CMP beans on Sun's Java App Server 8.1.
While googling around I [think I] see that Sun's Server doesn't really
'like' mysql. (When it comes to CMP beans.)
Question: Honest please! Is this supposed to work? (Nothing fancy, not
even auto generated pk.)
What's t
22 matches
Mail list logo
