Re: Why people don't use engine named BDB?
Thanks.I know the reason now.:) On Mon, Jul 21, 2008 at 10:54 PM, Bill Newton [EMAIL PROTECTED] wrote: No, its mainly because BDB wasn't very good. Its transactional, but not MVCC. Take a look at a contemporary article when the acquisition was made : http://www.computerworld.com/databasetopics/data/software/story/0,10801,108705,00.html Curtis Maurand wrote: Its mainly because it was purchased by Oracle. BDB provided transaction support. Innodb has been the defacto choice for a ACID transactions, but Innodb was also purchased by Oracle in its attempt to kill MySQL after its failed attempt to purchase MySQL. That's why MySQL has been working on their own storage engine as well as the pluggable storage system. Curtis David Giragosian wrote: On 7/21/08, Moon's Father [EMAIL PROTECTED] wrote: Any reply is appreciated . -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn Maybe something to do with this: *BDB support will be removed. * Note that, as of MySQL 5.1, BDB isn't supported any longer. http://dev.mysql.com/doc/refman/5.0/en/bdb-storage-engine.html But you're right that as a storgage engine, there have been very few questions related to it, on this mailing list anyway. -- Bill Newton Network Merchants Inc. http://www.nmi.com (847) 352-4850/ Tel (888) 829-3631/ Fax -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: Access denied for user 'debian-sys-maint'@'localhost'
Hi Jesse, If you're specifying the password in plain text, you shouldn't put the PASSWORD directive in there; you only use PASSWORD if you're using the hashed password that MySQL will actually store. GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'LongPasswordHere' WITH GRANT OPTION or GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD 'HexadecimalString' WITH GRANT OPTION Also, you will need to execute FLUSH PRIVILEGES once you're done, since MySQL normally only checks the privilege tables on start-up. On Mon, 2008-07-21 at 20:35 -0400, Jesse wrote: OK. This is driving me Nutz 8-p Any time I try to restart mysql, I get the error, Access denied for user 'debian-sys-maint'@'localhost' My understanding is that the password for the debian-sys-maint user is found in /etc/mysql/debian.cnf So, I edit that, and note the password. I then execute the following in MySQL (with the correct password, of course): GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD 'LongPasswordHere' WITH GRANT OPTION To test it out, I try a mysql -u debian-sys-maint -p, type in the password and get the Access denied error again. What's going on? Why can't I get this to work? Jesse -- Ian Simpson System Administrator MyJobGroup This email may contain confidential information and is intended for the recipient(s) only. If an addressing or transmission error has misdirected this email, please notify the author by replying to this email. If you are not the intended recipient(s) disclosure, distribution, copying or printing of this email is strictly prohibited and you should destroy this mail. Information or opinions in this message shall not be treated as neither given nor endorsed by the company. Neither the company nor the sender accepts any responsibility for viruses or other destructive elements and it is your responsibility to scan any attachments.
Re: Access denied for user 'debian-sys-maint'@'localhost'
That was it. Once I removed PASSWORD, it went through, and I'm able to restart MySQL now. Thanks for your help. Jesse - Original Message - From: Ian Simpson To: Jesse Cc: MySQL List Sent: Tuesday, July 22, 2008 4:48 AM Subject: Re: Access denied for user 'debian-sys-maint'@'localhost' Hi Jesse, If you're specifying the password in plain text, you shouldn't put the PASSWORD directive in there; you only use PASSWORD if you're using the hashed password that MySQL will actually store.
RE: Spaces in sourced file names?
Thanks, but I guess I wasn't clear. I meant the MySQL command line client. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 4:50 PM To: Jerry Schwartz; mysql@lists.mysql.com Subject: Re: Spaces in sourced file names? Ls -la file\ name.file \ Will escape the space for ya me believes --Original Message-- From: Jerry Schwartz To: mysql@lists.mysql.com Sent: Jul 21, 2008 13:48 Subject: Spaces in sourced file names? In the CLI, is there any way to source a file whose name has whitespace in it (particularly spaces)? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 http://www.the-infoshop.com www.the-infoshop.com http://www.giiexpress.com www.giiexpress.com www.etudes-marche.com Sent via BlackBerry from T-Mobile -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
LEFT JOIN and RIGHT JOIN
Hi All, Can u please let me know when should i use LEFT JOIN and when should i going for a RIGHT JOIN. Please let me know some examples. regards anandkl
Re: LEFT JOIN and RIGHT JOIN
At 09:05 AM 7/22/2008, you wrote: Hi All, Can u please let me know when should i use LEFT JOIN and when should i going for a RIGHT JOIN. Please let me know some examples. regards anandkl anandkl, Take a look at the tutorial at http://www.keithjbrown.co.uk/vworks/mysql/mysql_p5.php Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: LEFT JOIN and RIGHT JOIN
Example: mysql select * from tableA; +---+--+ | name | age | +---+--+ | Amit | 27 | | Sumit | 31 | | Anand | 29 | | Parry | 32 | +---+--+ mysql select * from tableB; +---++ | name | Salary | +---++ | Amit | 5 | | Sumit | 6 | | Anand | 55000 | | Alex | 1 | | Ben | 9 | +---++ TABLEA RIGHT JOIN TABLEB mysql Select tableA.Name, tableA.Age, tableB.Salary from tableA right join tableB on tableA.Name=tableB.Name; +---+--++ | Name | Age | Salary | +---+--++ | Amit | 27 | 5 | | Sumit | 31 | 6 | | Anand | 29 | 55000 | | NULL | NULL | 1 | | NULL | NULL | 9 | +---+--++ TABLEA LEFT JOIN TABLEB mysql Select tableA.Name, tableA.Age, tableB.Salary from tableA left join tableB on tableA.Name=tableB.Name; +---+--++ | Name | Age | Salary | +---+--++ | Amit | 27 | 5 | | Sumit | 31 | 6 | | Anand | 29 | 55000 | | Parry | 32 | NULL | +---+--++ Regards, Amit Sharma @ Affle -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2008 7:59 PM To: mysql@lists.mysql.com Subject: Re: LEFT JOIN and RIGHT JOIN At 09:05 AM 7/22/2008, you wrote: Hi All, Can u please let me know when should i use LEFT JOIN and when should i going for a RIGHT JOIN. Please let me know some examples. regards anandkl anandkl, Take a look at the tutorial at http://www.keithjbrown.co.uk/vworks/mysql/mysql_p5.php Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: LEFT JOIN and RIGHT JOIN
Thanks a lot all of you, Thank u very much. regards anandkl On 7/22/08, Amit Sharma [EMAIL PROTECTED] wrote: Example: mysql select * from tableA; +---+--+ | name | age | +---+--+ | Amit | 27 | | Sumit | 31 | | Anand | 29 | | Parry | 32 | +---+--+ mysql select * from tableB; +---++ | name | Salary | +---++ | Amit | 5 | | Sumit | 6 | | Anand | 55000 | | Alex | 1 | | Ben | 9 | +---++ TABLEA RIGHT JOIN TABLEB mysql Select tableA.Name, tableA.Age, tableB.Salary from tableA right join tableB on tableA.Name=tableB.Name; +---+--++ | Name | Age | Salary | +---+--++ | Amit | 27 | 5 | | Sumit | 31 | 6 | | Anand | 29 | 55000 | | NULL | NULL | 1 | | NULL | NULL | 9 | +---+--++ TABLEA LEFT JOIN TABLEB mysql Select tableA.Name, tableA.Age, tableB.Salary from tableA left join tableB on tableA.Name=tableB.Name; +---+--++ | Name | Age | Salary | +---+--++ | Amit | 27 | 5 | | Sumit | 31 | 6 | | Anand | 29 | 55000 | | Parry | 32 | NULL | +---+--++ Regards, Amit Sharma @ Affle -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2008 7:59 PM To: mysql@lists.mysql.com Subject: Re: LEFT JOIN and RIGHT JOIN At 09:05 AM 7/22/2008, you wrote: Hi All, Can u please let me know when should i use LEFT JOIN and when should i going for a RIGHT JOIN. Please let me know some examples. regards anandkl anandkl, Take a look at the tutorial at http://www.keithjbrown.co.uk/vworks/mysql/mysql_p5.php Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL server statistics
On 21.07.2008 22:52 CE(S)T, Benjamin Wiechman wrote: With 5.1 you have more control over general query log and the slow query log - enable or disable at runtime, output to file or DB table. Okay, now that sounds a lot better. Waiting for 5.1 GA then. Although it only provides the very basics. I still have to postprocess/aggregate the log to find who did what and how long that all took. Or - looking at your original question it may be able to narrow down the source of the queries if you can graph your data more often - maybe every 10-15 seconds instead of a longer interval to help you profile which applications are hammering your db server. This is a webhosting services machine. I don't know who of the users is doing what and what applications they have installed. Recently I found one of my applications being vulnerable to senseless recursive bot requests that took quite a bit of the time. That was by chance because I had also looked into the web server requests diagramm, which I can separate by users. And in that case, my colour was clearly visible... ;) So maybe it will already help a lot to see for which user account the database server is working most in a certain time range. -- Yves Goergen LonelyPixel [EMAIL PROTECTED] Visit my web laboratory at http://beta.unclassified.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
failure to connect to mysql-server at localhost
Hi all, i am installing a library automation software called koha which uses mysql-server. i initially installed version5.0 and later uninstalled it because the system was giving me some errors. i installed the lower version(mysql-server-4.1). when reinstalling koha i get the following: MYSQL ROOT USER PASSWORD To create the koha database, please enter your mysql server's root user password: Password: CREATING DATABASE Creating the MySQL database for Koha... ERROR CREATING DATABASE /usr/bin/mysqladmin: connect to server at 'localhost' failed Couldn't connect to the MySQL server for the reason given above. This is a serious problem, the database will not get installed. Press ENTER to continue: i continued with with installation to the end. As a result of the above problem everything seems to work (adding members, searching and importing records from the internet using z39.50) But it doesnt add bibliographic records to the database- whenever i try to add records i get a server error. will be grateful if somebody can sort me out. i am using ubutu 6.06 operating system. Thanks kenneth
Re: memory usage
Hi ! Ananda Kumar wrote: Hi All, I have setup slave db. The machine configuration details of this slave is same as master. OS=redhat 8 cpu 16GB RAM key_buffer_size=3000M innodb_buffer_pool_size=1M. But when i do top, in the master db Cpu(s): 0.5%us, 0.3%sy, 0.0%ni, 87.2%id, 11.9%wa, 0.0%hi, 0.1%si, 0.0%st Mem: 16436956k total, 16350252k used,86704k free, 9188k buffers Swap: 16386292k total,37232k used, 16349060k free, 2358944k cached PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND 28706 mysql 15 0 14.3g 13g 4688 S6 84.1 540:21.55 mysqld On slave db Cpu(s): 0.7%us, 0.2%sy, 0.0%ni, 87.3%id, 11.8%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 16436956k total, 16351536k used,85420k free,16400k buffers Swap: 16386292k total, 164k used, 16386128k free, 4289520k cached PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND 14042 mysql 18 0 14.0g 11g 4652 S7 72.5 265:08.62 mysqld 435 root 10 -5 000 S0 0.0 3:29.07 kswapd0 As you can see the RES in master is 13g, but on slave its 11G any specific reason for this. This is causing some of the sql's on the slave to be slower than master for the same select statement on both master and slave. RES is the amount of RAM used by the process, as controlled by the memory allocation (Linux kernel). It depends not only on the address space requested by the process, but also on those by other processes and on the paging / swapping policy (which AFAIK depends on the which process accesses memory how frequent). The MySQL process on the slave has a smaller RES if and only if there is reason for the Linux kernel to allocate less RAM, this typically means there are other processes requiring it more urgently. *If* the database load on the master is higher, or accesses more data, or there is less competition about the RAM, it is only natural that RES for the slave is less. Database performance strongly depends on caching: If the cache on the master already contains the needed pages, and on the slave it doesn't, it is normal that the first statement needing them has to wait for disk I/O and so is slower. Jörg -- Joerg Bruehe, MySQL Build Team, [EMAIL PROTECTED] Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP, MySQL questions
Hi there I am going to make 2 Webserver at my work going to handle 50 mil hits per month... They are using Linux already. But being a FreeBSD fan, I have proposed MySQL and FreeBSD to my Boss convincing him that MySQL and FreeBSD is more Fast and Secure solution for his needs... And now I want to show the results... *Hardware: *Dell PowerEdge 2950 III having 2 x CPU 3,0 GHz Intel Xeon L5450 Quad-Core 2x6MB cache WITH 16 GB RAM. *Tools:* 1. FreeBSD 7 Production Release 2. Apache 2.2.9 3. MySQL 5.1.26 4. PHP 5.2.6 My question is, *To get the speed, performance and security*: Should I use Ports or Packages to install all these tools One by One? *OR * Should I use TAR files and compile them manually. For example giving command line arguments and commands like ./configure --prefix=/www --enable-module=so make make install cd ../php-xxx ./configure --with-mysql --with-apxs=/www/bin/apxs make make install etc I have googled but still haven't reached to solution...personally I would prefer comiling them with command line arguments but then I seek some help from you guys i.e. How should I write this ./configure..stuff in FreeBSD and what would be the best options combination, I must choose to get the speed, performane and security in Apache, MySQL and PHP? Any suggestion is very welcomed! -- Thanks! BR / vj
Master-to-Master replication on same server
I recently installed 2 instances of mysql on the same server, using port 3307 for the second server, the normal 3306 for the first server. I found that while logged onto that box I could communicate to the 3307 instances using the socket parameter. Using the port parameter (--port=3307) didn't work. I am now trying to set up master-to-master replication on that machine, where the 2 masters are the 2 instances running on that machine (sounds a little flaky, but it's for a dev box and it ought to work). It's not working and I'm wondering if it's because I can't specify the socket the 3306 master needs to connect to on the 3307 master. In the change master to command I can only specify the port. I did specify it as 3307 but the slave still can't connect. Has anyone done this? -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
MySQL Cluster 6.2 Disk Based Data Storage Requirements
Hi I am using Disk Based MySql Cluster 6.2.15 . I would like to know one important thing regarding MySQL cluster. I am using two servers with 1.8 TB each. What will be the maximum space available for Data Storage when both machines are in cluster? Suppose if i add one more machine with 1.8TB again, what will be the effective space available for Data Storage ? Any formula from where we can find out How much will be the effective space for storing actual data when all 3 machines are in cluster? Please advice me on this . Thanking all in advance Anjitha Software Engineer.
Who could please tell me whether my procedure's memory usefulness is normally or not?
mysql show global status like '%stmt%'; +-+-+ | Variable_name | Value | +-+-+ | Com_stmt_close | 4875504 | | Com_stmt_execute| 4875504 | | Com_stmt_fetch | 0 | | Com_stmt_prepare| 4875507 | | Com_stmt_reset | 0 | | Com_stmt_send_long_data | 0 | | Prepared_stmt_count | 0 | +-+-+ 7 rows in set (0.00 sec) -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn