I like to share with you all, an interesting article about eBay's
deployment of database arrays.
http://www.eweek.com/article2/0,1759,1640234,00.asp
Specifically on page 2, Marty Abbott (eBay's VP of Technology) states
that eBay has four equal data centers. So in this array scheme, a
write
Does anybody know if it's possible to use together the mysql interface
and native myisam commands?
I tried with unfortunate result, obtaining a:
Program received signal SIGSEGV, Segmentation fault.
0x080b7aee in _mi_writeinfo (info=0x8118bf0, operation=0) at
mi_locking.c:371
371
Hi,
I have a configuration with 1 master and 2 slaves; all servers are
correctly running mysql-max-4.0.20.
All is fine, but I'm observing a strange usage of logs.
On one of the slaves I have:
mysql show slave status \G
*** 1. row ***
Nico Sabbi wrote:
[...]
There are 3 GB of logs that no one needs anymore. Since the master knows
that all
the slaves are correctly aligned up to a certain MASTER_LOG_POS, can't
it automatically remove the logs up to that position?
The problem here is that MySQL masters aren't necessarily aware of
Johanne,
DROP DATABASE is rather safe, if it succeeds.
http://dev.mysql.com/doc/mysql/en/InnoDB.html is the best reference.
Best regards,
Heikki
Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up
See http://dev.mysql.com/doc/mysql/en/PURGE_MASTER_LOGS.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/
Todd Gruben [EMAIL PROTECTED] wrote:
I have an interesting problem. I have developed a custom mysql
replication client that we use for monitoring our mysql database. Kinda
like a poor man's trigger, but the power of an asynchronus trigger is
very beneficial. Any way, I developed this
Mauricio Pellegrini [EMAIL PROTECTED] wrote:
I'm trying to backup the 'binary log' and don't know which file is it.
these are the files I see in my datadir
-rw-rw 1 mysql users175K Sep 14 14:21 hrrgp01-bin.07
-rw-rw 1 mysql users345K Sep 14 15:03
mysql create table list_admin (
- admin_id int(11) default '0' not null auto_increment
- );
ERROR 1067 (42000): Invalid default value for 'admin_id'
How can I set default value to 0?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Mike Bao [EMAIL PROTECTED] wrote:
Last week, the all tables in one database had been deleted, which is
second times since I upgrade my operation system from NT 4.0 to Server
2003. Before that, they had been deleted many times.
I just copied all table files to one database(one directory).
Wouter van Vliet [EMAIL PROTECTED] wrote:
Would I be able to support the datatype change on this? And more
generally; can somebody advice me on (maybe some other) strategy for
changing the datatype?
Actually it's easy, you just need to have free space to be able to convert
from blob to
joe mcguckin [EMAIL PROTECTED] wrote:
Does the mysql server return to the client (DBI in this case) the query
execution time? If so, how do I retrieve it?
my $_startTime = time;
$dbh-do(INSERT INTO dinner VALUES ('chicken','grille'));
print Execution time: .(time - $_startTime).\n;
Like
Sanjeev Sagar [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] DBIx-DWIW-0.41]# make test
PERL_DL_NONLAZY=3D1 /usr/bin/perl -Iblib/lib -Iblib/arch test.pl
1..1
# Running under perl version 5.008 for linux
# Current time local: Wed Sep 15 13:42:27 2004
# Current time GMT: Wed Sep 15 20:42:27
Scott Hamm [EMAIL PROTECTED] wrote on 17/09/2004 13:15:30:
mysql create table list_admin (
- admin_id int(11) default '0' not null auto_increment
- );
ERROR 1067 (42000): Invalid default value for 'admin_id'
How can I set default value to 0?
I don't think you can have a default
You can't - auto_increment cannot have a default value, AFAIAA.
Terry
- Original Message -
mysql create table list_admin (
- admin_id int(11) default '0' not null auto_increment
- );
ERROR 1067 (42000): Invalid default value for 'admin_id'
How can I set default value to
Marten Lehmann [EMAIL PROTECTED] wrote:
security problem? Is there any way to trick the mysql-server, so that a
remote-client can claim to be a localhost-client and thus can connect as
mysql-user root?
No.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
Alberto Mucignat [EMAIL PROTECTED] wrote:
I mean, suppose we have max_connections=500, is it possible to say that
from all external clients there could be at max 490 connections, while a
single host or user can have at max 10 connections? Obviously, if host
who has reserved 10 connections
Mauricio Pellegrini [EMAIL PROTECTED] wrote:
Hi, Sorry to disturb but Mysql 4.1.4 gamma goes down when executing this
query.
Please create a testcase and send it to me by email at [EMAIL PROTECTED]
I will investigate and get back to you. Somehow looks like you've found a
bug.
--
For
Irek Slonina [EMAIL PROTECTED] wrote:
I have two interfaces on my slave:
ppp0 80.80.80.8 ( - Internet )
eth0 10.10.10.1 ( - LAN )
and remote master host 192.168.168.168 available by 80.80.80.8.
How can I force mysql to start slave processes using 10.10.10.1
and not 80.80.80.8, which is
[EMAIL PROTECTED] wrote:
Scott Hamm [EMAIL PROTECTED] wrote on 17/09/2004 13:15:30:
mysql create table list_admin (
- admin_id int(11) default '0' not null auto_increment
- );
ERROR 1067 (42000): Invalid default value for 'admin_id'
How can I set default value to 0?
I don't think you can
Peter Flynn [EMAIL PROTECTED] wrote:
manual, mysql_install_db gets run automatically when you
do this, but I don't know what to look for as evidence that
this has happened.
Wrong way.
Remove it and install MySQL official binary RPMs downloaded from
www.mysql.com.
--
For technical
Ruben Safir Secretary NYLXS [EMAIL PROTECTED] wrote:
Is there a way of checking for live connections prior to using
mysql_connect in the C API (asside from mysql_ping)
Try to open a TCP connection to port 3306 of target server. If
successful - then connections are live. Close that test
[EMAIL PROTECTED] wrote:
I'm wondering whether or not I should implement fulltext searching for 2 letter
words within a product database (HP, TV, G5, LG, etc)... My searchable text is
currently about 600Mb and a 3-letter fulltext index is consuming about 420Mb.
Is the trade-off for user
Dathan Vance Pattishall [EMAIL PROTECTED] wrote:
I get permission from my bosses to release the benchmarks I will send it =
to the list.
Please! This definitely will be a valuable information for the community.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
Jeremy Zawodny [EMAIL PROTECTED] wrote:
I can verify that a quad opteron 2.2 runs about a million times
better than a quad xeon 3.06. The opteron can handle more than 3
gigs of memory which is a 32 bit limitation. Right now in my quad
opteron we have 32 gigs of memory and MySQL is using
[EMAIL PROTECTED] wrote:
I am doing a technical comparison between two products of which one is
MySQL. But I don't exactly know which product that MySQL offers that I
should pick.
I am thinking of MaxDB, because it's supposed to be the most feature rice,
but it does not seem to be MySQL
Egor Egorov wrote:
Mauricio Pellegrini [EMAIL PROTECTED] wrote:
I'm trying to backup the 'binary log' and don't know which file is it.
these are the files I see in my datadir
-rw-rw 1 mysql users175K Sep 14 14:21 hrrgp01-bin.07
-rw-rw 1 mysql users345K Sep 14
Here is the output I got when I ran my query - and yours, Michael - against
DB2 V7.2. Please note that I replaced the 'temp' table in Michael's query
with the real table in both the outer query and the subquery; no other
changes were made.
Paul DuBois [EMAIL PROTECTED] wrote:
According to the documentation, when delay_key_write is active the index
keys aren=92t written to disk until the table(s) are closed. When is a =
table
closed? Is it only when a connection is closed?
When connection is closed, when FLUSH TABLES
Marten Lehmann [EMAIL PROTECTED] wrote:
Redhat Enterprise Linux 3, self-build mysql 4.0.20 (server and client).
OKay, here's the problem - a self-built MySQL. Unfortunately, due to
some glibc bugs it's not really possible to build a stable MySQL
under linux using stock glibc...
And the
Hello folks
Can I use or implement database relations in sql as some do in databases
in accecss..?
tommie
--
___
msc. tomas alberto ramirez.andujar
webmaster - cejisoft - +5332 262451 /261410
universidad pedagogica jose marti. camaguey
circunvalacion norte
On Fri, 2004-09-17 at 13:47, Egor Egorov wrote:
Peter Flynn [EMAIL PROTECTED] wrote:
manual, mysql_install_db gets run automatically when you
do this, but I don't know what to look for as evidence that
this has happened.
Wrong way.
Remove it and install MySQL official binary RPMs
Say, for example, I want to run an insert like the following:
java.sql.Statement select = conn.createStatement();
select.executeUpdate(update test set observerNote='\u201C ... \u00BC');
FWIW, u201C is an opening curly quote and u00BC is a fraction representing
one quarter.
If I create my JDBC
Hi list,
First question - I have a machine that was being managed by Plesk, and
an update to mod_python left Plesk in a nonrunning state (actually
causes apache to segfault). So I am attempting to manually manage
MySQL (the way it should be done!) - but there is apparently no root
user in
Hello,
I am trying to setup mysql and need some guidance -
thanks
Linda Caulfield
Software Quality Engineer
Global Hawk Program
Rancho Bernardo X4680
Phone:858.618.4680
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi Michael,
Thanks for the reply.
It doesn't work, at least not with 4.0.18. I also tried without
the _ to simplify the case, but the grant statement isn't wild about
the wildcard. :)
The docs you list are for 4.1. I guess I will have to wait
until 4.1. :)
the statement is taking 3 hours and counting.
optimize TABLE tablename
normally this takes 30 minutes or so.
boss wants to kill this thread.
does that mean the table will end up corrupt?
any input helpful.
david
hrdw: solaris 4cpu, running version 8
mysql version
Nico Sabbi wrote:
Hi,
I have a configuration with 1 master and 2 slaves; all servers are
correctly running mysql-max-4.0.20.
All is fine, but I'm observing a strange usage of logs.
On one of the slaves I have:
mysql show slave status \G
*** 1. row
There probably is a root user, but it's not called root. You can name
the root user whatever you want. You probably just don't have a user
named root, which is why you can change the password for user root.
You want to start MySQL with the skip grant tables options, just like
in the
Is there a known bug with outer joins in MySQL 5.0.1?
I tried the following query on 5.0.1:
SELECT s.tech_id, s.full_name, sa.points_awarded, sa.date_submitted
FROM student s
INNER JOIN enrollment e ON e.tech_id = s.tech_id
INNER JOIN submitted_assignment sa ON sa.tech_id = s.tech_id
RIGHT JOIN
That's my fault. It does work with 4.0.18. (The manual is usually pretty
good at specifying when something is 4.1 only, by the way.) You need to
quote the db string with backticks, not single quotes (as I did in my
example). So, you would use
GRANT SELECT ON `dev\_%`.* TO [EMAIL
I am building a database with permissions for different modules. The
permissions table contains a separate row for each module/user combination, and
lists the add/mod/del permissions for that module. So, for example, user 'bob'
might have add and del rights for 'module1', add only rights for
On Fri, 17 Sep 2004 11:33:04 -0700 (PDT), David T. [EMAIL PROTECTED] wrote:
I am building a database with permissions for different modules. The
permissions table contains a separate row for each module/user combination,
You didn't say, but if you're using PHP you might find this of use:
- Original Message -
From: David T. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 17, 2004 2:33 PM
Subject: Problems with Left Join query
I am building a database with permissions for different modules. The
permissions table contains a separate row for each
First, you want to get an answer for every module, so you must use
modules LEFT JOIN permissions
to get a row for every module. You see? The table with missing rows (no
row for Bob/module3 in permissions) goes on the right.
When the table on the right does not have a matching row, the LEFT
On Fri, Sep 17, 2004 at 04:01:53PM +0300, Egor Egorov wrote:
Jeremy Zawodny [EMAIL PROTECTED] wrote:
I can verify that a quad opteron 2.2 runs about a million times
better than a quad xeon 3.06. The opteron can handle more than 3
gigs of memory which is a 32 bit limitation. Right now in
I took a closer look and found the problem -- char(date). Is char()
necessary in DB2 to cast the date as a string? In MySQL, char() expects a
list of integers to interpret as a list of character codes
http://dev.mysql.com/doc/mysql/en/String_functions.html. Removing char()
makes the query
Hello:
Am currently using Ver 11.18 Distrib 3.23.58
on Linux 2.4.20-20.9. (RH 9.0).
I'd like to upgrade to the current version. I would
like to know if there are any cautions to observe,
or any prepartory steps to take.
If I look at the following URL:
You can ignore both of those if you use the binaries.
-Eric
On Fri, 17 Sep 2004 18:43:02 -0800, Tim Johnson [EMAIL PROTECTED] wrote:
Hello:
Am currently using Ver 11.18 Distrib 3.23.58
on Linux 2.4.20-20.9. (RH 9.0).
I'd like to upgrade to the current version. I would
like to know
From the SQL Reference for DB2:
---
-CHAR--(--datetime-expression+---+--)
'-,--+-ISO---+--'
+-USA---+
+-EUR---+
I'm getting an Error 1130, (MyDNSName is not allowed to connect to this
machine), whenever I try to connect to MySQL server from any client by
using its IP or friendly DNS name other than 127.0.0.1 or localhost.
This has happened on three machines so far, is there something I forgot to
51 matches
Mail list logo
