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
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
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 ka...@el.net wrote:
hi all..
this hasn't happened before...
i'm in as root on the command line cleint.
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.
Warning:
? if not, google
the docs for 'local infile'
yes. my laptop.
On 2012-10-16 10:45 PM, Lixun Peng pengli...@gmail.com wrote:
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
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 =
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
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
at 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: http
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/mysql
To unsubscribe
--
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
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
-t -hlocalhost -uxxx main.sql
~/linux/test/mysql/mysql/LOAD_DATA/CHARACTER_SET$ ./main.sh
+--+
| name |
+--+
| βΒ |
+--+
2011/10/16 Peng Yu pengyu...@gmail.com:
Hi,
I have the greek character Β (not that it is different from the
English character B, although they look similar
On Sun, Oct 9, 2011 at 10:33 AM, Peng Yu pengyu...@gmail.com 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
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
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 carlos.pr...@gmail.com wrote:
Downloads are available in http://dev.mysql.com/downloads
Carlos
On Sun, Oct 9, 2011 at 10:33 AM, Peng Yu pengyu
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
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 List
For list archives: http
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
--
MySQL
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 unsubscribe
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://lists.mysql.com/mysql
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 victorsube...@gmail.com
Hi,
I have the following python code:
cursor.execute('create database if not exists spreadsheets;')
cursor.execute('use spreadsheets;')
but it generates
you also can do this:#sudo -u mysql mysqldump command
or
#su - mysql -c mysqldump command
2009/7/24 walter harms wha...@bfs.de
muhammad subair schrieb:
On Thu, Jul 23, 2009 at 10:10 PM, walter harms wha...@bfs.de wrote:
Hi list,
i use mysqldump --tab to create database dumps. this
#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/7/21
# chown mysql.mysql datafile
2009/7/23 walter harms wha...@bfs.de
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
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:
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]
));
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 PROTECTED]
--
http://www.fastmail.fm - Accessible with your email software
or over
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]
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 General Mailing List
For list archives: http://lists.mysql.com
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: mysql@lists.mysql.com
Sent:
Does anyone know where to download the 'Err Nr. Description'? pdf is best.
Peng
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
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
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=xxxpassword=yyy );
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.
Peng
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.
Peng
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.
--
Regards
Peng
--
Peng Zhao [EMAIL PROTECTED]
http
)
Fix:
how to correct or work around the problem, if known (multiple lines)
Submitter-Id: submitter ID
Originator:
Organization:
Regards
Peng
--
Peng Zhao [EMAIL PROTECTED]
http://www.cs.ualberta.ca/~pengzhao
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
47 matches
Mail list logo