Hi, I signed Oracle Contributor Agreement about a month ago, but have not got a
response. I reported a bug, but I can not contribute my patch. So, could anyone
please tell me how long will it take before I am informed? Thanks, sincerely
Hello Steve,
To what list should I post with a post-installation config and startup
> question?
>
>
This list, the MySQL General Mailing List, is the right place if the
question is about MySQL!
Cheers
--
Claudio
To what list should I post with a post-installation config and startup
question?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Am 26.07.2011 19:13, schrieb Todd Lyons:
> On Tue, Jul 26, 2011 at 8:18 AM, Reindl Harald wrote:
>>> 1. I did a full copy of the running master database server using
>>> xtrabackup to a backup server via nfs. It took 2 hours, of which the
>>> last 15 minutes did a write lock of the entire serv
On Tue, Jul 26, 2011 at 8:18 AM, Reindl Harald wrote:
>> 1. I did a full copy of the running master database server using
>> xtrabackup to a backup server via nfs. It took 2 hours, of which the
>> last 15 minutes did a write lock of the entire server as it copied
>> over the *.frm files and the
Am 26.07.2011 16:18, schrieb Todd Lyons:
> 1. I did a full copy of the running master database server using
> xtrabackup to a backup server via nfs. It took 2 hours, of which the
> last 15 minutes did a write lock of the entire server as it copied
> over the *.frm files and the few myisam tabl
skip problems and restart replication.
So everything is alright. There are no issues. But there is a question.
Is there a better way to do this? Is there something automated that
will "compare THIS binlog to THAT server and tell me where the data
was no longer being inserted" ?
I just want to point out that public IPs are no longer given out as
Class A, B, and C networks, but based on CIDR. You can use rwhois to
figure out who has use of a certain subnet and what the range of it is.
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
D
3/7/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> wrote:
>
>> From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
>> Subject: Re: a question...
>> To: "Daniel Brown" <[EMAIL PROTECTED]>
>> Cc: [EMAIL PROTECTED], mysql@lists.mysql.com
>> Date: Wedne
On Wed, 2008-07-23 at 12:10 -0400, [EMAIL PROTECTED] wrote:
> Yes, sorry. I have a database that records ip of attacks on a customer
> server, what I like to do get a count so that I can see what subnet is
> doing the major of the attacks.
>
> select ip from ipslimit 10;
> +-+-
On Wed, Jul 23, 2008 at 12:10 PM, <[EMAIL PROTECTED]> wrote:
> Yes, sorry. I have a database that records ip of attacks on a customer
> server, what I like to do get a count so that I can see what subnet is
> doing the major of the attacks.
>
> select ip from ipslimit 10;
> +-+
I think you're after the SUBSTRING_INDEX(str,delim,count) function, so (I've
not tried this):
select substring_index(ip,'.',3) from ipslimit 10;
--- On Wed, 23/7/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Yes, sorry. I have a database that records ip of attacks on a customer
server, what I like to do get a count so that I can see what subnet is
doing the major of the attacks.
select ip from ipslimit 10;
+-+---+
| ip | count(ip) |
+-+---+
On Wed, Jul 23, 2008 at 11:45 AM, <[EMAIL PROTECTED]> wrote:
> Guys,
>
> I have been fighting with mysql trying to get it to only show every after
> the last dot(.) on a ip. for example
>
> instead geting 10.0.0.0 only get 10.0.0
As pulled from a database row? Sorry, I didn't quite understan
Guys,
I have been fighting with mysql trying to get it to only show every after
the last dot(.) on a ip. for example
instead geting 10.0.0.0 only get 10.0.0
But what every I try doesn't work. Can someone pls point to a web page
where I can learn how to do it, of explain it here.
Thanks.
Payne
Thanks very much.
2008/5/21 Paul McCullagh <[EMAIL PROTECTED]>:
>
> On May 21, 2008, at 8:46 AM, Paul McCullagh wrote:
>
> On May 21, 2008, at 8:09 AM, Moon's Father wrote:
>>
>> Now I want to know which way you use to create index of a table.
>>> 1、ix_u (item_id,item_count)
>>>ix_item_coun
Thanks for your reply very much.
What I always use is the first way.
But I also want to know if the following way is proper when I search
"item_id AND item_count" and the column 'item_count'.?
ix_item_id (item_id)
ix_item_count (item_count)
2008/5/21 Paul McCullagh <[EMAIL PROTECTED]>:
>
>
On May 21, 2008, at 8:46 AM, Paul McCullagh wrote:
On May 21, 2008, at 8:09 AM, Moon's Father wrote:
Now I want to know which way you use to create index of a table.
1、ix_u (item_id,item_count)
ix_item_count (item_count)
This makes sense if you have queries which search "item_id AND
i
On May 21, 2008, at 8:09 AM, Moon's Father wrote:
Now I want to know which way you use to create index of a table.
1、ix_u (item_id,item_count)
ix_item_count (item_count)
This makes sense if you have queries which search "item_id AND
item_count", and queries which just search the column
[EMAIL PROTECTED] schrieb:
> I am running the 64 bit version of mysql server 5.1.18, and on the
> client side I am running python with the mysqldb module. While
> running a very large insert query I get the following error :
>
> 2013, 'Lost connection to MySQL server during query'
>
> I have --l
I am running the 64 bit version of mysql server 5.1.18, and on the
client side I am running python with the mysqldb module. While
running a very large insert query I get the following error :
2013, 'Lost connection to MySQL server during query'
I have --log-warnings set to 3, but I get no corres
John Sutton wrote:
Hi...
How do I go about posting a question about MySQL?
I think you're getting the hang of it.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [
Just like you did this right now :)
Ales.
On 3/19/07, John Sutton <[EMAIL PROTECTED]> wrote:
Hi...
How do I go about posting a question about MySQL?
Thank you,
John Sutton
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi...
How do I go about posting a question about MySQL?
Thank you,
John Sutton
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
Some information you can find here:
http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html
http://dev.mysql.com/doc/refman/5.0/en/innodb-checkpoints.html
Have a look to innobase/log/log0log.c file in MySQL source distribution.
wangxu wrote:
> There are many information about di
There are many information about different logs in manual but innodb log file.
Please tell me where can i find it?
What's innodb log file different to binlog?
Where can i find data about redo and undo?
thanks
Hello.
>If "default-character-set" can't set in "[client]"?
The comprehensive explanations you will find at:
http://bugs.mysql.com/bug.php?id=11673
"wangxu" <[EMAIL PROTECTED]> wrote:
>Follow is a part of my my.ini.
>--
"default-character-set" can't set in "[client]"?
- Original Message -
From: "sheeri kritzer" <[EMAIL PROTECTED]>
To: "wangxu" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, November 18, 2005 5:44 AM
Subject: Re: a question of specifying Tim
What does your my.cnf configuration for mysql say? Check out:
http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html
I think you want "character_set" as your variable, not "default_character_set".
Just my guess, not seeing any of your config files.
-Sheeri
On 11/16/05, wangxu <[EMAIL
Hello.
If you want to enable large pages in the Linux kernel, run a quick
search in Google. I've found these links (ignore the 'DB2'
and 'oracle' in the URL:)
http://www.linux.com/howtos/DB2-HOWTO/kernels.shtml
http://linux.inet.hr/oracle10g_on_debian.html
Íõ Ðñ wrote:
> I learn
I learn configuring the mysql server in the manul 5.3.1.I notice there is a
parameter "--large pages".Please tell my how do i alter linux system memory
pages .
_
免费下载 MSN Explorer: http://explorer.msn.com/lccn
--
MySQL Gener
Hello.
Very often PREPARED STATEMENTS are helpful in similar situations. For a pity,
they are disabled in the current release. See:
http://dev.mysql.com/doc/mysql/en/sqlps.html
Leonardo Javier Belén wrote:
> Hi all,
> I am wondering if I can construct a query string inside a stored
@lists.mysql.com
Subject: A question about stored procedures
Hi all,
I am wondering if I can construct a query string inside a stored
procedure and then execute it. I mean, what I want to do is given a set of
IN parameters, be able to construct a huge where statement out of them an
then complete the
Hi all,
I am wondering if I can construct a query string inside a stored
procedure and then execute it. I mean, what I want to do is given a set of
IN parameters, be able to construct a huge where statement out of them an
then complete the query string to execute. Is that possible? because if t
Hello.
SERIALIZABLE is like REPEATABLE READ, but all plain SELECT statements are
implicitly converted to SELECT ... LOCK IN SHARE MODE. In REPEATABLE
READ statements like SELECT ... LOCK IN SHARE MODE that use a unique
index with a unique search condition lock only the index record found,
no
In the transaction isolation level,Database send some "duplicate entry"
message to me.
Why?
_
与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
Selon [EMAIL PROTECTED]:
> Mathias <[EMAIL PROTECTED]> wrote on 06/28/2005 01:11:59 PM:
>
> > Selon [EMAIL PROTECTED]:
> >
>
> >
> > Thanks Shawn, but i'm not speaking about data consistency during
> > transaction and
> > isolation levels.
> > I spoke about what is seen in the data dictionary as
Mathias <[EMAIL PROTECTED]> wrote on 06/28/2005 01:11:59 PM:
> Selon [EMAIL PROTECTED]:
>
>
> Thanks Shawn, but i'm not speaking about data consistency during
> transaction and
> isolation levels.
> I spoke about what is seen in the data dictionary as num_rows an why
> it can not
> be used ev
Selon [EMAIL PROTECTED]:
> Mathias <[EMAIL PROTECTED]> wrote on 06/28/2005 06:13:08 AM:
>
> > Selon Behrang Saeedzadeh <[EMAIL PROTECTED]>:
> >
> > > Mathias,
> > >
> > > Thanks a lot!
> > >
> > > > I will not explain the same thing for sqlserver, sybase ..., but
> when
> > > > your RDBMs
> > > >
Mathias <[EMAIL PROTECTED]> wrote on 06/28/2005 06:13:08 AM:
> Selon Behrang Saeedzadeh <[EMAIL PROTECTED]>:
>
> > Mathias,
> >
> > Thanks a lot!
> >
> > > I will not explain the same thing for sqlserver, sybase ..., but
when
> > > your RDBMs
> > > have a data dictionnary, you don't need to exec
Selon Behrang Saeedzadeh <[EMAIL PROTECTED]>:
> Mathias,
>
> Thanks a lot!
>
> > I will not explain the same thing for sqlserver, sybase ..., but when
> > your RDBMs
> > have a data dictionnary, you don't need to execute count(*) :o) WITH
> > Updated
> > statistics of course.
>
> I'm a little bit
Mathias,
Thanks a lot!
I will not explain the same thing for sqlserver, sybase ..., but when
your RDBMs
have a data dictionnary, you don't need to execute count(*) :o) WITH
Updated
statistics of course.
I'm a little bit confused here. Why the count(*) is not transformed to a
select from
Selon Behrang Saeedzadeh <[EMAIL PROTECTED]>:
> Hi all
>
> I was reading the High Performance MySQL book (by O'Reilly) and there
> was mentioned that executing a count(*) is slower on the InnoDB
> engine compared to the MyISAM engine, because InnoDB tables do not keep
> track of the number of the
Hello.
Complete information about licensing policy you can receive
from [EMAIL PROTECTED]
"Behrang Saeedzadeh" <[EMAIL PROTECTED]> wrote:
> Hi
>
> We've developed a J2EE application for one of our customers. Currently,
> the system uses SQLServer as the backend database. The databse sy
Hi
We've developed a J2EE application for one of our customers. Currently,
the system uses SQLServer as the backend database. The databse system
is not embedded with the J2EE application and we can safely switch to
other RDBMSes.
I wanted to know that if we change the RDBMS from SQLServer to MyS
Hi all
I was reading the High Performance MySQL book (by O'Reilly) and there
was mentioned that executing a count(*) is slower on the InnoDB
engine compared to the MyISAM engine, because InnoDB tables do not keep
track of the number of the records. I just wanted to know that if
this performance d
: Sunday, May 22, 2005 7:12 AM
To: mysql@lists.mysql.com
Subject: a question about MySQL installation
Dear,
I have installed MySQL4.1. But why it can not startup when I open my computer?
Also, how can I test MySQL can run or not? Thanks for your advice.
Best Regards,
Terry
--
MySQL General
Dear,
I have installed MySQL4.1. But why it can not startup when I open my computer?
Also, how can I test MySQL can run or not? Thanks for your advice.
Best Regards,
Terry
Thankyou,
That worked a treat! Thankyou so very much
--
David Scott
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Critters" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, May 17, 2005 5:01 PM
Subject: Re: A question of joining...
Critters
Critters wrote:
Hi,
I am having problems with the JOIN function.
MESSAGES
memberID_1, memberID_2, Message
MEMBERS
id, name
I can only manage to replace the "memberID_1" in MESSAGES with the "name" in MEMBERS, I
can not replace both memberID_1 and memberID_2 with "name".
Please can someone tell me
Hi,
I am having problems with the JOIN function.
MESSAGES
memberID_1, memberID_2, Message
MEMBERS
id, name
I can only manage to replace the "memberID_1" in MESSAGES with the "name" in
MEMBERS, I can not replace both memberID_1 and memberID_2 with "name".
Please can someone tell me what I shoul
[EMAIL PROTECTED] wrote:
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have a 2nd column where a result of 5 is 5
but -5 is also 5, so in effect all the negative (and only the negative)
results are made positive to find the deviation from zero.
ABS(column) ?
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 01, 2004 6:59 AM
Subject: A question of negative numbers..
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able t
<[EMAIL PROTECTED]> wrote on 01/09/2004 11:59:58:
> is there a function to make negative
> numbers positive?
ABS(x)
See http://dev.mysql.com/doc/mysql/en/Mathematical_functions.html
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Found answer to my own question:
Returns the absolute value of X:
mysql> SELECT ABS(2);
-> 2
mysql> SELECT ABS(-32);
-> 32
This function is safe to use with BIGINT values.
MySQL Reference Manual (C) 2002 MySQL AB
abs()
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 01, 2004 12:59 PM
Subject: A question of negative numbers..
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have a 2nd column where a result of 5 is 5 but -5 is also
5, so in effect all the negative (and only the negative) results are made positive to
find the deviation from zero.
so
5, 4, -3, 4, -1,
[mailto:[EMAIL PROTECTED]
Sent: Sunday, August 01, 2004 6:26 PM
To: bruce
Cc: [EMAIL PROTECTED]
Subject: Re: a question/issue...
On Sun, Aug 01, 2004 at 09:22:21AM -0700, bruce wrote:
> hi...
>
> i'm testing an app where i want a parent app to create the mysql db
> connection l
On Sun, Aug 01, 2004 at 09:22:21AM -0700, bruce wrote:
> hi...
>
> i'm testing an app where i want a parent app to create the mysql db
> connection link/handle, and basically pass this handle off to child
> procesess. is there any reason why this can't be done? are there any
> examples of this alr
;m inclined to believe that if you can create a db connection handle, then
> any other process should be able to use it, as long as the creating
> process/parent process is still alive/running
>
> -bruce
>
>
>
>
> -Original Message-
> From: Justin Swanhart [mailto:[EMAIL PR
hi...
i'm testing an app where i want a parent app to create the mysql db
connection link/handle, and basically pass this handle off to child
procesess. is there any reason why this can't be done? are there any
examples of this already being accomplished that you might provide???
as far as i can
hello , mysql . first,sorry for my poor english .
I'm used CRecordSet to connected database of mysql(linux) . Read source data no
error , but can't write data , has a "memory allocation error" error in used
CRecordSet::Update() . into debug , this error (
CATCH_ALL(e)
{
lResult = AfxGetT
On 02/25/2004 09:13 AM Frederic Wenzel wrote:
Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I want to make sure whether the following procedures are correct for database backup.
1. mysqldump -F --opt database_name > database_name.backup
In my opinion, you shou
on 02/27/2004 12:11 AM, Li, Lenny Yong Bo (Lenny) at [EMAIL PROTECTED]
wrote:
>
> 1. database backup.
> This is done on the standby one with the following command.
> mysqldump --opt --quote-names --flush-logs database_name > database.backup
How does this operations handle binary fields, password
t, R&D, Lucent Qingdao
[EMAIL PROTECTED] 86-532-8702000-5033
http://gdcsr60.gdc.lucent.com/~lennyli
> -Original Message-
> From: Frederic Wenzel [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 25, 2004 4:13 PM
> To: Li, Lenny Yong Bo (Lenny)
> Cc: [EMAIL PROTECTED
-
> From: Frederic Wenzel [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 25, 2004 4:13 PM
> To: Li, Lenny Yong Bo (Lenny)
> Cc: [EMAIL PROTECTED]
> Subject: Re: A question about mysql database backup.
>
>
> Li, Lenny Yong Bo (Lenny) wrote:
>
> > Now I am
Li, Lenny Yong Bo (Lenny) wrote:
> Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I
> want to make sure whether the following procedures are correct for database backup.
> 1. mysqldump -F --opt database_name > database_name.backup
In my opinion, you should gen
Ms./Sir,
Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I
want to make sure whether the following procedures are correct for database backup.
1. mysqldump -F --opt database_name > database_name.backup
2. stop mysqld if is running. Then start it with "--log-bin"
-->-Original Message-
-->From: Erik Osterman [mailto:[EMAIL PROTECTED]
-->Sent: Wednesday, November 12, 2003 4:05 AM
-->To: [EMAIL PROTECTED]
-->Subject: A question on INTERVAL
-->
-->
-->I would like to do something like this
-->
-->SELECT * FROM orde
I would like to do something like this
SELECT * FROM orders,subscriptions
WHERE orders.subscription_id = subscriptions.id
created < created - INTERVAL subscriptions.term subscriptions.unit;
But I get "ERROR 1064: You have an error in your SQL syntax near
'subscriptions.unit)
FYI
I want to share this with others JIC you didn't know. I asked a question
about slave compatibility between masters and slaves of different
versions. Here is the compatibility matrix chart found.
http://www.mysql.com/doc/en/Replication_Implementation.html
Master
Master
M
Hi!
I read mysql doc (4.0.5-beta.) and see this:
Note that upon connection, mysql_real_connect() sets the reconnect flag (part of the
MYSQL structure) to a value of 1. This flag indicates, in the event that a query
cannot be performed because of a lost connection, to try reconnecting to the serve
tin
- Original Message -
From: "Li Yang" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Thursday, April 03, 2003 7:32 PM
Subject: A question about using C API in mysql (linux platform)
Hi, I'm a newbie to MySQL
Now I am using C to connect mysql
Hi, I'm a newbie to MySQL
Now I am using C to connect mysql in Linux
The heaser souce code like:
#include
#include
#include
and After I use "gcc test.c -L /usr/local/mysql/lib/ -shared " to compile it , and
when I run the a.out ,it always say that "Segmentation Fault
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 29 January 2003 5:11 PM
To: Inmate 67859432
Subject: Re: just a question.
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter
] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 09, 2003 5:01 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: May I raise a question?
Thanks, Gerald,
I'm trying to install the MySQL. Apache & Php in Windows 2000 Professional.
A
book telling me that
Dear all,
Your endeavour and speedy action impress me. Thanks.
Seed Chan
-Original Message-
From: admin [SMTP:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 3:11 PM
To: Chan, Seed; gerald.clark
Cc: admin; mysql
Subject: Re: May I raise a question?
- Original Message -
From
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 2:00 AM
Subject: RE: May I raise a question?
> Thanks, Gerald,
>
> I'm trying to install t
y I raise a question?
What OS are you running?
Did you start the server?
What is in the error logs?
[EMAIL PROTECTED] wrote:
>Dear Editor,
>
>After installed the MySQL version 3.23.53, I tried to test the MySQL by
>typing the following command, relevant error message appears, plea
Your mysql server does not seem to be running...
Did you execute safe_mysqld ?
Check the "Post installation setup" chapter from the manual.
http://www.mysql.com/doc/en/Post-installation.html
On Thu, 2003-01-09 at 01:16, [EMAIL PROTECTED] wrote:
> Dear Editor,
>
> After installed the MySQL versi
On Thursday 09 January 2003 03:16, seed dot chan at citicorp dot com wrote:
> After installed the MySQL version 3.23.53, I tried to test the MySQL by
> typing the following command, relevant error message appears, please advise
> how to fix.
>
> Command: Display Error Message:
>
>
What OS are you running?
Did you start the server?
What is in the error logs?
[EMAIL PROTECTED] wrote:
Dear Editor,
After installed the MySQL version 3.23.53, I tried to test the MySQL by
typing the following command, relevant error message appears, please advise
how to fix.
Command:
Dear Editor,
After installed the MySQL version 3.23.53, I tried to test the MySQL by
typing the following command, relevant error message appears, please advise
how to fix.
Command: Display Error Message:
mysqlshowmysqlshow: Can't connect to MySQL server on
'local
Hello, I am new to the list, I've subscribed in last ressort when I couldn't
find an answer, neither the web or the list archives...
I've had a question from a client that I've answered in this way :
"
> One other question, when you have built the
> database, will
Hi,
I am trying to comile a c++ program but I got an error message as below:
sqlplus.hh: No such file or directory
I have mysql server and client 3.23... on rh 7.2 and I have installed binary
RPM for SuSE 8.* built by gcc 3.2
<../Downloads/mysql++/mysql++-1.7.9gcc3.2-2.i386.rpm>
by: rpm -ivh "my
From: svens [mailto:[EMAIL PROTECTED]]
Sent: 29 October 2002 12:52
To: [EMAIL PROTECTED]
Subject: jus a question about tables
So I have question.
is it ok if I put all data in one table by days (by date)
in resul I will have lot of rows
day 20021025 - 45000 rows
day 20021026 - 23445 rows
d
So I have question.
is it ok if I put all data in one table by days (by date)
in resul I will have lot of rows
day 20021025 - 45000 rows
day 20021026 - 23445 rows
day 20021027 - 389023 rows
day 20021028 - 78632 rows
total = 536100 rows of data
I count web page hits and hosts by hourly rotat
Hi,
I was having problems because I had to rename my slave sever. Now I think I
understand the problem better. I looked in slave.cc and found my error
message and can see that it only applies to the slave. So I guess that
brings up two issues.
1. Why can't the relay-log deal with the name change
j.random.programmer wrote:
> Hi:
>
> Firstly, I'd like to congratulate both MySQL AB and
> Mr. Mathews on making the JDBC driver an officialy
> supported download.
>
> I have a query though. Newer versions of the mm.mysql
> driver (now called connector/j) will be released *not*
> under the LGPL
On Monday 19 August 2002 07:21 am, Nicolas Ivering wrote:
Several things spring to mind here...
1st of all when you use JDBC, you're coding to the JDBC interface, not to any
proprietary interface (IE, your application could just as well call a
PostgreSQL JDBC driver and it would not need to be
I'm not from an official source but I would imagine the reason for the
change of license is to be able to charge for a non-GPL version of the
driver. With that in mind it wouldn't make much sence if you could use
the driver with a non-GPL program without making the program GLP also
(and thus a
Hi:
Firstly, I'd like to congratulate both MySQL AB and
Mr. Mathews on making the JDBC driver an officialy
supported download.
I have a query though. Newer versions of the mm.mysql
driver (now called connector/j) will be released *not*
under the LGPL but under the GPL.
Now if I am using the my
* Jones Tyler
> My problem is that I am unable to change data in an
> existing table. I use the UPDATE function and it
> continues to tell me that I am using an Unknown
> Column.
That's right, you are... :)
> When I do a DESCRIBE on the table, I clearly see the
> column.
>
> Since I can see the
the format
of a table, which is not my goal...yet=)
--- Oscar Rylin <[EMAIL PROTECTED]> wrote:
> From: "Oscar Rylin" <[EMAIL PROTECTED]>
> To: "'Jones Tyler'" <[EMAIL PROTECTED]>
> Subject: RE: Newbie With a Question
> Date: Wed, 14
I downloaded mysql win 32 1.75-2 and downloaded the GUI for it. How do I
tie the SDK to the gui? Pardon me if this sounds vague.
AMeet
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
Andrew,
Friday, April 26, 2002, 3:12:25 AM, you wrote:
AW> Hello, I am new to mysql - past the very basics - you may see a few silly
AW> questions - here is the first.
AW> I have a DELETE statement:
AW> delete bond_master,bond_data from bond_data where
AW> bond_master.cusip=bond_data.cusip an
Hello, I am new to mysql - past the very basics - you may see a few silly
questions - here is the first.
I have a DELETE statement:
delete bond_master,bond_data from bond_data where
bond_master.cusip=bond_data.cusip and bond_master.maturity <= "2002/02/15";
That has syntax errors. I am issu
On Fri, Sep 07, 2001 at 07:19:01AM -0700, Mike Wexler wrote:
>
> Jeremy Zawodny wrote:
> >
> > On Fri, Sep 07, 2001 at 12:07:07PM +0100, Basil Hussain wrote:
> > >
> > > I'm quite surprised that this level of performance is available from
> > > such standard (well, not standard as in 'common', b
Hi,
> > On the other hand though, it gives me some comfort that the hardware
> > being used in my operation will meet any future needs. We have
> > similar spec servers (P3-1Ghz dual-cpu, 512Mb RAM, 3x36Gb SCSI
> > RAID5). Maybe I should try out mysql-super-smack and see what kind
> > of numbers
Jeremy Zawodny wrote:
>
> On Fri, Sep 07, 2001 at 12:07:07PM +0100, Basil Hussain wrote:
> >
> > I'm quite surprised that this level of performance is available from
> > such standard (well, not standard as in 'common', but y'know what I
> > mean...) hardware. The last I heard, 1K+ queries/sec
1 - 100 of 130 matches
Mail list logo
