MySQL Hits Analysis
hi list, Does anyone has experient in analyzing MySQL traffic? Is there any method/tool to know how frequent a particular table is accessed / which table is heavily used / which is the table that causing speed bottle neck and et cetera. Thanks. Chee Peng - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: Replication
hi Victoria, I stopped both mysql in master and slave. Then I put in the server id for both master and slave, start the master then the slave. Is it okay? Thanks, Chee Peng - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 30, 2002 10:37 PM Subject: re: Re: Re: Replication CP, Monday, September 30, 2002, 3:48:31 AM, you wrote: C The Master's server id is 1 while the slave's server id was set to 5. There C is no problem for the slave to establish connection to the master. However, C the slave complains that error reading packet from server, the reason is C misconfigured-master, server id was not set and this messages keep on C repeating. Did you set up server-id for master from the very outset or you set up the one after master has been started? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Replication
hi Victoria, The Master's server id is 1 while the slave's server id was set to 5. There is no problem for the slave to establish connection to the master. However, the slave complains that error reading packet from server, the reason is misconfigured-master, server id was not set and this messages keep on repeating. Any idea? Thanks, Chee Peng - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 27, 2002 9:16 PM Subject: Re: Re: Replication Hello CP, Friday, September 27, 2002, 3:11:14 AM, you wrote: C hi Victoria, thanks for the reply. I have set server id in the very C beginning, but its still not working. I don't understand why the MySQL would C not let me change its server id accordingly. The server id was set to 1. You must set up unique server-id for the master and for the slave. You said that server-id=1, but it's only one server id, what about another? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SHAPE command for Hierarchical Recordset
I would suggest you use MS Access report with MyTool-DLL For VB and MySQL. - Original Message - From: NZEYIMANA Emery Fabrice [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 27, 2002 4:40 PM Subject: SHAPE command for Hierarchical Recordset I have created a MySQL database that will help me manage my Invoicing system but I have been stack when I tried to print a report using a VB application. I have read from Help that I will need to use a hierarchical recordset to achieve what I want to. You know an Invoice has some headers like: Customer names, Invoice number, ... It also has details of ordered products/services Like: Item ID, Description, ... So my invoice should look like: ++ NZEYIMANA (Customer name) Some Addresses Invoice No.: 2002-09/5 -- -- -+ Item IDDescriptionQtyUPTotal -- -- -+ 12dfhsdfdsfjsd525 125 ... ... _ Total 125 VAT: - ++ To build such an invoice using ADO, VB, DataReport you need that Hierarchical recordset because DataReport won't accept if it is not a hierarchical recordset. How do I achieve this? Thanks Emery - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication
hi List, I am trying to do a master-slave replication on mysql-3.23.42. My master is sitting on a FreeBSD machine and the slave is running in a Red Hat Linux 7.1 machine. From the log, the master-slave connection is okay, but the slave seems unable to read the binary content from master. My Server-id is set to 1. Below is the error from the log: 020926 15:41:59 Error reading packet from server: Misconfigured master - server id was not set (read_errno 0,server_errno=2000) Any idea? Thanks, Chee Peng - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL crashes on a select query from select.test
MySQL crashes, when number of entries in table is greater than some number 'X', in mf_radix.c file on execution of a select query. Optimization used: O2 Please suggest some approach to debug this crash. It works fine with O0 optimization option. __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php