Am Mittwoch, 3. Juli 2002 20:43 schrieb central:
> >More specific: Can I efficiently read the bytes x to y from
> > any BLOB stored in a MySQL database?
>
> Why not just add another column, Char(3), that contains the
> file extension?
That would fix this particular case, but my thought were more
Hi,
Hi,
It depends also of how many threads are running at the same time + sort
buffer / record buffer values.
The memory consumption can be roughly calculated as key buffer + (sort
buffer + record buffer) * number of thread.
As you can see, only the key buffer is shared between all the threads.
Thanks for the confirmation Dan,
I will look a little closer but I could have sworn when I shutdown MySQL
about 300MB of memory got freed.
I had a suspicion the case was one process and ps/top could not
distinguish...I just needed to hear confirmation of it I guess.
-Dave
> In the last episo
In the last episode (Jul 03), Dave said:
> Hello all,
>
> I have mysql running on a 2.4.18 kernel:
>
> /usr/libexec/mysqld Ver 3.23.49 for redhat-linux-gnu on i386
>
> and note that one started about 4 processes (threads?) began to
> handle the various signal/table tasks and such. After severa
Hello all,
I have mysql running on a 2.4.18 kernel:
/usr/libexec/mysqld Ver 3.23.49 for redhat-linux-gnu on i386
and note that one started about 4 processes (threads?) began to handle the
various signal/table tasks and such. After several random queries the
process list grows accordingly.
Aft
I can't login using root to mysql server from my pc-client...
I have tried to use this command but still have a problem...
> mysql -u root -p -h 192.168.x.xxx
i already created one user which have all privileges
so, if i check into mysql database and user tables, i found two user, root
and use
Hie there,
I'm having a potential problem with Load Data Infile function
where i'm unable to get the right no. of records to appear in the table. I
have a table created in MySQL with 2 fields region (char 1)-pkey and
regionname (char 30). The table name is called region. I've also create
Pada Wed, 3 Jul 2002 12:56:30 -0700
"Jeff Kilbride" <[EMAIL PROTECTED]> menulis :
>
> Is this just a normal timeout error, because there's currently very little
> activity on these machines? Or is there some other problem? The
> slave_net_timeout value is at it's default of 3600, so I would expe
> Hello,
>
> I have a bunch of text with Japanese in it that uses shift_jis encoding.
> My initial tests show that this encoding has the same problems in MySQL
> as it does in Perl: it gives false matches.
>
> I have to convert the data to the EUC enconding (I think I've seen it
> called ejis i
Pada Wed, 3 Jul 2002 16:39:03 -0700
"Eric Mayers" <[EMAIL PROTECTED]> menulis :
> Hello All,
>
> I'm using mysql version 3.23.47 as a database in an embedded device. In
> the startup scripts for the database I have it run :
>
> myisamchk -o -s /usr/local/var/data/*/*.MYI
> (to fix any possible
You can use the InnoDB table type which supports foreign keys.
http://www.mysql.com/doc/S/E/SEC446.html
If you want to use MyIsam table types, the only solution is to send a
specific request to delete records in both the tables.
Regards,
Bhavin.
- Original Message -
From: "multivac" <[EMA
If 'text' is stored in the HTML format in the db, the only solution I can
think of is writing a perl/shell script to parse out the and recreate
the files without it, that ways, the data in the DB is not disturbed and
Excel should be able to read it to (unless someone knows of a setting in
Excel w
I'm working on a search interface in MySQL for a series of items that
have titles and descriptions. I'd like to weight the results so that
matches in the title count for more than matches in the description.
Is there a recommended way of doing this?
So far, I've come up with three ways, two of w
Hello All,
I'm using mysql version 3.23.47 as a database in an embedded device. In
the startup scripts for the database I have it run :
myisamchk -o -s /usr/local/var/data/*/*.MYI
(to fix any possible problems)
with safe_mysqld --datadir=/usr/local/var/data &
(to start the database)
On one oc
Hi mysql wizards,
I've a problem with mysqlhotcopy, i.e. the 'copy step' fails. I've no
idea why (for I don't understand perl), could anyone help?
Here is how mysqlhotcopy is invoked (intentionaly using option
'-n' here):
mysqlhotcopy webimages /swpr_ss02-2/frisbee/dbbackups --allowold
--keep
On Wed, Jul 03, 2002 at 02:37:16PM -0700, Michael Ivanyo wrote:
> Hello,
>
> My perception of the InnoDB vs BDB question is that although the BDB
> is very impressive and long standing, it does not get the same level
> of attention that InnoDB seems to get from the good folks at MySQL
> AB. If I
Hello,
My perception of the InnoDB vs BDB question is that
although the BDB is very impressive and long standing,
it does not get the same level of attention that
InnoDB seems to get from the good folks at MySQL AB.
If I am not mistaken, BDB does not yet offer foreign
key support.
I have chosen
Hi,
I'm making a CSV from a Mysql table, in which text is stored as is, with all
to keep format etc (I need to keep line breaks because the same text
has to be printed out in a page taking care of the original fomatting);
The problem comes actually when Excell tries to read the CSV (; separates
Well. Good to know. So I guess the only alternative would be to generate
keys by date/time?
I was hoping to avoid that. I am still worried about the timestamp type not
having good enough resolution. Seconds are pretty broad.
Thanks,
Eric
>You're asking for trouble. :-)
>
>AUTO_INCREMENTS a
if you set it up so that the slaves occasionally update the master, you can
get around the
problem as follows.
For the *primary* table(s), when you update the master, get the data for 1
row to update from the
slave.
When you insert this row into the master, remove the auto_increment field
from th
On ons, jul 03, 2002 at 11:00:19 +0200, Anders Gustafsson wrote:
> On Wed, Jul 03, 2002 at 08:06:52PM +0200, Tobias Bengtsson wrote:
>
> > I want to do transparent encryption. Like being able to choose an encryption
> > scheme of a table or database when created so that the data on disk is
> > al
In the last episode (Jul 03), Mike Hall said:
> FreeBSD 4.5-STABLE with LinuxThreads 2.2.3. and MySQL 3.23.51. Duel
> PIII 1Ghz with 1G of RAM. All from source.
>
> Compiled okay and came through super-smack and crash-me tests okay.
> But a few hours later, for no reason, MySQL decided to look at
On Wed, Jul 03, 2002 at 08:06:52PM +0200, Tobias Bengtsson wrote:
> I want to do transparent encryption. Like being able to choose an encryption
> scheme of a table or database when created so that the data on disk is
> always encrypted.
Why don't you just put the tables on an encrypted filesyst
Hello,
I'm quite new in MySQL and PHP, so I guess my question is stupide. Sorry
for that but I really need the solution...
I have 2 tables
table Client :
---
|ClientID | ClientName|
---
|1| Eric |
|2| Mark |
|3| Simon
On Wed, Jul 03, 2002 at 10:54:23AM -0700, Eric Frazier wrote:
> From the manual 4.10.4
> "Replication will be done correctly with AUTO_INCREMENT, LAST_INSERT_ID(),
> and TIMESTAMP values."
>
> I am somewhat fearful and curious about how this works. Say we have
> a master web database that gets
at last,
i got an error 5 'Access Denied', then after some blah,blah, etc, etc,
it got started with InnoDB.
not InnoDB is yes.
now i can write a good SQL QUERY ;)
special thanks to Heikki and Bert
--
Hytham Shehab
From: Harald Kleiner <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: unexpected results using LEFT JOIN with more than one join_condition
>Description:
I use LEFT JOIN to join together two tables. And (for some 'complex'
reason) I want to add additional conditions into the join_condition-pa
I have replication running successfully between two Linux boxes running
3.23.51. However, I'm getting the following error very frequently (every
30 - 60 seconds) in my slave error log:
-
020703 15:41:09 Error reading packet from server: (server_errno=1159)
020703 15:42:0
looks like mysql is not running.
type ps ax
and see if you see any mysqld lines.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Rahadul Kabir [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 2:24 PM
To: MySql Mailing List
Subject: my
start the server before connecting to it.
*** REPLY SEPARATOR ***
On 7/3/2002 at 3:24 PM Rahadul Kabir wrote:
>[root /root]# mysqladmin -u root password '30waverly'
>mysqladmin: connect to server at 'localhost' failed
>error: 'Can't connect to local MySQL server through socket
Salutations.
1:
I personally use InnoDB. I think Bdb tables were the first with
transactions but I don't see a lot of people talking about using them these
days. Also, InnoDB is being activly developed and between sleeping, eating
and coding, Heikki answers questions here! :)
2:
Signed integ
depending on your distro. You should have a dir named /etc/rc.d/init.d or
/etc/init.d in it should be a script named mysql for starting and stopping
mysql. Use it (as root) to start mysql.
/etc/init.d/mysql start
or
/etc/rc.d/init.d/mysql start
HTH,
=C=
*
* Cal Evans
* The Virtual CIO
* http:
This are the few variables for mysql. Does anyone know how can I set the
"current value" to some other value. because whats happing now is when I
try to startup mysql, it starts and right after a second it ends. and I
think Its because of this "current value: 0". can someone please tel me
in which
[root /root]# mysqladmin -u root password '30waverly'
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql
.sock' (111)'
Check that mysqld is running and that the socket:
'/var/lib/mysql/mysql.sock' ex
ists!
[root /roo
> Hi,
> What is written in err.log ("/var/lib/mysql") ?
nothing :(
something like
mysql started and ready for connection
> I think you have some problems with network (switch or hub).
Euh network hardware i don't think, perhaps a problem with software but may
be strange 'cause ifconfig says that
Hi mysql wizards,
I've a problem with mysqlhotcopy, i.e. the 'copy step' fails. I've no
idea why (for I don't understand perl), could anyone help?
Here is how mysqlhotcopy is invoked (intentionaly using option
'-n' here):
mysqlhotcopy webimages /swpr_ss02-2/frisbee/dbbackups --allowold
--keep
How did you install MySQL? Package, source, binary?
*** REPLY SEPARATOR ***
On 7/3/2002 at 3:06 PM Rahadul Kabir wrote:
>hi
> im getting the message :
>Can't connect to local MySQL server through socket
>'/var/lib/mysql/mysql.sock' (111)
> when i try to connect to mysql
>
>Th
hi
im getting the message :
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111) when i try to connect to mysql
Then I tried to run daemon
[root /root]# /usr/sbin/mysqld
Fatal error: Please read "Security" section of the manual to find out
how to run
mysqld as
Heey There Folks,
Well, I hope that this message gets through finallly. First I got it back
from the deamon because I had send it in html format, then because of I was
suspected from spamming this list. Only for not having used the words query
or sql once ... well, I have now so it should come th
hi
im getting the message :
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
when i try to connect to mysql
Then I tried to run daemon
[root /root]# /usr/sbin/mysqld
Fatal error: Please read "Security" section of the manual to find out
how to run
mysqld as
[admin admin]$ mysql mysql
or once you have the mysql prompt type: use mysql
then issue the command
Curtis
Page Works Web Solutions said:
> Hi,
>
> any ideas on this one
>
> [admin admin]$ mysql
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 7 to ser
Kristian,
>Question: Can the MySQL BLOB API access and transfer partial
>blobs. That is, if you want to do the equivalent of a "file *"
>to a BLOB table, the first 10 bytes or so of each BLOB must be
>read in order to guess the type of the BLOB. Is it possible to
>implement this efficiently using
Hi users and developers!
I deleted the in-reply-to header as everybody misunderstood my first mail.
Please give this a thought folks, especially developers, I can help developing
it if nessecary.
I want to do transparent encryption. Like being able to choose an encryption
scheme of a table or
From the manual 4.10.4
"Replication will be done correctly with AUTO_INCREMENT, LAST_INSERT_ID(),
and TIMESTAMP values."
I am somewhat fearful and curious about how this works. Say we have a
master web database that gets replicated back to the office slave over the
Internet. A person on the w
Hi .
One table with three filed full-text indexed :
titlu,continut,descriere
qry :
SELECT autori.nume as autor,
ref_data.id as id_ref,
ref_data.marime as marime,
ref_data.clasa as clasa_ref,
ref_data.titlu,
ref_data.nota as nota
,materii.*,MATCH (titlu,continut,descriere) AGAINST ('conceptia') as
Hi,
Newbie here...please be kind!
Sometimes when I try to execute some SQL statment MySQL throws an Error
7...(see below)
For example:
ALTER TABLE `categorias` RENAME `catAnimais`;
And here's the error
Error: 7 - Error on rename of '.\orniex\categorias.MYI' to
'.\orniex\#sql2-ffc-4.MYI' (Errcod
Hi,
What is written in err.log ("/var/lib/mysql") ?
I think you have some problems with network (switch or hub).
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMA
>Description:
when running a "insert data infile" command on a 500MB text file, I
get the error "ERROR 1030: Got error 22 from table handler" from
mysql. I did a listing of the database files and it looks like this:
-rw-rw 1 root root 2147397632 Jul 3 09:4
This is not specific to MySQL (probably) but I thought this wizened
community might have a definitive answer.
Take this simple grouped select:
SELECT Value1,Value2 FROM Table1 GROUP BY Value1,Value2
Value1 Value2
---
Joe Red
Joe Blue
Joe Green
Jim Red
Jim
What happens if you put third TIMESTAMP column.?. Will that be
updated?. Just curios.
Nilesh
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 12:42 PM
To: Paul Tomsic; [EMAIL PROTECTED]
Subject: Re: verification upon update, help, please
A
Hi,
I have installed mySql 3.23 max for NT and i'm getting the following error,
but I am not sure if it is ADO or MySQL at fault !
I need to list the tables,columns and indices of the DB and the last index
access statement is failing. I'm accessing MySql via a DSN connection from
within VB6.
At 12:07 -0400 7/3/02, Paul Tomsic wrote:
>Does MySQL prevent updates from occurring when the values involved
>are the same as the database's current state.
I don't know if "prevent" is the word exactly. It doesn't bother to update
the row unless you actually change a value. The phenonenon you
Does MySQL prevent updates from occurring when the values involved are the
same as the database's current state.
For instance, if I've got a table
create table updater(
id int not null primary key auto_increment,
is_active int not null default 1
};
insert into updater(is_active) values (1);
in
Christopher,
Wednesday, July 03, 2002, 5:15:44 PM, you wrote:
CAL> Is there a command like perror for the Windows version of MySQL? I can't
CAL> seem to find anything to list error code descriptions in either MySQL 3 or
CAL> 4.
Take a look at perror.exe program in /bin directory.
--
For
Ralf,
Wednesday, July 03, 2002, 4:48:11 PM, you wrote:
RN> The subject says it all: What rights does a user need to have (minimal
RN> rights of course) to be able to execute PURGE MASTER LOGS command?
Since version 4.0.2 user must have SUPER privilege.
before 4.0.2 you must have PROCESS privile
Diana,
Wednesday, July 03, 2002, 2:24:51 PM, you wrote:
DS> I have 2 machine dual-processor Pentium III, with 1G of memory.
DS> They have the same software, same architecture, with one-way replication
DS> beetween. Versions:
DS> [root@localhost tmp]# mysql -V
DS> mysql Ver 11.18 Distrib 3.23.51
Hi list,
I've got lots of troubles with one of my mysql dedicated server.
The problem occurs time to time ( during peac or idle time ).
In fact mysql seem not to answer all connections.
Netstat show several connections "TIME_WAIT" and show process_list only show
1 ou 2 queries running ...
But on
I'm trying to import a 1 GB mysql database into oracle using a perl/dbd
interface written by a 3rd party software company. This is over a network,
but I've pinpointed my bottleneck as being the disks attached to the
target oracle db server. This process dies with a timeout on the mysql
server whil
Okay:
FreeBSD 4.5-STABLE with LinuxThreads 2.2.3. and MySQL 3.23.51. Duel PIII
1Ghz with 1G of RAM. All from source.
Compiled okay and came through super-smack and crash-me tests okay. But a
few hours later, for no reason, MySQL decided to look at /var/tmp instead of
/usr/local/mysql/var for the
Well maybe I sould map this out more clearly...
members
+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-++
| rowid | int(11)
* Christopher A. Libby
> Is there a command like perror for the Windows version of MySQL? I can't
> seem to find anything to list error code descriptions in either MySQL 3 or
> 4.
It should be in the bin diretory:
C:\>dir \mysql\bin\perror*
Volume in drive C has no label.
Volume Serial Number
Yes there is:
perror.exe located in c:\yourmysqldir\bin\
:)
-Original Message-
From: Christopher A. Libby [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 15:16
To: [EMAIL PROTECTED]
Subject: PERROR on Windows
Is there a command like perror for the Windows version of MySQL?
You can use the winmysqladmin tool located in the bin directory to install
it as a service.
(I'm not sure wether this also works on a '98SE machine)
CB
-Original Message-
From: Gerhard H. W. May [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 15:00
To: [EMAIL PROTECTED]
Subject
Is there a command like perror for the Windows version of MySQL? I can't
seem to find anything to list error code descriptions in either MySQL 3 or
4.
TIA - Chris
-
Before posting, please check:
http://www.mysql.com/manua
Hello!
The subject says it all: What rights does a user need to have (minimal
rights of course) to be able to execute PURGE MASTER LOGS command?
Thanks in advance
Ralf
For the poor little filter: sql query
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germ
Hello,
I have a bunch of text with Japanese in it that uses shift_jis encoding.
My initial tests show that this encoding has the same problems in MySQL
as it does in Perl: it gives false matches.
I have to convert the data to the EUC enconding (I think I've seen it
called ejis in a MySQL contex
On Tue, Jul 02, 2002 at 10:55:25PM -0500, Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 21:41 -0400 7/2/02, Bob Bell wrote:
> >Pardon my posting as soon as I subscribed to this list, but I have
> >a problem that's really annoying me. I just installed MySQL on
> >a virtual server account that I have
Any clues? Anyone? I'm stumped here guys.
On 2 Jul 2002 at 18:00, [EMAIL PROTECTED] wrote:
> Hi.
>
> I am trying to install MySQL on BSDI BSD/OS 4.0.1 Kernel #3.
>
> Processor: Cpu-1 = Pentium III (448 MHz) GenuineIntel mdl 7 step 2 type 0, feat
> 387fbff
>
> Ram: 128M
>
> I configured usin
I was wondering if anyone knows of a way to make a mysql server running
on red hat linux authenticate using nt pass through (something like
samba does it) or possibly ldap. I am new to mysql so this may be very
easy to do I just don't know how. It also might be impossible. Just
wondering if any
Hi all,
I have a problem whith a very simple query.
My problem is: it doesn't use indexes. It does full table scans instead.
The only way I found to make it fast was using UNION.
Can somebody please tell me,
how I can make it fast (using indexes) without using UNION?
My query:
SELECT * FROM
Hi,
I am using the component zeos, but I need to connect
to oracle version 7.3.4.
He gives me a error "ORA-03115 unsupported network
datatype or representation"
Anybody know if Do I get to connect Oracle 7.3.4??
Regards
sql, query
__
When I issue the following query from phpMyAdmin,
SELECT b.* FROM newblocks b LEFT JOIN groups_blocks_link l ON
l.block_id=b.bid WHERE (l.groupid=3) AND b.isactive=1 AND b.side=0 AND
b.visible=1 ORDER BY b.weight,b.bid
I get the following error
Can't create/write to file '/var/tmp/#sql3f2_194_0.
Hello and good morning all! I'm running into a problem when trying to test
mysql on Red Hat Linux. I have the server up and running just fine with no
problems, but when I go to run ./mysql-test-run it spits back the
following.
TEST USER SYSTEM ELAPSEDRESULT
--
Mark Colvin wrote:
> I have a php script that executes a query and depending on the results
> builds a section of a table for each record returned in the query. Each
> section has some fields and three buttons. My problem is this. When I want
> to change the data in one particular section, how can
>Description:
Single quotes (') in comments may cause syntax errors.
>How-To-Repeat:
Run this MySQL code from a file, including the comment
(running from the MySQL shell will also expose the bug,
but you will not be able to complete the command without
Hi,
I have 2 machine dual-processor Pentium III, with 1G of memory.
They have the same software, same architecture, with one-way replication
beetween. Versions:
[root@localhost tmp]# mysql -V
mysql Ver 11.18 Distrib 3.23.51, for pc-linux-gnu (i686)
[root@localhost tmp]# cat /etc/redhat-release
Am Mittwoch, 3. Juli 2002 10:58 schrieb Elizabeth Mattijsen:
> Not meaning to put down MySQL, but have you tried this also
> with a ReiserFS filesystem? I had a similar number of files,
> about 70 GByte worth on an ext2 filesystem. Moved them to a
> ReiserFS filesystem and found I only needed 51
I have a php script that executes a query and depending on the results
builds a section of a table for each record returned in the query. Each
section has some fields and three buttons. My problem is this. When I want
to change the data in one particular section, how can I submit the form
passing
Hi.
I recently update my servers from 3.23.29 to 3.23.51 version.
Replication alwais works fine.
Now, when I send show processlist command to slave, this is the response:
+--+-+---+--+-+--+---+--+
| Id | User
Hello.
On Wed 2002-07-03 at 09:42:52 +0100, [EMAIL PROTECTED] wrote:
[...]
> I was thinking more of an application like an access control system, where
> there might be tens of thousands of photographs of people, each a jpeg of a
> small number of K, or a catalogue, again with thousands of tiny p
Are you sure that you are starting mysqld-max-nt.exe for the server ?
If so, try mysqld-max-nt --print-defaults to see what parameters are set,
maybe that will give you a clue ...
CB.
-Original Message-
From: Hytham Shehab [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 00:19
>From the manual :
Note that the statistics SHOW gives about InnoDB tables are only
approximate: they are used in SQL optimization. Table and index reserved
sizes in bytes are accurate, though.
CB.
-Original Message-
From: Crercio O. Silva [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, Ju
Petre,
- Original Message -
From: "Petre Agenbag" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, July 03, 2002 9:01 AM
Subject: Re: MAX vs plain vanilla mysql
> Thanks,
>
> So, just to be 100% sure, the BEST to do is to install max, as I can't
> see any reason w
At 09:42 AM 7/3/02 +0100, Tim Ward wrote:
>I was thinking more of an application like an access control system, where
>there might be tens of thousands of photographs of people, each a jpeg of a
>small number of K, or a catalogue, again with thousands of tiny photos.
>
>The experiment I did with 5
Hytham,
- Original Message -
From: ""Hytham Shehab"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, July 03, 2002 6:21 AM
Subject: Re: innodb is disabled, how can i make it yes?
> hi Heikki,
> i do what u said:
> > yourpathtomysqlbindir> mysqld-max-nt --consol
> Grabbing a half-gig video segment out of any
> database
I'm sure you're absolutely right about not putting half gig videos in a
database!
I was thinking more of an application like an access control system, where
there might be tens of thousands of photographs of people, each a jpeg of a
small
86 matches
Mail list logo