i have a little quirck with my current Mysql setup. I log all messages
from my mtas into Mysql and then use a simple query to generate stats
from them... as below:
mysql select exim.hour,sum(exim.count),stats.spam,stats.ham from
servers,exim,stats where exim.date=stats.day and exim.date
Hi
I have a problem I need to create recordes with a time stamp that is not
updated when the record is updated. Is this posible or will I have to
manualy create the timestamp using php and insert it when the record is
created ?
Thank you for your time.
--
Gregory Machin
[EMAIL PROTECTED]
[EMAIL
Ady,
INSERT into .. SELECT .. would be the largest part of the workload. My
workload is a relatively small number of relatively large operations. Your
reported bug appears to be the other way around.
I am using MyISAM - very large quantities of data - can't afford, and don't
need, transactions.
I dont think it is possible although I have never searched hard for the
ability. It seems unlikely - since you get to name the columns in the table
and the columns in the query (using 'as'). I suggest you use one of those
abilities.
-Original Message-
From: Yasir Assam [mailto:[EMAIL
Ronan McGlue [EMAIL PROTECTED] wrote on 03/09/2006 05:05:15 AM:
i have a little quirck with my current Mysql setup. I log all messages
from my mtas into Mysql and then use a simple query to generate stats
from them... as below:
mysql select exim.hour,sum(exim.count),stats.spam,stats.ham
Can you post the failed SQL statement from your altered bin log, and
maybe the preceding commands related to that table?
Scott Tanner
AMi Entertainment.net
On Thu, 2006-03-09 at 08:28, Goldblatt, Eric wrote:
Scott,
The table already existed before the binlog. The strange thing is that
[EMAIL PROTECTED] wrote:
Ronan McGlue [EMAIL PROTECTED] wrote on 03/09/2006 05:05:15 AM:
i have a little quirck with my current Mysql setup. I log all messages
from my mtas into Mysql and then use a simple query to generate stats
from them... as below:
mysql select
Are my emails not coming through? Or is this question way too 'newbie'
and no one wants to touch it?
-Ryan
Ryan Stille wrote:
I'm still hoping someone can else can share their input on this.
What do other people usually do as far as the collation setting?
Thanks,
-Ryan
Ryan Stille
clint lenard wrote:
Hey Guys,
I was wondering if I could get some assistance with building a
Simple Import Script using PHP and MySQL. Basically I'm trying to pull
info out of one Table and Insert it into the other Table.
Can anyone show me a simple example of this? I can figure out how to
Ryan Stille [EMAIL PROTECTED] wrote on 03/09/2006 09:59:32 AM:
Are my emails not coming through? Or is this question way too 'newbie'
and no one wants to touch it?
-Ryan
Ryan Stille wrote:
I'm still hoping someone can else can share their input on this.
What do other people
I have some questions regarding InnoDB indices.
Say I have a table with millions of records. On of the fields is a type
field that has a possible value of 1,2,3, or 4. I sometimes query by the
type field and may at other times order on it.
Do queries benefit from an index with this low of a
To restore specific tables (or full databases) I often use this trick (I'm
just writing this down from memory, you would want to run it through a
test environment first). It runs something like this:
1) MASTER: query FLUSH TABLES WITH READ LOCK;
query SHOW MASTER STATUS\G
2) SLAVE:
I have a severe problem that php5 cannot connect to mysql and i don't
know why
also i am using linux
here is my peice of code
:?php
print hi;
mysql_connect('localhost', '', '') or die(mysql_error());
echo Connected to MySQLbr /;
print connected;
?
if their is any configuration please tell me
Robert DiFalco [EMAIL PROTECTED] wrote on 03/09/2006 12:32:44 PM:
I have some questions regarding InnoDB indices.
Say I have a table with millions of records. On of the fields is a type
field that has a possible value of 1,2,3, or 4. I sometimes query by the
type field and may at other
Please explain to me how mysqld's key buffer uses memory under Linux
(kernel 2.4, glibc 2.3, mysql 4.1).
I'd want to know for sure if every mysqld thread (forked upon an
incoming connection) uses its own memory for key buffer (key_buffer_size)
or key buffer is common for all mysql
- Original Message
From: Robert DiFalco [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, March 9, 2006 9:32:44 AM
Subject: InnoDB Indices
I have some questions regarding InnoDB indices.
Say I have a table with millions of records. On of the fields is a type
field that has
Do you have control over the DELETE queries? If so I would look into the
option of using 'SQL_LOG_BIN':
http://dev.mysql.com/doc/refman/5.0/en/set-option.html
SQL_LOG_BIN = {0 | 1}
If set to 0, no logging is done to the binary log for the client.
The client must have the SUPER
You need a login id and password unless this is test DB added under
ID root
You have to use the same login id as the one you created the
db/table with.
mysql_connect('localhost', 'Login id', 'pw') or die(mysql_error())
mysql_connect('localhost', 'root') or die(mysql_error())
-Original
All,
I would like to knew if anyone knows of a way to automate innoDB Hot Backups
of several databases that can be set to occur at off hours. Also, is it
possible to run several backups at one time. I am using MySQL 4.1.x on a
Solaris system.
Thanks,
Alan Fisher
--
MySQL General Mailing List
++ I can't see it helping with insert, but depending on the where
clause on your updates and deletes it could.
I guess I was thinking that if an index with otherwise low selectivity
added a rightmost column that was completely unique that it would
improve key distribution and therefore make
This would clear your doubt about which memory is shared by all threads and
which memory is used by individual threads ..
min_memory_needed_by_mysql = (global_buffers + ((thread_buffers )*
max_connections)))
where thread_buffers includes the following:
sort_buffer
myisam_sort_buffer
Mary Adel wrote:
I have a severe problem that php5 cannot connect to mysql and i don't
know why
also i am using linux
here is my peice of code
:?php
print hi;
mysql_connect('localhost', '', '') or die(mysql_error());
echo Connected to MySQLbr /;
print connected;
?
if their is any configuration
Atle,
No, unfortunately we have no control over the DELETE queries. The master
mysql database is the back end for an application which we cannot touch.
Eric
-Original Message-
From: Atle Veka [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 09, 2006 1:35 PM
To: Goldblatt, Eric
Cc:
Thanks for al your help and i di that and now i have another error
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
my code is as follows:
?php
print hi;
mysql_connect('localhost', 'root','') or die(mysql_error());
echo Connected to MySQLbr /;
print connected;
Scott,
There were 257 commands related to the table before the error. They all
look the same.
Below are the last two (256th and 257th), followed by the one that
caused the read-only error.
LOAD DATA LOCAL INFILE
'f:\\Staging\\infiles1\\4539_1140709500_1140709923.in_process-1ccede-0'
INTO TABLE
I'm not sure what version of MySQL you're running, but might it be
possible to put a trigger on the tables in the slave DB to insert
deleted records into another table?
I've done such things for large tables that need trimmed from time to
time, but I need to save the old data for archival.
Robert,
actually, InnoDB always internally adds the PRIMARY KEY to every secondary
index record:
http://dev.mysql.com/doc/refman/5.0/en/innodb-table-and-index.html
If a column has just four different values, then in most cases an index on
that column does not help at all. And every index
Alan,
- Original Message -
From: Alan Fisher [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 09, 2006 8:38 PM
Subject: InnoiDB Backups
All,
I would like to knew if anyone knows of a way to automate innoDB Hot
Backups
of several databases that can be
On Thu, 9 Mar 2006, Mary Adel wrote:
Thanks for al your help and i di that and now i have another error
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
my code is as follows:
?php
print hi;
mysql_connect('localhost', 'root','') or die(mysql_error());
echo
If you still have issues after that, then read
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist -
Mary, you need to know 100% that mysql is actually running
and what port or socket it is listening on for connections,
before you even try and connect to it.
If you call mysqld directly with a script something like:
#! /bin/sh
# start-mysql-5.0.18
#
# start the MySQL database server
Also be careful with this:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
(after to establish a connection)
Edwin.
-Mensaje original-
De: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
Enviado el: Jueves, 09 de Marzo de 2006 02:17 p.m.
Para: Mary Adel
CC: [EMAIL
On 9/03/2006 9:43 a.m., Kishore Jalleda wrote:
could you tell us if these 6 are in a cluster or in a replication set up,
and u also said the 3 linux bixes all crash at once, did u check the logs,
do they crash under load, what about the OS, is it stable when mysql
crashes
Kishore Jalleda
Thanks Dave. I was hoping I could avoid naming the columns myself (all
my queries are built using an SQL code compiler from data stored in XML
files). I'll have to write code to add the column alias names (but only
if they don't use expressions).
Yasir
I dont think it is possible although I
Thanks for that Nicolas.
Yasir
Can you run without the Order By at all? If not, you may need to
properly join the tables.
I could reproduce the issue with MySQL 4.1 as well and I would go around
it myself by creating a temporaty table, populating it with the
aggregate, doing a select on the
Hi all,
I understand that the option log-errors and log-warnings only logs server
related internal errors. How do I enable logging errors from queries
executed, so that I can fix the problematic query statement accordingly?
The statement SHOW WARNINGS and SHOW ERRORS does not work on my server
I posted this same item on the mysql forum but the
only place that looked remotely appropriate was under
the Newbie section... I'm not sure if it will be
answer there so I thought I might toss it out here to
see if there were any takers.
I'm baffled as to why this stored procedure is acting
this
In the last episode (Mar 08), ryan lwf said:
I understand that the option log-errors and log-warnings only logs
server related internal errors. How do I enable logging errors from
queries executed, so that I can fix the problematic query statement
accordingly?
The statement SHOW WARNINGS
Your table is missing. Try this:
mysqldump --single-transaction -u root clientdb table
--where=FLD_CLIENT_ID=1 client1_dbbackup.sql
Yes. The tables are missing. That's because I want the backup of all the
tables in the db, and those tables that have the column FLD_CLIENT_ID, they
should be
39 matches
Mail list logo