2012/03/27 12:33 +0200, Johan De Meersman
MySQL does have a proper CSV engine; and it's mystifying why it isnt'
accessible in any other way. I say "engine", and you can take that literally:
just like you have MyISAM and InnoDB engines, CSV is also an engine that is
applicable to tables
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 ty
On Tue, Mar 27, 2012 at 3:43 PM, Dan Nelson 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 what
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 GPL-l
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 | 8
Hi Rick
Thank you for replying.
Please see my answers to your questions.
On Tue, Mar 27, 2012 at 7:58 PM, Rick James wrote:
> Do you have 12GB of RAM?
total used free sharedbuffers cached
Mem: 12038 11959 78 0139 1
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?
>
> s
2012/3/27 Halász Sándor :
> 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)
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 mu
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 '/e
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
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,
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
wrote:
> Hi,
>
> I
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 server
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
key_buffer_size=8
- Original Message -
> From: "Kinaan Khan Sherwani"
>
> 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.
>
> I want to
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 wrote:
> Hey Guy
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
- Original Message -
> From: "Cifer Lee"
>
> 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 it
in your
- Original Message -
> From: "Halász Sándor"
>
> 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 have a
it seems none of you hava answered my question.
On Tue, Mar 27, 2012 at 7:01 AM, Walter Tross wrote:
> 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 products have made in
21 matches
Mail list logo
