How to set OS disk quota?
On 2015/9/6 17:52, Reindl Harald wrote:
set OS disk quota for them
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hi,
If disk quota is reached, an error can be threw out. we can accept this
policy. Thanks.
On 2015/9/6 17:28, Reindl Harald wrote:
Am 06.09.2015 um 11:08 schrieb Ken Peng:
We have some instances running in a hardware server, each instance has
different port.
For quota limits, we can
Hello,
We have some instances running in a hardware server, each instance has
different port.
For quota limits, we can adjust my.cnf to control each instance's memory
usage, also can use cgroups to set CPU quota.
But what's the general solution to setup the disk quota? For example, I
want
he same host as the mysql server? if not, google
>> the docs for 'local infile'
>>
>
> yes. my laptop.
>
>
>
>
>
>> On 2012-10-16 10:45 PM, "Lixun Peng" wrote:
>>
>> Hi,
>>
>> What's the dir permissions?
>>
&
Hi,
What query is running? Is web server and DB server in the same server? Have
something in error.log of MySQL?
On Wed, Oct 17, 2012 at 10:32 AM, ad...@canadianinvestors.com <
ad...@canadianinvestors.com> wrote:
> Hi,
>
> I run www.canadianinvestors.com and am getting this error message.
>
> Wa
Hi,
What's the dir permissions?
For example, if we have a file in /a/b/file, dir a is 644, even though file
is 777, we can't access file, too.
On Wed, Oct 17, 2012 at 10:31 AM, kalin wrote:
>
>
> hi all..
>
> this hasn't happened before...
>
> i'm in as root on the command line cleint. trying
Hi,
If you are using Percona Server, you can use this query:
SELECT DISTINCT s.table_schema,
s.table_name,
s.index_name
FROM information_schema.statistics `s`
LEFT JOIN information_schema.index_statistics indxs
ON ( s.table_schema = indxs.table_sc
sign
the schema automatically from DTD. Does anybody have some suggestions?
http://www.nlm.nih.gov/databases/dtd/nlmmedlinecitationset_110101.dtd
--
Regards,
Peng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
the
database file level using something like unison. However, this will be
slow when the database file gets bigger. But I'm wondering what is the
best way to synchronize mysql databases in the scenario that I just
mentioned.
--
Regards,
Peng
--
MySQL General Mailing List
For list archives:
can create a table column like this?
--
Regards,
Peng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
/bin/env bash
mysql -t -hlocalhost -uxxx < main.sql
~/linux/test/mysql/mysql/LOAD_DATA/CHARACTER_SET$ ./main.sh
+--+
| name |
+--+
| βΒ |
+--+
2011/10/16 Peng Yu :
> Hi,
>
> I have the greek character "Β" (not that it is different from the
> English charact
ring what charset I should
for this greek letter.
--
Regards,
Peng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
LOSED BY '"'; -- ESCAPED BY '"';
Query OK, 5 rows affected, 7 warnings (0.03 sec)
Records: 5 Deleted: 0 Skipped: 0 Warnings: 7
--
Regards,
Peng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
7 | birthday | Gave him a new flea collar |
| Whistler | 1998-12-09 | birthday | First birthday |
+--++--+-+
10 rows in set (0.03 sec)
--
Regards,
Peng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
On Sun, Oct 9, 2011 at 10:33 AM, Peng Yu wrote:
> Hi,
>
> I'm not able to connect to downloads.mysql.com. Is it down?
I guess the problem is that this website is too slow for a browser
(like firefox) to download (it takes too long to initiate the
transaction because the browser f
er names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
--
Regards,
Peng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
wo URLs. I guess either links
on http://dev.mysql.com/doc/ should be fixed or downloads.mysql.com
should be fixed.
On Sun, Oct 9, 2011 at 10:47 AM, Carlos Proal wrote:
> Downloads are available in http://dev.mysql.com/downloads
>
> Carlos
>
>
> On Sun, Oct 9, 2011 at 10:33
Hi,
I'm not able to connect to downloads.mysql.com. Is it down?
--
Regards,
Peng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
-A
mysql> select geneName as symbol, name as refSeq, chrom, strand,
txStart, txEnd from refFlat group by refSeq having count(*)=1;
ERROR 1 (HY000): Can't create/write to file
'/var/lib/mysql/#sql_9e1_0.MYI' (Errcode: 13)
--
Regards,
Peng
--
MySQL General Mailing
up by refSeq having count(*)=1);
--
Regards,
Peng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I seems that mysql and may SQL has only two levels databases->tables.
Where there many tables, it become hard to properly name the tables
and databases. I'm wondering if there is any variant of SQL or some
other database that support arbitrary levels of complexity.
--
Regards,
Peng
-
It seems that there is no direct support to limit 'select' to only the
first N rows in a table. Could you let me know what the best way
select rows from the first N rows in a table is?
--
Regards,
Peng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
om a_table where min(col1, col2) >= max(col3,col4)
I could expand the above expression to just using primitive
comparisons. But it would not be very readable. I'm wondering if there
is a better way to do so in sql.
--
Regards,
Peng
--
MySQL General Mailing List
For list archives: http://lis
hello erveryone, I have a question about mysqldump.I have some blob data,
someone tell me mysqldump the data must use "hex-blob" options, why?
Hi,
I try to configure mysql-connector-odbc-5.1.5r1144, But I got the
following error. Can somebody let me know where to download the
package which includes sqlext.h?
Regards,
Peng
checking whether the f95 linker (/home/pengy/utility/linux/bin/ld -m
elf_x86_64) supports shared libraries... yes
Warning: Can't create database 'spreadsheets'; database exists
This is the answer.
2009/8/24 Victor Subervi
> Hi,
> I have the following python code:
>
> cursor.execute('create database if not exists spreadsheets;')
> cursor.execute('use spreadsheets;')
>
> but it generates this warning:
>
>
you also can do this:#sudo -u mysql "mysqldump command"
or
#su - mysql -c "mysqldump command"
2009/7/24 walter harms
>
>
> muhammad subair schrieb:
> > On Thu, Jul 23, 2009 at 10:10 PM, walter harms wrote:
> >
> >> Hi list,
> >> i use mysqldump --tab to create database dumps. this will prod
# chown mysql.mysql datafile
2009/7/23 walter harms
> Hi list,
> i use mysqldump --tab to create database dumps. this will produce txt and
> sql files.
> the resulting sql files is owned by the user but the resulting datafile is
> owned by mysql.mysql
> is there any way to change that ?
>
> r
#mysqldump -u username -p -h mysqld_host databasename > database_name.sql
username is the mysqld server login name
mysqld_host is the mysqld server address or hostname
databasename is the database which you should dump
You can use "man mysqldump" or "mysqldump --help" to get more infomation
2009/
On Dec 22, 2007 10:55 AM, Moon's Father <[EMAIL PROTECTED]> wrote:
> how big your mysql connections's users.
How big users? don't know what you said.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Dec 21, 2007 7:45 PM, Moon's Father <[EMAIL PROTECTED]> wrote:
> If you know ,just tell me,thanks.
> etc.
> declare cnt int default 0;
> How can I know what type the variabe cnt is?
>
Can't 'desc table' show what you want?
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
;
my $iso_str = encode('iso-8859-1',decode('utf8',$utf8_str));
first you select utf8 string from db one by one and store it to
$utf8_str,then use the function above to be converted to iso-8859-1,then
insert it again to mysql.
--
Ken Peng
[EMAIL PROTECTE
ly,but each directive is 2G.
Is this right for a 32bit system?Thanks.
--
Ken Peng
[EMAIL PROTECTED]
--
http://www.fastmail.fm - I mean, what is it about a decent email service?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ire mysqld server including its child,modules should
only use 4G memory?
If so,the config below for 32 bit OS is may wrong,is it?Thanks.
key_buffer_size=2G
innodb_buffer_pool_size=2G
--
Ken Peng
[EMAIL PROTECTED]
--
http://www.fastmail.fm - The way an email service should be
--
MySQL
Hi everyone,
How to change the log file path of a database. I am using Window XP OS.
Thanks.
Peng
Hi,
I would like to change the path of a database's log. Which command I should
choose?
Thanks.
Peng
The schema of your contract should be like this:
Contract (id, level, ...)
where column 'id' is the primary key, isn't it?
If so, you can try this:
SELECT COUNT(id)
FROM contract
GROUP BY level
- Original Message -
From: "Jay" <[EMAIL PROTECTED]>
To:
Sent: Thursday, May 11, 2006 5:4
Hi,
It seems that ISO do not support SQL:2003 standard for free but I really need a
copy. Does anyone know where I can download it? Or does anyone have it?
Any type will be just OK.
Peng
Does anyone know where to download the 'Err Nr. Description'? pdf is best.
Peng
>Description:
High Resolution Science Imaging experiment(HiRISE) project for one of
important instrument on MRO spacecraft which will be launched to MAR in
2005 are using MySQL server 4.0.13 as database management system.
we recently encounter a unstable privilege problem.what we do like that:
(1)
hi,
Does anyone has any idea to improve this situation?
When I show my processlist, there is inner join query that having "Copying
to tmp Table" state, and it takes quite long time to finish the query. Any
idea to avoid Copying to tmp Table? I have tried to increase my
tmp_table_size however it do
I am using mysql 4.0 on linux and mm.mysql 2.0.11, however I can't access
mysql from java application.
try {
Class.forName( "org.gjt.mm.mysql.Driver" ).newInstance();
Connection connection = DriverManager.getConnection
("jdbc:mysql://localhost/test?user=xxx&password=yyy" )
ompiler accept those flags. Are those flags
included in some standards? My problem is that I don't want the mysqld
"crashed randomly" when I do benchmarking on it.
>
> And greetings to a fellow UofA student (though I've now graduated).
thank you. I am honored.
that? And why throw-catch stuff is not performance
friendly (just because the exception handling mechanism? but usually
exceptions are very rare, there is no need to avoid exception, from this
point of view)?
thanks.
be used). I want to find a workaround for this issue,
but first I need to know why these flags are needed.
Can you explain me this? Can I eliminate these options and make mysql still
runs well?
thanks.
P
ix:
>Submitter-Id:
>Originator:
>Organization:
Regards
Peng
--
Peng Zhao [EMAIL PROTECTED]
http://www.cs.ualberta.ca/~pengzhao
TEL (Lab): (780)492-3725 Lab: CSC251
>
>MySQL sup
Dear Sir,
The Create Table function is not working. Any steps that I need to
take besides creating a database first.
Yew Peng
Singapore
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
hotel" table by using AUTO_INCREMENT as well). How am I supposed to
connect different primary keys into one table (I mean how can I transfer the hotel_id
in Hotel table to
the Reservation table)? And after that how can I insert those primary keys inside one
table?
Thank you very much for your time.
Sincerely,
Cheri Peng
48 matches
Mail list logo
