Robert,
- Original Message -
From: Robert DiFalco [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, February 26, 2006 8:27 PM
Subject: RE: Why do these transactions show table locks?
It might be important to note that I have a delete trigger on the ELEMS
table,
Rithish,
- Original Message -
From: Rithish Saralaya [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, February 27, 2006 7:06 AM
Subject: RE: error 1016 : cant open ibd file even though it exists
Heikki.
I found the ibdata1 and ib_log files located in only
If you want to find out the content of the CD you should buy the book !
I'm sure it's illegal to make a copy of the CD available online... and also
to have a copy without having the book !
With the respect of the content let me tell you that it contains the book
itself in PDF and some PDFs with
Hello.
I was going to recreate a database of size 35 GB from sql dump file. Wanted
to know if it is possible to do it without mysql writing into the binary
log. If yes, how?
Regards,
Rithish.
Hi,
I'm having a few problems at the moment with replication.
We are in the process of migrating a cache to 2 new database machines.
As the data is a cache its very large is refreshed constantly.
Currently we have 2 machines, 1 master and 1 slave.
I am trying to set up this configuration but I
Thanks.
Since i use Innodb, i decrease the value of all variables affected
myisam table
Thx
[EMAIL PROTECTED] wrote:
Lowering your sort_buffer and read_buffer to 512K should help (there are
allocated for each connection, and (12+12)*910 is a lot more than what
your system can handle).
Greetings,
We are running a server and the CPU is at %99.99 at all times, after about
2-3 hours of processing queries just hang, sounds like our hardware is weak
but we are running a 4GB RAM Dual Xeons 3.4 at 64bit OS.
I was hoping someone could look at our settings and would help us analyze
MY GOAL
To collect any consumers.id WHERE date of birth, last name and
first name matches what was entered by the user. The trick is that
date of birth lives in the consumer table and last name and first
name lives in the cases table (which can be joined to consumers
Why do some many people that work in the U.S government post to this mysql
list? Do they really hire people with no experience ? I fear for our
homeland..
-Original Message-
From: Courtney Braafhart
[*mailto:[EMAIL PROTECTED][EMAIL PROTECTED]]
Sent: Monday, February 27, 2006 10:31 AM
select consumers.id from consumers LEFT JOIN cases ON consumers.id =
cases.id WHERE consumers.date_of_birth = '?' AND cases.last_name = '?' AND
cases.full_first_name = '?'
-Original Message-
From: Courtney Braafhart [mailto:[EMAIL PROTECTED]
Sent: Monday, February 27, 2006 1:31 PM
To:
SELECT consumers.id FROM consumers, cases
WHERE
consumers.id=cases.consumers_id
AND consumers.date_of_birth = ?
AND cases.last_name = ?
AND cases.first_name = ?
John A. McCaskey
-Original Message-
From: Courtney Braafhart [mailto:[EMAIL PROTECTED]
Sent: Monday, February 27, 2006
Hi there,
I am in the midst of creating a forums hosting site.
1. It has to be highly scalable, so I doubt a single MYSQL db with TONS
of subforums that simulate full forums would do.
2. Also regarding scalablity, I hope to Add capacity as and when its
needed. So i'll have one server running
Hi: My database is mysql 4.1.14-standard. I have a
blob type field in a table1 with mutlple attributes
together in the field as shown below
table1.field1 value for a record is abc=2 def=4
ghi=10
I have table2 which has fields abc, def and ghi. I
want to be able to parse the table1.field1 and
Courtney,
SELECT consumers.id FROM consumers
WHERE date_of_birth = ? AND consumer.id =
(SELECT consumer_id FROM cases WHERE last_name = ?
AND full_first_name = ? )
Is there a way to form the above statement in MYSQL?
Something like this would be faster ...
SELECT co.id
FROM cases
It doesn't allow to bind to a hostname. According to
http://dev.mysql.com/doc/refman/5.0/en/server-options.html
you have to specify an IP address, not a hostname.
-Sheeri
On 2/22/06, James Long [EMAIL PROTECTED] wrote:
I would like to be able to bind to a host name, rather than
an IP
Hi Chris,
I remember that article, I think I saw it on PlanetMySQL.com -- but I
can't find it either. I do remember that it encrypted the column
putting it into the database, and used a VIEW to decode it, and then
limited the access to the view.
Hope that helps!
-Sheeri
On 2/23/06, [EMAIL
Hi Julie,
If you notice after your import, you have 3 warnings. This intrigued
me, so I created a test case (also running 5.0.18 standard):
create table bit_test (b bit(8));
cat /tmp/bit_test.txt
01010101
2
b'010'
b\'010\'
0x2
02
mysql load data infile '/tmp/bit_test.txt'
Hi,
Anyone out there using MySQL and Delphi together?
Would love to exchange experiences.
Regards,
John
John Barrington
[EMAIL PROTECTED]
+27 11 6489876
Hi there,
I am in the midst of creating a forums hosting site.
1. It has to be highly scalable, so I doubt a single MYSQL db with TONS of
subforums that simulate full forums would do.
2. Also regarding scalablity, I hope to Add capacity as and when its
needed. So i'll have one server running
It doesn't allow to bind to a hostname. According to
http://dev.mysql.com/doc/refman/5.0/en/server-options.html
you have to specify an IP address, not a hostname.
-Sheeri
Thanks for your reply. Yes, I am aware of that, as stated in
my question.
Wouldn't it be an improvement if it
Sheeri,
Wow. That was my first forum email and I thought it would go unnoticed. I
sure was wrong.
You are exactly right, because apparently with LOAD DATA INFILE, everything
in the file is treated as a string. I'm using PHP to create the text file,
so I tried PHP's pack() function to write
Yes, there is a very good, not so technical reason to only allow binding
by IP Address. Have you ever heard of putting the cart before the horse
?
If binding by hostname were allowed, that would mean that every time your
MySQL server started up, it would need to somehow resolve that name into
You seem to be unaware of /etc/hosts.
Yes, there is a very good, not so technical reason to only allow binding
by IP Address. Have you ever heard of putting the cart before the horse
?
If binding by hostname were allowed, that would mean that every time your
MySQL server started up, it
Is there a command to regenerating the selectivity statistics of indices
with MySQL? Or does MySQL not have a cost based optimizer and this would
make no difference?
R.
Oh, no. I know about etc/hosts (even Windoze boxes has one). It's just
normally not available for reference until you bind your socket library to
at least one socket. Again, it's a cart and horse thing. You see, the
etc/hosts file counts as a local DNS server and the DNS protocol
requires a
Robert DiFalco [EMAIL PROTECTED] wrote on 02/27/2006 04:53:06 PM:
Is there a command to regenerating the selectivity statistics of indices
with MySQL? Or does MySQL not have a cost based optimizer and this would
make no difference?
R.
MySQL uses a cost-based optimizer
Mark,
Databases are not e-mail handlers, so the basic answer is no.
However, it's possible to have the e-mail handlers update a database
record -- I've seen it done with exim (but don't ask me how!)
-Sheeri
On 2/24/06, Mark [EMAIL PROTECTED] wrote:
Can anyone tell me if it is possible to send
Thanks. I am pretty sure that I am not getting the list and that it is
not being caught by my spamassassin. I have looked at my maillog file
(I'm running Linux) and my spamassassin/mimedefang logs everything even
if it is ditched. I have gotten a couple of general news things from
mysql.com
Oh, no. I know about etc/hosts (even Windoze boxes has one). It's just
normally not available for reference until you bind your socket library to
at least one socket. Again, it's a cart and horse thing. You see, the
etc/hosts file counts as a local DNS server and the DNS protocol
requires
Hi Philip, thanks for the reply.
Single master + many read only slaves would only solve the problem of
handling many many concurrent read accesses, by distributing the load
across all slaves.
However, I guess the real problem, is that the writes would still need
to be performed across ALL
Your subject is misleading, I would rather call this something like
Chained Replication. Unless your slaves all replicate from 'Master', in
that case your drawing is the culprit. :)
Does the error log on slave3 or slave2 indicate any problems?
Atle
-
Flying Crocodile Inc, Unix Systems
Hi,
Not having a lot of luck with replication.
Have 2 4.1x boxes
Slave is configured, via my.cnf, to only replicate three tables:
replicate-do-table = db.table1
replicate-do-table = db.table2
replicate-do-table = db.table3
SHOW SLAVE STATUS; (sanitised) output is as follows:
mysql show slave
Are you doing a lot of insert statements?
I noticed:
ft_max_word_len: 84
ft_min_word_len : 2
And if you have sizable full text index insert statements, I could you see
having more than normal cpu usage.
On 2/27/06, Taiyo [EMAIL PROTECTED] wrote:
Greetings,
We are running a server and
The curse of the impatient and deadlined sysadmin:
060227 19:22:28 [ERROR] The slave I/O thread stops because master and
slave have different values for the COLLATION_SERVER global variable.
The values must be equal for replication to work
Change default charset, all works. Sorry for the noise.
Hi James,
I would like to be able to bind to a host name, rather than
an IP number. IP numbers come and go, and are beyond the
control of anyone who doesn't have their own direct allocation.
But since I own my domain, a host name is more permanent.
Adding this functionality is fairly
Hi James,
I would like to be able to bind to a host name, rather than
an IP number. IP numbers come and go, and are beyond the
control of anyone who doesn't have their own direct allocation.
But since I own my domain, a host name is more permanent.
Adding this functionality is
Hi,
Thank you very much! I'm willing to help test if you can provide me a diff
of your changes.
Well, that was easy. I checked the code, and it turns out that the
functionality is already there. I just tested it on my laptop (running
5.0.13) and it does indeed work.
I did:
* echo
q: I want to pull a distinct list of content that have a category
(we have a content_categories table linking content ids with category
ids), BUT I want it to be able to work from multiple categories in an
AND fashion.
the table structure is, roughly:
content:
id
name
blahblahblah
Hi,
Thank you very much! I'm willing to help test if you can provide me a diff
of your changes.
Well, that was easy. I checked the code, and it turns out that the
functionality is already there. I just tested it on my laptop (running
5.0.13) and it does indeed work.
I did:
Marvin,
The process is working between Master, Slave1 and Slave2 but
for some reason Slave2 is not writing bin-log information.
So Slave3 is sitting empty and not getting any data because of no data
in Slave2's bin-log.
I guess u don't have 'log-slave-updates' flag
On Mon, 27 Feb 2006, Marvin Wright wrote:
Hi,
I'm having a few problems at the moment with replication.
We are in the process of migrating a cache to 2 new database machines.
As the data is a cache its very large is refreshed constantly.
Currently we have 2 machines, 1 master and 1 slave.
starmonkey wrote:
q: I want to pull a distinct list of content that have a category
(we have a content_categories table linking content ids with category
ids), BUT I want it to be able to work from multiple categories in an
AND fashion.
the table structure is, roughly:
content:
id
name
Hello Keith.
The power outage was known before-hand, and the server was shutdown before
the outage happened. The server was brought up once the power returned. So
no UPs intervention happened here.
Regards,
Rithish.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Hello.
Yes. Maybe a mystery that will remain unsolved for some time; however,
hopefully will get solved.
I deleted all the related files, dropped the database, and recreated it
again freshly from a backup. It was needed to try out some migration of data
across tables, and hence the data was not
Quoting Chris [EMAIL PROTECTED]:
SELECT content.name
FROM content as c
INNER JOIN content_categories as cg
ON(c.id = cg.content_id)
INNER JOIN categories as g
ON(cg.category_id = g.id)
WHERE g.id IN (3,5,9)
GROUP BY c.id
HAVING 3 = COUNT(*)
Thanks, Chris - that did the trick alright! I use
[EMAIL PROTECTED] wrote:
Hi,
Anyone out there using MySQL and Delphi together?
Would love to exchange experiences.
Regards,
John
John Barrington
[EMAIL PROTECTED]
+27 11 6489876
You'd better try Borland's newsgroups like:
borland.public.delphi.database.dbexpress
etc. - that's where the
46 matches
Mail list logo