Hello list,
What is the current replication implementation in mysql: sync or
async or both are supported? (and the respective db versions) What are the plans for
the
future? Thanks
--
Best regards,
Angel mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For
Dear lists,
Simple question for geniuses outthere:
my database has an integer field where i created with CREATE table test (first
int(10));
so when i use php to grab the "first" field and read it in $myrow["first"] , then try
to make the number increase by doing a
$increase = $myrow["first"
Hello,
can i configure mysql to send logs to host by protocol syslog instead of
mysql.log?
thaks again,
César
-Mensaje original-
De: Dan Nelson [mailto:[EMAIL PROTECTED]
Enviado el: miércoles, 22 de octubre de 2003 18:30
Para: Fernández García, Cesar
CC: [EMAIL PROTECTED]
Asunto: Re: sy
Hi!
Think about using DISTINCT and COUNT together.
I don't think it is a best coice.
But maybe I'm wrong.
Please Paul Dubois make your point.
regards
On Wed, 22 Oct 2003 13:25:20 -0400, Hector Del Curto wrote
> I have this 2 queries:
>
> SELECT COUNT(DISTINCT(LEFT(p.prod_num,5))) FROM products
It might also help to at least try to understand why you normalize. Don't
just try to follow the rules, there is some art to it as well.
My favorite book on this is "Database Design for Mere Mortals"
Thanks,
Eric
At 09:11 PM 10/22/03 -0700, olinux wrote:
>Read up on database normalization. (
Read up on database normalization. (do a search on
your favorite search engine) It will give you an
appreciation of storing related pieces of info in
different tables. Though you shouldn't need a series
of forms to access the data (most of the time) - this
has more to do with your programming logic
thanks paul...
I have downloaded the 4.0.16 and installed. And it works find now it was
4.0.15 that I installed.. the 4.0.16 just released today...
Cheers,
Clive
-Original Message-
From: Paul Darius [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 12:32 PM
To: [EMAIL PROTEC
Hi all,
I have followed the instruction from the mysql manual installing the binary
distribution. I am actually having problem starting mysqld. I have got the
following message. It started but stopped straight away.
root>bin/mysqld_safe &
[1] 30527
root>Starting mysqld daemon with databases from
I usually use ps.setBytes() and pass it a byte[] array ..
On Wed, 22 Oct 2003, Scott Purcell wrote:
> Hello,
> I have opted to insert some small jpg files into the mysql database using java.
> Code below.
>
> When I do a select from the table using the mysql> command line, it generates
> pages
Hi,
I really doubt putting PHP files (or any site files) on a RAM disk will
make any performance difference; and certainly not 30-50%. When the
files/scripts are accessed, they are cached by the OS. So, in effect,
they are automatically put in a sort of "RAM disk." The disk is
definitely NOT acces
Thank you Egor for you reply.
Cheers,
Clive
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 6:25 PM
To: [EMAIL PROTECTED]
Subject: Re: Linux (x86, libc6) Standard 4.0.15 quesiton?
"Clive Luk" <[EMAIL PROTECTED]> wrote:
>
> Just some simp
Keith C. Ivey wrote:
On 22 Oct 2003 at 17:57, Kaeru the Frog wrote:
I've just started working with MySQL. I'm using MySQL version 4.0.14
on Gentoo Linux.
I've been reading chapter 9 (http://www.mysql.com/doc/en/Charset.html)
in the documentation but it hasn't helped. The commands 'SHOW
CHARACTER
On 22 Oct 2003 at 17:57, Kaeru the Frog wrote:
> I've just started working with MySQL. I'm using MySQL version 4.0.14
> on Gentoo Linux.
>
> I've been reading chapter 9 (http://www.mysql.com/doc/en/Charset.html)
> in the documentation but it hasn't helped. The commands 'SHOW
> CHARACTER SET', 'SH
I wrote:
> Let's say I have a table with two columns, "id" which is unique and auto
> incremented, and "time" which is int(10) unsigned (unix timestamp at time
> record is added). Due to earlier problems with my insert statements, some
> records do not have a time value (NULL). I want to provide
I've just started working with MySQL. I'm using MySQL version 4.0.14 on
Gentoo Linux.
Now, how do use Unicode in a database? I will mostly be storing Japanese
and would like to store data using the ucs2 character set. I've been
reading chapter 9 (http://www.mysql.com/doc/en/Charset.html) in the
There is seemingly conflicting advice in the mysql manual in regards to log file sizes
and buffer
pool sizes for inndob
I only mention this because tweaking Innodb values and getting the best performance
with inndob
isn't easy because the mysql daemon has to be stopped, the log files deleted, ne
Hello,
i think DBDesigner 4 [ http://fabforce.net/dbdesigner4/ ] is the tool you are looking
for! :)
burci
Tuesday, October 21, 2003, 8:49:31 PM, you wrote:
JW> Looking for an open source or commercial tool to help with database
JW> visualization for a presentation we are to give. Can't seem
from one dan to another.
select man.description as man_description, cat.description as cat_description
from main_table as main, manufacturer_table as man, categories_table as cat
where main.manufacturer_id = man.manufacturer_id
and main.category_id = cat.category_id
and title_id = 3
Dan
Hi there,
Let's say I have a table with two columns, "id" which is unique and auto
incremented, and "time" which is int(10) unsigned (unix timestamp at time
record is added). Due to earlier problems with my insert statements, some
records do not have a time value (NULL). I want to provide an
how do I get the values of foreign keys, that I have used within a
database
example
Main_DB
Main_Table
PK title_id3
FK manufacturer_id 5
FK category_id 4
Manufacturer_Table
PK manufacturer_id 5
description
I have a table that contains a date of birth (date) and a age field. How can
I create an update query that would calculate the correct age (from the date
of birth) and update the age field? I tried doing it with php but ran into
problems with persons born before 1969.
thanks,
Luis R. Lebron
Sigm
Hello,
I have opted to insert some small jpg files into the mysql database using java.
Code below.
When I do a select from the table using the mysql> command line, it generates
pages of
---
At 01:49 PM 10/21/2003, Jeff Weeks wrote:
Looking for an open source or commercial tool to help with database
visualization for a presentation we are to give. Can't seem to find a
simple way to generate a nice poster of our database design.
Any suggestions?
Thanks.
Jeff,
MS also had a pretty
At 12:32 PM 10/21/2003, you wrote:
Thanks a lot guys.
Haydies:
>Just out of wondering, are you using PHP and if so do you use
mysql_pconnect
>rather then mysql_connect because that would really speed things up.
I tired pconnect before but it didn't help but using up all the available
memory.
http://www.dbmail.org/
On Wednesday 22 October 2003 10:29 am, Apollo (Carmel Entertainment) wrote:
> I was wondering if there is an opensource mail server (IMAP, not POP) that
> would keep all the messages in a MySQL database, not in a regular file?
>
> Apolinaras "Apollo" Sinkevicius
>
>
I have moved our database from Access to MySQL, but I did leave same structure.
Problem is that in our business we deal with companies that have multiple
branches so having it like we have now with sub queries and subforms that have
to look up info from 3 tables to give me one record of contact inf
I have a single table that I need to pull info from can anyone help?
Table: Product
Fields: Itm_Code, Itm_Color, Itm_Size, Itm_Price, Itm_Desc, otherjunk
Primary Key(Itm_Code,Itm_Color,Itm_Size)
I am using ColdFusion MX as my programming language, CF does not permit
queries within queries.
Sampl
Hello,
can somebody tell me what the status "Writing to net" returned by "show
processlist" exactly mean? I've tried to find it in MySQL documentation but
either it's not there or I missed it.
I am asking because this status is usually shown when my J2EE application
[using Connector/J 3.0.9] starts
I was wondering if there is an opensource mail server (IMAP, not POP) that would
keep all the messages in a MySQL database, not in a regular file?
Apolinaras "Apollo" Sinkevicius
-
Visit CARMEL MUSIC & ENTERTAINMENT website http://carmelme.com
--
You're getting a distinct on just the prod_num in the first query, but
are requesting distinct prod_num, description, line, and content in the
second one: if any of those last three columns are different between
rows, you will see ones additional to the count you get in the first
query. You ei
I have this 2 queries:
SELECT COUNT(DISTINCT(LEFT(p.prod_num,5))) FROM products p, tlines l,
prod_line pl WHERE l.Line = 'Solaris' AND l.id=pl.line_id AND pl.prod_id =
p.id_product
SELECT DISTINCT(LEFT(p.prod_num,5))as prod_num, p.description AS
description,l.Line as line,l.Content as content FRO
Would innodb tables help?
Travis
Daniel Kasak wrote:
Travis Reeder wrote:
It seems mostly to be mysql pinned, not the app. like 99% mysql until
all data is processed and keeps going up when data coming in is more
than can be processed.
What could I change in my.cnf to get better performance
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi again
After further inspection of libmysql sources the conclusion is:
- - mysql_real_escape_string() uses MYSQL->charset field from the MYSQL
struct
- - this field is initilized in mysql_real_connect()
- - so after my connection times out I should
Well, according to your message, you might want to make sure you are typing mysql and
not mysqld(which is the server daemon)
According to the docs when I go to the cmd window, I should type in mysql -username
and then get prompted for a password.
But I get this:
look at what you typed, you
>Description:
It is possible to get into a situation where foreign key constraints
on a replication slave have different labels to the same foreign key
constraint on the master. This normally causes replication to fail when
a drop of a foreign key on the master is attempted (although presumab
In the last episode (Oct 22), "Fernndez Garca, Cesar" said:
> Hello,
> can i send logs by protocol syslog to another host instead of a file?
This is the wrong mailinglist, but on most systems, yes, you can.
Instead of a filename in syslog.conf, use @hostname to forward the log
entry to "hostname"
I know I can issue "show tables" to give me a list of tables from the
current database, how can I do the same thing with temporary tables?
That is, is there a command to list the current temporary tables?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hello Heikki!!!
Multiple table spaces eh? Funky! Of course, as you've no doubt become
aware, I am one of these annoying
people that has many questions to ask the list the moment something like
this comes along! Please feel
free to ignore these questions though, as we're all hanging out for 4.1.1
Off the top of my head:)
In the my.cnf file under the [mysqld] section add the following line:
datadir= /path.to/new/datadir
Stop mysql. Move all dbs to new datadir (if your'e only using MYISAM, this
is a straight copy). Restart mysql.
HTH
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMA
http://www.mysql.com/doc/en/MyISAM_table_formats.html
"In the future you will be able to compress/decompress tables by
specifying ROW_FORMAT=compressed | default to ALTER TABLE."
Anyone know when this future is?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
We are running MySQL 3.23.47 on a AIX Risc System. It is IBM's compiled version of
MySQL, it does everything as far as installing and compiling it for us. But what we
found is that is stores the databases where it wants and would like to move them but
cant seem to figure it out. Does anybody hav
Hello,
I am new to mysql and have a couple of questions that I can't seem to get through at
this time.
I have installed the product on my win2000 box. I followed the docs for PC, and
removed the generic user in the users table.
Here is my question:
According to the docs when I go to the cmd win
Hi,
I have a redhat 9 box.I had both mysql 4.0 and 4.1 installed on it and running
separately.Today one of user of 4.1 wanted to change the max connections
allowed to the server and so she logged into the 4.1 as root and changed the
tables in mysql database.after that she shutdown the database a
"Juan M. Quiroz" <[EMAIL PROTECTED]> wrote:
> Hi,
> That's basically my question. I want to be able to run the 2 releases
> on the same OSX 10.2.8 machine.
>
> Is there a way?
Yes. Values of the --port, --socket, --pid-file must be different for each server.
Check also this section of MySQL manua
Try the following:
SELECT ip_address, url, count(distinct ip_address)
FROM tablename
GROUP BY ip_address, url
At 09:48 PM 10/21/2003, John Kelly wrote:
: > -Original Message-
: > From: John Kelly [mailto:[EMAIL PROTECTED]
: > Sent: Tuesday, October 21, 2003 3:45 PM
: > To: [EMAIL PROTECTED
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi
- From the online docs:
"The string in from is encoded to an escaped SQL string, taking into
account the current character set of the connection."
Lets say I have a connection, setup, working, then it timesout (server
side, ex. because of "wait_
I have several queries that are taking at least a full minute to process...
From a web page, user submits parameters to a perl program which performs
multiple queries, then spits the info out formatted for the web.
Does anyone have a quick & dirty method of locating a bottle neck slowing
these
Hello Steve,
Steve Vernon wrote on 22.10.2003 16:47
I suppose I could return the month as a number, and then output the text
from that, but this seems a bit tacky!
I think that's the most reliable way, imagine you move to a new server
or install your software somewhere else . . . I got
Hi!
InnoDB is a MySQL table type which provides transactions, row-level locking,
non-locking consistent SELECT (multiversioned concurrency control), foreign
key constraints, and a non-free hot backup tool for backing up InnoDB
tables.
InnoDB is included in all MySQL-4.0 and 4.1 downloads, and als
Hello,
I runned this command...
optimize table table_name
.. and got a result:
"The handler for the table doesn´t support optimize".
The table is InnoDB type. Do you know how can I run it?
Thanks in advance
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
Look in your my.ini file.
There's maybe an entry:
language=f:/mysql/share/german
Set it to your favourit language!
Bernhard
- Original Message -
From: "Steve Vernon" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROTECTED]>
Sent: Wednesday, October 22, 2003 4:47 PM
Subject: date_format
Scott,
First, you don't mention indexes, - generally you need to make sure you've
got the right indexes. Each table should have an index that contains every
field in the where clause.
Second, searching for "%x%" is always slow as this search can't use indexes
(search for "x%" can though). As it
Hello,
I have read and searched the internet, but I cannot find much on getting
mysql to return German and other languages months. Is there codes you use?
I really would prefer to use the English MySQL (if there is such a one) as I
don't know much German, and need the error messages in English!
As I understand it, anything with LIKE '%foo', i.e. with the % at the front
of the search string, has blown all indexing away. The only wan the
database can perform this is by an exhaustive search though the whole
table. If I undersyand correctly what you are doing, you probably want a
FULLTEXT in
I'm having tremendous problems with a query and I was hoping someone could point out
where (if) I'm going wrong.
Using MySQL 4.0.15 on a LINUX box.
Basically I have a database that lists a large number of web links cataloged by
subject.
The first table (records) contains all the link informat
> Is there a way to select/query the table structure and get a recordset
> with the results?
> Something like:
> "Id", int, not null, autoincrement
> name, varchar(20), not null
SHOW COLUMNS FROM
or even
DESCRIBE
These commands return recordsets exatly line SELECT commands.
Alec
--
When I run LOAD DATA it sometimes notices that there were some warnings. For example;
mysql> LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO TABLE quantis_mkr;
Query OK, 271392 rows affected (4 min 2.95 sec)
Records: 271392 Deleted: 0 Skipped: 0 Warnings: 61
How can I see those warnings?
> Is there a way to select/query the table structure and get a recordset
> with the results?
> Something like:
> "Id", int, not null, autoincrement
> name, varchar(20), not null
DESC table_name
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
"describe tablename"
return columns:
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
> -Ursprungligt meddelande-
Is there a way to select/query the table structure and get a recordset
with the results?
Something like:
"Id", int, not null, autoincrement
name, varchar(20), not null
Thanks,
Gjoko.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.my
Hello,
I am trying to use the mysql binary log for Unix. To do that I have included
the line log-bin in .my.cnf file at the HOME dir. -It is an installation for
tests, so every user launches its own instance of mysql and the datadir and
config is in its own home-.
The server reads that line nd th
> > I am no expert on playing around with IP addresses, but I would think
this
> > a rather dodgy option. Wouldn't connections which you appear to have
open
> > still get through, and connect to something unexpected? Dynamic DND
would
> > probably work. I cannot guarantee access to the DNS syste
Hello
I got a table that crashes everytime that I use "delete from
hvd_layout_settings"
This is a infinite loop:
while (1)
{
check table hvd_layout_settings = table ok
delete from hvd_layout_settings
check table hvd_layout_settings = table crashed
repair table hvd_layout_settings
}
Im using my
Timotius Alfa <[EMAIL PROTECTED]> wrote:
>
> How to install Mysql 4.1, I always failed to do that ? pls help me
If you have any problem with installation, describe it more detailed.
>
> and how to backup database in mysql ?
You can use mysqldump, mysqlhotcopy programs, BACKUP TABLE and SELEC
Hi,
I've been thinking about converting our database from MyISAM to InnoDB
and while I was in the process of testing this out I ran across a kind
of "anomaly". In several of our tables, we have an auto_increment as
the second field of the primary key. For example:
CREATE TABLE test_myisam (
id1 s
Hi,
You can not use native MYSQL C API to handle Oracle DataBase.Work very well
(mixed with MYSQL C API) the ORACLE C API which is named OCI(Oracle Call
Interface).
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTEC
Thanks Mark - I missed this message the first time around, glad I came
across it as that saves a step for sure!
-Chris
- Original Message -
From: "Mark V" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 20, 2003 11:37 AM
Subject: Re: Getting remote connected machine as
Hi,
I'm trying to use replication and the slave stopped with error:
"Could not parse relay log event entry. The possible reasons are: the
master's binary log is corrupted (you can check this by running
'mysqlbinlog' on the binary log), the slave's relay log is corrupted
(you can check this by
Hello,
can i send logs by protocol syslog to another host instead of a file?
thanks,
César.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I am no expert on playing around with IP addresses, but I would think this
a rather dodgy option. Wouldn't connections which you appear to have open
still get through, and connect to something unexpected? Dynamic DND would
probably work. I cannot guarantee access to the DNS system I (or rat
> I was considering having a floating IP for each of the machines, so that
> if one dies, the other takes over the others IP address, thus making
> changes at the application level unnecessary really.
I am no expert on playing around with IP addresses, but I would think this
a rather dodgy optio
Hi,
thank you very much for your reply!
I think it's simpler than you thought.
This is just the kind of response I was hoping for :)
Just set up circular replication (A replicates B, B replicates A) and
> ensure, at the application level, that
you only write on one machine for each separate dat
I think it's simpler than you thought. Just set up circular replication (A
replicates B, B replicates A) and ensure, at the application level, that
you only write on one machine for each separate database. MySQL handles
circular replication: updates travel round the circle until the reach the
mach
How to install Mysql 4.1, I always failed to do that ? pls help me
and how to backup database in mysql ?
thank you
-
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
"Uma Shankari T." <[EMAIL PROTECTED]> wrote:
>
> I need to store the charater value as well as some float value in the
> varchar defined field..is there any other way of decalaration of the field
> that i can store the character as well as float value ?
>
Sorry, I don't understand what exactly
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.16, a new version of the popular Open Source/Free Software
Database, has been released. It is now available in source and binary form
for a number of platforms from our download pages at
http://www.mysql.com/downloads/ and mirror sites.
> -Original Message-
> From: Jean-Pierre Schwickerath [mailto:[EMAIL PROTECTED]
>
> Hello Mumba, Hello Barry,
>
> > > How do I select out and filter only rows that match
> > > both 16 and 62 in the KEYW_ID col? IE. The query
> > > would return only 119 and 108?
> >
> > I'm sure this cou
"Dan Lampkin" <[EMAIL PROTECTED]> wrote:
>
> I've looked online and searched through many threads in the lists and
> can't find a good reference for the cnf file. I've found the page with
> the command line options, but there are options I see in the list
> threads that aren't in the page.
>
> I
"Clive Luk" <[EMAIL PROTECTED]> wrote:
>
> Just some simple questions. The Linux (x86, libc6) Standard 4.0.15 14.5M.
>
> from http://www.mysql.com/downloads/mysql-4.0.html
>
> Is that version I donwloaded a binary verison?
Yes.
> Does that version support Chinese character?
It supports big5,
"Pey Ling" <[EMAIL PROTECTED]> wrote:
>
> i have a question. i am looking for the solution to put this into mysql server:
> [EMAIL PROTECTED]
Use GRANT statement:
http://www.mysql.com/doc/en/GRANT.html
> can i know what does this mean? normally, it is [EMAIL PROTECTED] how can i set
"DANIELE Paolo" <[EMAIL PROTECTED]> wrote:
>
> I have a version of MySQL on my server (mysql Worm 11.18 Distrib
> 3.23.56, for PC-linux (i686)) which I wish to transfer towards a more
> recent server (mysql Ver 11.18 Distrib 3.23.58, for PC-linux (i686)). I
> make a complete backup of the data wi
Hello,
I have a version of MySQL on my server (mysql Worm 11.18 Distrib
3.23.56, for PC-linux (i686)) which I wish to transfer towards a more
recent server (mysql Ver 11.18 Distrib 3.23.58, for PC-linux (i686)). I
make a complete backup of the data with the following command:
mysqldump - U
82 matches
Mail list logo