Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 ChoiSaehoon schrieb: > Thanks Uwe, > > I used ` now. It says > ls: z*: no such file or directory exists You need to use the path full qualified, e.g. ls /var/lib/mysql/db/z*, or wherever your mysql installation live. > > then, when I enter the p

Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 ChoiSaehoon schrieb: > I tried it, then it gives the following error message > > mysqldump: Can't get CREATE TABLE for table 'ls z*' (Table '(db-name).ls z*' > doesn't exist) > > What does 'ls' mean? (as in linux command 'ls'?) you have to use th

Re: binlog question

Baron Schwartz schrieb: So, how it's possible to replicate one specific db? I have 4 db's writing into binlog. I need only one of them at client site. After the successful setup of the replication I get errors on client site like no such table, no such database etc... On the slave side, use --r

Re: binlog question

ch database etc... Thanks, Uwe - michael dykman On Sat, Apr 18, 2009 at 7:11 AM, Uwe Kiewel wrote: Hi, is it possible to have separated binlogs for each mysql-db? Thanks, Uwe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://

binlog question

Hi, is it possible to have separated binlogs for each mysql-db? Thanks, Uwe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL runs on 16-cores server

Moon's Father wrote: > Thank you very much. > Could you tell me what is IIRC? If I remember correctly. HTH, Uwe > > > > On Fri, Apr 10, 2009 at 8:24 PM, Uwe Kiewel wrote: > > Moon's Father wrote: > > Hi. > >If the serv

Re: MySQL runs on 16-cores server

Moon's Father wrote: > Hi. >If the server has 16 cores, how to set parameters to make MySQL runs > well. IIRC is mysqld multi threaded - so if you have parallel queries, mysqld will spam multiple threads across multiple cores. HTH, Uwe -- MySQL General Mailing List For list archive

Re: [Fwd: Re: Is it a bug or my mistake in server configuration?]

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John Daisley schrieb: > Hit 'Reply to All' instead of reply. > Is is okay for you the have your answers twice? If I post to a list, I read that list. So there is no need to have the ansers at the list and in my inbox Uwe -BEGIN PGP SIGNATURE

Re: [Fwd: Re: Is it a bug or my mistake in server configuration?]

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Andy Shellam schrieb: > >> This mailing list has a stupid configuration. Pressing the answer >> button, the message goes to the sender not to the list :-( >> > > Hint - use Reply to All - it's not specific to this mailing list. :-) > It dosn't m

Re: Is it a bug or my mistake in server configuration?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Curtis Maurand schrieb: > > I've been having the same trouble in a Xen virtual machine. After about > an hour and a half, mysql will be consuming 100% of cpu. There is > nothing wrong with the tables. I'm assuming its a dynamic vs. fix > amount of

[Fwd: Re: Is it a bug or my mistake in server configuration?]

2008 18:36:34 +0100 Von: Uwe Kiewel <[EMAIL PROTECTED]> An: Alexey Vlasov <[EMAIL PROTECTED]> Referenzen: <[EMAIL PROTECTED]> Alexey Vlasov schrieb: > open files (-n) 1024 just a shot to the blue: can you count your open files with lsof? HTH,

how to create a trigger

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I have 2 databases: production_db and test_db. Both databases have the same tables. Now, I want to do as follows: If a new record is inserted to the production_db interst the same recort into the test_db. I am pretty sure, it's a case fo a trigg

Re: Rotate regular log file only

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Olaf Stein schrieb: > Hi all > > Is it possible to rotate just the regular (--log) log file? I am not sure if it will be safe, but maybe with logrotate and for /var/log/mysqld.log the "copytruncate" option for logrotate. > If I do flush-logs I have t

Re: MySQL Sort by Array

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Keith Spiller schrieb: > Hi Guys, > > I'm trying to sort by a particular order: > > SELECT * FROM tablename > WHERE id='5' OR id='9' OR id='25' OR id='34' what about ... WHERE id in (5, 9, 25, 34) ... > ORDER BY id(5, 34, 9, 25) like the others said

can not "start slave" after slave crash

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, my replication slave crashed. Now, I am unable to restart with following error message: 081021 21:34:21 [Note] Slave SQL thread initialized, starting replication in log 'log.000129' at position 28457291, relay log '/video/mysql/mysqld-relay-bin.0

Re: Query Cache questions

Bard Aase schrieb: > On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote: >> Hi, >> >> I have two questions regarding the query cache: >> >> 1. What is the difference between query_cache_limit and query_cache_size? > > query_cache_li

Query Cache questions

Hi, I have two questions regarding the query cache: 1. What is the difference between query_cache_limit and query_cache_size? mysql> show variables like '%query_cache%'; have_query_cache | YES | query_cache_limit| 1048576 | query_cache_min_res_unit | 4096 |

mysql logfile configuration

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi @all, ich have configured in /etc/my.cf as follow: [...] log="/var/log/mysqld.log" [...] Now, mysqld writes every query to the log file. How can I avoid the queries in the log file? I want to see any action done by mysql, but not the queries. T

Re: only myisam storage engine

Ananda Kumar schrieb: Hi All, i set the skip-innodb in my.cnf, but when i do the below, it still shows some default values assigned to innodb parameters, can i avoid this as there is some amount of memory allocated to innodb, and i dont what that. I want all resource to allocated to only myisam.