Hi,
I just noticed that replication on my servers failed when they were
under heavy load. I have 1 master and 2 slaves.
For example, I have table for all incoming messages.
message_inbox | CREATE TABLE `message_inbox` (
`member_id` mediumint(8) unsigned NOT NULL default '0',
`message_id` in
Hi all,
I am looking to purchase hardware for a large database running MySQL or Oracle on
Linux.
Was thinking of the Opteron for its good scalability and memory bandwidth until my
friend told me that the DL760 from HP that uses the F8 (from Intel Profusion) chipset
allowing up to 8 CPUs and me
Stuart,
Can you give more information about the other tables as well?
I followed what you are trying to do until you mentioned:
If someone was searching through records, they would
say I found someone who is Spanish and yes, they are
Spanish. Not, I found someone who is Spanish and they
speak
Hello,
The function mysql_stmt_fetch_column() in MySQL4.1 and higher is
undocumented in the Manual:
http://dev.mysql.com/doc/mysql/en/mysql_stmt_fetch_column.html
So, my question is simple: what does this function do???
Thank you in advance,
Boris "borfig" Figovsky.
www.borfig.com
I'm not sure , can't resolve in my mind if this is a
M2M or something else.
I have 5 tables, users may enter multiple records in
each table. The only trick is (for me) is how to tie
a unified record together across all of them.
I'll try to illustrate, and only use 2 tables to keep
it brief.
T
Do MYsql require something similiar to "compacting" a database in Access ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You can use regular expression.
Santino
At 6:45 -0500 3-10-2004, Bob Ramsey wrote:
Hi,
I have some web pages in a database and I want to check to make sure
that all of the images have alt tags in them. So what I need to do
is ask something like this in psuedocode:
select page_name from web_page
I think I may have discovered one of my issues, is
memberID in Table2 was primary key. Should not have
been. As far as the error messages in removing key,
I'm still unsure.
Stuart
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
> Two tables:
>
> Table1 [innodb]
> userID.
> addtlfields
Chris Blackwell wrote:
not sure you can do this just with mysql, I think your gunna need to select
the html from the db then send it to something like perl or php and use a
regex parser on it.
Yeah, that's what I was afraid of. Now all I have to do is decide
between PERL and PHP for the script
Two tables:
Table1 [innodb]
userID.
addtlfields.
Table2 [innodb]
memberID.
addtlfields.
I created a foreign key in Table2 for memberID to
userID
set to "no action" on both delete and update.
I get this error when I try to add a record to table
2:"Cannot add or update a child ro
not sure you can do this just with mysql, I think your gunna need to select
the html from the db then send it to something like perl or php and use a
regex parser on it.
-Original Message-
From: Bob Ramsey [mailto:[EMAIL PROTECTED]
Sent: 03 October 2004 12:45
To: [EMAIL PROTECTED]
Subject
On Sat, Oct 02, 2004 at 08:25:49PM -0500, Paul DuBois wrote:
> At 16:31 -0600 10/2/04, "Dave Shariff Yadallee - System
> Administrator a.k.a. The Root wrote:
> >New error WITH password implemented:
>
> Apparently the ownership of the mysql database and/or the files in
> it is not set such that t
Hi,
I have some web pages in a database and I want to check to make sure
that all of the images have alt tags in them. So what I need to do is
ask something like this in psuedocode:
select page_name from web_pages where page_body does not contain 'alt='
between '';
But I just can't figure out
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
14 matches
Mail list logo
