hi,
how can i spread reads on a non-cluster config? what i have in mind is
a
master (with a passive box beside) and 2 replicated servers.. unfortunately i
can only spread reads and not writes...
thanks,
DISCLAIMER: This Message may contain confidential information intended only for
Hi,
Its delete * from table will only do if you go for a truncate it will
recreate the table structure ?
It's better to use delete.
Thanks Regards
Dilipkumar
- Original Message -
From: Peter Lauri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Wednesday,
Finally I have an erroneous /etc/hosts file.
But aside from that what of the realeses is best suited for a CentOS 4.4
Double Pentium III 1.0 Ghz?
* Linux (x86, glibc-2.2, standard is static, gcc):
mysql-standard-5.0.24a-linux-i686.tar.gz
* Linux (x86):
On Friday 22 September 2006 18:36, JM wrote:
sorry.. what i have in mind is the writes..
master
|
|_ _ _ _ replicated 1 (read)
|
|_ _ _ _ replicated 2 (read)
thanks,
hi,
how can i spread reads on a non-cluster config? what i have in
I have done this, but only with some external programming. I was using
Informix, not MySQL, but the principle would be the same. Essentially, I put
a layer in between the client and the data base, and it wrote transactions
into a FIFO for a slave on each server. The slaves, in turn, took care of
Dear MySQL-ers,
After upgrading to MySQL 5.0.24a (from 4.0.26), I've been raking my brain
over installing DBD-mysql-3.0007. Installed DBI-1.52, then DBD::mysql, all
by the book. Troublesome installation. But that's not what I want to ask
about.
So, after installing DBI-1.52 (built against
The MySQL Reference Manual has become huge (about 2000 pages), and this
means it's becoming increasingly hard to find things. And often it's
hard for the MySQL documentation team to decide where to put things,
because no matter where we put them some people expect to find them in
another place.
Did anyone have any thoughts?
On Mon, 2006-09-18 at 00:02 -0400, THO wrote:
In need of suggestions to get correct part multiplier factor.
(apologies up front for message length)
I have an parts/assemblies table.
mysql describe assycard;
Does anyone know if MySQL currently integrates with MIT Kerberos
authentication (http://web.mit.edu/Kerberos/)
http://web.mit.edu/Kerberos/ . And if not, are they working on this
for a future release? MIT Kerberos has broad use in government,
academic and research institutions as well as some
Hello,
Is there any way to find out, using only plain SQL, the number of fields
of a given table.
describe gives me the number of fields as result, but I need to get only
that.
Is it possible?
Is it also possible to get only the fields name?
Thanks
David
--
MySQL General Mailing List
For
Hi David
If you are using mysql 5.0 and up, you can select from the
INFORMATION_SCHEMA database to get this information and much more.
Following is an example using a database called test and a table
called t
To get the column names, use
SELECT column_name FROM information_schema.columns
David,
For the count of columns in a table:
SELECT count(information_schema.columns.column_name)
FROM information_schema.columns
WHERE information_schema.columns.table_schema = 'database_name'
ANDinformation_schema.columns.table_name = 'table_name'
For the names of the
[...]
Is there any way to find out, using only plain SQL, the number of fields
of a given table.
describe gives me the number of fields as result, but I need to get only
that.
Is it possible?
Is it also possible to get only the fields name?
AFIK there's no easy way to accomplish this using
Hello,
@Mr. Price and Mr. Sims
Thank you for show me the way, your tips where very educational.
Thanks again.
--
Iván Alemán ~ [[ Debian (Sid) ]] ~
-BEGIN GEEK CODE BLOCK-
Version: 3.12
G!GCM d+ s: a? C+++ UL++ P L$ E--- W+++ N* o--- K- w O- M+ V--
PS++ PE-- Y PGP+++ t-- 5 X R+ !tv
We need a guy for some hourly PHP/MySQL work. Large project to start
with, plenty of incremental stuff down the road. Looking for someone
expert, with a flexible schedule who can make hours available when we
need them. Your regular hourly rate.
Also - only interested in someone local to
In the last episode (Sep 22), Whisler, David said:
Does anyone know if MySQL currently integrates with MIT Kerberos
authentication (http://web.mit.edu/Kerberos/)
http://web.mit.edu/Kerberos/ . And if not, are they working on
this for a future release? MIT Kerberos has broad use in
Hi!
Please see the Forge wiki and provide comments at the end of the technical
specification for pluggable authentication and authorization. Thanks!
Jay
http://forge.mysql.com/wiki/PluggableAuthenticationSupport
http://forge.mysql.com/wiki/PluggableAuthorizationSupport
On Friday 22 September
I seem to recall that when creating a table, you could designate an
auto_increment field to begin counting at zero(0) instead of one (1), but I
can't find an example in the documents.
I'm using 4.0.16 and table type=myisam.
David
--
MySQL General Mailing List
For list archives:
David - there's some info in the online docs here:
http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html
Specifically:
To start with an AUTO_INCREMENT value other than 1, you can set that
value with CREATE TABLE or ALTER TABLE, like this:
mysql ALTER TABLE tbl AUTO_INCREMENT = 100;
Thanks, Dan, but I can't get it to work. Defining a column like this:
a int not null auto_increment=0 primary key
throws an error, and while the alter table statement seems to work ok,
whether the table is empty or not, it has no effect on subsequent inserts.
I'm wondering if 4.0.16 has not
OK. If you assign to auto_increment any number higher than what currently
exists in the column, it changes the value and the incremented sequence
from that point. But apparently you can't assign the value zero to the
column, even if the table is empty.
Thanks, Dan, but I can't get it to work.
I just tried it in 5.0.21, and found that it fails silently with zero
(0). Works with 100. I did specify int, not unsigned int, in my test
table.
See http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
for some discussion about how you could get a zero in there; look for
At 14:16 -0500 9/22/06, [EMAIL PROTECTED] wrote:
I seem to recall that when creating a table, you could designate an
auto_increment field to begin counting at zero(0) instead of one (1), but I
can't find an example in the documents.
Don't store 0 in an AUTO_INCREMENT column.
--
Paul DuBois,
Hi,
I've got a view of a base table that is 100% identical to that base table
except for one column, which is a projection of the base table after its MD5
hashed. The table is largish (~700,000 rows) and is growing quickly.
Queries on the base table are nice and fast, but on the hashed view are
my ISP is using mysql v4.0.26 I am trying to do the following SQL and cannot
get it to parse without an #1064 error.
select r.prog_id, r.prog_name, p.show_id, p.show_title, p.show_desc,
p.show_speaker, p.show_date_recorded, s.spk_name
from programmes p, series r, speaker s
where r.prog_id =
At 14:16 -0500 9/22/06, [EMAIL PROTECTED] wrote:
I seem to recall that when creating a table, you could designate an
auto_increment field to begin counting at zero(0) instead of one (1),
but I
can't find an example in the documents.
Don't store 0 in an AUTO_INCREMENT column.
Thanks Dan
If I'm understanding right - the view contains an additional column
that is an MD5 hash of some or all of the data in the base table,
right?
Yes, I would expect that to be very very slow. When selecting, your
database engine has tro calculate 700K MD5 hashes. Slow. When
selecting a subset it
Rob - sub-selects aren't supported prior to version 4.1.
This page may be of some assistance:
http://dev.mysql.com/doc/refman/4.1/en/rewriting-subqueries.html
Have you tried using a MAX(p.show_date_recorded) and appropriate GROUP BY ?
Dan
On 9/22/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi, thanks for the comments,
If I'm understanding right - the view contains an additional
column that is an MD5 hash of some or all of the data in the
base table, right?
Close. It's got all of the data in the base table except for the colum
that's being hashed - we show the hashed version
The hit with a join on indexed columns is negligible. Relational
databases live for joins - they eat them for breakfast! Seriously, as
long as it's indexed in both tables, it'll be super-speedy.
Dan
On 9/22/06, Christopher Brooks [EMAIL PROTECTED] wrote:
Hi, thanks for the comments,
If I'm
30 matches
Mail list logo