[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 lo
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 cr
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
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 "UN
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
"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 proble
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
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:
M
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 w
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 inefficientl
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
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
que
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
ins
[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
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>
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 t
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?
>
> Fo
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,
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 /
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 a
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
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 time
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 b
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
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 wit
"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.
> > > wh
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
> > erro
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 f
"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.
>
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 or
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 w
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
> 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:
http
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 m
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]
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 r
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 o(
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:
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
FROM_UNIXTIME(
> 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 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
Benchmark/t
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:
li
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]
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 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. A
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
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 -u
> Hi
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
On Friday 07 April 2006 10:30, Mark Sargent wrote:
> alexj wrote:
> > try mysqldump --no-data -u
>
> 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
mysql
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
d
alexj wrote:
try mysqldump --no-data -u
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 List
For list archive
try mysqldump --no-data -u
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 couldn't find anythi
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 Mail
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 a
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), i
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]
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,
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,
http://dev.mysql.com/doc/refman/5.1/en/show-open-table
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:
http://dev.mysql.com/tech-resources/articles
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
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 any
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
62 matches
Mail list logo