Hello:
Does this mean that MySQL is headed for closed source?
re: Sun buys MySQL.
And does it mean that someone may be wanting back licensing
fees?
Just curious, and too lazy to chase down links and stories.
Jeff K
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
But my test result is different with you,here is my test
mysql> truncate table c_t;
Query OK, 0 rows affected (0.00 sec)
mysql> load data infile '/tmp/Book1.csv' into table c_t fields
terminated by ',' lines terminated by 'w';
Query OK, 1 row affected (0.00 sec)
Records: 1 Deleted: 0 Skipped: 0
Hey all,
I'm curious if anyone has any thoughts on how I can handle a data
retention issue I've been facing with a larger dataset.
My process, roughtly is run mysqldump against the DB and gzip the
output. Then I transfer it off to a different machine for archival
onto optical media (yes I
Hi Paul,
On Jan 16, 2008 12:19 PM, Paul Berry <[EMAIL PROTECTED]> wrote:
> hi there, sorry if this email doesn't follow policy correctly, its my first
> post here.
>
> we had a master/slave setup between 2 servers and 98% of the data seems to
> have moved correctly, but there is a seemingly random
hi there, sorry if this email doesn't follow policy correctly, its my first
post here.
we had a master/slave setup between 2 servers and 98% of the data seems to
have moved correctly, but there is a seemingly random 2% that didn't arrive
in the right way. for example records with a higher ID are t
http://mysql.com/news-and-events/sun-to-acquire-mysql.html
--
/Brett C. Harvey;
/Creative-Pages.Net, President;
/Facility Management Systems, CTO (www.waldo.com/www.fmsystems.biz);
/Lasso Professional Alliance Member
I tend to think this blogger is correct:
"Sun is directly competing with Red Hat to become the heart of the
open-source business community." And "Oracle may be in for a fight ..."
http://blogs.cnet.com/8301-13505_1-9851662-16.html
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
> > Searching on-line is surprisingly unhelpful; the only things I've found
so
> > far which looks half-sensible are "Database is Depth" by Chris Date, and
> > "Expert mySQL" by Charles A. Bell (which looks more practical rather
than
> > theoretical).
>
> I have that book by Date. Heavy on theory
Hi,
I have a partitioned table using hash. For the example lets say I have N
partitions. Selects perform well due to the partitioning. However I noticed
that inserts and updates slow down considerably when the number of
partitions goes up. (I think because if needs to inspect / open all
partiti
On Jan 16, 2008 10:35 AM, mos <[EMAIL PROTECTED]> wrote:
> Baron,
> I'm glad to hear there is going to be an update to "High Performance
> MySQL". What MySQL versions will it cover and is there a table of contents
> available online? TIA
It covers what we know well, which is 5.0, in great de
1) 'mysqldump' all databases to an SQL file
2) Drop all databases
3) Shutdown mysqld
4) Delete the ibdata1, ib_logfile0, ib_logfile1
5) Add innodb_file_per_table to my.cnf (which you already did)
6) Make sure you gave this setting in [mysqld] group of my.cnf
innodb_data_file_path=ibdata1:10M:autoe
Dear Monty and David
If you're surfing this listCongrats! You guys deserve every bit of it.
Best,
Michael
[EMAIL PROTECTED] wrote:
I was lurking on Sun's website.. they are also carrying PostgreSQL in
their line of products.. Great!!
-Original Message-
From: [EMAIL PROTECTED] [mail
At 08:54 AM 1/16/2008, Baron Schwartz wrote:
On Jan 16, 2008 9:40 AM, Toby Douglass <[EMAIL PROTECTED]> wrote:
> I'm currently applying for a developer job with mySQL.
>
> I want to improve my database theory knowledge.
>
> Any book recommendations?
>
> Searching on-line is surprisingly unhelpful
I was lurking on Sun's website.. they are also carrying PostgreSQL in
their line of products.. Great!!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 16, 2008 10:07 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject
Oracle and Sun has a tight relationship right? Wouldn't there be a
conflict of interest?
-Original Message-
From: Sebastian Mendel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 16, 2008 10:03 AM
To: [EMAIL PROTECTED]
Cc: Jerome O. Macaranas; mysql@lists.mysql.com
Subject: [SPAM] -
Richard Heyes schrieb:
Will this bring good things to MySQL?
$800,000,000 tends to bring good things. Hopefully. :-)
??? why, this payment goes to current owners and investors, not to MySQL
itself ...
but anyway, using Suns structures and "power" will help of course ...
--
Sebastian
--
On Jan 16, 2008 9:40 AM, Toby Douglass <[EMAIL PROTECTED]> wrote:
> I'm currently applying for a developer job with mySQL.
>
> I want to improve my database theory knowledge.
>
> Any book recommendations?
>
> Searching on-line is surprisingly unhelpful; the only things I've found so
> far which loo
Not necessarily theory but very good if you want to work with mysql is the
mysql 5.0 certification guide
olaf
On 1/16/08 9:40 AM, "Toby Douglass" <[EMAIL PROTECTED]> wrote:
> I'm currently applying for a developer job with mySQL.
>
> I want to improve my database theory knowledge.
>
> Any boo
I'm currently applying for a developer job with mySQL.
I want to improve my database theory knowledge.
Any book recommendations?
Searching on-line is surprisingly unhelpful; the only things I've found so
far which looks half-sensible are "Database is Depth" by Chris Date, and
"Expert mySQL" by C
Will this bring good things to MySQL?
$800,000,000 tends to bring good things. Hopefully. :-)
--
Richard Heyes
http://www.websupportsolutions.co.uk
Mailing list management service allowing you to reach your Customers
and increase your sales.
** NOW OFFERING FREE ACCOUNTS TO CHARITIES AND NON-
Big fish eats the small fish.. :)
Will this bring good things to MySQL?
-Original Message-
From: John Meyer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 16, 2008 8:58 AM
To: Brett Harvey; mysql@lists.mysql.com
Subject: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject
Bre
Brett Harvey wrote:
http://www.reuters.com/article/mergersNews/idUSWNAS661820080116
No offense, but this is definitely not off topic when it comes to MySQL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
no errors are there in log file
On Jan 16, 2008 6:38 PM, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Hi,
>
> On Jan 16, 2008 7:52 AM, Krishna Chandra Prajapati
> <[EMAIL PROTECTED]> wrote:
> > Hi all,
> >
> > In order to reclaim the free space from mysql innodb storage engine. I
> have
> > stoppe
http://www.reuters.com/article/mergersNews/idUSWNAS661820080116
--
/Brett C. Harvey;
/Creative-Pages.Net, President;
/Facility Management Systems, CTO (www.waldo.com/www.fmsystems.biz);
/Lasso Professional Alliance Me
Hi,
On Jan 16, 2008 7:52 AM, Krishna Chandra Prajapati
<[EMAIL PROTECTED]> wrote:
> Hi all,
>
> In order to reclaim the free space from mysql innodb storage engine. I have
> stopped the mysql server, remove all the things from data (to create new
> datadirectory and log files) directory, added inn
Hi,
On Jan 16, 2008 5:13 AM, Richard Heyes <[EMAIL PROTECTED]> wrote:
> > I think it's the same.
>
> I seem to remember that a BIGINT id two INTs tacked together, so how is
> that possible?
MySQL uses BIGINT for most internal math. The data types influence
only how the data is stored, not how My
Hi,
On Jan 16, 2008 3:36 AM, MAS! <[EMAIL PROTECTED]> wrote:
>
> Il giorno 16 gen 2008, alle ore 02:59, Moon's Father ha scritto:
>
> > Post your error message here.
>
> (from php)
>
> Error message: mysql_connect(): Lost connection to MySQL server
> during query
>
> and I have that for _each_ apa
Hi all,
In order to reclaim the free space from mysql innodb storage engine. I have
stopped the mysql server, remove all the things from data (to create new
datadirectory and log files) directory, added innodb_file_per_table
component in my.cnf. Restarted mysql server. After restarting mysql -serv
I think it's the same.
I seem to remember that a BIGINT id two INTs tacked together, so how is
that possible?
--
Richard Heyes
http://www.websupportsolutions.co.uk
Mailing list management service allowing you to reach your Customers
and increase your sales.
** NOW OFFERING FREE ACCOUNTS TO
I think it's the same.
On Jan 16, 2008 6:03 PM, Richard Heyes <[EMAIL PROTECTED]> wrote:
> Performance wise, what is a BIGINT like in comparison to an INT on a 32
> bit machine?
>
> Thanks.
>
> --
> Richard Heyes
> http://www.websupportsolutions.co.uk
>
> Mailing list management service allowing
Performance wise, what is a BIGINT like in comparison to an INT on a 32
bit machine?
Thanks.
--
Richard Heyes
http://www.websupportsolutions.co.uk
Mailing list management service allowing you to reach your Customers
and increase your sales.
** NOW OFFERING FREE ACCOUNTS TO CHARITIES AND NON-P
MAS! napsal(a):
can you post values of wait_timeout and interactive_timeout
variables. You can get them from SHOW VARIABLES output. If they are
set to 3600 (1 hour in secs), set them to something bigger like one
week and then you will see if it helps or not. You can read more about
+-
Daevid Vincent schrieb:
Huh? This doesn't make any sense to me.
If I'm running a LAMP box (all services on the same box), and my PHP calls
out to the mySQL database, I would expect it to use the fastest method
possible (since it's LOCAL). If that's sockets, then that's what it should
use. I wo
can you post values of wait_timeout and interactive_timeout
variables. You can get them from SHOW VARIABLES output. If they are
set to 3600 (1 hour in secs), set them to something bigger like one
week and then you will see if it helps or not. You can read more about
+---
Marco,
can you post values of wait_timeout and interactive_timeout variables.
You can get them from SHOW VARIABLES output. If they are set to 3600 (1
hour in secs), set them to something bigger like one week and then you
will see if it helps or not. You can read more about those timeouts also
You should give me an error message here.
On Jan 16, 2008 4:44 PM, MAS! <[EMAIL PROTECTED]> wrote:
> > Enter your mysql shell and enter the command:
> > set global max_allowed_packet=10M
>
> I have it setted at 32M, but that is not the problem; the data are
> not too much ...
>
> and it's strange
Enter your mysql shell and enter the command:
set global max_allowed_packet=10M
I have it setted at 32M, but that is not the problem; the data are
not too much ...
and it's strange because _ALL_ clients seems to died/be disconnected
each hour, when the hourly cron runs..
--
MySQL Gener
This means you should take care of the routine replication of this section.
On Jan 13, 2008 6:04 PM, gengxy-douban <[EMAIL PROTECTED]> wrote:
> With MySQL's classic statement-based replication, there may be issues with
> replicating stored routines or triggers
>
> from : http://dev.mysql.com/doc/r
Cursors can fetch from procedure.
On Jan 10, 2008 1:36 AM, Robert DiFalco <[EMAIL PROTECTED]> wrote:
> A while back there was a general consensus that useCursorFetch (with
> useServerPrepStmts) was somehow flakey?
>
> Is this still the case? I had heard from someone that MySQL will not
> even pro
Enter your mysql shell and enter the command:
set global max_allowed_packet=10M
The value of the variable can be set whatever you want .
On Jan 16, 2008 4:36 PM, MAS! <[EMAIL PROTECTED]> wrote:
>
> Il giorno 16 gen 2008, alle ore 02:59, Moon's Father ha scritto:
>
> > Post your error message here
Il giorno 16 gen 2008, alle ore 02:59, Moon's Father ha scritto:
Post your error message here.
(from php)
Error message: mysql_connect(): Lost connection to MySQL server
during query
and I have that for _each_ apache2 thread/php-page opened
MAS!
--
MySQL General Mailing List
For list
41 matches
Mail list logo
