sql - Benchmark MySQL on SSD: Tools and Strategies -


I am currently switching my servers from running on SSD on IISADB on hard drives.

I

My server has set up:

  • With a Ubuntu 64 + Nginx + MySQL 5.5 +, a 3,800,000 rows (16GB) table is in the form of benchmark tables. ...

I have two things that I have to do too much tests:

  • How to affect the sync sensitivity to SSD from the hard drive < Li>
  • How to switch to INODB will affect the concurrency

I have questions about both the tools and strategies:

  • 'mostly Interest in concurrency, What tools do I use to test? I played with the Siege and I found it really easy to play, but I think that even the most powerful Linux software should be better suited to my needs. completes.
  • How do test strategies look like? I think the option of strategy can be a tight relationship with the device that I have chosen to use. For example, when playing with the siege, I would write PHP scripts that upload some heavy lift MySQL files, upload it to the server, in the form of parameters to surround the script URL (which is in my local laptop) Installed) and simulate concurrent traffic for me.

General tests are fine, but only tell the difference between actual load software & amp; hardware configuration. li> Load the database in test configuration and run slow query log on it (use PT-Log-Player).

  • Capture all queries from the test server with long servers.
  • Analyze Results from a slow query log with PT-query-digest.

    • I refer tools to mysql (although some tools might require the percona server, I'm not sure).


    Comments

    Post a Comment

    Popular posts from this blog

    Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

    I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
    Read more

    java - How not to audit a join table and related entities using Hibernate Envers? -

    I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
    Read more

    mongodb - CakePHP paginator ignoring order, but only for certain values -

    While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
    Read more