it seems none of you hava answered my question.
On Tue, Mar 27, 2012 at 7:01 AM, Walter Tross wal...@waltertross.comwrote:
Harald,
keep in mind that
a) this mailing list is badly set up: unless you do a reply all, the
reply goes only to the poster (happened to me too)
b) Microsoft
- Original Message -
From: Halász Sándor h...@tbbs.net
input for Word (yes, I have to work MySQL CSV-ish output into real
CSV, ensuring that there are no escapes in it, nor 'NULL' either).
And this is why it's beneficial to specify your goal along with your question
:-)
MySQL does
- Original Message -
From: Cifer Lee mantia...@gmail.com
it seems none of you hava answered my question.
Yes, that happens :-)
I'm slightly confused as to the difference between user variables and local
variables, though. Are you saying you couldn't just declare @myvar and use
Hey Guys
Yesterday I sent an email, about '1 client is using or hasn't closed the table
properly', but the problem is actually bigger than I realised.
We run Mysql replication, and on the second node, Mysql is crashing with
'mysqld got signal 6' every so often.
Other than the drives, we have
HI Brent,
Can you please paste your configuration file settings (my.cnf) ? It will
help to identify where things went wrong.
Is there any other memory consuming application running on the server
beyond mysql ?
Regards,
KarthiK.P.R
On Tue, Mar 27, 2012 at 4:17 PM, Brent Clark
- Original Message -
From: Kinaan Khan Sherwani mr.sherw...@gmail.com
that MySQL server keeps data dictionary information in .frm files
which it stores in the database directories, whereas InnoDB also stores
the information into its own data dictionary inside the table space files.
Good day KarthiK.P.R
Other than the replication settings in '/etc/mysql/conf.d/replication.cnf' and
our /etc/mysql/conf.d/custom.cnf
xyz-web02:/data# cat /etc/mysql/conf.d/custom.cnf
[mysqld]
innodb_file_per_table
bind-address = 0.0.0.0
datadir = /data
binlog_format=mixed
Hi,
I created Parallel Universe which is a MySQL 5.5 compatible server with fast
query execution.
Speed is achieved by processing tables in parallel utilizing multi core/CPU
server hardware.
Pre-release field evaluation is being conducted and MySQL users are solicited
to try out the new
The license of this software is unclear. The binary is clearly derived
from the MySQL server with InnoDB, but no source code is provided. Is
the software GPL-licensed? If so, where can I get a copy of the source
code?
- Baron
On Tue, Mar 27, 2012 at 10:26 AM, Hiromichi Watari
Thanks Baron. I downloaded it and found it was dervied from the MySQL
server as well. I was looking for the source and found nothing. Mr. Watari,
is there source code available? Since you are using GPL source code in your
code, you must provide the source code.
S
On Tue, Mar 27, 2012 at 10:40,
2012/03/27 00:22 +0200, Walter Tross
it looks like it's as simple as this:
insert into mytable (mycolumn) values (0xE29C94), (0xE29C98)
In some contexts it might be necessary to force the character set like this,
though:
convert(0xE29C94 using utf8)
Yes! and with this I can use it for a
Do you have 12GB of RAM?
Is this a 64-bit mysqld?
Let's see
SHOW VARIABLES LIKE '%buffer%';
SHOW GLOBAL STATUS LIKE 'Max%';
SHOW GLOBAL STATUS LIKE 'Up%';
What is Apache's MaxClients?
On 3/27/12 6:25 AM, Brent Clark wrote:
Good day KarthiK.P.R
Other than the replication settings in
Please elaborate on what conditions your server will/won't process
queries in parallel.
On 3/27/12 7:26 AM, Hiromichi Watari wrote:
Hi,
I created Parallel Universe which is a MySQL 5.5 compatible server with fast
query execution.
Speed is achieved by processing tables in parallel utilizing
2012/3/27 Halász Sándor h...@tbbs.net:
2012/03/27 00:22 +0200, Walter Tross
it looks like it's as simple as this:
insert into mytable (mycolumn) values (0xE29C94), (0xE29C98)
In some contexts it might be necessary to force the character set like this,
though:
convert(0xE29C94 using utf8)
In the last episode (Mar 27), Paul Halliday said:
Say I have:
SELECT COUNT(name), name, COUNT(DISTINCT(status)) FROM table GROUP BY name
and it returns:
20 paul 5
19 john 2
75 mark 3
is there a way to return what comprises DISTINCT(status) as part of the
result?
so:
20 paul
Hi Rick
Thank you for replying.
Please see my answers to your questions.
On Tue, Mar 27, 2012 at 7:58 PM, Rick James rja...@yahoo-inc.com wrote:
Do you have 12GB of RAM?
total used free sharedbuffers cached
Mem: 12038 11959 78
MaxClients 1000
could overwhelm max_connections = 41 . Strongly recommend you decrease
MaxClients to less than max_connections (not the other way around).
Uptime| 18492
Not very long to see stuff.
| innodb_buffer_pool_size | 8388608 |
| key_buffer_size |
Guys, really...
Is this a binary release? Need to sudo to root? Not on my watch!
On Tue, March 27, 2012 16:40, Baron Schwartz wrote:
The license of this software is unclear. The binary is clearly derived from
the MySQL server
with InnoDB, but no source code is provided. Is the software
On Tue, Mar 27, 2012 at 3:43 PM, Dan Nelson dnel...@allantgroup.com wrote:
In the last episode (Mar 27), Paul Halliday said:
Say I have:
SELECT COUNT(name), name, COUNT(DISTINCT(status)) FROM table GROUP BY name
and it returns:
20 paul 5
19 john 2
75 mark 3
is there a way to return
Am 27.03.2012 23:24, schrieb Rick James:
MaxClients 1000
could overwhelm max_connections = 41 . Strongly recommend you decrease
MaxClients to less than max_connections
(not the other way around).
totally wrong!
not every http-connection implies a myql-connection
a website
20 matches
Mail list logo