Hi,
I am conveying my apologies for this mail. I did not read this mail
completly and pressed next button, which resulted a mail to all recipeints
of my adressbook.
I won't repeat this again.
bala
Hi,
I have a table with a time stamp column defined as
ts timestamp(14) NOT NULL
this is the first timestamp value in a series of timestamp columns.
Whenever I update a row in the table ts gets updated with the current
timestamp. I read from the documentaion that the first timestamp column
Hi,
Recently I created a new replication set up with 5.0.18-standard-log on Solaris
8 (one master, one slave).
Replication is running, but periodically (after a bunch of INSERT/UPDATE
statements) there is a very large replication lag, with Seconds_Behind_Master
values of 21 and more. This
Mac OS X 10.4.6 (Tiger), MySQL 5.0.21.
Hi folks. I'm needing to start up my general query log to see what's
ticking me off.
I've looked into safe_mysqld but it's confusing as ... something
that's confusing.
Anybody know how I can easily turn this thing on for a day, then turn
it off?
Hi All,
I am looking at OSCommerce for design comparisons and wonder what others
think about the below table design,
CREATE TABLE `customers` (
`customers_id` int(11) NOT NULL auto_increment,
`customers_gender` char(1) NOT NULL,
`customers_firstname` varchar(32) NOT NULL,
Hello Mark,
I am looking at OSCommerce for design comparisons and wonder what others
think about the below table design,
CREATE TABLE `customers` (
`customers_id` int(11) NOT NULL auto_increment,
`customers_gender` char(1) NOT NULL,
`customers_firstname` varchar(32) NOT NULL,
[snip]
Why have customer info in both? Delivery and Billing info makes sense,
but why the redundant info in both? Anyone got views on this? Do/would
you do it differently, and could you tell us why? Cheers.
[/snip]
It is bad database design IMHO.
--
MySQL General Mailing List
For list
Bad design that violates basic DB design checks. Redundant information will
become a major problem for you going forward. Unless you have hard and fast
performance issues they require it, just don't do it:-)
Create a single table that contains customer info and reference the information
using
Hello,
This question is for those with experience sizing their MySQL back-end.
I have one box running 3000 mysqld threads and serving 6000 qps, and is
operating fine. The run queue is generally empty, but we observe ~20K
context-switches/s. At some point, as usage increases, the run queue
I've found that queries that take a long time cause lag time.
Replication on a slave has 2 threads -- one to retrieve stuff from the
logs, and another to actually run the DML queries. Therefore, while
one thread is stuck on a loggg query, the other thread is
still gathering stuff from
Did you successfully alter the table? What does SHOW CREATE TABLE give you?
mysql CREATE TABLE test ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT
PRIMARY KEY, ts_create TIMESTAMP DEFAULT CURRENT_TIMESTAMP, ts_modify
TIMESTAMP );
Query OK, 0 rows affected (0.00 sec)
mysql insert into test(id)
On 5/19/06, Lyle Tagawa [EMAIL PROTECTED] wrote:
Given a nptl/linux box (or pthreads/freeBSD) for example, can you tell
what is the theoretical max running thread count (in the context of
paging/process scheduling and not in the context of memory sizing),
assuming that there's no
On 5/19/06, Martijn Tonies [EMAIL PROTECTED] wrote:
Well, one reason could be, for example, that the address changes
over time and they want to know what address the customer was
when the order was processed.
I agree.
I wouldn't enter the delivery and billing info either, but create
some
Hi,
On Friday 19 May 2006 17:12, sheeri kritzer wrote:
I've found that queries that take a long time cause lag time.
Yes, I know, especially on a busy server. The master handles multiple
statements (connections) in parallel, but the slave processes them serially.
My 4.1.10 setup does about
put
log
or
log=/path/to/file
in your config file (my.cnf) and restart the server. To turn it off
you have to take it out of the my.cnf and restart the server.
I've put in a request to make the general log something that can be
dynamically turned on.
-Sheeri
On 5/19/06, Rich [EMAIL
On 5/19/06, Martijn van den Burg [EMAIL PROTECTED] wrote:
Nothing special, just some updates on a single database. No flushing of
logs... The strange thing is that the condition of extremely high lag lasts
only a couple of seconds, and then tapers back very quickly to zero.
That is weird. If
I wouldn't enter the delivery and billing info either, but create
some sort of customer_address table or order_customer_address
in which records would be inserted if and only if the addresses used
for billing and delivery differ from the normal customer address.
And what happens if the
Not that I know of, but if you don't do binary (case-sensitive)
searching then does it really matter?? You can retrieve with LOWER, or
put it in your application, if your application needs to display it
that way.
-Sheeri
On 5/18/06, Ferindo Middleton [EMAIL PROTECTED] wrote:
I have column and
Mark Sargent wrote:
Hi All,
I am looking at OSCommerce for design comparisons and wonder what others
think about the below table design,
CREATE TABLE `customers` (
`customers_id` int(11) NOT NULL auto_increment,
`customers_gender` char(1) NOT NULL,
`customers_firstname` varchar(32) NOT
That is weird. If it only lasts a couple of seconds, how are you
monitoring it to find out what the lag time is?
I've written a replication monitor script using Perl::POE, which checks
replication lag every 15 seconds or so (can't check the exact interval now -
weekend has begun here).
--
You have to change the delimiter you use, otherwise MySQL treats the ;
as the end of the line and processes the commands. When I tried to
run your trigger (with the standard delimiter of ;) I got:
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to
I have column and I want to make sure the db is always making sure the
value
that gets input into this VARCHAR() column is always lowercase;
Is there a way to set the value of a column within a table to
automatically
be lowercase. I know how to use the LOWER() function when performing
I suggest writing a very simple shell script to run SHOW SLAVE
STATUS and output it to a file every 15 seconds, to verify your
script is working. I have never seen MySQL give a bad lag time for
replication -- it's always been accurate for lag time, or 0, or NULL.
As a bonus you could then use
[snip]
Well, one reason could be, for example, that the address changes
over time and they want to know what address the customer was
when the order was processed.
[/snip]
So you would delete an old customer address in favor of a new one? I
would rather have an 'active/inactive' column with an
Replication puts 2 threads on the slave -- 1 to get the information
from the master and put it into the relay log, and another to read
from the relay log. You pose a good question about master.info -- I
honestly don't know, but the read position is either the same as or
before the exec position,
It depends on what the data is being used for. If you want to know
what address an order was shipped to then you need the historical
address info. If all you need is the current customer address,
because, say, you're sending out holiday cards, then you might not
need to keep an old address.
Yes. idea #1 -- reply all, including the list.
idea #2 -- what's in the error logs?
Check that the user that runs mysql has permission to write to the
file and that /var/log exists.
-Sheeri
On 5/19/06, Rich [EMAIL PROTECTED] wrote:
Hi there.
I added the my.cnf file (it wasn't there) and
That's because ignoring cpu and query complexity isn't generally done.
Sure, you can run a zillion queries per second if all you're doing is
SELECT num from table;. But really threads are limited by memory
I agree with many of your points. We tuned our per-thread buffers
appropriately and
You could always use a trigger on BEFORE UPDATE/BEFORE INSERT which
changes NEW.column to LOWER(column). I know it's not declarative, but
it works.
sheeri kritzer wrote:
Not that I know of, but if you don't do binary (case-sensitive)
searching then does it really matter?? You can retrieve
Why this list goes private I'll never know. I guess that's why I
always get two copies.
In the errors log:
Found option without preceding group in config file: /etc/my.cnf at
line: 1
Fatal error in defaults handling. Program aborted
/var/log/ does indeed exist
root runs mysqld
On
Or check out a very nice Perl snippet on the Forge:
http://forge.mysql.com/snippets/view.php?id=5
sheeri kritzer wrote:
I suggest writing a very simple shell script to run SHOW SLAVE
STATUS and output it to a file every 15 seconds, to verify your
script is working. I have never seen MySQL
I'd like to announce the first release of Sparse, a new way to
create MySQL programs without actually programming anything! Sparse
takes care of handling the SQL data, navigation, displaying errors,
input validation, and caching. Using a few extra HTML tags allows
surprising power, yet
On 5/18/06, Dominik Klein [EMAIL PROTECTED] wrote:
Hi,
for recovery purposes I need to know what exactly is in the master.info
file. Especially the log position. Is it Read_Master_Log_Pos or
Exec_Master_Log_Pos?
Another question: Does stop slave; only stop reading the log from
master or does
If you replicate a long command; more specifically, a command (or
transaction) that started a long time ago, it will appear that replication
is far behind. This is because the apparent delay is computed [I think]
from the diff of the current time on slave and the time that the currently
Dear All,
Need to find ids that are NOT in other two tables. With the help of PHP
scripting and three queries I am able to do the task. Can this be done with
one mysql query?
Below are current quires:
SELECT DISTINCT company_id FROM company_db
SELECT company_id FROM
On Friday 19 May 2006 17:49, sheeri kritzer wrote:
I suggest writing a very simple shell script to run SHOW SLAVE
STATUS and output it to a file every 15 seconds, to verify your
script is working. I have never seen MySQL give a bad lag time for
replication -- it's always been accurate for lag
Yesmin Patwary wrote:
Dear All,
Need to find ids that are NOT in other two tables. With the help of PHP scripting and three queries I am able to do the task. Can this be done with one mysql query?
Below are current quires:
SELECT DISTINCT company_id FROM company_db
SELECT
Hi,
This is driving me crazy. When we were using MySQL 4.0.x we could create
a shared library with libmysqlclient.a bound in.
With MySQL 4.1 onwards, we get the error,
/usr/ccs/bin/ld: Invalid loader fixup in text space needed in output
file for symbol $003A in input file
That means that your options have no group. Options should go under
the program they're intended to be run under, for instance
[mysqldump]
user=root
[mysql.client]
user=guest
[mysqld]
log=/path/to/logfile
You want the mysqld program (mysql server) to use the general log, so
put it under a
Hi,
Greatly appreciated your kind help. Would it work, if I rewrite your query
as below to remove all records from company_db that don't have any relation to
other two tables?
DELETE
FROM company_db c
LEFT JOIN person p
ON c.company_id = p.company_id
LEFT JOIN customer cu
ON
So I've seen replication break a few times due to duplicate queries.
A few times it was around a server crashing, but I thought perhaps it
was because of the crash. (ie, master sends a query, crashes, and
then tries to send the query again when it comes back up).
But in the past 16 hours, it's
Thanks Jay. Yeah, I'll just write a trigger... It sure would be cool though
if you could say something like... ADD COLUMN new_column VARCHAR(100)
DEFAULT LOWER(new_column) and then be done without having to
explicitly define a trigger for it.
This is for a userid field. Userid values at my
On 5/19/06, sheeri kritzer [EMAIL PROTECTED] wrote:
So I've seen replication break a few times due to duplicate queries.
A few times it was around a server crashing, but I thought perhaps it
was because of the crash. (ie, master sends a query, crashes, and
then tries to send the query again
I have a similar desire like my first question regarding a DATETIME field. I
have a DATETIME field in my db that I would like to DEFAULT to the exact
value of another DATETIME field in the same table... However, if I write a
trigger for this and the application or the user or someone accessing
I have a table of many IP addresses. I'm doing some PHP/JS/AJAX to populate
a select box based upon what someone types in a search field. That works
great, except that a user can spend a lot of time guessing as to what
possible IPs exist.
What I'd like to do now is one of those google
I may have just solved my own problem:
SELECT DISTINCT(SUBSTRING_INDEX(INET_NTOA(IP_Addr), '.', 3)) as niceip FROM
IPTable HAVING niceip LIKE '192.168.15%';
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
-Original Message-
From: Daevid Vincent [mailto:[EMAIL PROTECTED]
Hi Sheeri,
So I've seen replication break a few times due to duplicate queries.
A few times it was around a server crashing, but I thought perhaps it
was because of the crash. (ie, master sends a query, crashes, and
then tries to send the query again when it comes back up).
But in the past 16
Is there an easy way to add row numbers to the result of a select
statement?
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http://thewishzone.com
--
MySQL General Mailing List
For
Chris W wrote:
Is there an easy way to add row numbers to the result of a select
statement?
With a user variable:
SET @i = 0;
SELECT @i:= @i + 1 AS 'Row', ...
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
hi,
I have a database from dbf file that has almost 100 thousands records, when I
import them into mysql, it is only imported 13359 records.
my table structure is like this:
`faktur` varchar(10) NOT NULL,
`tgl` date default NULL,
`tgl_terima` date default NULL,
`kontan` varchar(1)
50 matches
Mail list logo