--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 269-1555 Baltimore, Maryland 21218
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 269-1555 Baltimore, Maryland 21218
.
so why does 'explain select * from files where
(pathref,version)=(129286,0);' scan the whole table?
It is documented that this syntax can't be optimized yet. See:
http://dev.mysql.com/doc/mysql/en/row-subqueries.html
Jason Pyeron [EMAIL PROTECTED] wrote:
On Tue, 6 Sep 2005, Dan Nelson
Is there a way to rename an index without droping it?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7
as a
primary key field...
Once you do that, you can rename the field, and then reinitiate it as a
primary keyfield.
M i l e s.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron
|
+-+---++---+-+--+--+--+
[EMAIL PROTECTED] root]#
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron
, Jason Pyeron wrote:
mysqladmin is truncating the output, how can i disable this?
or is there a better way to examine what the serer is executing at that
moment in time?
[EMAIL PROTECTED] root]# mysqladmin process
)
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218
On Tue, 6 Sep 2005, Dan Nelson wrote:
In the last episode (Sep 06), Jason Pyeron said:
there is an unique key index 'pathref_2 (pathref,version)' on this
table.
so why does 'explain select * from files where
(pathref,version)=(129286,0);' scan the whole table?
I have to admit I have never
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218
fail on 100);
String val=cnumbers[1]+cnumbers[0]+cnumbers[0];
stmt.setString(1,val);
stmt.setString(2,val);
stmt.executeUpdate();
}
}
On Mon, 5 Sep 2005, Jason Pyeron wrote:
On Sun, 4 Sep 2005, Alexey Polyakov wrote:
Why do you choose to convert varchar to tinytext? Doesn't look like
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland
?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218
.
On Sat, 3 Sep 2005, Jason Pyeron wrote:
are there backups of this machine?
do you have administrator access?
does kessler/products.frm still exist? [likely:
/var/lib/mysql/kessler/products.frm]
On Sat, 3 Sep 2005, Brian Dunning wrote:
My web site has always worked, I didn't change anything
all the parent dirs +x ?
what is the ouput is the show databases?
On Sat, 3 Sep 2005, Brian Dunning wrote:
On Sep 3, 2005, at 1:43 PM, Jason Pyeron wrote:
it could be that the permissions are wrong, too.
The permissions for all the files in there are -rwxrwxr-x ...I don't know if
that's
of characters. Take this into account when specifying a prefix
length for a column that uses a multi-byte character set.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218
;
};
};
};
|---
---
---
---
---
--+
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason
)
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218
, Chris wrote:
Because you're asking how many rows are in those tables and it has a reply?
Jason Pyeron wrote:
mysql select count(*) paths;
+---+
| paths |
+---+
| 0 |
+---+
1 row in set (0.00 sec)
mysql select count(*) files;
+---+
| files |
+---+
| 0 |
+---+
1 row
.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218
] AS `count`, `value` FROM `table`;
I can't execute more select in my system. (Delphi software) :(
Only 1 select allowed! Because it is the reporting system...
1 output is 1 select!
Best Regards!
Zoli
- Original Message - From: Jason Pyeron [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent
the
system down.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921
the daily process.
http://dev.mysql.com/doc/mysql/en/backup.html
you can rsync the bin logs.
our server flushes 4 times a day for the backup script.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason
be able to do this outside of sql by
parsing the binary log. It is a history of updates to the database, in
chronological order.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron
?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218
,
Rafal
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381
Just curious, why not use the rpm to install?
We use RHEL3 and RHEL4 here, every thing is done by rpm.
Is something missing? If so could you let us know, I would like to get the
rpms patched.
-Jason Pyeron
of the
necessary libraries and includes? I have never ventured into the rpm realm so
I am not sure if they give me the same flexibility that compiling does.
Jason Pyeron wrote:
Just curious, why not use the rpm to install?
We use RHEL3 and RHEL4 here, every thing is done by rpm.
Is something missing
some for MySQL 5.x
-Jason Pyeron
On Tue, 23 Aug 2005, Bing Du wrote:
Hi,
When I run a Perl script that uses DBI and DBD::mysql on a RHEL 3 machine,
I got this error:
==
Can't load
'/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBD/mysql/mysql.so'
for module DBD::mysql
you handle such a task?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1
ideas how to change this?
Which version of the Conenctor J are you using?, is it the latest?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us
Anyone out there heard of a rcs udf (or similar) for MySQL?
Google is not being nice to me, too much noise in the results.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron
sorry,
RCS= Revision Control Sytems
it is what backends things like cvs.
and yes user defined functions
http://www.cs.purdue.edu/homes/trinkle/RCS/
On Tue, 16 Aug 2005 [EMAIL PROTECTED] wrote:
Jason Pyeron [EMAIL PROTECTED] wrote on 08/16/2005 01:01:03 PM:
Anyone out there heard
? It's been one of those days for me.
Jason Pyeron [EMAIL PROTECTED] wrote on 08/16/2005 02:15:34 PM:
http://www.cs.purdue.edu/homes/trinkle/RCS/
RCS does not use MySQL or any other SQL engine.
I am looking to use a SQL backend for RCS.
RCS is a specific tool unlike source control management
, for transactions.
-jason
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1
On Fri, 12 Aug 2005, Jay Blanchard wrote:
Yes. Linux will consistently outperform Windows in many areas.
Except Dilbert's boss's approval queue.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason
)
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218
so slow?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381
this OS before for production ? Success story?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street
on the
list about it. Can anyone perform a quick test or verify one way or the
other? I'd be much obliged.
Thanks!
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http
are not images - so I am hoping
that MySQL can indeed deal with BLOBs ok ?
Andy
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218
why does this list not have the reply to header set?
-jason pyeron
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager
) ?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218
then there is no need to pass the -h
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1
it in an option file?
Storing in an option file didn't work, so I use this option.
Could you please explain storing in an option file did not work?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason
for this situation?)
Tnx!
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921
I have make going right now, but does anyone have any suggestions?
google was not much help for 4.1.x
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http
you can find what you need here:
http://public.pdinc.us/rpms/mysql
please email the list with questions and comments
-Jason Pyeron
On Tue, 26 Jul 2005, Jeff wrote:
I've got a brand new dell server with RedHat ES3 on it.
As usuall it came pre-installed with mysql 3.23.
Trying to upgrade
`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
mysql
but the FK is not enforced, another day to tacle that.
Jason Pyeron [EMAIL PROTECTED] wrote:
any ideas on this? google has not helped.
can temp tables be innodb? can they have fk?
mysql
mysql create temporary table
' (errno: 150)
mysql create temporary table bvolsetparents
- (id int);
Query OK, 0 rows affected (0.48 sec)
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218
.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218
10,485,760 ibdata1
07/05/2005 07:04 18,874,368 ib_logfile0
07/05/2005 06:54 18,874,368 ib_logfile1
any ideas?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron
I am willing to give up on my data recovery efforts if I can just get the
schema from the dead tables, any suggestions?
Sincerely,
Jason Pyeron
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason
)
|
+-++--+-+
files.ibd does not exist on the system.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218
No the user is still the same, there are just no innodb files. ?anymore?
On Mon, 4 Jul 2005, Gleb Paharenko wrote:
Hello.
[EMAIL PROTECTED] gleb]$ perror 1
OS error code 1: Operation not permitted
Do you run new MySQL service under different user account?
Jason Pyeron [EMAIL PROTECTED
rpm -i MySQL-Max.rpm
solved it
On Sun, 23 Nov 2003, Jason Pyeron wrote:
Our old lcs.MYSQL.so from MySQL 3.23 give the same garbage out.
This has worked on many RedHat 7.3 / MySQL 3.23.xx boxes.
On Sun, 23 Nov 2003, Jason Pyeron wrote:
I have never seen an error like this one
I have never seen an error like this one, are the RPMs setup for dynamic
libraries?
ERROR 1126: Can't open shared library 'diff.so' (errno: 0
/lib/tls/libc.so.6: unexpected reloc type 0x0$ôç¿_½)
Sincerely,
Jason Pyeron
Our old lcs.MYSQL.so from MySQL 3.23 give the same garbage out.
This has worked on many RedHat 7.3 / MySQL 3.23.xx boxes.
On Sun, 23 Nov 2003, Jason Pyeron wrote:
I have never seen an error like this one, are the RPMs setup for dynamic
libraries?
ERROR 1126: Can't open shared library
63 matches
Mail list logo