MySQL 5.1.29 and OPTIMIZE
Hi All, I have used MySQL 5.1.29 and I would like to ask a question related to InnoDB and row_format=COMPACT and OPTIMIZE Why when trying to run OPTMIZE on InnoDB table with row_format=compact it displays Table does not support optimize, doing recreate + analyze instead ? +--+--+--+---+ | Table| Op | Msg_type | Msg_text | +--+--+--+---+ | table1 | optimize | note | Table does not support optimize, doing recreate + analyze instead | | table1 | optimize | status | OK | +--+--+--+---+ Thanks for your help, Mariella -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
5.1.24-rc and partitioning and add, drop partitions and select
Hi ALL, I have been using 5.1.24-rc and partitioning by range. I have noticed that while doing a set of SELECT statements on one of the partitions (e.g. p1) and at the same time doing an ALTER TABLE with drop or add a different partition (e.g. ALTER TABLE DROP or ADD PARTITION p10) all the select statements are placed on hold (Waiting for table). Would it be possible to know the reason for that ? My understanding was there there was a lock per partition, instead of lock per table ? Thanks in advance for your help, Mariella Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 5.1.24-rc and partitioning and add, drop partitions and select
One more question, plz (http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations.html) Table locks. The process executing a partitioning operation on a table takes a write lock on the table. Reads from such tables are relatively unaffected; pending INSERT and UPDATE operations are performed as soon as the partitioning operation has completed Is that true also for the InnoDB storage engine ? What does Reads from such tables are relatively unaffected; implies, please ? Thanks, Mariella --- Mariella Petrini [EMAIL PROTECTED] wrote: Hi ALL, I have been using 5.1.24-rc and partitioning by range. I have noticed that while doing a set of SELECT statements on one of the partitions (e.g. p1) and at the same time doing an ALTER TABLE with drop or add a different partition (e.g. ALTER TABLE DROP or ADD PARTITION p10) all the select statements are placed on hold (Waiting for table). Would it be possible to know the reason for that ? My understanding was there there was a lock per partition, instead of lock per table ? Thanks in advance for your help, Mariella Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ -- MySQL Internals Mailing List For list archives: http://lists.mysql.com/internals To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Maria Engine and AMD and 5.1.23 binary version
Hi All, Is there any plan to release a binary version for mysql-5.1.23-maria-alpha for Linux 64 for AMD ? Thanks in advance for your help, Mariella Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Maria Engine and AMD and 5.1.23 binary version
Hi, Do you know an approximate date ? Thanks, Mariella --- Sergei Golubchik [EMAIL PROTECTED] wrote: Hi! On Feb 14, Mariella Petrini wrote: Hi All, Is there any plan to release a binary version for mysql-5.1.23-maria-alpha for Linux 64 for AMD ? Yes. Regards / Mit vielen Grüssen, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ Principal Software Developer/Server Architect /_/ /_/\_, /___/\___\_\___/ MySQL GmbH, Dachauer Str. 37, D-80335 München ___/ Geschäftsführer: Kaj Arnö - HRB München 162140 Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5.1.23-rc compiled and max open files
Hi ALL, I have compiled MySLQ 5.1.23-rc for Linux 64bit ./configure CC=gcc CFLAGS=-DBIG_JOINS=1 -O3 CXX=g++ CXXFLAGS=-DBIG_JOINS=1 -felide-constructors -fno-exceptions -fno-rtti -O3 --prefix=/app/mysql-5.1.23-rc --localstatedir=/app/mysql-5.1.23-rc/data --libexecdir=/app/mysql-5.1.23-rc/bin --datadir=/app/mysql-5.1.23-rc/data -with-comment=Debian x86_64 --with-server-suffix=Debian x86_64 --enable-shared --enable-static --enable-thread-safe-client --enable-assembler --enable-local-infile --with-big-tables --with-raid --with-mysqld-user=mysql --with-libwrap --with-mysqld-ldflags=-all-static --with-vio --with-bench --with-readline --with-extra-charsets=all --with-innodb --with-isam --with-archive-storage-engine --with-csv-storage-engine --with-federated-storage-engine --with-embedded-privilege-control --with-zlib-dir=bundled --with-ssl=bundled --with-partition 1) While trying to run the sudo bin/mysql_install_db it failed (even though I specified the src directory) sudo bin/mysql_install_db --user=mysql --builddir=/src/mysql-5.1.23-rc --srcdir=/src/mysql-5.1.23-rc --ldata=/app/mysql/data Installing MySQL system tables... Installation of system tables failed! Examine the logs in /app/mysql/data for more information. The logs did not get created; only the test database directory got created (only the directory) I did copy over the mysql-5.1.22-rc/data/mysql table files and after that the MySQL server was able to start. 2) I have tried to specify to mysqld (in the same way of MySQL 5.1.22-rc) to use more open files than limit using mysqld_safe --defaults-file=/app/mysql/etc/my.cnf --open-files-limit=20 and it says [Warning] option 'open_files_limit': unsigned value 20 adjusted to 65535 Is there any way to get around that, please ? Thanks in advance for your help, Mariella Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Question related to MySQL 5.1.21 and enabling pbxt engine, please
Hi All, I would like to be able to use MySQL 5.1.21 with the PBXT engine. I have compiled MySQL 5.1.21 64 bits on Debian 4.0 with linux 2.6 with the options specified in the README that comes with the PBXT source code. I have copied the binary of the pbxt library into the lib/mysql directory When I tried to execuute the sql command install plugin pbxt soname 'llibpbxt.so'; I would get an error saying that I should have compiled with HAVE_DLOPEN ERROR 1289 (HY000): The 'plugin' feature is disabled; you need MySQL built with 'HAVE_DLOPEN' to have it working So I have re-compiled mysql server including -DHAVE_DLOPEN (e.g. ./configure CC=gcc CFLAGS=-DBIG_JOINS=1 -DHAVE_DLOPEN -O2 CXX=g++ CXXFLAGS=-DBIG_JOINS=1 -DHAVE_DLOPEN -felide-constructors -fno-rtti -O2 --prefix=/usr/local/mysql-5.1.21 --localstatedir=/usr/local/mysql-5.1.21/data --libexecdir=/usr/local/mysql-5.1.21/bin --datadir=/usr/local/mysql-5.1.21/data -with-comment=Debian x86_64 --with-server-suffix=Debian x86_64 --enable-shared --enable-static --enable-thread-safe-client --enable-assembler --enable-local-infile --with-big-tables --with-raid --with-mysqld-user=mysql --with-libwrap --with-mysqld-ldflags=-all-static --with-vio --with-bench --with-readline --with-extra-charsets=all --with-innodb --with-isam --with-archive-storage-engine --with-csv-storage-engine --with-federated-storage-engine --with-embedded-privilege-control --with-zlib-dir=bundled --with-ssl=bundled --with-partition --with-extra-charsets=complex --with-plugins=max-no-ndb --with-embedded-server) but unfortunately I get an error during the compilation mysqld.o: In function `set_user(char const*, passwd*)': mysqld.cc:(.text+0x406f): warning: Using 'initgroups' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking mysqld.o: In function `main': mysqld.cc:(.text+0x558d): warning: Using 'getpwnam' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking mysqld.cc:(.text+0x5949): warning: Using 'getpwuid' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking ../mysys/libmysys.a(mf_pack.o): In function `unpack_dirname': mf_pack.c:(.text+0x485): warning: Using 'endpwent' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking hostname.o: In function `ip_to_hostname(in_addr*, unsigned int*)': hostname.cc:(.text+0x391): warning: Using 'gethostbyaddr' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking mysqld.o: In function `mysqld_get_one_option': mysqld.cc:(.text+0x5b19): warning: Using 'gethostbyname' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking ../mysys/libmysys.a(my_gethostbyname.o): In function `my_gethostbyname_r': my_gethostbyname.c:(.text+0x10): warning: Using 'gethostbyname_r' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking mysqld.o: In function `set_ports()': mysqld.cc:(.text+0x292d): warning: Using 'getservbyname' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking sql_udf.o: In function `free_udf(st_udf_func*)': sql_udf.cc:(.text+0x124): undefined reference to `dlclose' sql_udf.o: In function `init_syms(st_udf_func*, char*)': sql_udf.cc:(.text+0x151): undefined reference to `dlsym' sql_udf.cc:(.text+0x18e): undefined reference to `dlsym' sql_udf.cc:(.text+0x1ae): undefined reference to `dlsym' sql_udf.cc:(.text+0x1d1): undefined reference to `dlsym' sql_udf.cc:(.text+0x1ee): undefined reference to `dlsym' sql_udf.o: In function `udf_free()': sql_udf.cc:(.text+0x4a8): undefined reference to `dlclose' sql_udf.o: In function `udf_init()': sql_udf.cc:(.text+0x92a): undefined reference to `dlclose' sql_udf.cc:(.text+0x9e1): undefined reference to `dlopen' sql_udf.o: In function `mysql_drop_function(THD*, st_mysql_lex_string const*)': sql_udf.cc:(.text+0xc46): undefined reference to `dlclose' sql_udf.o: In function `mysql_create_function(THD*, st_udf_func*)': sql_udf.cc:(.text+0xe35): undefined reference to `dlclose' sql_udf.cc:(.text+0xe70): undefined reference to `dlopen' sql_plugin.o: In function `plugin_dl_del(st_mysql_lex_string const*)': sql_plugin.cc:(.text+0x2ae0): undefined reference to `dlclose' sql_plugin.o: In function `plugin_shutdown()': sql_plugin.cc:(.text+0x3032): undefined reference to `dlclose' sql_plugin.o: In function `plugin_dl_add(st_mysql_lex_string const*, int)': sql_plugin.cc:(.text+0x355c): undefined reference to `dlopen' sql_plugin.cc:(.text+0x357f): undefined reference to `dlsym' sql_plugin.cc:(.text+0x35b5): undefined reference to `dlclose' sql_plugin.cc:(.text+0x3660): undefined reference to `dlsym' sql_plugin.cc:(.text+0x3691): undefined reference
Re: Question related to MySQL 5.1.21 and enabling pbxt engine, please
2 make[1]: Leaving directory `/var/local/repository/src/mysql-5.1.21-beta/sql' make: *** [all-recursive] Error 1 --- Vladimir Shebordaev [EMAIL PROTECTED] wrote: Mariella, try to disable building static binaries, please don't use --enable-static configure option, you'd better use --disable-static instead. In the hope it helps. Regards, Vladimir Mariella Petrini пиÑеÑ: Hi All, I would like to be able to use MySQL 5.1.21 with the PBXT engine. I have compiled MySQL 5.1.21 64 bits on Debian 4.0 with linux 2.6 with the options specified in the README that comes with the PBXT source code. I have copied the binary of the pbxt library into the lib/mysql directory When I tried to execuute the sql command install plugin pbxt soname 'llibpbxt.so'; I would get an error saying that I should have compiled with HAVE_DLOPEN ERROR 1289 (HY000): The 'plugin' feature is disabled; you need MySQL built with 'HAVE_DLOPEN' to have it working So I have re-compiled mysql server including -DHAVE_DLOPEN (e.g. ./configure CC=gcc CFLAGS=-DBIG_JOINS=1 -DHAVE_DLOPEN -O2 CXX=g++ CXXFLAGS=-DBIG_JOINS=1 -DHAVE_DLOPEN -felide-constructors -fno-rtti -O2 --prefix=/usr/local/mysql-5.1.21 --localstatedir=/usr/local/mysql-5.1.21/data --libexecdir=/usr/local/mysql-5.1.21/bin --datadir=/usr/local/mysql-5.1.21/data -with-comment=Debian x86_64 --with-server-suffix=Debian x86_64 --enable-shared --enable-static --enable-thread-safe-client --enable-assembler --enable-local-infile --with-big-tables --with-raid --with-mysqld-user=mysql --with-libwrap --with-mysqld-ldflags=-all-static --with-vio --with-bench --with-readline --with-extra-charsets=all --with-innodb --with-isam --with-archive-storage-engine --with-csv-storage-engine --with-federated-storage-engine --with-embedded-privilege-control --with-zlib-dir=bundled --with-ssl=bundled --with-partition --with-extra-charsets=complex --with-plugins=max-no-ndb --with-embedded-server) but unfortunately I get an error during the compilation mysqld.o: In function `set_user(char const*, passwd*)': mysqld.cc:(.text+0x406f): warning: Using 'initgroups' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking mysqld.o: In function `main': mysqld.cc:(.text+0x558d): warning: Using 'getpwnam' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking mysqld.cc:(.text+0x5949): warning: Using 'getpwuid' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking ../mysys/libmysys.a(mf_pack.o): In function `unpack_dirname': mf_pack.c:(.text+0x485): warning: Using 'endpwent' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking hostname.o: In function `ip_to_hostname(in_addr*, unsigned int*)': hostname.cc:(.text+0x391): warning: Using 'gethostbyaddr' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking mysqld.o: In function `mysqld_get_one_option': mysqld.cc:(.text+0x5b19): warning: Using 'gethostbyname' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking ../mysys/libmysys.a(my_gethostbyname.o): In function `my_gethostbyname_r': my_gethostbyname.c:(.text+0x10): warning: Using 'gethostbyname_r' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking mysqld.o: In function `set_ports()': mysqld.cc:(.text+0x292d): warning: Using 'getservbyname' in statically linked applications requires at runtime the shared libraries from the glibc version used for linking sql_udf.o: In function `free_udf(st_udf_func*)': sql_udf.cc:(.text+0x124): undefined reference to `dlclose' sql_udf.o: In function `init_syms(st_udf_func*, char*)': sql_udf.cc:(.text+0x151): undefined reference to `dlsym' sql_udf.cc:(.text+0x18e): undefined reference to `dlsym' sql_udf.cc:(.text+0x1ae): undefined reference to `dlsym' sql_udf.cc:(.text+0x1d1): undefined reference to `dlsym' sql_udf.cc:(.text+0x1ee): undefined reference to `dlsym' sql_udf.o: In function `udf_free()': sql_udf.cc:(.text+0x4a8): undefined reference to `dlclose' sql_udf.o: In function `udf_init()': sql_udf.cc:(.text+0x92a): undefined reference to `dlclose' sql_udf.cc:(.text+0x9e1): undefined reference to `dlopen' sql_udf.o: In function `mysql_drop_function(THD*, st_mysql_lex_string const*)': sql_udf.cc:(.text+0xc46): undefined reference to `dlclose' sql_udf.o: In function `mysql_create_function(THD*, st_udf_func*)': sql_udf.cc:(.text+0xe35): undefined reference to `dlclose
Re: MySQL 6.0.2-alpha and Falcon and possible bug/problem
I have re-run and job and I was able to repeat the problem. Find attached the mysql server error log with all the tarces. Could you please help ? Thanks, Mariella --- Mariella Petrini [EMAIL PROTECTED] wrote: Hi All, I have started using MySQL 6.0.2 with Falcon on Linux with Debian 4. I have compiled the source code for 64 bit executable. The system is an Intel 2 cpus 4 cores each, with 8 GB of RAM. I have started creating tables (without partitioning) whit engine type Falcon. After having created approximately 8,500 empty tables mysqld server was still alive, you could connect with the mysql client, but any command that you would type would freeze (never come back). I will try to re-run the same job, enabling falcon_debug_mask and see if I can get more info and repeat the problem. Mariella Below are shown the Falcon settings used: +--+-+ | Variable_name| Value | +--+-+ | falcon_checkpoint_schedule | 7 * * * * * | | falcon_debug_mask| 0 | | falcon_debug_server | OFF | | falcon_disable_fsync | OFF | | falcon_index_chill_threshold | 4 | | falcon_initial_allocation| 1073741824 | | falcon_max_transaction_backlog | 150 | | falcon_page_cache_size | 4194304 | | falcon_page_size | 4096 | | falcon_record_chill_threshold| 5 | | falcon_record_memory_max | 262144000 | | falcon_record_scavenge_floor | 50 | | falcon_record_scavenge_threshold | 67 | | falcon_scavenge_schedule | 15,45 * * * * * | | falcon_serial_log_buffers| 10 | | falcon_serial_log_dir| | | have_falcon | YES | +--+-+ Need a vacation? Get great deals to amazing places on Yahoo! Travel. http://travel.yahoo.com/ -- MySQL Internals Mailing List For list archives: http://lists.mysql.com/internals To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Shape Yahoo! in your own image. Join our Network Research Panel today! http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 6.0.2-alpha and Falcon and possible bug/problem
I don't think that is the problem. I have been able to create over a 1,000,000 of tables with MySQL 5.1.21 and different storage engines with the same environment (I had already ulimit set). Thanks, Mariella Mathieu Bruneau [EMAIL PROTECTED] wrote: I never tried the falcon engine, but could it be that mysql is running out of file descriptor ? I think debian is limited to something around 8k per user by default. Check your pam settings and your ulimit ... Database usually use a lot of file handle and it's generally safe to increase it. Don't know if falcon use file handle per table or not tough... -- Mathieu Bruneau aka ROunofF === GPG keys available @ http://rounoff.darktech.org Mariella Petrini a �crit : I have re-run and job and I was able to repeat the problem. Find attached the mysql server error log with all the tarces. Could you please help ? Thanks, Mariella --- Mariella Petrini wrote: Hi All, I have started using MySQL 6.0.2 with Falcon on Linux with Debian 4. I have compiled the source code for 64 bit executable. The system is an Intel 2 cpus 4 cores each, with 8 GB of RAM. I have started creating tables (without partitioning) whit engine type Falcon. After having created approximately 8,500 empty tables mysqld server was still alive, you could connect with the mysql client, but any command that you would type would freeze (never come back). I will try to re-run the same job, enabling falcon_debug_mask and see if I can get more info and repeat the problem. Mariella Below are shown the Falcon settings used: +--+-+ | Variable_name| Value | +--+-+ | falcon_checkpoint_schedule | 7 * * * * * | | falcon_debug_mask| 0 | | falcon_debug_server | OFF | | falcon_disable_fsync | OFF | | falcon_index_chill_threshold | 4 | | falcon_initial_allocation| 1073741824 | | falcon_max_transaction_backlog | 150 | | falcon_page_cache_size | 4194304 | | falcon_page_size | 4096 | | falcon_record_chill_threshold| 5 | | falcon_record_memory_max | 262144000 | | falcon_record_scavenge_floor | 50 | | falcon_record_scavenge_threshold | 67 | | falcon_scavenge_schedule | 15,45 * * * * * | | falcon_serial_log_buffers| 10 | | falcon_serial_log_dir| | | have_falcon | YES | +--+-+ Need a vacation? Get great deals to amazing places on Yahoo! Travel. http://travel.yahoo.com/ -- MySQL Internals Mailing List For list archives: http://lists.mysql.com/internals To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Shape Yahoo! in your own image. Join our Network Research Panel today! http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 - Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out.
MySQL 6.0.2-alpha and Falcon and possible bug/problem
Hi All, I have started using MySQL 6.0.2 with Falcon on Linux with Debian 4. I have compiled the source code for 64 bit executable. The system is an Intel 2 cpus 4 cores each, with 8 GB of RAM. I have started creating tables (without partitioning) whit engine type Falcon. After having created approximately 8,500 empty tables mysqld server was still alive, you could connect with the mysql client, but any command that you would type would freeze (never come back). I will try to re-run the same job, enabling falcon_debug_mask and see if I can get more info and repeat the problem. Mariella Below are shown the Falcon settings used: +--+-+ | Variable_name| Value | +--+-+ | falcon_checkpoint_schedule | 7 * * * * * | | falcon_debug_mask| 0 | | falcon_debug_server | OFF | | falcon_disable_fsync | OFF | | falcon_index_chill_threshold | 4 | | falcon_initial_allocation| 1073741824 | | falcon_max_transaction_backlog | 150 | | falcon_page_cache_size | 4194304 | | falcon_page_size | 4096| | falcon_record_chill_threshold| 5 | | falcon_record_memory_max | 262144000 | | falcon_record_scavenge_floor | 50 | | falcon_record_scavenge_threshold | 67 | | falcon_scavenge_schedule | 15,45 * * * * * | | falcon_serial_log_buffers| 10 | | falcon_serial_log_dir| | | have_falcon | YES | +--+-+ Need a vacation? Get great deals to amazing places on Yahoo! Travel. http://travel.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB and RAW Device and autoextend question
Hi All, I have been using MySQL 5.1.x with InnoDB and Raw Devices. [mysqld] innodb_data_home_dir= innodb_data_file_path=/dev/hdd1:3Gnewraw;/dev/hdd2:2Gnewraw ... [mysqld] innodb_data_home_dir= innodb_data_file_path=/dev/hdd1:5Graw;/dev/hdd2:2Graw Is there any way to specifiy the autoextend option (...::autoextend) when using Innodb with raw devices for the Shared Tablespace ? Thanks in advance for your help, Mariella Need a vacation? Get great deals to amazing places on Yahoo! Travel. http://travel.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL and writing RAMFS for tmp question
Hi, Is there way with MySQL 5.0.45 on Linux Debian to specify tmpdir (in my.cnf) to a directory on a RAMFS filesystem. I have tried but MySQL did not even start (it generated an error saying that it could not write ) Thanks in advance for your help. I look forward to hearing from you, Mariella Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Question: How to fix TABLE LOCK table and lock mode AUTO-INC waiting ? one more question, please
Hi, What does exactly happens when the AUTOINC lock is happening ? Why is it not a problem on our amd (quadcore) machine with the data sitting on a raid10 partition, we have never seen this problem before, its apparently happening so fast that it doesn't matter. With the intel machine (quadcore with hyperthreading enabled) sitting on a DRBD partition (raid 10) the process of getting a lock is slow. So slow, that it cascades to this problem of rollbacks, etc...as show in the previous email. Thanks in advance for your help, Mariella --- Sunny Bains [EMAIL PROTECTED] wrote: Mariella, Mariella Petrini wrote: Hi, I have been using 5.0.32 MySQL on Debian. Everything worked properly. DRBD has been added and configure with MySQL and restarted. The tables used are InnoDB type and use auto_increment. After that during INSERTs and UPDATEs innodb started to roll back for table lock on AUTO_INC The behavior observed is most likely related to this bug report: http://bugs.mysql.com/bug.php?id=16979 Regards, -sunny Oracle/Innobase. Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool. http://autos.yahoo.com/carfinder/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Question related to MySQL and Threads and Context_voluntary
Hi, I have been working with MySQL 5.1.20 (64 bits compiled on Mac OS for MacPro Intel Xeon Quad-Core qith 2 processors and 8GB of RAM) and MySQL 5.0.41 (32 bits). While running some of the select statements (independently of the storage engine used, either InnoDB or MyISAM) I have noticed that the response time of a query degrades badly (double degrades) as soon as another query is run. E.g. This is a case for a very simple query that faces the problem. SELECT SQL_NO_CACHE count(DISTINCT user_id) as res_count FROM t1 WHERE (acc 0 AND cat=34 AND thr between 42 and 52) AND genre='SF'; Using explain ++-+---+--+---+---+-+---+---+-+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | ++-+---+--+---+---+-+---+---+-+ | 1 | SIMPLE | t1 | ref | uag,genre_idx | genre_idx | 6 | const | 61324 | Using where | ++-+---+--+---+---+-+---+---+-+ show index from t1; +---++---+--+-+---+-+--++--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +---++---+--+-+---+-+--++--++-+ | t1 |1 | user_id_idx |1 | user_id | A | 178219 | NULL | NULL | | BTREE | | | t1 |1 | uag |1 | acc | A | 8 | NULL | NULL | | BTREE | | | t1 |1 | uag |2 | cat | A | 8 | NULL | NULL | | BTREE | | | t1 |1 | uag |3 | thr | A | 538 | NULL | NULL | | BTREE | | | t1 |1 | genre_idx |1 | genre | A | 6 | NULL | NULL | | BTREE | | +---++---+--+-+---+-+--++--++-+ If there is only one query running the response time is x, if there two queries running at the same time the response time of each select is approximately 2x, if there 3 queries running the response time is approximately 4x and if there are 4 queries running concurrently the response time of each query is approximately 8x I have been using show profiling in 5.0.x and I have noticed that the amunt of increased time is due to the step called Sending data. Doing a little more digging, the variables that approximately double increase (during the Sending Data step) are Context_voluntary, Messages__received and Messages_sent . Question: Which could be the MySQL variables that could be changed and that could provide a major increase ? Could you please help ? Thanks in advance for your help, Mariella Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out. http://answers.yahoo.com/dir/?link=listsid=396545433 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Question, please: How to fix TABLE LOCK table and lock mode AUTO-INC waiting ?
Hi,
I have been using 5.0.32 MySQL on Debian.
Everything worked properly.
DRBD has been added and configure with MySQL and
restarted.
The tables used are InnoDB type and use
auto_increment.
After that during INSERTs and UPDATEs innodb started
to roll back
for table lock on AUTO_INC
How could that problem be fixed and still using MySQL
5.0.32 ?
Could you please help ?
Thanks in advance for your help,
Mariella
Please find below a snapshot of show innodb status
\G
INNODB MONITOR OUTPUT
=
Per second averages calculated from the last 15
seconds
--
SEMAPHORES
--
OS WAIT ARRAY INFO: reservation count 600464, signal
count 592446
Mutex spin waits 0, rounds 160295369, OS waits 262356
RW-shared spins 1496027, OS waits 14850; RW-excl spins
16362229, OS waits 104422
LATEST DETECTED DEADLOCK
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
*** WE ROLL BACK TRANSACTION (2)
TRANSACTIONS
Trx id counter 0 3667761
Purge done for trx's n:o 0 3666432 undo n:o 0 0
History list length 449
Total number of lock structs in row lock hash table 4
---TRANSACTION 0 384, ACTIVE 8 sec, process no
8014, OS thread id 1143544160 setting auto-inc lock
mysql tables in use 1, locked 1
LOCK WAIT 1 lock struct(s), heap size 368
MySQL thread id 634392, query id 3774951
NSERT INTO t2 VALUES ('')
--- TRX HAS BEEN WAITING 3 SEC FOR THIS LOCK TO BE
GRANTED:
TABLE LOCK table `t2` trx id 0 3667440 lock mode
AUTO-INC waiting
--
..
INSERT INTO t1 (...) VALUES (0, 4394621, 4275679,
now(), 11, 3, 1)
--- TRX HAS BEEN WAITING 8 SEC FOR THIS LOCK TO BE
GRANTED:
TABLE LOCK table `t1` trx id 0 384 lock mode
AUTO-INC waiting
and so on
FILE I/O
I/O thread 0 state: waiting for i/o request (insert
buffer thread)
I/O thread 1 state: waiting for i/o request (log
thread)
I/O thread 2 state: waiting for i/o request (read
thread)
I/O thread 3 state: waiting for i/o request (write
thread)
Pending normal aio reads: 0, aio writes: 0,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 1; buffer pool: 0
507426 OS file reads, 2589974 OS file writes, 2233731
OS fsyncs
0.00 reads/s, 0 avg bytes/read, 169.99 writes/s,
169.79 fsyncs/s
-
INSERT BUFFER AND ADAPTIVE HASH INDEX
-
Ibuf: size 1, free list len 3297, seg size 3299,
682052 inserts, 727524 merged recs, 168421 merges
Hash table size 35401603, used cells 8213520, node
heap has 13783 buffer(s)
64.06 hash searches/s, 638.36 non-hash searches/s
---
LOG
---
Log sequence number 7 3937023738
Log flushed up to 7 3937023519
Last checkpoint at 7 1938367130
1 pending log writes, 0 pending chkp writes
2173015 log i/o's done, 169.66 log i/o's/second
--
BUFFER POOL AND MEMORY
--
Total memory allocated 19080668522; in additional pool
allocated 24182272
Buffer pool size 1048576
Free buffers 120072
Database pages 914721
Modified db pages 208086
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 721174, created 930486, written 1646312
0.00 reads/s, 6.40 creates/s, 4.27 writes/s
Buffer pool hit rate 1000 / 1000
--
ROW OPERATIONS
--
8 queries inside InnoDB, 4 queries in queue
1 read views open inside InnoDB
Main thread process no. 8014, id 1140881760, state:
sleeping
Number of rows inserted 57073968, updated 805579,
deleted 0,
When will partitioning be included in the MySQl stable release ?
Dear All, I would like to know if there are short time plans (and eventually when approximately it will be) to include partitioning in the next MySQL stable release. Thanks in advance for your help. I look forward to hearing from you, Mariella - You snooze, you lose. Get messages ASAP with AutoCheck in the all-new Yahoo! Mail Beta.
InnoDB and raw devices and DRBD question
Hi ALL, I would like to use INNODB with raw devices for tablespace in the innodb_data_file_path both on MySQL 5.0.x and MySQL 5.1.x. Is it possible to use DRBD (Distributed Raw Block Device) with InnoDB and raw devices. If yes, which are the constraints ? Thanks in advance for your help, Mariella - Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos more.
Fwd: Re: MySQL 5.0.x and 5.1.x Compiling options and settings on Linux IA64: one more question: ./bin/mysqladmin: connect to server at 'localhost' failed
Hi, After having compiled (debug and optimized version) of MySQL 5.1.14 on Itanium-2 using icc, I have run mysql_install_db --user=... and started mysqld_safe in both scenarios (debug and optimized). In both cases mysqld starts without any errors. Unfortunaly when running the optimized version of mysqld I am not able to connect and set the root password. ./bin/mysqladmin -u root password '***' ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' The same procedure applied on the mysqld compiled with debug version (--with-debug) has no problem and I am able to set up the root password without any problems. Is there a bug in the MySQL 5.1.14 version when not compiled with --with-debug or am I missing something ? P.S. I have also tried to set the root password using the debug version, shut-down the mysqld debug, replaced the mysql subdirectory in the data subdir in the optimized version and restarted the optimized mysqld with the new mysql subdir in the data subdir, but I got the same error. Could you please help ? Thanks in advance for your help, Mariella - Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers.
Porting MySQL 5.0.x and 5.1.x on Linux IA64: Compiling options and errors
Dear All, I am trying to compile MySQL 5.0.27 and 5.1.14 on a shared memory processors system with 128 processors IA-64 Itanium-2. I have downloaded the binary version of MySQL-max 5.0.27 Linux IA64 and I have installed and configured it with no problems. I need to install also the MySQL-max 5.1.x Linux IA64 version. I could not find a compiled binary version for MySQL 5.1.x for Linux IA64, so I have downloaded the source code for MySQL 5.1.14. The shared memory processors system is running Linux 2.6.16.21-0.8 and it has Intel compiler ecc/icc version 9.0 I have tried to compile MySQL 5.0.27 and 5.1.x with the settings below, but unfortunately it fails. These are the options used: -- CC=icc CFLAGS=-O2 -tpp2 -ip -nolib_inline CXX=icc CXXFLAGS=-O2 -tpp2 -ip -nolib_inline ./configure --prefix=/home/app/mysql --with-extra-charsets=complex --enable-thread-safe-client --enable-local-infile -- These are the error messages: -- icc -O2 -tpp2 -ip -nolib_inline -rdynamic -o conf_to_src conf_to_src.o -lcrypt -lnsl -lm -lz make[2]: Leaving directory `/home/mysql-5.1.14-beta/libmysql' Making all in client make[2]: Entering directory `/home/mysql-5.1.14-beta/client' if icc -DUNDEF_THREADS_HACK -DDEFAULT_MYSQL_HOME=\/home/./mysql-5.1.14\ -DDATADIR=\/home//mysql-5.1.14/var\ -I. -I. -I.. -I../include -I../include -I../regex -O2 -tpp2 -ip -nolib_inline -fno-implicit-templates -fno-exceptions -fno-rtti -MT mysql.o -MD -MP -MF .deps/mysql.Tpo -c -o mysql.o mysql.cc; \ then mv -f .deps/mysql.Tpo .deps/mysql.Po; else rm -f .deps/mysql.Tpo; exit 1; fi /usr/include/sys/ucontext.h(52): error: identifier __builtin_offsetof is undefined unsigned long _pad[_SC_GR0_OFFSET/8]; ^ /usr/include/sys/ucontext.h(52): error: function call is not allowed in a constant expression unsigned long _pad[_SC_GR0_OFFSET/8]; ^ /usr/include/sys/ucontext.h(52): error: type name is not allowed unsigned long _pad[_SC_GR0_OFFSET/8]; ^ /usr/include/sys/ucontext.h(52): error: expected a ) unsigned long _pad[_SC_GR0_OFFSET/8]; ^ /usr/include/sys/ucontext.h(52): error: expected a ] unsigned long _pad[_SC_GR0_OFFSET/8]; ^ /usr/include/sys/ucontext.h(52): error: expected a ; unsigned long _pad[_SC_GR0_OFFSET/8]; ^ compilation aborted for mysql.cc (code 2) make[2]: *** [mysql.o] Error 1 make[2]: Leaving directory `/home/mysql-5.1.14-beta/client' make[1]: *** [all-recursive] Error 1 -- I have tried to compile the MySQL 5.0.27 source code with the same settings used to compile 5.1.14, but it fails as well. I have also tried to use the BUILD/compile-ia64-debug-max but I get the same set of errors. Could you please help ? Which are the compilation, linking options used to produce the binary version of MySQL 5.0.27 for Linux IA64 (using Intel icc and gcc), available at http://dev.mysql.com/downloads/mysql/5.0.html ? Which version of the Intel icc has been used ? Does anybody know whether the issues could be related to the version of the icc ? ( e.g. http://dev.mysql.com/doc/refman/5.1/en/porting.html, even though I am trying to compile 5.0.27 I get the same set of errors that I get when trying to compile 5.1.14). Thanks in advance for your help, Mariella __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
