2006/4/7, Charles Q. Shen [EMAIL PROTECTED]:
Hi all,
I am running MySQL 4.1.11 with an innoDB table holding about 17GB of
records. I took a few hundreds of randomly selected records from the table
and measured the average access time:
1st test: average access time is 600ms
2nd test:
Hi,
Sorry if I wasn't very clear with my question. I was hoping to obtain
the functionality such that I could do something similar to:
CREATE TRIGGER IF NOT EXISTS
Because I usually get a trigger already exists in my script. I might be
missing something.
The script basically does the
Ian Collins wrote:
Hi,
I have a customer who wants to be able to replicate their live MySQL
database to a second server, but not to have any data deleted.
So there is data on the second server?
i.e., they want to accumulate the data.
I don't believe you can do this with replication. Does
The OS used are Mandriva and Fedora.
Can you explain more?
Thanks.
Charles
-Original Message-
From: Philippe Poelvoorde [mailto:[EMAIL PROTECTED]
Sent: Friday, April 07, 2006 2:43 AM
To: MySQL General
Subject: Re: MySQL 4.1.11 innodb cache can't be flushed after
restart ?
No, replication is not designed for this task.
It sounds like the Archive Storage Engine could be a good solution for you:
http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html
Robin Schumacher has written a nice introductory article:
Hi All,
am trying to get up to speed on cli syntax again,
mysql show open tables from osc
-
what is wrong with the command above and the one below,
mysql show tables from osc
-
Why do I not get any output? I was following here,
Hi Comunity,
I am getting problem while i am upgrading to MySql ver 4 to MySql ver 5. I
planned first to install MySQL-shared-compat-5.0.19-0.rhel4.i386.rpm, but
i am getting following error.
Preparing...###
[100%]
1:MySQL-shared-compat
Hi All,
Ah, sorry, a semicolon makes it a whole new world, eh.
Cheers.
Mark Sargent.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
2006/4/7, Charles Q. Shen [EMAIL PROTECTED]:
The OS used are Mandriva and Fedora.
Can you explain more?
I'll make it quick, there is plenty of doc on a web that will explain
this better than I can.
Once you read few things from your hard drive (let's say the index
file for your table), it's
Hi Mark.
On Fri, 7 Apr 2006, Mark Sargent wrote:
To: mysql@lists.mysql.com
From: Mark Sargent [EMAIL PROTECTED]
Subject: Syntax Error
Hi All,
am trying to get up to speed on cli syntax again,
mysql show open tables from osc
-
what is wrong with the command above and the one
Hi All,
we have cli access to our MySQL database via ssh in the Admin GUI and
were wondering how to print the complete structure of a DB. I searched
the documents on MySQL homepage but couldn't find anything specific.
Anyone know how to do this? Cheers.
Mark Sargent.
--
MySQL General
try mysqldump --no-data database-name -u user-name
Thanx
Alex
On Fri, 7 Apr 2006, Mark Sargent wrote:
Hi All,
we have cli access to our MySQL database via ssh in the Admin GUI
and were wondering how to print the complete structure of a DB. I
searched the documents on MySQL homepage but
alexj wrote:
try mysqldump --no-data database-name -u user-name
Hi All,
thanx, but get the following,
mysql mysqldump --no-data osc -u admin;
ERROR 1064: You have an error in your SQL syntax near 'mysqldump
--no-data osc -u admin' at line 1
Cheers.
Mark Sargent
--
MySQL General Mailing
Hi All,
I have a problem with my multi master replication plan.
I have set my server (linux) to run 4 instance of mysqld, each with a
different port, socket, tmpdir, log file, relay log file, master info
and relay info.
the illustration as follow :
Server 1 (non slave)
db1
db2
db3
On Friday 07 April 2006 10:30, Mark Sargent wrote:
alexj wrote:
try mysqldump --no-data database-name -u user-name
Hi All,
thanx, but get the following,
mysql mysqldump --no-data osc -u admin;
ERROR 1064: You have an error in your SQL syntax near 'mysqldump
--no-data osc -u admin' at
mysql mysqldump --no-data osc -u admin;
ERROR 1064: You have an error in your SQL syntax near 'mysqldump
--no-data osc -u admin' at line 1
You are supposed to execute that from a shell, not from within mysql Client.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
hey,
run mysqldump from your command prompt and not you mysql prompt.
[EMAIL PROTECTED]:~ mysqldump --no-data osc -u admin
-- MySQL dump 10.9
--
-- Host: localhostDatabase: osc
Thanx
Alex
On Fri, 7 Apr 2006, Mark Sargent wrote:
alexj wrote:
try mysqldump --no-data database-name
Hi,
is there a possibility to configure a MySQL database in such a way that I
can store the database on a read-only medium (say a CD), but still be able
to write to the database (without having to copy the datafiles to disk or
memory first)?
What I have in mind is something like telling MySQL to
Hi All,
I forgot to mention, although a general range exists for say, Jeans,
36-44 for existence, there are variations for different areas for
different labels. Example, a 34 for Jean A is say 42 in the waist, but
Jean B is 44, within the same maker. I find that as making it more
complexed.
Duncan Hill wrote:
mysqldump is a shell command, not a mysql command.
Hi All,
oops, what a blunder. lol. Cheers.
Mark Sargent.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi!
Can I return a record set from a stored procedure/function in mysql?
Kind regards
Prueba el Nuevo Correo Terra; Seguro, Rápido, Fiable.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am planning to upgrade mysql ver 4 to mysql ver 5 but i am getting this
errors
[EMAIL PROTECTED] trinity]$rpm -Uvh
MySQL-server-standard-5.0.19-0.rhel4.i386.rpm
warning: MySQL-server-standard-5.0.19-0.rhel4.i386.rpm: V3 DSA signature:
NOKEY, key ID 5072e1f5
error: Failed dependencies:
Hi balaraju.
You could try:
Linux x86 generic RPM (statically linked against glibc
2.2.5) downloads
Server 5.0.19-013.5M Pick a mirror
MD5: 118abbb9c8ee5ff212fd2797fcde35e8
Max 5.0.19-02.8MPick a mirror
MD5: a49c484f561753678319678c1cfcc6c3
Hi!
Can I return a record set from a stored procedure/function in mysql?
Kind regards
yes - stored procedures
no - stored function
Michael Louie Loria
LoRz Technology Solutions
http://www.lorztech.com
signature.asc
Description: OpenPGP digital signature
Hi Ravi, all!
Ravi Malghan wrote:
Ok. I found something. But wondering if this is most
efficient
Events for yesterday:
select count(*) from EVENT_DATA where
FROM_UNIXTIME(utime,'%Y-%m-%d') = (CURDATE() -
INTERVAL 1 DAY);
Events for last week
select count(*) from EVENT_DATA where
hello all,
In which order the datas are displayed, when the SELECT quey is used ?
Is it random or the order in which the datas are inserted?
-- r.subramani
My log file: http://subramanitce.blogspot.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
subramani wrote:
hello all,
In which order the datas are displayed, when the SELECT quey is used ?
Is it random or the order in which the datas are inserted?
-- r.subramani
My log file: http://subramanitce.blogspot.com
Random
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o
Leonardus Setiabudi [EMAIL PROTECTED] wrote on 04/07/2006 05:33:50
AM:
Hi All,
I have a problem with my multi master replication plan.
I have set my server (linux) to run 4 instance of mysqld, each with a
different port, socket, tmpdir, log file, relay log file, master info
and relay
In case anyone is interested in where MySQL is going with transactions
http://www.computerworld.com.au/index.php/id;1262876365;relcomp;1
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
If the sequence in which the result set is displayed is important to you,
you will need to use SQL clauses to force the sequence you want. ORDER BY is
the main way of accomplishing this although other clauses, like GROUP BY and
DISTINCT, can also affect the sequence. But ORDER BY is the normal
In case anyone is interested in where MySQL is going with transactions
http://www.computerworld.com.au/index.php/id;1262876365;relcomp;1
As expected :-)
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
I'm using the MySQL 5.0.15 client to a 5.0 server all 32-bit windows.
It appears that the UNSIGNED_FLAG is being returned for column types of
timestamp.
Checking the flags variable of the MYSQL_FIELD structure indicates that the
following flags are returned:
Field-flags = 1249
NOT_NULL_FLAG
Do you have control over your DELETE queries? If so, 'SET SQL_LOG_BIN=0'
would be an easy implementation.
A common approach in my experience is to have a script query the master
and archive data to a second database before any deletes are done.
If you have no control over the DELETE queries and
Dear Friends,
I have linked tables from MySQL through ODBC DSN in Access 2003.
when I go for updating any record in any linked table then it gives me
error as follows:
Reserved Error (-7776); there is no message for this error.
What will be the problem? Please help.
Is this error from MS ACCESS
C K [EMAIL PROTECTED] wrote on 04/07/2006 01:35:22 PM:
Dear Friends,
I have linked tables from MySQL through ODBC DSN in Access 2003.
when I go for updating any record in any linked table then it gives me
error as follows:
Reserved Error (-7776); there is no message for this error.
What
You need root privileges.
Login as root or use sudo. E.g.
sudo rpm -Uvh MySQL-shared-compat-5.0.19-0.rhel4.i386.rpm
If you don't have root or sudo access, you can't perform this upgrade.
You could possibly use the --prefix and --relocate rpm install options
to install mysql into a directory
On 4/7/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
C K [EMAIL PROTECTED] wrote on 04/07/2006 01:35:22 PM:
Dear Friends,
I have linked tables from MySQL through ODBC DSN in Access 2003.
when I go for updating any record in any linked table then it gives me
error as follows:
C K [EMAIL PROTECTED] wrote on 04/07/2006 01:59:39 PM:
On 4/7/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
C K [EMAIL PROTECTED] wrote on 04/07/2006 01:35:22 PM:
Dear Friends,
I have linked tables from MySQL through ODBC DSN in Access 2003.
when I go for updating any
I also tried folloing and got results as below:
1) I updated the default for timestamp filed as CURRENT TIMESTAMP as
mentioned in MySQL 5.1 manual.
But this not worked.
2) I dropped timestamp fiield from that table and refreshed link, then
I can ork properly. Now I can insert and update reocrds
Mark Sargent [EMAIL PROTECTED] wrote on 04/06/2006 10:45:43 PM:
[EMAIL PROTECTED] wrote:
I agree with the basic design: one table for all of your basic objects
(shirts, pants, coats, shoes, etc), one table for all of your
attributes
(see Barry's response), a sku table equating objects
Hi all,
It's all well and good having mysql using port 3309 (or any other port for
that matter); I'm writing an application that will be used by loads of users
off the internet - so I'm expecting firewall issues.
One easy way is to have the mysql traffic flow over port 80; that works
sometimes
Anyone have any experience to share about running mysql on a linux tmpfs
(using memory)?
For us it's worked out pretty well and is normally operating lightning
fast compared to an identical SCSI based system. However, even though
there is plenty of free memory linux makes weird decisions from
Anyone have an idea on this?
Can anyone explain how I might be able to return a numbers of records based on
the sum of a quantity in a field in the same table? (After I read that it
sounds even confusing to me).
Let me explain. I have records like this,
Part#Qty
1254
No need to re-invent that wheel:
Just use port=80 in my.cnf or start with --port=80
See http://dev.mysql.com/doc/refman/5.0/en/server-options.html
Eric
--
Eric Braswell
Web Manager MySQL AB
Cupertino, USA
Jangita wrote:
Hi all,
It's all well and good having mysql using port 3309 (or
Frank,
1) Check out the FEDERATED storage engine, that might help.
2) You cannot specify a different location for a read database and a
write database.
3) Another solution is to use multiple databases -- each database is
just a directory, so you could try to symlink:
ie, if your datadir is
Try the documentation.
http://mysql.com/triggers
sends you to
http://dev.mysql.com/doc/refman/5.0/en/triggers.html
from there you can click on CREATE TRIGGER SYNTAX
to get to
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
which clearly shows that syntax is not valid.
Alternatively,
While the query is still running, type
mysql show processlist
or
mysql show full processlist
find the query(ies) with the State column having a value of Locked
-Sheeri
On 4/7/06, 古雷 [EMAIL PROTECTED] wrote:
Hello:
How could I know which transaction or thread hold the lock?
For example:
Try the sybase lists, or googling for sybase import file.
-Sheeri
On 4/6/06, Mohammed Abdul Azeem [EMAIL PROTECTED] wrote:
Hello,
I have a mysql data bcp file ( using select into outfile ) from a table
in mysql database. I have a similar table existing in a sybase database.
I need to bcp in
Here's an idea -- patience is a virtue. Some of us read the list when
we get a chance, and can't just jump on every e-mail because we
actually do work at work.
mysql create table Orders (partno int unsigned not null, quant
tinyint unsigned not null);
Query OK, 0 rows affected (0.07 sec)
mysql
[snip]
Anyone have an idea on this?
Can anyone explain how I might be able to return a numbers of records
based on the sum of a quantity in a field in the same table? (After I
read that it sounds even confusing to me).
Let me explain. I have records like this,
Part#Qty
1254
Jangita wrote:
Yes this is very true Eric, thanks.
BUT there are LOADS of firewalls that don't allow non http traffic (like
mysql) over port 80; and your method wont work if all that's
available is a
http proxy!
Ah, so you want to be able to bypass a firewall that does stateful
I have been linking MySQL tables into access for versions 3.23 thorough
5.17. The only way I have been able to deal with insert/update tables with a
timestamp field is to build a query which includes all of the fields except
the timestamp field. You can then do your insert or update against the
Hi,
Yes, the syntax is not valid. I have tried it. :-)
I was hoping for maybe a workaround to simulate the described
functionality. There might also be something wrong with the structure of
my script. Maybe I shouldn't be creating triggers there? But I was
thinking if the CREATE DATABASE and
Hi,
I'm trying to find the most efficient way of linking members to one
another in a social networking application.
Currently I link them using 2 separate fields for the members: id1, id2. So,
to find people in your network you would do:
WHERE id1=%ID OR id2=%ID
This uses indexes
How about something like this
Users table
user_id
user_name
user_password
user_whatever
and then
Relation table
rel_id
user_id
friend_id
and then selecting from relations table
On Fri, 2006-04-07 at 14:47 -0700, Martin Gallagher
That's similar to what I currently have set up.
The problem is it is a request based system.
Example table:
id1
id2
group
flag
When a person makes a request something such as the following is insert:
MYID, REQUEST_USER_ID, 'family', 0
If user REQUEST_USER_ID accepts it will be flagged as 1:
Martin Gallagher wrote:
Hi,
I'm trying to find the most efficient way of linking members to one
another in a social networking application.
Currently I link them using 2 separate fields for the members: id1, id2. So,
to find people in your network you would do:
I'm not sure exactly what it
of course you have the problem where john has Joe as a friend but Joe
doesn't have john as a friend. This seeming inconsistency, may or may not
be a problem depending on exactly what kind of a relationship you are trying
to define.
You've just hit the nail on the head! That's exactly the
probuly sounds like noobish! or silly but what i would do is have a new
table with 2 colums the first will be a login id and the second will be
a login id
and i would just do like ...
id1 id2
JohnJoe
JohnAlex
JohnFred
Joe Fred
FredAlex
would mean John as Alex, Fred
Seems like what you're looking for is a way to query your database
more efficiently/quickly, and still find all links in either
direction.
I think the use of a UNION statement should allow this. Basically
write your query twice, joining on id1 the first time and id2 the
second time, with
Hi,
In a messaging system I'm working on, I will allow user's to send the same
identical message to numerous other people. Kind of like in email you can
separate recipients with ; or use CC.
It would be nice to be able to perform a query like so:
INSERT INTO messages, social_networking (author,
I have a fairly small table WRT the data size. Its about 300M of
data. Right now it has about 6M rows.
The schema is pretty simple. It has one 64bit ID column. Basically
its for checking the existence of an object in our DB and is designed
to work very fast.
One the table was FIRST
[EMAIL PROTECTED] wrote:
Leonardus Setiabudi [EMAIL PROTECTED] wrote on 04/07/2006
05:33:50 AM:
Hi All,
I have a problem with my multi master replication plan.
I have set my server (linux) to run 4 instance of mysqld, each with a
different port, socket, tmpdir, log file, relay log
63 matches
Mail list logo
