alter table and 'something wrong in indexes'?

g? I guess is not an aws problem, even if that is the first time I have a similar error thank you in advance bye bye MAS! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: (real) silly question about variables...

> what version of MySQL are you running? I get this:- mysql> select version(); +---+ | version() | +---+ | 5.1.63-0+squeeze1 | +---+ I'm asking that because I have a trouble with a select.. I have something similar.. SELECT @sec:=IF(GROUP_C

(real) silly question about variables...

58809499311 | 0.747058809499311 | ciao| ciao| +---+---+-+-+ 1 row in set (0.00 sec) why in the first execution the latest value is 0 and not 'ciao'? and why in the first 2 columns the variables seems works as expected!? thank you in advance bye MAS! -- MySQL Gener

sql indentation / reformat / beautifier

I'm looking for a way (better command line under linux) to reformat/ indent/beautify sql code like that (great) online (free) tool: http://www.dpriver.com/pp/sqlformat.htm or better, something to have that directly in emacs. any help? thank you in advance bye bye MAS! -- MySQL Ge

Re: backup from a slave

was thinking it'd be a better solution. btw, I have to get the Master_Log_File and Read_Master_Log_Pos or Relay_Master_Log_File and Exec_Master_Log_Pos to start the new slave correctly !? may be my slave is not updated in 'realtime' thank you in advance MAS! -- MySQL Gen

Re: backup from a slave

was thinking it'd be a better solution. btw, I have to get the Master_Log_File and Read_Master_Log_Pos or Relay_Master_Log_File and Exec_Master_Log_Pos to start the new slave correctly !? (my slave is not always updated in 'realtime') thank you in advance MAS! -- MySQL Gen

Re: backup from a slave

s thinking it'd be a better solution. btw, I have to get the Master_Log_File and Read_Master_Log_Pos or Relay_Master_Log_File and Exec_Master_Log_Pos to start the new slave correctly !? may be my slave is not updated in 'realtime' thank you in advance MAS! -- MySQL Gen

backup from a slave

p a new slave (from the same (and unique) master); the problem is I don't know how set-up this new slave, since I don't know the right master binary-log num and position; in the backup I have the "slave's" binary-log/pos and not the master ones :( any suggestio

mysqladministrator and differents query cache hits graphs

sults?! thank you in advance bye MAS! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

mysql administrator and different cache hit graphs

sults?! thank you in advance bye MAS! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: write lock and sql_cache

The query_cache_wlock_invalidate server variable controls the behavior you are seeing. You can configure it as desired. thank you so much to all.. by MAS! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

write lock and sql_cache

does the "lock table" on MySQL (I'm using 5.0.22 or 5.0.45) works even for a cached result? this is my scenario, (I'm using MyIsam tables) thread 1: LOCK TABLE foo WRITE; thread 2: SELECT * FROM foo ; (locked) thread 1: UNLOCK TABLES; thread 2: result of SELECT * .. and that's is, IMHO, co

write lock and sql_cache

does the "lock table" on MySQL (I'm using 5.0.22 or 5.0.45) works even for a cached result? this is my scenario, (I'm using MyIsam tables) thread 1: LOCK TABLE foo WRITE; thread 2: SELECT * FROM foo ; (locked) thread 1: UNLOCK TABLES; thread 2: result of SELECT * .. and that's is, IMHO, co

lock write and sql_cache

does the "lock table" on MySQL (I'm using 5.0.22 or 5.0.45) works even for a cached result? this is my scenario, (I'm using MyIsam tables) thread 1: LOCK TABLE foo WRITE; thread 2: SELECT * FROM foo ; (locked) thread 1: UNLOCK TABLES; thread 2: result of SELECT * .. and that's is, IMHO, co

Re: Lost Connection each hour :(

can you post values of wait_timeout and interactive_timeout variables. You can get them from SHOW VARIABLES output. If they are set to 3600 (1 hour in secs), set them to something bigger like one week and then you will see if it helps or not. You can read more about +---

Re: Lost Connection each hour :(

Enter your mysql shell and enter the command: set global max_allowed_packet=10M I have it setted at 32M, but that is not the problem; the data are not too much ... and it's strange because _ALL_ clients seems to died/be disconnected each hour, when the hourly cron runs.. -- MySQL Gener

Re: Lost Connection each hour :(

Il giorno 16 gen 2008, alle ore 02:59, Moon's Father ha scritto: Post your error message here. (from php) Error message: mysql_connect(): Lost connection to MySQL server during query and I have that for _each_ apache2 thread/php-page opened MAS! -- MySQL General Mailing List For

Lost Connection each hour :(

Can anyone help me to understand why my site (php 4.4.2 / ubuntu dapper) loose all connections to mysql server when /etc/cron/hourly starts? (there are no process to start hourly, the directory is empty) I have heavvy web/apache2 traffic on my site and that is not so nice for my users.. t

how to optimize this simple query with join?

I have to tables (on mysql 5.0.22): Table: shelf CREATE TABLE `shelf` ( `isbn` varchar(10) NOT NULL default '', `product_type` char(1) default NULL, `title` varchar(150) NOT NULL default '', (...) PRIMARY KEY (`isbn`), KEY `publ_date` (`publ_date`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1

double db in replicate_do_db..

thank you in advance bye bye MAS! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

best way to setup replication

ble to sync system C with the other ones? what is the best 'recipe' to setup correctly a slave system (better without stop the master db, if it's possibile) thank you in advance :) bye bye MAS! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql T

join vs subqueries

ON DELETE CASCADE ) TYPE=INNODB; thank you in advance MAS! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL with OpenMosix

Hi ! Does anybody have experience running MySQL with OpenMosix ? How is the performance increase ? Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Sudden error when replicationg - please help

Pada Wed, 8 Oct 2003 15:13:00 +0200 Søren Neigaard <[EMAIL PROTECTED]> menulis: what was the "show slave status" output ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

myodbc or server problem

Hello all, y send an SQL to server by VB & ADO. y traced from ODBC and I obtained this trace: GESTION fd28fee3-fd2805ff ENTER SQLExecDirectW HSTMT 02361D94 WCHAR * 0x01B46750 [ 211] "INSERT INTO macbase_totales.recibos

archive of old mails in lists?

Hello, is a archive where all the mails sent to mysql list are stored? if yes, where is the archive and how con I access to it. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://l