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
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.
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 provide
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 :
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
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 because
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
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
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
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 you to
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
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
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
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_ apache2
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 MySQL
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
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
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
stopped the mysql
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]
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
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
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
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 book
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 looks
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
--
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] -
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
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; the
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]
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
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 detail.
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
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 and ranting
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
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
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
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 2%
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
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
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
41 matches
Mail list logo