On Tue, 2002-03-26 at 14:35, Christopher Thompson wrote:
On Tuesday 26 March 2002 3:26 pm, Steven Hajducko wrote:
I'm trying to take a string ( In this case, a password ), and encrypt it
with RSA encryption via the perl module, Crypt::RSA. Later on, I want
to be able to pull
.
Thanks for the help guys,
Steve
On Tue, 2002-03-26 at 14:35, Christopher Thompson wrote:
On Tuesday 26 March 2002 3:26 pm, Steven Hajducko wrote:
I'm trying to take a string ( In this case, a password ), and encrypt it
with RSA encryption via the perl module, Crypt::RSA. Later on, I want
));
CREATE UNIQUE INDEX CHARLIMITS_PK ON CHAR_LIMITS(
CHAR_ID);
/*/
Steven Gearhart
Gearhart, Inc.
Phone/Fax: 770.466.2898
Email: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com
If I understand correctly, you can achieve your goal in either of 2 ways.
The first, is to copy sql.exe to one of your path directories (i.e. Windows
or Windows\System) or include MySQL\bin in your DOS path statement. This
will allow you to run mysql from a DOS prompt.
The second method is to
GUI interfaces with the same result. I am able to run a single command,
however, if I try and run a script with two or more commands, I receive an
error number 1064 - syntax error. This usually shows the error at line 1.
What am I doing wrong? I am about to give up.
/*/
Steven
there is likely a better way. But this
actually works. :)
2. Change:
s/^# Time: (\d+) Lock_time: (\d+) Rows_sent: (\d+).*\n//;
To:
s/^# Query_time: (\d+) Lock_time: (\d+) Rows_sent: (\d+).*\n//;
Submitter-Id: submitter ID
Originator:Steven Roussey
Organization:
Network54
MySQL support
+).*\n//;
To:
s/^# Query_time: (\d+) Lock_time: (\d+) Rows_sent: (\d+).*\n//;
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
. We sample every minute. Maybe we'll add qps
to the sampling. I just didn't think of that before...
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 8:47 pm
To: [EMAIL PROTECTED
presented with the default variables.
Which are?
Also, what is in /var/lib/mysql?
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
That should immediately help. There is a more optimal solution, but the
amount of work to properly tune will take at least another email and the
answers to the above questions. I can write a chapter Apache/PHP/MySQL
optimizations
Steven Roussey
Network54.com
with
ls -l
?
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Also, I forgot these questions:
- What is Apache's http.conf value of MinSpareServers?
- What is Apache's http.conf value of MaxSpareServers?
Steven Roussey
Network54.com
sql,query
-
Before posting, please check:
http
(no documentation though..)?
Too cool. At peak seconds we get 3000 queries per second. :)
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
connections solves this crash
problem).
Maybe with a new MySQL module for PHP in the works, this will get fixed.
It needs to use shared memory so multiple apache processes can use the
same connection pool.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
sql,query
done an 'analyze table iv_alert'?
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
, it is an
error.
http://www.mysql.com/doc/s/a/safe_mysqld.html
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
mysql on linux box and the mysqlgui is on the same box. The gui
version is 1.7.5.
I look forward to hearing from you.
Thanks, steven
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Japan.'S'')
I think it is the '' at the two locations...
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
. Right now I want every last ounce of speed while our
external RAID array is being rebuilt. 2 disk SCSI RAID 0 is not enough.
4 disk SCSI RAID 0 or 4 disk SCSI 0+1 is much better.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-Original Message-
From: David Turner [mailto:[EMAIL
I've never heard of this in a recent kernel/e2fsprogs. Nor have I
experienced it (thankfully). Do you any further information?
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-Original Message-
From: David Turner [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 25, 2002 4:01 pm
the lack of large file support in some (now old)
OSes. For speed, RAID is best handled by the OS or hardware.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 25, 2002 11:21 pm
To: [EMAIL PROTECTED]
Subject: Re: Re: recover lost index
To: [EMAIL PROTECTED]
Your message cannot be posted
speed of the disks once the server is disk bound. RAID 0 lets you
increase the effective speed of the virtual drive by summing the speed
of the disks (roughly). I have no experience with IDE RAID though. SCSI
still outperforms and likely always will.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
databases, distributing access
to replicated databases and throttling database access.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-Original Message-
From: Colin Faber [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 4:13 pm
To: [EMAIL PROTECTED]
Subject: Re: load formula
Sergei for such a wonderful improvement to LIKE '%word%'!
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
PS - is FTS search and update O(n^2)?
-
Before posting, please check:
http://www.mysql.com/manual.php
That would be great. Thanks!
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-Original Message-
From: Brian P. Austin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 10:45 pm
Subject: RE: Request for help in testing new replication code in 4.0.2
I have finished
, can you do #2 and #4.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
At 11/02/2002 05:21, Paul DuBois wrote:
At 4:10 +0700 2/11/02, Steven Haryanto wrote:
i believe since 3.23.39 it should not be?
BDB and MyISAM tables have different properties with respect to
AUTO_INCREMENT behavior.
i see, so this is an undocumented feature (i haven't seen this
in http
i believe since 3.23.39 it should not be?
mysql create table t1_b(i int unsigned primary key
auto_increment, j int) type=bdb;
mysql create table t1_m(i int unsigned primary key
auto_increment, j int) type=myisam;
mysql insert into t1_bdb(j)values(0);
mysql insert into t1_bdb(j)values(0);
mysql
), we will move the main server to v4 and keep
the slave around as a live backup. I've been wanting such a slave for a
long time. Stopping the slave to make a backup would be great. Not to
mention faster fulltext and order by DESC.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
i believe since 3.23.39 it should not be?
mysql create table t1_b(i int unsigned primary key
auto_increment, j int) type=bdb;
mysql create table t1_m(i int unsigned primary key
auto_increment, j int) type=myisam;
mysql insert into t1_bdb(j)values(0);
mysql insert into t1_bdb(j)values(0);
mysql
At 11/02/2002 05:21, Paul DuBois wrote:
At 4:10 +0700 2/11/02, Steven Haryanto wrote:
i believe since 3.23.39 it should not be?
BDB and MyISAM tables have different properties with respect to
AUTO_INCREMENT behavior.
i see, so this is an undocumented feature (i haven't seen this
in http
() method to MERGE tables to be able to choose the
right index when there is many to choose from. We should also extend the
info interface to get the key distribution for each index, _of_ analyze
is run on all sub tables.
_of_ should be if
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
Hello
I was wondering if anyone knew of a program that would allow you to print
out a complete database. I have seen it on a PostGre DB, so I am sure
MySQL should have something...
cheers!
Regards,
___
Steven Wren
[EMAIL PROTECTED]
http://www.server101.com
Webhosting and E-commerce
be good for management and seeing where you can improve indexes
etc...
thanks.
Regards,
___
Steven Wren
[EMAIL PROTECTED]
http://www.server101.com
Webhosting and E-commerce Solutions
Phone : AU (07)38766 101
US 877 7762 101
Fax : +61 7 38763 101
The world is not only stranger
integer type and CONV() only works with
up to 64-bit 8-byte numbers anyway.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
hardware.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
In honor of Jeremy:
MySQL 3.23.47-log: up 5 days, processed 595,464,211 queries (1,350/sec.
avg)
:)
-
Before posting, please check:
http://www.mysql.com/manual.php
Is it possible to compile and run MySQL as a 64-bit program on Solaris 8?
If so, are there precompiled bits available?
The primary reason for doing this is to determine if a 64-bit version would
allow the database to be larger than 4-gig. I have been told by another
member of our team MySQL
-bit capable gcc-3.0.3. How might I verify that
I indeed have a 64-bit MySQL?
TIA,
Steven
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
for the LDFLAGS
variable. What library files should I be pointing to with it? I put my gcc
in /opt/gcc-3.0.3-64. Will this influence the proper choice of value for
LDFLAGS?
Steven
-
Before posting, please check:
http
, then I can send the request and quit.
Thanks for the idea!
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
and mysql threads with the least bit of
effort.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hi!
Is there a way to create a temp table and _not_ have it logged to the
binlog? We use temp tables only to increase the speed of certain types of
selects (we have discussed the type of select that causes this problem on
this list already), and don't want them rerun when we might have to to a
Try mysqlfront (www.mysqlfront.de) I use it daily in development tasks for a hybrid
Win2k - Linux setup. Works great.
10 Sep 01 10:28:21 PM, Francois Meehan [EMAIL PROTECTED] wrote:
Hi all,
I am looking for a freeware-shareware pgm for data entry, on win32 for a
mysql database on Linux(not
unsigned
int not null' and set it in an insert to (0x - ip) and have an index
on ip_desc. (If the column was signed you would use 0x7FF - thevariable,
but ip numbers need to be stored as unsigned).
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
PS: I'm trying to set aside a week
mysql explain select * from dominf.domip order by ip desc;
'ORDER BY something DESC' does not use an index. It must be ascending. See
the manual.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-
Before posting, please
index table. Check the list
archives. If you are scanning for something like 'SCRIPT type=' in a field,
then you will have little luck. So the answer depends on what you are trying
to do (as always).
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
mysql
I am having a problem with MySQL. I am seeking some advice on either what is wrong
or how to pursue the cause of this bug.
I am using Perl DBI to interface with MySQL and when i execute the
following statement:
$dbh = DBI-connect('DBI:mysql:database=dbmysql2', undef, undef,
{PrintError =0}) ||
I am using Perl DBI to interface with MySQL and when i execute the
following statement:
$dbh = DBI-connect('DBI:mysql:database=dbmysql2', undef, undef,
{PrintError =0}) || die $ DBI::errstr;
it causes the error:
[Fri Aug 17 09:59:50 2001] productioncontent14.pl: Access denied for user:
I am having a problem with MySQL. I am seeking some advice on either what is wrong
or how to pursue the cause of this bug.
I am using Perl DBI to interface with MySQL and when i execute the
following statement:
$dbh = DBI-connect('DBI:mysql:database=dbmysql2', undef, undef,
{PrintError =0}) ||
I am having a problem with MySQL. I am seeking some advice on either what is wrong
or how to pursue the cause of this bug.
I am using Perl DBI to interface with MySQL and when i execute the
following statement:
$dbh = DBI-connect('DBI:mysql:database=dbmysql2', undef, undef,
{PrintError =0}) ||
In my (limited) experience it's nearly as easy as using ASP/ADO wirth Access. MySQL
is a bit touchier about what it considers proper SQL. We're developing a hybrid
(mutant?) system using MS's
IIS web server and MySQL running on a Linux box and it's coming along quite nicely.
You really
Hi all, I have not been using MySQL for too long but have been using SQL7.0 for a
while now, so I am generally familiar with the structure.
My basic problem right now is trying to figure out how to get MySQL to do nested
queries such as ...
select count(*) from (select count(*) as A,
:1
read_next: 0
read_rnd 0
read_first: 0
write: 0
delete 0
update: 0
Table status:
Opened tables: 2
Open tables:2
Open files: 6
Open streams: 0
Sincerely,
Steven Roussey
Recently the index files became corrupted and I ran the
myisamchk *.MYI -r -S to repair them.
Try an OPTIMIZE TABLE or ANALYZE TABLE. Your queries may be using the
incorrect indexes since the statistics have not been updated.
You can also do this: myisamchk *.MYI -a
Sincerely,
Steven
-S *MYI
myisamchk -R1 *MYI
Do them as sepparate commands. It will take a while. Look for messages from
myisamchk about the tables.
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please
Steven Now I have a question: Does this also apply to automatic
repair inside
Steven mysqld? I'd finally use the feature if its true...
If you just run CHECK TABLE, it will repair the open count (it should
always have done that).
myisamchk --fast --force is equal to:
run CHECK TABLE
the selects on metadata
and convert them to lowercase in the code to get the replication to work
?...
Steven Goodliff.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Hello,
I'm trying to set up replication, but I cant get any further than this
message on the slave.
Error reading packet from server: log event entry exceeded
max_allowed_packet
My max allowed packet size is 512M which I've gradually reached while trying
to stop the above error message.
a question: Does this also apply to automatic repair inside
mysqld? I'd finally use the feature if its true...
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com
a way to do it in one query.
Any tips or hints would be extremely appreciated.
Thanks!
Have a good one.
Regards,
Steven Wren
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
I have installed mysql 3.23.36 for the first time ever
I did the test (ok)
I ran the bench mark and could not load DBI
I installed DBI 1.14
And Data Showtable 3.3
Then tried to install (Msql-Mysql-modules-1.2215)
Perl Makefile.pl worked fine
I run make and this is what it ends with:
make[1]:
I have installed mysql 3.23.36 for the first time ever
I did the test (ok)
I ran the bench mark and could not load DBI
I installed DBI 1.14
And Data Showtable 3.3
Then tried to install (Msql-Mysql-modules-1.2215)
Perl Makefile.pl worked fine
I run make and this is what it ends with:
make[1]:
Hi folks,
The recent additions of storage handler for transaction-supporting table
confuses us. From what I read on the list, Innobase is generally much
faster than BerkeleyDB. But I can live with slower speed since my
application will not be expecting high rates. It is reliability and tested
it first with php 4.0.4pl1: didn't help (by the way: is there any
way to get the zend optimizer for php 4.0.5pl1?)
so, any new idea?
steven
-Ursprngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Im
Auftrag von Van
Gesendet: Dienstag, 20. Mrz 2001 04:47
An: [EMAIL PROTECTED
PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Van
Sent: Tuesday, March 20, 2001 10:31 AM
To: [EMAIL PROTECTED]
Subject: Re: AW: AW: Got an error reading communication packets
Steven Glogger wrote:
hi van
thank you for the tip.
on a test server i installed a fresh version of mysql
Yes, I have tried it both ways. I configure Apache a second time after
making php and it still does not work. :(
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
Subject: Re: [PHP-DEV] RE: 4.0.5RC1 static build with Apache 1.3.19
problem
Did you configure Apache after
1.3.19,
Linux 2.2.18-SMP #1 SMP Sat Jan 20 07:41:17 GMT 2001 i686 unknown,
PHP 4.0.5 RC1
any idea what it is?
greetings
steven
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi!
Does MySQL's insert delayed handler insert concurrently with selects on
MyISAM tables like the non-delayed inserts?
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check
an error in your SQL syntax ...'
PS - we do not use autoincrement in insert delayed tables.
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php
,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
this appear.
Is there a binary of a debug version for Linux? I'd like to catch the server
going down with more information.
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check
Number of processes running now: 0
010306 15:13:38 mysqld restarted
I'm off to compiling a debug version. :( Will send a real bug report if it
dies again.
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
to browse through and see what I can find, but using vi is just not
worth my time.
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php
timeout reading communication packets)
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
have processes
running. What is going on?
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
exhibit A:
11519 pts/2S 0:00 /bin/sh ./bin/safe_mysqld --user=root -O
back_log=20 -O table_cache=3500 --log --debug=d,info,query
11567 pts/2S 1:48
/usr/local/mysql/libexec
I forget to give the tail of the error log:
010307 12:33:41 Aborted connection 90714 to db: 'logging' user: 'apache'
host: `neo.f' (Got timeout reading communication pac
kets)
010307 12:33:41 Aborted connection 90722 to db: 'logging' user: 'apache'
host: `morpheus.f' (Got timeout reading
pack_fields__FiRt4List1Z12create_field + 320
0x80bf4d9 make_empty_rec__Fi7db_typeUiRt4List1Z12create_fieldUiUi + 309
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com
vsprintf + 69
0x807c0ac net_printf__FP6st_netUie + 108
0x8084f28 handle_one_connection__FPv + 360
Hmm... Greek to me.
OK, so I'm starting over. Compliled my own version of
mysql-3.23.33 --with-debug as per manual. I'll be back when I have more
info
Sincerely,
Steven Roussey
Network54.com
One more thing:
In the processlist:
| Delayed_insert | 578 | reschedule | log_day_20010307
After another minute (now over 10 minutes to reschedule) I get a _lot_ of
these:
| Query | 9| waiting for handler insert | insert delayed into
logging.log_day_20010307 ...
Which
010307 9:29:44 read_next: Got error 127 when reading table
./perf/webstats_apollo
What causes them and how can I prevent them?
Check to be sure you have enough open file descriptors. Set open-files for
safe_mysqld or hack a ulimit in there yourself.
Sincerely,
Steven Roussey
Network54.com
of problems. As a note, there is a unique index it should
be using. Is there a way to see if it is, or USE INDEX like select?
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check:
http
Hi, I searched all over, but I can not find out what the state 'reschedule'
means in the PROCESSLIST.
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com
I'm using 3.23.30, and when I use delayed_insert_timeout set to 2000
(verified with show variables), I still see many threads that have much
higher time values. They aren't dieing off like they used to.
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
gives the same
error when i try to insert anything into the list ? What do i do to fix it
and what did i do to cause it? Please help me I need this database up and
running (loosing money every hour its down!)
:( please please please help thank you very much for your time and help.
-Steven
Steven
, but PHP has not yet noticed? Is the configuration different?
Thanks!
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
does
not succeed.
I was curious to hear any related stories that might help me create a test
case.
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com
.
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
Hi,
There was a bug in 3.23.31 (I think) with fultext indexes. Was this fixed in
3.23.32?
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php
on mysql's auto repair
feature so it can deal with it rather than me.
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
). They
are in CVS.
If you are using Apache (most of us are with PHP), note that persistent
connections are per process, not per machine. Mod_ssl can use an Apache
extension to keep shared memory across processes, but PHP does not. Read the
docs (or the PHP list) to find out more.
Sincerely,
Steven Roussey
301 - 391 of 391 matches
Mail list logo