Description:
See attached log
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:Ray Bellis
Organization: Community Internet plc
MySQL support: none
Synopsis: Can't login to server until access tables are flushed
Severity: serious
Priority:
Hello,
Till yesterday i was using an old library named Pthread 1.60 b6 (it
seem's to be the same that is in MIT-PTHREADS except for b5) for compiling
MySql but as i'm not able to compile it again i had to change.
And now for portability, I'm trying to use PTH library 1.4.0
It seem's compatible
Hi
When did the option log-slow-queries become available.
It works on my 3.23.33 setup, but not on a 3.22.32
Thanks
Simon
--
Simon Windsor
CricInfo http://www.cricinfo.com/
Tel: +44 (0) 1249 700744
Fax: +44 (0) 1249 700725
Email: mailto:[EMAIL PROTECTED]
This email message is for the sole
Hello mysql,
Resently I've found a problem when I was trying to upgrade from
3.23.32 to 3.23.36, well I had a same problem then tried to upgrade
to 3.23.33 so decided to wait a bit, but now i think I should check
more about this.
The problem is the followings: Sometimes then I rename
Sean Armstrong writes:
I can't seem to get this version of MySQLGUI 1.7.4-2 to connect to the mysql
server I'm running on the computer. I get the following denial of access
everytime I try to connect:
Access denied for user: ' mailto:'root@localhost' root@localhost
Hi MySQL people,
A question:
I'm evaluating the BDB performance.
I compiled and installed the source version 3.23.35 on Solaris 2.6
I noted that:
- An INSERT INTO using myisam table type get ~3ms, practically constant,
- An INSERT INTO using BDB take ~90 ms ! growing soon on the table size!
Hi,
We are a Telecom Software Product Development company, developed a product
on Windows NT platform with MS SQL Server 2000 Database,
inserting around 3 million records/month (in one table), the database grows
to 20GB/month and the database will be accessed simultaneously for providing
John Cartwright writes:
Hello All,
I see a -t or a --timeout= option listed for mysqladmin, but I can't
seem to get mysqladmin to recognize it. Is this an oversight in
documentation or a case of my misunderstanding?
My objective is to be able to ping each of our mysql servers
I'm getting a whole lot of mysql++ link problems on freebsd :/
Used gcc 2.95.3, latest mysql++
The program links fine under linux win32.
Any idea's?
g++-L/usr/local/lib/mysql -L/usr/local/lib -L/usr/lib -pthread -o bord
main.o BMain.o options.o ../actioninterface/libactioninterface.a
Gotta ask. Is this a problem or just a really bad idea? Part of me can see
why this is barfing. ON the same line you rename a table twice. If it's
threading these requests then one thread might not be finished with the
table formally known as table1 before you try and move it again.
If you
Hi,
If you need those things, mabye postgres is more your cup of tea!
Porting for Linux? Cool! There is always Oracle, is now ported to
Linux too!
Best Regards
Chidamparam [EMAIL PROTECTED] 29-03-01 12:46
Hi,
We are a Telecom Software Product Development company, developed a product
on
At 1:21 PM +1300 3/28/01, andrew.b wrote:
Does anyone know where I can find such a beast?
Have a look at ...
http://www.lilback.com/macsql/
... and ...
http://www.rtlabs.com/
--
%~%~%
| Ray Zimmerman ([EMAIL
Yes, Thanks. I was looking for wrong Keyword.
"Jeremy D . Zawodny" wrote:
On Wed, Mar 28, 2001 at 05:22:56PM +0200, Martin Jeremic wrote:
I have two mySQL servers, one is in office, and other at home. I
need to synchronize then via DialUp TCP/IP connection (not Internet
DialUp). Can
Modules that look like Compress::Zlib are indeed on CPAN, they have a
module search engine somewhere on the page
On Wed, 28 Mar 2001, Chris Becker wrote:
Is the zlib on CPAN? like module Compress::Zlib ?
Many Thanks Gerald!
ChrisB
MCSE MCDBA
-Original Message-
From:
I started this question yesterday. Since I can not get a compiled version of mysql to
run on Sparc
Solaris 2.6. I thought I would try and recompile mysql myself. This also failed
miserably with the "cross
compile" error. My question is this .. Has anyone gotten mysql to run on a sparc
I installed MySql using the AIX 4.3.3 binary version and ran into the
following problem. Please help me to locate the libz.a library. Thank
you!
scripts/mysql_install_db
Could not load program ./bin/my_print_defaults:
Dependent module libz.a(shr.o) could not
Ian Moss wrote:
Hi,
I'm receiving the following error message when doing a not very complicated
join between 2 tables.
ERROR 1030: Got error 134 from table handler
I've had a look through the manual but can't find any mention.
Any help would be very much appreciated.
Cheers
Antonio gulli wrote:
Any help is appreciated
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 158 to server version: 3.23.36-log
myisamchk -V
myisamchk Ver 1.45 for pc-linux-gnu at i686
a) Trying a recovery.
myisamchk -r -q
in PHP (I wouldn't try to do this in SQL) use this psuedo code:
$lcvA = 1;
while (you can still fetch rows){
$color = ($lcvA%2)=0 ? "RED" : "GREEN";
echo "TR bgcolor=\"$color\"";
.
.
.
$lcvA++;
}
HTH,
Cal
http://www.calevans.com
-Original Message-
From: Mike Roberts
On Thu, 29 Mar 2001 [EMAIL PROTECTED] wrote:
Hi,
I have two database`s with one table in each. (MySQL)
Is there a way that I can select data from one table and then match it with
the data in another and discard the results so all I am left with is the
original data from the first
On 3/29/01 7:29 AM, "Tim Bauer" [EMAIL PROTECTED] wrote:
Dear Friends,
Sorry for the stupid question, but are any of the distributions
available out there for the newly released Mac OS X.
I see two on MySQL download pages:
MacOS X Server (PowerPC) [apple-rhapsody5.5-powerpc]
3.23.27
Hi !
I notice a bug with MySQL 3.23.36 with REPLACE DELAYED which crash my MyISAM
tables.
The problem was present in MySQL 3.23.34, but not in 3.23.33 nor 3.23.35.
The bug occurs randomly and makes MySQL restart...
With REPLACE instead of REPLACE DELAYED, there seems to be no problem.
Here is
Yep, I did this too when I was first starting out.
Something you put into mysql.user is syntactically incorrect.
The server does a sanity check on it's permissions, and if they are screwy,
kills itself to save your data. (very big of it, yes?)
The quickest way out of this mess is to delete the
Hey all.
I asked a question on the list before, but didn't really get any replies so
I'd like to take another shot and give some more specifics.
I'm using MySQL running Win2K Prof with 128 MB RAM, 7200 DMA100 IDE drive,
etc.
I'm connecting to the MySQL server through MyODBC from a Visual
On 3/29/01 3:37 AM, "Darius Ivanauskas" [EMAIL PROTECTED] wrote:
Hello,
Does anybody know, how to insert large amount of data
(ex.: large binary files) into BLOB columns?
Thanks,
Darius Ivanauskas
P.S. Please reply to me.
The general algorithm is:
Open binary file
Check
MySQL doesn't use a table index when doing a string search like %string%,
but it MAY use the index when doing something string%. Is there a way you
can change your search to do a "string starts with" instead of a "string
contains" ? This should help with MySQL using the index that you want it
I have MySQL server on NT 4.0 SP6a
I connect to the db through this asp script :
strConnection = "driver={MySQL};server=xxx.xxx.xxx.xxx;uid=" + UID +
";database=" + DBName + ";password=" + Passwd + ";port=;";
adoDataConn = Server.CreateObject("ADODB.Connection");
Hello,
A question about the -O option you can pass on command line to safe_mysqld.
If for example I give -O record_buffer=64M does that mean that I'll get:
exactly 64M,
at the most 64M
or at least 64M?
Also I have a batchfile with about 150 queries (all plain selects) which I feed into
mysql.
Hello,
I'm attempting to compile MySQL 3.23.36 on a Linux system (heavily modified i386
RedHat 7.0 base with 2.4.2 kernel and gcc 2.95.3) but get the following error message
some ways down:
Making all in client
make[2]: Entering directory `/home/jandrews/mysql-3.23.36/client'
c++
MySQL doesn't use a table index when doing a string search like %string%,
but it MAY use the index when doing something string%. Is there a way you
can change your search to do a "string starts with" instead of a "string
contains" ? This should help with MySQL using the index that you want
Hi !
I notice a bug with MySQL 3.23.36 with REPLACE DELAYED which crash my MyISAM
tables.
The problem was present in MySQL 3.23.34, but not in 3.23.33 nor 3.23.35.
The bug occurs randomly and makes MySQL restart...
With REPLACE instead of REPLACE DELAYED, there seems to be no problem.
Here is
We have an older system that we have to put up with for another year,
their "fix" for y2k was, like several others, to place a number one before
the date "ex 1000329 or 1010329 which is interpreted as Mar. 29, 2000 or
Mar.29, 2001. Is there a way to delete the "1" at the beginning when
On Thu, Mar 29, 2001 at 02:09:02PM -0500, Thalis A. Kalfigopoulos wrote:
Hello,
A question about the -O option you can pass on command line to
safe_mysqld. If for example I give -O record_buffer=64M does that
mean that I'll get: exactly 64M, at the most 64M or at least 64M?
At most.
Hi,
I have problem about the mysql database file. After I deleted a lot of table
records,
the database data and index file still have the same size as that before I
deleted a lot of records.
Anybody knows how to shink the database file size after I delete a lot of
records?
Thanks in advance.
On Thu, Mar 29, 2001 at 01:46:28PM -0800, Guanglin Dong wrote:
Hi,
I have problem about the mysql database file. After I deleted a lot
of table records, the database data and index file still have the
same size as that before I deleted a lot of records. Anybody knows
how to shink the
In the last episode (Mar 29), Guanglin Dong said:
I have problem about the mysql database file. After I deleted a lot
of table records, the database data and index file still have the
same size as that before I deleted a lot of records. Anybody knows
how to shink the database file size after
Hi there,
i anybody out there running mysql on a netapp filer as data storage?
regards
Sven Huster
Senior Unix System Administrator
*BSD, Linux, Solaris
-
Before posting, please check:
http://www.mysql.com/manual.php
Help,
I am trying to install the Sun Solaris 2.7 Sparc static binary of
MySQLGUI 1.6 for the MySQLGUI the result was:
ld.so.1:./mysqlgui-solaris-2.7-sparc-static-1.6
:fatal:libstdc++.so.2.10.0:open fatal: no such file or directory
1. Trying to install this GUI on a solaris box,
Hey there,
Im in need of of a win2000 binary with the option --with-raid,
dont have any possibillity to compile it my self... So anyone with win2000 and
the possibillity to download and recompile the source?
/roger
Sven Huster wrote:
Hi there,
i anybody out there running mysql on a netapp filer as data storage?
Yes, I've done this for a client from a linux server. Worked
fine as long as there was only one mysql server accessing
the data. The network as 100 Mbs, and the SQL volume was
pretty
On Tue, 27 Mar 2001, Sinisa Milivojevic wrote:
You also need fl_editor package. You will find a link on mysqlgui
page.
OK, that indeed got me further. (Is it only me, or does putting a header
file into one package, and the source in another one really sound funky?).
Anyways, I'm down to one
Am 00:20 30.03.2001 schrieb Joshua Chamas:
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Sven Huster wrote:
Hi there,
i anybody out there running mysql on a netapp filer as data storage?
Yes, I've done this for a client from a linux server. Worked
fine as
I created a table with a datetime field. I need info on it! I don't know how
to work these fields.
So far there are about 5 records in the table and I haven't touched the
datetime field.
What I need to know is if that field gets updated automatically when the
record is inserted or updated. And
I think you want datestamp (or is it timestamp?) for automatic updates.
Chapter 7 of the manual describes all the functions that can be used for
date formatting. All this is in the manual.
- Original Message -
From: "Mike Roberts" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday,
Hi,
I`m just trying to figure out the best method to delete my records and
wondered if it was possible to do a DELETE statement to remove any records
that don`t match.
Here is my code so far
$Query="select blah its huge:-)";
$RESULT=mysql_query($Query);
$my_rows=mysql_num_rows($RESULT);
for
Here's how I would do it:
$inlist .= sprintf("\'%s\'",$Array['Email']);
Then after the loop:
$query = "DELETE FROM sometable WHERE email NOT IN (".$inlist.")";
mysql_query($query);
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 29, 2001 5:02 PM
From the returned results create a comma delimited list containing unique
identifiers of the returned results and then in your SQL statement, have
DELETE FROM ... WHERE ... NOT IN (comma delimited)
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday,
Howdy, all.
The following error came up when compiling under OS X release.
c++ -DMYSQL_SERVER
-DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\""
-DDATADIR="\"/usr/local/mysql/var\""
-DSHAREDIR="\"/usr/local/mysql/share/mysql\""
When compiling .36 under OS X release, the following error occurs:
c++ -DMYSQL_SERVER
-DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\""
-DDATADIR="\"/usr/local/mysql/var\""-DSHAREDIR="\"/usr/local/mysql/share/mysql\
""-DHAVE_CONFIG_H
Thanks so much. I fixed the problem with OPTIMIZE.
Linda
-Original Message-
From: Jeremy D . Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 1:54 PM
To: Guanglin Dong
Cc: '[EMAIL PROTECTED]'
Subject: Re: File size problem!
On Thu, Mar 29, 2001 at 01:46:28PM -0800,
What happens if i use INSERT DELAYED and the client sends a lot of
messages, much more that mysql is able to handle?
(like when you log to a sql database, and you got lots of messages)
--
Florin Andrei
-
Before posting,
reboot your pc in safe mode and install myodbc again.
Quentin Bennett wrote:
Hi,
When trying to install the latest ODBC I get
An error occurred while copying C:\WINDOWS\SYSTEM\ctl3d32.dll. Restart
Windows and try installing again.
The file mentioned exists, and is not read only.
Hmmm
Well I didn`t manage to get any of those examples to work. This is my select
statement..
"select Failed_Signups.EmailAddress.Email from Failed_Signups.EmailAddress
left join www_domain_net.Members on
Failed_Signups.EmailAddress.Email=www_domain_net.Members.EmailAddress where
What doesn't work and where is your delete statement?
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, March 30, 2001 11:35
Subject: Delete Again?
Hmmm
Well I didn`t manage to get any of those examples to work.
Hi,
No. you can't delete based on a join.
Regards
Quentin
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, 30 March 2001 3:35 p.m.
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Delete Again?
Hmmm
Well I didn`t manage to get
Hi,
Been running mysql-3.22.32 / Solaris / Sun / dual-processor:
Mysql.pm 1.2214 + DBI 1.14 + perl 5.004_04
Database with 40 tables.
Biggest table has 2,131,447 rows in it.
No problems for 6 months.
Recently ported to mysql-3.23.35 / Linux 2.2.12-20smp / dual-processor.
Mysql.pm 1.2215 + DBI
In a message dated 30/03/2001 04:42:44 GMT Daylight Time,
[EMAIL PROTECTED] writes:
What doesn't work and where is your delete statement?
This is my full code
$www_domain="select Failed_Signups.EmailAddress.Email from
Failed_Signups.EmailAddress left join www_domain_net.Members on
I know this question is not related here, but while on the Oracle
Question, could someone tell me how to install Oracle for Linux of the
list :)
Adrian
On Thu, 29 Mar 2001, Freaked Personality wrote:
Yea oracle has been ported for a while already, been running it for like 6
months on SuSE
Hi everybody, I have run a few test for innobase tables on linux and BSD
1. It seems that 'innobase' table was slower than 'bdb' table for 'insert' command,
which is surprising(or not? o_O)
2. It may be due to that fact that I dont' know much about optimazing the 'innobase'
table.
Hallo all,
A table containing some text needs to have some of the letters changed (eg.
letter to be replaced with "auml;" ).
Is there a way to use a replace function to search for such chararcters in a
text and then replace it with the html tag?
Thanks very much
Roland
Yep, what do you need ?
Sven Huster wrote:
Hi there,
i anybody out there running mysql on a netapp filer as data storage?
regards
Sven Huster
Senior Unix System Administrator
*BSD, Linux, Solaris
-
Before
Why don't use FULLTEXT index ? This select doesn't use normal index so
you have a sort of linear search
Chai-Hup Chen wrote:
Hi,
I find in our database, select "% string %" is very slow (1
minute). The database size have only 2M rows, any idea how could I get
faster response? Thanks a
Hi,
my problem is that now the second time the performance of my f740
goes down every day.
i solved the prob with increasing maxfiles (no to the max for the
volume).
after that the cpu of the filer, which went up from
25% peak to 90% peak in 5 days, goes down again.
any ideas why
Try printing out $inlist and see if this is correct. Each item must be
separated by commas and it looks like your code may not be doing that.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, March 30, 2001 11:58
I have a query I'm sending to the DB...however, instead of having the server
send me the data back, I want to put it into a CSV file for use in an Excel
Spreadsheet. This means either tab-delimited, or separated by commas. Can
someone help?
Thanks,
Is there any support for stored procedures in MySQL ? If so, what version of MySQL ?
I'm interested in stored procedure as well.
I only know that SP are available in the INNOBASE engine, but I'm
looking for access SP from mysql SQL interface.
ciao - Paolo
-Original Message-
From: Razvan Veina [mailto:[EMAIL PROTECTED]]
Sent: venerd 30 marzo 2001 8.39
To: [EMAIL
Sir,
created the following tables as primary and secondary
primary : partycode(primary key),partyname
secondary : partycode(references to primary),companyname
select partycode,companyname from secondary where partycode=(select
partycode from primary where partyname="");
as per mysql -
I am now using msql and wants to change to mysql. Is there any problem
in install both in the same server?
Regards,
Alan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
mysql doesn't support subselects.
Jeff Levy
Software Design
Meta-Craft Creations
On Fri, 30 Mar 2001, Ramasamy Palaniappan wrote:
Sir,
created the following tables as primary and secondary
primary : partycode(primary key),partyname
secondary : partycode(references to
70 matches
Mail list logo